'HOW TO' Category

• Percona Tease Kit

  April 16, 2012

  Percona you know I love you.  You have the largest brains working with MySQL. Your toolkit (formerly Maatkit and Aspersa) is a real gift to the MySQL community. But stop teasing us with webinars about what it can do and show us how to use it. The Percona ToolKit needs a cookbook. The documentation is […]

  posted in Commentary, HOW TO by mark

• The Full Monty – Version 2

  February 14, 2012

  Installing MySQL on CentOS 6.2 with PaceMaker, MHA and more When I work with High Availability software, I’m reminded of the maze in the original computer adventure game “You are Lost in a maze of twisty-turny passages all alike…”. If you search the web for HA programs you will find many well maintained projects all […]

  posted in Commentary, DRDB, HA, Heartbeat, HOW TO by mark

• What can I DROP?

  September 30, 2011

  So you have inherited a MySQL server and no one know what applications are use what databases.   Space is every tight and every night transactions logs almost fill your hard disk.  The server was once used as a replication server and it seems every database the company uses is duplicated here. You could do […]

  posted in HOW TO by admin

• PostGIS 1.5 in Postgresql 9.0 install on CentOS 5.6

  July 14, 2011

  I love short and consist install instructions. I know this is a MySQL blog but our good friend PostGreSQL has a great GIS library. This is what I learned upgrading our PostGIS system to GIS 1.5. Much thanks to Jeremy Tunnell for give this document it’s start. Start with CentOS 5.6 x86_64 basic install. Add […]

  posted in CentOS, HOW TO by admin