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
How do I mirror a MySQL db onto another server
Moderator: General Moderators
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
-
blackbeard
- Forum Contributor
- Posts: 123
- Joined: Thu Aug 03, 2006 6:20 pm
Try this link: http://www.onlamp.com/pub/a/onlamp/2005 ... QLian.html