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

Is pt-table-checksum with "replication-rewrite-db" enabled on the slave working ?

mollmoll EntrantCurrent User Role Beginner
Hi Guys,

I want to check a database consistency between master and slave, but this database name on the slave is set to different than it is on the master because the option "replication-rewrite-db" is being used on the slave.
Is it possible to make such check ?

Thanks,
Moll

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    pt-table-checksum only works via replication, assuming all schema's, tables, etc. on master are the same on the slaves. If you really need to do this, you could use pt-table-checksum version 1.x which still had the ability to checksum arbitrary schema's. I would suggest If you plan to go ahead and try 1.x please do it in a testing environment first as it's pretty old version now.
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.