Page 1 of 1

How do I mirror a MySQL db onto another server

Posted: Mon May 14, 2007 5:10 am
by Kadanis
Basically, we have just installed a new backup server for our application/database server. I need to set up an automated mirror of the database so that everything is copied across quickly and frequently.

I'm using rSync for the files, but I wondered if anyone here can suggest an easy way of doing the database. The backup schedule needs to be something like every 5 - 15 minutes tops.

Thanks in advance

Posted: Mon May 14, 2007 6:59 am
by Chris Corbyn
Look up "MySQL replication". You may also want to look up "MySQL with NDB". These are cluster/redundancy techniques.

Posted: Mon May 14, 2007 7:06 am
by blackbeard