froscon2010 - PREVIEW
FrOSCon
Free and Open Source Software Conference
| Speakers | |
|---|---|
|
Stephane Combaudon |
| Schedule | |
|---|---|
| Day | Day 1 - 2010-08-21 |
| Room | HS6 |
| Start time | 15:15 |
| Duration | 01:00 |
| Info | |
| ID | 573 |
| Event type | Lecture |
| Track | OpenSQLCamp |
| Language used for presentation | English |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
Keep your MySQL replication in sync with Maatkit
MySQL offers no built-in mechanism to check consistency between a master and its slaves. Maatkit, a famous set of tools to ease the administration of a MySQL server, does. In this session we will see various replication problems and how to solve them with Maatkit.
MySQL replication is straightforward to set up but also easy to break. If inconsistencies are introduced, the master and its slaves start being desynchronized. And as MySQL does not offer any tool to monitor the situation, most often you will not catch the problem, which can lead to strange behaviors and possibly make your application crash. Maatkit, a set of administration tools for MySQL, 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.