How about if master crashes?...is there anyway to recover?...aside from
copying all stuff from slave to master...
R.B.Roa
PhilCom Corporation
Tel. No. 858-xxxx
Mobile No. (63) (919-xxxxxxx)
-----Original Message-----
From: Davide Giunchi [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 5:37 PM
To: Marc Prewitt
Cc: [EMAIL PROTECTED]
Subject: Re: binlog and replication stuff
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?
Regards
> When a slave crashes or reboots, it should start replicating from
where it
> left off--at least ours do work that way. The current replication
state
> is saved in master.info on the slave and when it starts up again,
it
> should read that file and resume reading the binlog on the master
where it
> left off. The master.info file contains the binlog#, location,
user,
> password, etc... neccessary to restart replication.
>
> In you case, does the slave give you any error messages in it's
error log
> about why it couldn't resume replication? If it doesn't try to
start
> replication, have you tried doing a 'slave start' on the slave
after it
> reboots?
>
> -Marc
--
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
---------------------------------------------------------------------
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