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 ?
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.