On Wed, Jan 24, 2001 at 10:45:53PM -0500, Scott Vanderweyst wrote:
>
> 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)
Works well. If the slave connection to the master drops, the slave
simply tries to reconnect. That's what `master-connect-retry' is
about:
http://www.mysql.com/doc/R/e/Replication_Options.html
Hopefully the explanation there is clear...
> 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)
Yes.
> 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.
Yes, you can setup a replication hierarchy. A server can be a slave of
some master and also write its own binary log--which another slave can
read from.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
