database,sql,query,tabl
Hi all
I have a two way replication environment working 100% at the moment. I want
to now introduct a third server into the equation, and I want to know .....
Currently -
Server "A" replicates from Server "B"
Server "B" replicates from Server "A"
Is it possible that
Server "A" replicates from Server "B"
Server "A" replicates from Server "C"
Server "B" replicates from Server "A"
Server "B" replicates from Server "C"
Server "C" replicates from Server "A"
Server "C" replicates from Server "B"
I know that this is not "entirely" possible, because you can only specify
one master, but I will write a program that changes the master when I need
to.
Each of the servers are connected via a dialup connection, sometime I needs
to transmit information from Site "A" to Site "C" urgently, and cannot
afford the time it takes to complete a tri-angluar update, so I want to
change the Masters and sink "A" directly to "C" instead of the "normal"
tri-angular sequence.
My question is really .....
When the replication occurs how does it know what information is from what
server, do the logs stor the server id, and therefore the above should work
because when "A" replicates to "B" again, it will ignore the "C" entries it
already has????
Thanks
Warren
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
