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, [...]



Referral Whois and ARIN’s rwhoisd

Without strict standards, the internet would be just a bunch of interconnected networks, and finding valid information about some specific resource would be next to impossible.
The most simple example (not directly related to the Internet or IT, but illustrating the main idea):
Imagine the modern telephone system. Each country has it’s own area code, each state/district/region [...]



© 2003 - 2008 Remsys

All rights reserved