HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   multiple master replication with mysql 5 (http://www.howtoforge.com/forums/showthread.php?t=28144)

tanoy999 25th October 2008 14:43

multiple master replication with mysql 5
 
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 20: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_...on_debian_etch

Marc


All times are GMT +2. The time now is 11:04.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.