"other-master" has an entry to /etc/hosts pointing it to 127.0.0.1. I'm using SSH tunneling to have the other master's database appear on localhost port 3307.
This all may sound a little weird, but I've used pt-online-schema-change many times over many years in this configuration with no problem.
Thanks very much for looking into this.
This machine is a master, as is one of the slaves. They're in a master/master configuration. The other slave is just a slave.
Here's the DSN table which my command refers to:
MariaDB [percona]> select * from dsns_master; ------- ---+--- ------- ------- ------- ------- ------- ------- ------+ ------- ---+--- ------- ------- ------- ------- ------- ------- ------+ master, F=/etc/ mysql/my. cnf.percona, P=3307 | F=/etc/ mysql/my. cnf.percona | ------- ---+--- ------- ------- ------- ------- ------- ------- ------+
+----+-
| id | parent_id | dsn |
+----+-
| 2 | NULL | h=other-
| 3 | NULL | h=localhost,
+----+-
"other-master" has an entry to /etc/hosts pointing it to 127.0.0.1. I'm using SSH tunneling to have the other master's database appear on localhost port 3307.
This all may sound a little weird, but I've used pt-online- schema- change many times over many years in this configuration with no problem.