I have a couple of questions regarding replication in MySQL:
1) does it work well/handle loss of connections due to network
outages/delays; we have a geographically diverse environment, and were
hoping to be able to replicate the data across the connections (which
may have outages from time to time)
2) Is it possible to set the hosts up in the following manner,
where Host [1,2,3] all recieve data updates that should go to all other
hosts
Host[A,B] recieves updates from Host 1, and updates some tables only to
Host 1(client data)
Host A
\
Host 1 --- Host 2 --- Host 3
/
Host B
Host 2 is in the network between Host 1 and Host 3
I know it is possible to set up replication in a circular mode, but I
haven't heard/read of any way to configure them in a chain or star
configuration
(Host 2 would be a slave to Host 1 and Host 3)
and Host 1 would be a slave to A,B and 2
Also, each of these hosts is in a different geographic location, so it
would be nice to have some
redundancy and load balancing at some sites (Host 1.1, 1.2, 1.3, etc)
based on query load.
Scott V
---------------------------------------------------------------------
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
