Automated Backup to another MySQL Server

[Joe Casanova]

Hi,

I am interested in how I could set up and automated backup process to backup every database from one MySQL server to another MySQL server.

Both servers are currently running windows 2003 server and are on a copper gigabit network between them and are both quite powerful, so resource consumption is not a problem.

I'm assuming there is a command-line parameter I could use for this and just set up a windows scheduler agent to run the command every X minutes, but I do not know it.

The secondary server will be a backup, it will be backed up every 5 minutes from the primary server. If the primary server goes offline, my network monitoring system will automatically reroute all MySQL traffic to the secondary server and put a header on all webpages that we are running on our backup database server so things may not be 100% up to date due to the 5 minute backup window. I do not need to worry about a reverse replication because we want to do that manually here instead of on an automated system.

We may eventually move to a system where there is no dedicated primary/secondary servers and it works in a system where the live database server backs up to the stand by server and when the live fails, the standby goes live. Then the new live database server remains the live until it fails and the previous live server becomes the stand by server.

Any help would be greatly appreciated. Thanks in advance!

Joe Casanova