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

The Boston MySQL User Group got Keith Murphy to speak at the June User Group meeting, about backups. Direct play the video at:http://technocation.org/node/559/playDirect download the video (351 MB) at:http://technocation.org/node/559/downloadLinks referred to in the presentation:MyLVMBackup by

The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.

A presentation about MySQL HA solutions by Lenz Grimmer, presented at FOSDEM 2009 in Brussels, Belgium