Not the answer you need?
Register and ask your own question!

pt-table-sync

b3nkyb3nky EntrantInactive User Role Beginner
First of all, Hi!

I'm new in database world, and I started to read books and play with databases.

I created my little lab where I can try different setups and things. 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 is it possible to do following: I set sql_log_bin=0 and created 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 it's not working (throwing error that table doesn't exists; which is written 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 solution to sync it with pt-table-sync, to avoid backing up base on masterB and moving to masterA?

Thank you!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.