PDA

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