View Single Post
  #2  
Old 25th October 2008, 21:56
marchost marchost is offline
Junior Member
 
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts
Default

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

Last edited by marchost; 25th October 2008 at 21:59.
Reply With Quote