Mariadb – Percona pt-table-sync Can’t determine Master

connectionsmariadbperconareplication

We have following Multi master replication scenario. We are using MariaDB 10.1.34 and Percona 3.0.11

Master: Name: db-master1 (192.168.14.5)

Slave:
Name: db-slave2 (192.168.15.5) Replica Connection name: master1 (192.168.14.5)

SHOW SLAVE 'master1' STATUS\G on slave server is working fine.

I deliberately produced the data inconsistency and deleted 5 records in Test.dummy table on slave. Once I ran the below command to sync:

pt-table-sync --replicate --sync-to-master h=localhost,u=checksum_user,p=checksum_password --check-master --channel=master1

I got the error:

Can't determine the Master of h=localhost

Best Answer

pt-table-sync --execute --verbose --databases Test -t dummy --no-foreign-key-checks h=192.168.14.5,u=checksum_user,p=checksum_password h=192.168.15.5

The above command successfully synchronized the data from Test.dummy on Master (192.168.14.5) to Test.dummy on Slave (192.168.15.5).

Related Solutions

Mysql master-master permission replication issue

Your grants are not replicating because you have an (unnecessary) replication filter on INFORMATION_SCHEMA. There is no reason to exclude this, as it is not replicated anyhow. When replication filters are in place, you have to USE a database or your statements are not replicated.

For example...not replicated

Grant all privileges on *.* to foo@localhost identified by 'bar';

This is replicated...

USE anydb
Grant all privileges on *.* to foo@localhost identified by 'bar';

....but instead, just remove that replication filter.

Mysql – Rows already DELETEd on MySQL slave; How to DELETE on master

Here is something quick and dirty you can do

Run the DELETE like this on the Master:

SET SQL_LOG_BIN=0;
DELETE FROM ... ;

The first line tells the DB Session not to record the SQL that follows. Thus, when you run the DELETE on the Master, the SQL will not be written in the Master's binary logs. Consequently, the Slave will never receive the DELETE in its relay logs.

This will only affect the session you use to run these two lines. All other DB Connections will replicate as usual. Once you disconnect, any new session will replicate properly.

Give it a Try !!!

Best Answer

Related Solutions

Mysql master-master permission replication issue

Mysql – Rows already DELETEd on MySQL slave; How to DELETE on master

Related Question