On Sat, Dec 15, 2001 at 12:55:28PM +1100, Tim Wood wrote: > Hi Peter > > We use the mysql replication stuff here. Its very reliable, and the > synchronization between master & slave is pretty much instant. > > There does seem to be one problem when the master rotates its > transaction logs, the slave does not pick it up and you need to > manually issue "reset slave" to get it to go to the start of the > first transaction log
That shouldn't happen. We've had a few hundred log rotations without any real hiccups. I assume you're talking about the automatic log rotation based on file size? Or via FLUSH LOGS? 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,962,449 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