3 ms·
There's a few different ways to verify, a few of them involving stopping replication, like you pointed out. These can also sometimes be quite expensive, so depe
by jivid 10y ago
There's a few different ways to verify, a few of them involving stopping replication, like you pointed out. These can also sometimes be quite expensive, so depending on the type of verification required, the verification method can be tuned.
We also implemented table checksums inside of mysqldump, allowing us to dump out the restored data and compare checksums as well, if required. https://github.com/facebook/mysql-5.6/commit/54acbbf915935a0161af9ddb7173579ce1348e73 https://github.com/facebook/mysql-5.6/commit/54acbbf915935a0...
- predakanga 10y agoVery nice, thanks for the link! I'll definitely be seeing if I can replace my system with that; reducing the overhead to a single transaction would be a big win.