I have an existing Mysql 5.1.73 Master/Slave/Slave configuration, which is working correctly and all changes are being replicated.
I have now set up a PerconaDB (mysql+galera+XtraDB) 5.6.30 3-node cluster, which is working correctly.
One of the nodes in the Percona cluster is configured as a Replication Slave to the first cluster. This is being done in order to provide temporary synchronisation for migration purposes; eventually, the Master/Slave cluster will be removed and we will use only the Percona cluster.
If I use the mysql client, and make changes (add tables, add records, update records) on the Master, then this replicates to all clients, and to all nodes in the Percona cluster. So far so good.
However, if I use a certain web application to make changes, then these only replicate to the Master and original slaves, not to any of the Percona nodes.
I have verified that, if I use mysql to make the updates manually, they replicate correctly; however if done via the web application they seem to be filtered out by the PerconaDB slave node. Note that I do not have any visibility of the exact SQL being used by the application, and cannot stop the database in order to enable query logging.
SHOW SLAVE STATUS and
SHOW MASTER STATUS I can see that the log position is increasing on both master and slave when a change is made.
Can anyone tell me any reason why an update from the webapp would be ignored by the Percona slave thread, when a 'manual' SQL command to do the same update appears to replicate correctly? Is this a version incompatibility, and is there any temporary workaround?
Master configuration (part)
binlog-format = mixed
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
expire_logs_days = 10
log-bin = /var/lib/mysql/mysql-bin
server-id = 1
sync_binlog = 1
Slave configuration (part)
server-id = 1000
log-slave-updates = 1
relay-log = /var/lib/mysql/mysql-relay-bin.log
log_bin = /var/lib/mysql/mysql-bin.log
slave-skip-error = 1062,1050
replicate-ignore-db = mysql
replicate-ignore-db = information_schema
replicate-ignore-db = performance_schema
Slave_IO_State: Waiting for master to send event
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Warnings appearing on the Slave side:
2016-09-07 20:16:26 21354 [Warning] Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum failed with error: Unknown system variable 'binlog_checksum', Error_code: 1193
2016-09-07 20:16:26 21354 [Warning] Slave I/O: Unknown system variable 'SERVER_UUID' on master. A probable cause is that the variable is not supported on the master (version: 5.1.73-log), even though it is on the slave (version: 5.6.30-76.3-56-log), Error_code: 1193