Remsys logo
Remsys logo

Fail-safe Master-master MySQL replication

Reference:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
Assumptions:

Server1 IP: 10.1.1.1
Server2 IP: 10.1.1.2
We will completely replicate all databases
Servers are not in production yet. If they are – be careful when rsyncing data

Notes:

This setup can be used in HA environments, provided that only one of the servers is used for writes (INSERTs, UPDATEs, DELETEs) at a given moment
In case one of the servers crashes, [...]



Service high availability using open-source tools

People want their servers, and of course the projects that are running on them, to be available all the time, and to bring maximum revenue at the same time.
In a real-life situation, it is more than clear that pure 100% availability is impossible to achieve, especially if a single hardware device is involved. There can [...]



© 2003 - 2008 Remsys

All rights reserved