How do I mirror a MySQL db onto another server
Posted: Mon May 14, 2007 5:10 am
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
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