Diamond Notes

The MySQL Sandbox is a way to set up a new test server or servers in just a few seconds.

Features

• not an official MySQL product
• GPL
• installs from a tarball in a few seconds
• installs side servers, not the main one (doesn’t disturb running servers!!!)
• creates a separate environment — data directory, port and socket

Sandbox commands

• start
• stop
• clear ( creates a fresh installation)
• use
• start_all
• stop_all
• clear_all
• multi_cmd

m for master and s for slave

quick install

./express_install.pl /path/mysql_os_5.1.tar.gz

This would install a single server

For replication

./set_replication.pl /path/mysql_os.tar.gz

for multiple servers

./set_many 5.0.51

and multiple servers of different versions

./set _custom_many.pl 5.0.51 5.1.23 6.0.5

(can specify full path for configurations

–how_man_nodes option creates theh specified number of nodes (–how_many_nodes=4 creates four hosts)

–help prints the help screen

Fine Tuning

./express_install.pl /path/mysql_OS.tar.gz [option] [option] …

./express_install.pl /path/mysql-OS.tar.gz –my_file={small|medium|large|hug}

or you can specify a path to a custom my.cnf

Commands

start simply start the server, creates the pid and socket files

stop stops the server

clear stops the server and removes all files in the data directory and clears the test database

use start the mysql client

• uses the credentials in the my_sandbox.cnf fiel
• deafault username and password msandbox/msandbox and root password of msandbox

my {sqldump|sqlbinlog|sqladmin|}

For Replication

start_all

starts the master and then the slave

stop _all

stops the slave and then the master

clear_all

clear all the slaves and then the master

For Multi-node Sandbox

start_all

stop_all

clear_all

multi_cmd

executes command on all nodes

This is a really cool looking tool.  I have heard of it before, but never taken the time to download it and evaluate it.  It would be really nice to use this on our test machine.  If you do much testing at all I would recommend you download it and take it for a spin!!

Resources

http://sf.net/prjects/mysql-sandbox