MySQL Forums
Forum List  »  Backup

Automated Backup to another MySQL Server
Posted by: Joe Casanova
Date: October 28, 2005 09:40AM


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

Options: ReplyQuote

Written By
Automated Backup to another MySQL Server
October 28, 2005 09:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.