At the 2013 MySQL Connect Conference, Sheeri Cabral and Brandon Johnson of Mozilla talk about how they manage hundreds of MySQL servers efficiently using an open source puppet module.
The concepts can be easily adapted to Chef or any other management solution.
The slides can be found at http://bit.ly/puppet-mysql-slides
The code is at https://github.com/mozilla-it/puppet-...