| Speakers | |
|---|---|
|
Stéphane Combaudon |
| Schedule | |
| Day | Sunday |
| Room | AW1.121 |
| Start time | 14:15 |
| End time | 14:45 |
| Duration | 00:30 |
| Info | |
| Event type | Podium |
| Track | MySQL |
| Language | English |
Replication with MySQL is very easy to set up but also very easy to break. As soon as inconsistencies are introduced, the master and the slaves start being desynchronized - and most often, you have no way to be quickly and efficiently aware of the problem as MySQL offers no built-in mechanism to check data consistency between servers.
Fortunately Maatkit has a neat solution with 2 nice scripts: mk-table-checksum, which is a tool to detect inconsistencies between a master and its slaves and mk-table-sync, which can correct automatically these problems detected with mk-table-checksum.
This session will show you first how to use both tools depending on your replication setup (master-slaves or master-master) and then how to get the most from the multiple options that are available.