Setting up MySQL Replication

Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.

References mentioned in the video:
Brian Aker's DBIx::Password is at http://search.cpan.org/dist/DBIx-Password/


Giuseppe Maxia's article about federated tables is at http://www.oreillynet.com/pub/a/databases/2006/08/10/mysql-federated-tables.html

MySQL Toolkit -- renamed Maatkit -- lives at http://sourceforge.net/projects/maatkit

http://mysql.meetup.com/137/files/ has sample my.cnf files for 2 different dual-master replication scenarios

Category:

Science & Technology

Tags:

• mysqlug
• replication
• mysql
• patrick galbraith