Building a MySQL Slave and Keeping it in Sync

Sheeri K. Cabral of the Pythian Group (http://www.pythian.com) presents on how to get a consistent snapshot to build a slave, how to use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies.

The slides are online at http://technocation.org/files/doc/slave_sync.pdf

Category:

Science & Technology

Tags:

• slave
• replication
• master
• mysql
• maatkit
• lvm
• zfs
• mysqldump
• xtrabackup
• innodb hot backup
• backup
• snapshot
• mk-table-checksum
• mk-table-sync
• pythian
• sheeri
• sheeri cabral

[SheeriCabral]

datacharmer.blogspot.com/2011/­03/mysql-replication-for-deman­ding-users.html That might help. There's nothing from Oracle right now that's production ready, but there is Tungsten Replicator. Search youtube for "Tungsten mysql" and you should find some good videos (youtube won't allow me to post the URL)

[pedritoeddy]

Hi, i know this video is very old, but i have a question, do you know howto N-Master > 1 Slave??

[einoch]

For those interested in the LVM questions:

- LVM aggregates block devices. If the kernel sees something as a block device, you can use it as part of a volume group. So HDDs, SAN LUNs and MD devices all make good LVM devices (aka. Physical Volumes).

- A filesystem that you make on a logical volume doesn't know that it's doing anything special. It just thinks it's sitting on a big, single block device.