From: Michael R Kirkpatrick
Date: June 18 2009 4:01pm
Subject: safest binary log rotation method?
List-Archive: http://lists.mysql.com/replication/1650
Message-Id: <5FE2AE67C39C774EB4B45E21B89DCED302649ADD@EXCHANGE.ad.microcenter.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C9F02D.FA6B947F"

------_=_NextPart_001_01C9F02D.FA6B947F
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,
=20
    I am trying to determine the safest way to rotate binary logs in a
master-master replication environment on RH Linux with MySQL 5.0.45?
How do I make sure I save enough bin logs in case a slave has stopped
replicating and I won't need those logs? Trial and error is not an
option. The other side of the equation would be making sure my disk
doesn't fill up with too many log files? I don't see that there is a
mysql script in my /etc/logrotate.d folder. I would resort to a
customized script if need be but I'm not that adept at scripting. Has
anyone out there had good experience with a script for accomplishing
this job?
=20
Thanks 4 any help!!
=20
--Michael
=20
Michael Kirkpatrick
Systems Administrator
MicroElectronics, Inc.
=20
=20
=20

------_=_NextPart_001_01C9F02D.FA6B947F--