MySQL binary log rotation

We are running a MySQL replication setup, and find that the binary logs get very large, very quickly. Since MySQL didn’t come with a log rotation script, we rolled our own. Usage is simple:

At the top of the script are some definitions that you need to change for your setup:

1. MYSQL_USER MYSQL_PASS - You will need to create a user in MySQL that has the RELOAD and SUPER privileges
2. MYSQL_HOST - Where your MySQL server is located
3. MYSQL_LOG_PATH MYSQL_LOG_NAME - where your binary logs are kept, and what they are called
4. MYSQL_SLOW_LOG_NAME - the name of your slow log file
5. MAX_LOG_DAYS - the number of days worth of old logs that you want to keep

Once you’ve configured these values, whack the script into cron and run it daily.

Download the script (1.6Kb)