Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

  • #2
    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.

    Comment

    Working...
    X