MySQL Sandbox on Ubuntu

Helpful posts:
http://www.slideshare.net/datacharmer/mysql-sandbox-3
http://nicksda.apotomo.de/2013/10/running-multiple-mysql-servers-with-different-versions-on-the-same-machine/
http://tech-for-me.blogspot.com/2012/07/installing-mysql-sandbox-on-centos-6.html

Check if cpan is insalled
If not, suo apt-get install cpan

Install libraries needed for newer mysql
apt-get install libaio1 libaio-dev

Install mysql sandbox
sudo cpan MySQL::Sandbox

Test that it’s working
make_sandbox

Download MySQL tar balls
ftp://mirror.csclub.uwaterloo.ca/mysql/Downloads/
You can download the MySQL tarball from any MySQL mirror. It's important to get the non RPM, Intel C/C++ compiled, glibc-2.3 version (look for a tar.gz file with "icc" in the filename) for example if you want version 5.1:

Example, download MySQL 5.0 and 5.7
wget ftp://mirror.csclub.uwaterloo.ca/mysql/Downloads/MySQL-5.0/mysql-5.0.95-linux-i686-glibc23.tar.gz
wget ftp://mirror.csclub.uwaterloo.ca/mysql/Downloads/MySQL-5.7/mysql-5.7.8-rc-linux-glibc2.5-i686.tar.gz

NOTE, you need to use the i686 version for ubuntu running in VM on OS X. Use the x86_64 version when running Ubunutu directly like in AWS

Install mysql instances
make_sandbox ~/mysql-5.0.95-linux-i686-glibc23.tar.gz