I did a sqldump from a slave to another slave. On the master, we’re running mk-table-checksum. The new slave is showing as replicating correctly and from what I can tell it has to do with some tables having timestamp fields with an “on update CURRENT_TIMESTAMP” trigger. This causes the data in the slave to contain different values than the master and the checksum fails.
Is this an accurate assumption?
What is the solution?
One solution would be to run an update query against the master system to update the data in these fields to itself, but we’re dealing with millions of records and this of course will take time.
Is there a better way?