MySQL Sandbox: Treat MySQL Instances like Virtual Machines

I remember meeting Giuseppe Maxia (aka The Data Charmer), probably the most famous Italian MySQL enthusiast and hacker, back at what must have been the first MySQL Conference. At the time I’d seen him on mailing lists and knew he gave talks from time to time, but I had no idea of the useful software he’d be creating. This week, I’d like give you a tour of one of his projects: MySQL Sandbox.

I think of it as a sort of virtual server manager for MySQL instances. In fact, the one-line intro on the project web site hints at that:

Quick painless install of side MySQL server in isolation. MySQL Sandbox is a tool for installing one or more MySQL servers in isolation, without affecting other servers.

Isolation tends to be the hardest thing to get right (aside from the automation itself) when trying to bring up multiple…

1. InnoDB Performance Monitoring with innotop
2. MySQL Upgrade Testing
3. Some Reasonable Defaults for MySQL Settings
4. Hacking with CouchDB
5. An Introduction to CouchDB