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

Can pt-archiver breaks the replication

khannvinkhannvin EntrantCurrent User Role Beginner
Hi,

I am evaluating pt-archiver.

My scenario is:

I have two databases: prod_db & archive_db

prod_db has replication and we are ignoring archive_db to replicate.

I want to archive some data from table prod_db.foo (delete) to table archive_db.foo_archive (insert).

As we have to delete data from prod_db.foo and insert in to archive_db.foo_archive, Does this affects the replication.

Also the tool doesn't have any option --[no]check-replication-filters like pt-online-schema-change.
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.