Friday, July 27, 2012

Installing MySQL Sandbox on CentOS 6

MySQL sandbox is used to easily deploy MySQL instances for testing.  You can easily setup a single node, master-slave nodes, master-master nodes with one command.

More information on MySQL Sandbox is listed here:

To install MySQL sandbox, you will need compiler tools and MySQL dependencies.  Please refer to

1.  Install cpan 
yum install cpan

2.  Install build dependencies
yum install perl-Test-Simple

3.  Install MySQL sandbox
cpan MySQL::Sandbox

4.  Test if Sandbox is installed:
MySQL Sandbox should not run as root

If you know what you are doing and want to
 run as root nonetheless, please set the environment
variable 'SANDBOX_AS_ROOT' to a nonzero value

5.  Test is MySQL Sandbox can create one MySQL instance:
su - <regular user>
mysql_sandbox Percona-Server-5.5.25a-rel27.1-277.Linux.x86_64.tar.gz
mysql -umsandbox -pmsandbox --host= --port=5525


dogmatic69 said...

I had a problem following this:

Can't locate Test/ in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /usr/share/perl5/ExtUtils/Command/ line 50.
make: *** [test_dynamic] Error 2
/usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports GMAX/MySQL-Sandbox-3.0.43.tar.gz
Running make install
make test had returned bad status, won't install without force


yum install perl-ExtUtils-MakeMaker perl-Test-Harness

j said...

On my end, installing perl-Test-Simple and cpan installs perl-ExtUtils-MakeMaker and perl-Test-Harness. It might be a packaging issue.