MySQL Forums
Forum List  »  Data Recovery

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

Hello,

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
databases.

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?

Regards,
Yair

Options: ReplyQuote


Subject
Views
Written By
Posted
Disaster Recovery
5090
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.