I'm moving a MySQL database from the US to Australia and have a requirement where downtime is kept to an absolute minimum.
The database is 400GB is size, replication is working without any issues. However, performing data validation takes days with pt-table-checksum.
To ensure that the database integrity is maintained up until the point of cutting over, is there a better tool than pt-table-checksum to validate the data is consistent between the master and slave? Or can pt-table-checksum be optimised to run faster?
Please note that initial testing with pt-table-checksum across the different geographic regions was performed where the databases were both idle
Any advice is appreciated!