Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a database setup with chained replication:

+-----------+       +-----------------+       +----------+
| A: master |  <--  | B: slave/master |  <--  | C: slave |
+-----------+       +-----------------+       +----------+

So A is the master of B and it is itself a master of C.

Now the C lost track of B and I need to synchronize it back. Copying the whole database would be very inconvenient, as it's about 100GB in size and C is connected over WAN.

Normally I'd use pt-table-sync, but I'm not sure if it's safe to run it on B, which is a slave itself. The man page isn't very clear about such scenarios, it just mentions that replication should be always done on the master, but here I have two.

So I'd like to ask: What are the options I could use?

  • Is it possible and safe to use pt-table-sync, either on B, or somehow on A, telling it to make checksums on C instead of B?
  • Are there some other, efficient options, how to synchronize C with B?
share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.