A Useful Tool to Centrally Manage Many MySQL Instances

Posted in: Technical Track

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.

Interested in working with Sheeri? Schedule a tech call.

2 Comments. Leave new

Sometimes, even a command line guy likes a GUI | Reseh Portal
May 15, 2010 2:43 am

[…] 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 […]

Reply
Sometimes, even a command line guy likes a GUI « JZ Talk Blogger
May 16, 2010 3:42 am

[…] 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 […]

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *