View Full Version : multiple master replication with mysql 5
tanoy999
25th October 2008, 15:43
I want howto multiple master replication with mysql 5 in centos / fedora,
example have 3 master or 4 master .etc.. ..... Thank you
from tanoy999 >>>>Thailand
marchost
25th October 2008, 21:56
Try circular replication....
A--------------B
|................|
|................|
D--------------C
A slave of D
B slave of A
C slave of B
D slave of C
In /etc/mysql/my.cnf (mysql config file)
[...]
auto-increment-offset = 1
[...]
Has to be changed. A=1, B=2, C=3, D=4
The rest should be pretty much the same as : http://howtoforge.com/mysql5_master_master_replication_debian_etch
Marc
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.