views:

65

answers:

1

I am thinking of writing a small MySQL provisioning for my organization's internal use. We are feeling the need as both Developers and Quality Assurance people spend a significant time in preparing databases before they can do their work.

So as a first step, I am searching for an existing open-source tool that can do basic MySQL Server provisioning. I am looking for features like:

  1. Create new instances of MySQL and return parameters like port the new instance is listening on. Edit: Why instances instead of databases? See comment below for my reason.
  2. Accept parameters specifying existing data-folder
  3. List existing running instances with some information about who started it, how long its been running etc.
  4. Stop running instances on-demand and as-scheduled
+1  A: 

you've got the mysqladmin binary which comes with the distribution for free. and you've also got SQLyog which is a GUI implementation

Haim Evgi