In the topology you just illustrated, you need to be specific about your scheme
using arrows. Here are some examples:
======================================================
Example 1: This is MultiMaster Replication among 4 servers
Master1----------->Master2
^ |
| |
| |
| V
Master4<-----------Master3
======================================================
Example 2: This is Tree Replication among 4 servers
Master1
|
____________|____________
/ | \
| | |
| | |
V V V
Slave2 Slave3 Slave4
======================================================
Example 3: This is Chained Replication among 4 servers
Master1--->Slave2--->Slave3--->Slave4
======================================================
Example 4: This is MultiMaster Replication among 4 servers
Using two masters and two slaves
______________
/ \
V \
Master1 Master2
| \ ^ |
| \______________/ |
| |
| |
V V
Slave3 Slave4
======================================================
As long as you obey the rule: A SLAVE CANNOT HAVE TWO MASTERS,
there are many replication topologies that are possible
-----Original Message-----
From: Frank Becker [mailto:[email protected]]
Sent: Tuesday, January 13, 2009 12:33 PM
To: [email protected]
Subject: Question about Master-Master replication: Is this possible?
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible to set up such a replication
between three (or more) servers? Like this
Master3 --- Master1 --- Master2
|
Master4
Thanks for your feedback
Best regards
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
