posted by Sheeri Cabral
on
Wed 11 Nov 2009 13:29 UTC
Tags:
(
edit)
mysql,
Technical Blog,
backup snapshot,
innodb hot backup,
lvm zfs,
Maatkit,
master,
mk-table-checksum,
mk-table-sync,
mysqldump,
Pythian,
Replication,
slave,
video,
Xtrabackup
Video: Building a MySQL Slave and Keeping it in Sync
At the Boston MySQL User Group Sheeri Cabral presented 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.
This link contains the slides and the videos