Hi Guys,
Is there any problems running the pt-table-sync or pt-table-checksum on the slave and setting the DSN to the master?
In terms of the checksum. Does the percona database only get created on 1 server or is it created on the each server in the replication setup?
E.g. Our master server is running slightly tight on space until we’re able to resize the partition during our next maintenance period so would like to have the percona database on the slave only so not to use disk space on the master.
Ideally I’d also like to be able to run the pt-table-sync from the slave rather than having to install the percona tool kit on the master too.
Thanks
Hi,
Answers are inline.
Is there any problems running the pt-table-sync or pt-table-checksum on the slave and setting the DSN to the master?
No, You can run both the utilities from the slave by DSN option. But while running, when you specify DSN option, you must specify the master’s username/password.
In terms of the checksum. Does the percona database only get created on 1 server or is it created on the each server in the replication setup?
Percona DB will be created on master but it will get replicated to the slaves too and you can run the query to find the differences on the slave. Where ever you run pt-table-checksum (on master/slave with DSN), It inserts data into a percona db on master server. But I guess it will be small amount of data so it should not affect disk space that much.