Sample Header Ad - 728x90

pt-table-sync - Resync non existing table

1 vote
0 answers
390 views
I created my little lab where I can try different setup/scenarios. I have four machines debootsraped/chroot and this is my current layout: `| Master A | | Master B | | | Slave C | | Slave D |` Database is created with one table, replication is working. Intention of this post it to find out if it is possible to do the following: - I set sql_log_bin=0 and create table called sync on masterA, (to simulate inconsistent state) - then I returned variable sql_log_bin to 1. Normally when I try to use pt-table-sync this doesn't work (throwing error that table doesn't exists; which is noted on percona site), so I was thinking if I create identical table on slave and try to synchronize that it will work but it doesn't. Is there a solution to sync it with pt-table-sync, to avoid backing up db on masterB and moving to masterA?
Asked by b3nky (11 rep)
Dec 14, 2015, 12:58 PM
Last activity: Dec 14, 2015, 03:04 PM