Not the answer you need? Try our search, browse our categories, or register and ask your own question!

Use pt-table-sync to re-sync table when ignored_replicate_table Master-slave model

bienkmabienkma Active Member Poster
Hi there,
I have db02 is replicated by db01 and I have ignored replication  t1 table on db02 last week. Now I want to re-replicate t1 table again. So I can use pt-table-sync for solving  the problem? And if the  answer is  yes How to do?
Thank you very much!

Answers

  • jriverajrivera Percona Support Engineer Percona
    Hi, I would suggest to do a mysqldump and restore of that table instead of using pt-table-sync. Basically prevent applications from updating the table, stop slave replication, remove the replication filter, dump and restore the table then resume replication. Another option would be to dump the table from the master, drop the table, remove replication filter, restart replication and then restore the table from the master. I would suggest testing either of these procedures prior to implementing them.
  • bienkmabienkma Active Member Poster
    Hi Jrivera,
    Thank you for your reply but my expectation is a little downtime there. In my situation, the table was too big and we will take a lot of time to dump and restore it then replication. 
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.