# pt-table-sync

**URL:** <https://forums.percona.com/t/pt-table-sync/4593>\
**Category:** Percona Toolkit\
**Created:** [December 11, 2015, 8:24am UTC](https://forums.percona.com/t/pt-table-sync/4593 "2015-12-11T08:24:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![b3nky](https://avatars.discourse-cdn.com/v4/letter/b/a87d85/32.png) [@b3nky](https://forums.percona.com/u/b3nky)\
**Post date:** [December 11, 2015, 8:24am UTC](https://forums.percona.com/t/pt-table-sync/4593/1 "2015-12-11T08:24:20Z")

</div>

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!