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.

1 Answer 1


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.

  • 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, 2012 at 4:56

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