A Useful Tool to Centrally Manage Many MySQL Instances

May 13, 2010 / By Sheeri Cabral

Tags: , ,

I have been talking with a group of folks who have been making a product that has lots of free functionality, including the ability to centrally manage many MySQL instances. The administration functions include starting and stopping MySQL, seeing status and system variables, seeing and managing the MySQL config file (/etc/my.cnf), seeing and managing accounts, a small dashboard of overall health graphs, and more.

With this free tool you can look at and manage local and remote databases. It supports ssh tunneling, including ssh using password-protected ssh keys. It’s pretty neat, and I have been working with the product manager to add features. I think this took will become the de facto standard for centralized GUI administration of MySQL.

The tool is
MySQL workbench….Surprise! One of the best new features for the administrator is that you can now create an administration connection for an existing workbench connection with a click of a button, instead of having to enter in all that information again.

I use the “developer” version, 5.2.21. Note that the 5.1 version does not have administration capabilities.

2 Responses to “A Useful Tool to Centrally Manage Many MySQL Instances”

  • Sometimes, even a command line guy likes a GUI | Reseh Portal says:

    [...] of the items I need.Now, if I couple the above issues with the notion that MySQL Workbench is A Useful Tool to Centrally Manage Many MySQL Instances, I think that every command line enthusiast should give this tool a try.Lastly, I should mention [...]

  • Sometimes, even a command line guy likes a GUI « JZ Talk Blogger says:

    [...] of the items I need.Now, if I couple the above issues with the notion that MySQL Workbench is A Useful Tool to Centrally Manage Many MySQL Instances, I think that every command line enthusiast should give this tool a try.Lastly, I should mention [...]

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>