Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone know of any good tools for cnf configuration management? It's often the case I have a group of machines that has a very similar config except for a few differences such as server id or buffer pools to match their specific hardware.

I'm looking for something where I can setup a general template, tell it I want to generate some configs for that machine from that template, have it prompt me for the variables that need to be filled in and write out the .cnfs for me.

share|improve this question

closed as off-topic by Aaron Bertrand Nov 18 '14 at 15:25

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

Percona just built a tool to do just that called the Configuration Wizard. I tested it out once just to see what it would return and the results were pretty darn close to what we were using on our servers, whose cnf's were put together by highly trained mysql certified dba's.

share|improve this answer
That's a neat toy but not what I was looking for. I was thinking something more along the lines of a puppet or chef management system. One of those may actually work out for what I'm wanting but I haven't played with them enough to know for sure. – atxdba Jan 27 '12 at 4:56

Not the answer you're looking for? Browse other questions tagged or ask your own question.