Anyone know of/have recommendations on a perl script to do replication (binary) log rotation? I have a master with multiple slaves. I need to be able to rotate the binary log of the master and get rid of any old files that the slaves aren't reading.
I'm looking for a script that will talk to the slaves, queries their status with "SHOW SLAVE STATUS", find the lowest common master file, and then connect to the master and issue a "PURGE MASTER LOG TO" query . I'm pretty sure that I could write it myself, but why "reinvent the wheel" if someone has already written this... thanks, adam a -- Adam Arrowood || http://www.gatech.edu/adam || [EMAIL PROTECTED] Office of Information Technology/O&E/CS || (404) 894-0372 Georgia Institute of Technology, Atlanta, GA USA --------------------------------------------------------------------- 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
