Flusing MySQL replication logs

Thu, Feb 28, 2008 04:07 PM

MySQL master servers won't remove their logs automatically when slaves are done with them. You can set expire_logs_days to remove them after a certain number of days. But, you are not assured that a slave is done with the logs. So, we wrote a script to connect to slaves and then purge logs on the master servers. It works for us. Your mileage may vary. BSD style license. Enjoy.

flush_mysql_master.php.gz

6 comments

anonymous Says:

The file is indeed corrupted, even after I tried with gzip -d filename. Can you please post it again?!

doughboy Says:

Apparently my proxies are acting up. I need to figure out why they are compressing non text content.

I updated the link in the post to this working link:
http://content.dealnews.com/dealnews/developers/flush_mysql_master.php.gz

otis Says:

The zip file seems to be corrupted

Foobar Says:

It is not a ZIP. It is Gzipped as the extension gz states and it extracts just fine.

Links for 2008-02-28 [del.icio.us] : e-Spot.se Says:

[...] Flusing MySQL replication logs « Ramblings of a web guy [...]

Propiedad Privada » Blog Archive » Ens Says:

[...] Flusing MySQL replication logs [...]

Comments are disabled for this post.