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. It's 100% free, no registration required.

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.

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

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.
–
atxdbaJan 27 '12 at 4:56