• home
  • words
  • pictures
  • contact
 
 

Tag Cloud

motorcycle mysql motorcycle racing battery electric car fzr400 environmentally friendly car electric bike batteries road racing common sense police lathe engineering derby phoenix google britain alistair darling budget cadwell tt europe electric motorcycle security paris

Browse by Date

  • July 2010
  • June 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008

Subscribe via RSS

Subscribe

A cheeky MySQL replication log flusher

Posted by Andrew on 1 February 2010 | 0 Comments

Tags: binlogs, event scheduler, mysql, replication, stored procedure

Rather than relying on the expire_log_days feature to ensure your replicating master doesn't fill up with obsolete binary logfiles, you can deploy this little SQL script.  It's a bit cheeky and dirty, but it works.

0 comments | Read the full post

Copyright © 2010 kickingtyres.com | site created by Craftspeed | sitemap