I did this some time ago.
Host A and B You just configure host A as master and host B as slave of host A. Then you do the same vice versa. There is a description in the manual.
----> A B Is a circle. <----
I have this set up, but I also have other slaves off of A like this:
C
^ | |
A <----> B
| | V
D
(note that C and D are simple slaves of A).
The problem is that if you update B, it never reaches C and D unless you enable log-slave-updates, but then A and B seem to get into a loop so if you do an update on A, it updates on B which then send the update back to A, etc. I thought that MySQL wasn't supposed to do this (they have different server-id's), but it did. I would love to get this to work.
It's a pitty that one can't construct a star formed structures though.
S2 I S1 <--> X <--> S3
This would be even better.
-m -- ## Mark T. Dame, VP, Internet Application Development ## MFM Communication Software: http://www.mfm.com/ ## E-mail: mailto:[EMAIL PROTECTED] WWW: http://www.mfm.com/~mdame/ "Eagles may soar, but weasels don't get sucked into jet engines."
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]