MySQL Forums
Forum List  »  Data Recovery

Disaster Recovery
Posted by: Yair Sade
Date: March 02, 2007 05:27AM


I've need to establish a disaster recovery site to my (innodb) mysql site.

I need an active-passive configuraiton (one active machine and one standby that becomes active once the main site goes down).

The information in the database is critical and must have all the updates in both

My system consists of an applicaiton that runs on the same machine with mysql (no other clients connect to the mysql).

I thought about using mysql replicaiton but since it is asynchrounous, I may lose changes.

On the other hand mysql cluster is an overkill and actually, I dont need active-active envronment (additionally, it requires more than 2 machines).

Do you think of any simple solution that provides synchronous replication of an active/passive machines?


Options: ReplyQuote

Written By
Disaster Recovery
March 02, 2007 05:27AM

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.