7 essential tools for MySQL DBA

by jagbir on May 28, 2012

1. Percona Toolkit
Percona Toolkit (aka Maatkit and Aspersa) is must have collection of advanced command-line tools which helps in performing tasks that are too difficult or complex to perform manually.

2. Mydumper
Mydumper is a high-performance multi-threaded backup/restore tool for MySQL. It’s up to 10x faster compared to mysqldump, can take consistent snapshots and provides File compression on-the-fly. Though it’s still under active development but is well tested/used in production on some large installations.

3. MySQL Master HA
This tool helps to maintain your Master-Slave replication setup. A primary objective is automating master fail-over and slave promotion within short (usually 10-30 seconds) downtime, without suffering from replication consistency problems. It provides automated and manual master monitoring, fail-over and switching as well.

4. ESF Database Migration Toolkit
This toolkit enables you to smoothly migrate in between completely different database formats. How to migrate from IBM DB2 to MySQL easily? ESF Database Migration Toolkit will help you!

5. Xtrabackup
An excellent tool from Percona. It performs nonblocking/live backups and is the only free, open source tool that can do that.

6. Mycheckpoint
The key objective which this tool fulfill amazingly is to monitor MySQL thoroughly, from monitoring variables to detecting changes that can lead to issues, it does all this smoothly. Recommended tool for your MySQL monitoring infrastructure. ajaxMyTop (http://sourceforge.net/projects/ajaxmytop/) is another worthy Web-based tool featuring AJAX User Interface for monitoring a MySQL server.

7. Web based GUI Tools to manage MySQL
For light-weight quick tasks, SIDU is my favorite tool. People having Windows will find HeidiSQL very useful to manage MySQL, in fact, In my opinion, this is better than popular PhpMyAdmin which looks slow comparatively and have less features. I like Navicat a lot but it’s paid, SQLyog is also worthy which is though paid but a community edition exist here.

Which one is your favorite tool to manage MySQL and why? Any worthy tool that I missed here? Please put your comment below.

  • Mahesh Patil

    You have missed MONyog – http://webyog.com Web based monitoring and advisory tool for MySQL servers.

  • Bartek Bednarowicz

    Oracle’s own MySQL Workbench has come a long way (tons of bugfixes). I’m on Windows so anything quick I can’t do with Heidi I do with Workbench.

    Additionally, the new MySQL Utilities bundled with Workbench are very useful addition (http://drcharlesbell.blogspot.com/2012/05/mysql-utilities-frequently-asked.html)

  • http://www.Bytesmiths.com Jan Steinman

    Perhaps not germane to a Linux blog, but I find the free “Sequel Pro” to be the best-of-class platform-specific MySQL interface for MacOS X.

  • Pingback: Ten mien quoc te

  • Daniel

    Toad for MySQL would seem a very good addition 4 Windows users to the list as it offers some neat features like Schema Comparison, Data Comparison and Version Control publishing.

  • http://www.percona.com/ Baron Schwartz

    I prefer Adminer over phpMyAdmin. http://www.adminer.org/

  • JS

    For Windows, I think SQLyog wins hands down. I’ve used Navicat and couldn’t stand all of the windows everywhere. I don’t mind paying for good software, and SQLyog is great. I’m on a Mac now and I sorely miss it… :(

  • http://mywebsql.net MyWebSQL

    Have you tried MyWebSQL for web based GUI? Give it a try and you will love it.

  • Bartek Bednarowicz

    Daniel, I see that Toad is a multi-vendor database tool. Does it understand MySQL-specific table options when comparing schemas?

  • Daniel

    Yes, there is a MySQL specific version which works like a charm.

  • http://linuxadminzone.com jagbir

    Thanks a lot for such informative comments, I will definitely try tools suggested here.

    Any suggestion about script/tool/scenario to efficiently manage fail-over of master/slave servers like promoting slave in case master fails with minimal disruption/data loss?

  • Pingback: VoIP Telefonie

  • homebrew

    Does any tool let you manage replication with a GUI instead of having to know the code ? I have MySQL running on a Linux server, but want to manage it from a Windows machine. I am currently using Toad and Heidi, but don’t see replication options in them.

    • http://linuxadminzone.com jagbir

      Thanks for comment. I don’t recall any tool as such but you can check some options like php based mysqlreplicationmanager, mysqlrpladmin (not gui).

Previous post:

Next post: