Actually, we've been runnning mySQL replication for ~4 months now We've never had a problem with the slaved machines losing their position in the log, nor do we ever run a reset slave... Try the following script instead out of cron... #!/bin/sh
FIRST_LOG=`echo 'SHOW MASTER LOGS ;' | mysql|head -3|tail -1` export FIRST_LOG echo " FLUSH LOGS; PURGE MASTER LOGS TO '$FIRST_LOG'; " | mysql Basically, find the oldest log, start a new log, remove oldest log. Run a couple of 'flush logs' to get a couple of bin log files, and then start using the script... (throw it in cron) After that, you will have a running history so that slow servers can connect and grab their data. We're storing ~360H worth of history broken up into 2H files... (we're up to host-bin.3281 right now..) (Yes, we have had machines off-line for 2 weeks, and when they came back on-line, they caught up completely with no user intervention...) Scott V 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 > > Tim > ----- Original Message ----- > From: Peter M. Perchansky > To: > Sent: Saturday, December 15, 2001 10:36 AM > Subject: Question on mySQL replication > > > > Greetings everyone: > > > > RE: http://www.mysql.com/doc/R/e/Replication.html > > > > How frequently does each slave get data from the master? > > > > 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? > > > > Thank you. > > > > > --------------------------------------------------------------------- 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
