Comment 2 for bug 1693614

Revision history for this message
Xan Charbonnet (xan-biblionix) wrote :

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;
+----+-----------+---------------------------------------------------+
| id | parent_id | dsn |
+----+-----------+---------------------------------------------------+
| 2 | NULL | h=other-master,F=/etc/mysql/my.cnf.percona,P=3307 |
| 3 | NULL | h=localhost,F=/etc/mysql/my.cnf.percona |
+----+-----------+---------------------------------------------------+

"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.