FLUSH LOGS in the master and all is ok? binlog will be rotate and slaves will see it, continue to work and update master.info?
Regads Il 15:31, giovedì 11 aprile 2002, hai scritto: > FLUSH LOGS safely rotates the binlog. > > Davide Giunchi wrote: > > You are right, but my master generate about 150Mb of binlog x day, i a > > slave fail after 4 day it will reexec a lot of query and take some time. > > how can i safely rotate the log in master+slaves without restarting them? > > The Mysql manual explain how to rotate from a `hostnmae`-bin`.002 (or > > > 001) file, but what about if the binlog is always the same? > > I could do a FLUSH MASTER in the master and then FLUSH SLAVE in the > > slaves, it wouldn't loose the sync? > > -- Davide Giunchi. Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it GPG Key available on http://www.keyserver.net Fingerprint: 8075 363A B4FA 0196 FEEC AF9C 19A9 66C7 CDAB D0D5 --------------------------------------------------------------------- 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
