Open Query

There are many tools out there. Here we don't intend to provide a complete overview, those exist elsewhere. We just want to list the few that we deem particularly useful. Please do feel free to add a comment with your own favourites!

Note that Open Query does not re-sell any tools. This is a conscious decision, providing you with additional assurance that we are independent in our advice and recommendations.

• Maatkit - (Perl) is a handy set of tools, with specific trickery for synchronising MySQL Replication. If you run on Windows, get ActiveState Perl (free, just requires registration).
• Multi-Master Replication Enabler - a script to handle multi-source replication to a slave (round-robin fashion).
• Support foo for doing multi-master failover:
  • MMM by Percona
  • Flipper by Proven Scaling
  • Heatbeat by the Linux High Availability Project
• Nagios - Enterprice grade Open Source host, service and network monitoring program.
  • Nagios Scripts for MySQL
• Cacti - RRD Based graphing solution
  • Cacti templates for MySQL (by Baron Schwartz)
• myLVMbackup - Use LVM for safe InnoDB backup snapshots (by Lenz Grimmer)
• mysqladmin - standard with any MySQL installation
  • mysqladmin debug (make MySQL server dump locking info to errorlog)
• vmstat - Track virtual memory/swap use on Linux
• iostat - Track I/O issues on Linux
• phpMyAdmin - Web based MySQL Administration (PHP)
• MONyog - Web based monitoring