On Fri, Dec 14, 2001 at 06:36:19PM -0500, Peter M. Perchansky wrote: > Greetings everyone: > > RE: http://www.mysql.com/doc/R/e/Replication.html > > How frequently does each slave get data from the master?
The slaves have a thread running (the "slave thread") which is always connected to the master, waiting for new queries. > If the server the master was on went down unexpectedly, how much > data would still be on the master that the slave(s) may not have > picked up? Depends how far behind the slave is. Under ideal conditions, you lose nothing. Under non-ideal conditions, you can lose quite a lot because the slave is only running a single slave thread and doesn't "read ahead" from the master while it's running a query from the master. I've suggested an enhancement to MySQL that would add a second slave thread which buffers queries from the master on the slave. It would guard against that sort of problem. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 16 days, processed 373,980,467 queries (254/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
