Replication in MySQL 5.0

March 6, 2008 10:16 AM

Does anyone know of a quick and clear guide to set up my MySQL Replication in MySQL 5.0?

Does anyone know of a quick and clear guide to set up my MySQL Replication? I want a master and multiple slaves. All machines are on the same LAN. Must be for MySQL 5.0. Of course, I want it to automatically replicate itself.

posted by kaozity to computers & internet (2 answers total)

It's not terribly difficult to set up a Master + Slave(*n) arrangement. You're going to add a user to your database, make some changes to my.cnf, import data if you need to, and then tell mysql to start the replication process.

MySQL's own HowTo from the reference documentation will lead you through it.
posted by toxic at 11:07 AM on March 6, 2008

I've recently had good success with these instructions from HowToForge.
posted by mnology at 8:07 PM on March 6, 2008