Forum : How do I rotate replication logs?
Brief description  about Online courses   join in Online courses
View Abhijit  Paul 's Profile

How do I rotate replication logs?

How do I rotate replication logs????
Asked by Abhijit Paul | Mar 19, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi Abhijit,
In Version 3.23.28 you should use PURGE MASTER LOGS TO command after determining which logs can be deleted, and optionally backing them up first. In earlier versions the process is much more painful, and cannot be safely done without stopping all the slaves in the case that you plan to re-use log names. You will need to stop the slave threads, edit the binary log index file, delete all the old logs, restart the master, start slave threads,and then remove the old log files.
Mar 19, 2010