On Tue, Jun 05, 2001 at 10:11:06PM +0200, Warren van der Merwe wrote:
> HI
>
> What effect will this have in my current setup where A is a slave of
> B and B is a slave of A.
>
> If A, is correct, and I issue a load on B, when A syncs for an
> update will it not try and write those records back?
It will not.
Replication is based on the binary update log stored on each
master. Then you do a LOAD TABLE <foo> FROM MASTER on a slave, it has
no effect no the binary log of the master (or slave, if it's also a
master).
It simply copies the table over to the slave.
Slaves don't directly read data from the master's tables. They simply
read and "replay" queries from the master's binary log.
It takes a bit of tinkering before you really wrap your head around
how it works. For a while, I kept thinking that it was more complex
than it actually was! In reality, it's simple and reliable once it is
running right.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 11 days, processed 68,893,061 queries (71/sec. avg)
---------------------------------------------------------------------
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
