MySQL Sandbox Usage Examples
[edit] MySQL Sandbox Usage Examples
WORK IN PROGRESS
[edit] Setting the Sandbox directory
[mysql_sandbox_1.21]$ export SANDBOX_HOME=$HOME/sandboxes [mysql_sandbox_1.21]$ ls ~/sandboxes ls: /Users/gmax/sandboxes: No such file or directory
[edit] Single Sandbox from tarball
[mysql_sandbox_1.21]$ ./express_install.pl ~/install/build/50/mysql-5.0.64-darwin9.2.2-i386.tar.gz
unpacking /Users/gmax/install/build/50/mysql-5.0.64-darwin9.2.2-i386.tar.gz
Executing ./install.pl --basedir=/Users/gmax/install/build/50/5.0.64 \
--sandbox_directory=msb_5_0_64 \
--install_version=5.0 \
--sandbox_port=5064 \
--no_ver_after_name
The MySQL Sandbox, version 1.21 09-Jun-2008
(C) 2006,2007,2008 Giuseppe Maxia, MySQL AB
installing with the following parameters:
home_directory = /Users/gmax/sandboxes
sandbox_directory = msb_5_0_64
sandbox_port = 5064
datadir_from = script
install_version = 5.0
basedir = /Users/gmax/install/build/50/5.0.64
my_file =
operating_system_user = gmax
db_user = msandbox
db_password = msandbox
my_clause =
prompt_prefix = mysql
force = 0
no_ver_after_name = 1
verbose = 0
load_grants = 1
no_load_grants = 0
do you agree? ([Y],n)
loading grants
sandbox server started
installation options saved to current_options.conf.
To repeat this installation with the same options,
use ./install.pl --conf_file=current_options.conf
----------------------------------------
Your sandbox server was installed in /Users/gmax/sandboxes/msb_5_0_64
[edit] Single Sandbox from existing expanded tarballs
[mysql_sandbox_1.21]$ ls $HOME/opt/mysql/ 5.0.51 5.0.64 5.1.23 5.1.24 5.1.26 6.0.6
[edit] Sandbox 5.0.51
[mysql_sandbox_1.21]$ ./express_install.pl 5.0.51 --no_confirm
Executing ./install.pl --basedir=/Users/gmax/opt/mysql/5.0.51 \
--sandbox_directory=msb_5_0_51 \
--install_version=5.0 \
--sandbox_port=5051 \
--no_ver_after_name \
--no_confirm
The MySQL Sandbox, version 1.21 09-Jun-2008
(C) 2006,2007,2008 Giuseppe Maxia, MySQL AB
installing with the following parameters:
home_directory = /Users/gmax/sandboxes
sandbox_directory = msb_5_0_51
sandbox_port = 5051
datadir_from = script
install_version = 5.0
basedir = /Users/gmax/opt/mysql/5.0.51
my_file =
operating_system_user = gmax
db_user = msandbox
db_password = msandbox
my_clause =
prompt_prefix = mysql
force = 0
no_ver_after_name = 1
verbose = 0
load_grants = 1
no_load_grants = 0
loading grants
sandbox server started
installation options saved to current_options.conf.
To repeat this installation with the same options,
use ./install.pl --conf_file=current_options.conf
----------------------------------------
Your sandbox server was installed in /Users/gmax/sandboxes/msb_5_0_51
[edit] Sandbox directory
# The sandbox directory was successfully created [mysql_sandbox_1.21]$ ls -lh ~/sandboxes total 40 -rwxr-xr-x 1 gmax staff 60B Jun 10 15:25 clear_all drwxr-xr-x 3 gmax staff 612B Jun 10 15:25 msb_5_0_51 -rwxr-xr-x 1 gmax staff 1.9K Jun 10 15:25 sandbox_action -rwxr-xr-x 1 gmax staff 60B Jun 10 15:25 start_all -rwxr-xr-x 1 gmax staff 59B Jun 10 15:25 stop_all -rwxr-xr-x 1 gmax staff 58B Jun 10 15:25 use_all
[edit] Sandbox 5.1.24
[mysql_sandbox_1.21]$ ./express_install.pl 5.1.24 --no_confirm
Executing ./install.pl --basedir=/Users/gmax/opt/mysql/5.1.24 \
--sandbox_directory=msb_5_1_24 \
--install_version=5.1 \
--sandbox_port=5124 \
--no_ver_after_name \
--no_confirm
The MySQL Sandbox, version 1.21 09-Jun-2008
(C) 2006,2007,2008 Giuseppe Maxia, MySQL AB
installing with the following parameters:
home_directory = /Users/gmax/sandboxes
sandbox_directory = msb_5_1_24
sandbox_port = 5124
datadir_from = script
install_version = 5.1
basedir = /Users/gmax/opt/mysql/5.1.24
my_file =
operating_system_user = gmax
db_user = msandbox
db_password = msandbox
my_clause =
prompt_prefix = mysql
force = 0
no_ver_after_name = 1
verbose = 0
load_grants = 1
no_load_grants = 0
loading grants
sandbox server started
installation options saved to current_options.conf.
To repeat this installation with the same options,
use ./install.pl --conf_file=current_options.conf
----------------------------------------
Your sandbox server was installed in /Users/gmax/sandboxes/msb_5_1_24
[edit] Sandbox 5.1.26
[mysql_sandbox_1.21]$ ./express_install.pl 5.1.26 --no_confirm
Executing ./install.pl --basedir=/Users/gmax/opt/mysql/5.1.26 \
--sandbox_directory=msb_5_1_26 \
--install_version=5.1 \
--sandbox_port=5126 \
--no_ver_after_name \
--no_confirm
The MySQL Sandbox, version 1.21 09-Jun-2008
(C) 2006,2007,2008 Giuseppe Maxia, MySQL AB
installing with the following parameters:
home_directory = /Users/gmax/sandboxes
sandbox_directory = msb_5_1_26
sandbox_port = 5126
datadir_from = script
install_version = 5.1
basedir = /Users/gmax/opt/mysql/5.1.26
my_file =
operating_system_user = gmax
db_user = msandbox
db_password = msandbox
my_clause =
prompt_prefix = mysql
force = 0
no_ver_after_name = 1
verbose = 0
load_grants = 1
no_load_grants = 0
loading grants
sandbox server started
installation options saved to current_options.conf.
To repeat this installation with the same options,
use ./install.pl --conf_file=current_options.conf
----------------------------------------
Your sandbox server was installed in /Users/gmax/sandboxes/msb_5_1_26
[edit] Sandbox 6.0.6
[mysql_sandbox_1.21]$ ./express_install.pl 6.0.6 --no_confirm
Executing ./install.pl --basedir=/Users/gmax/opt/mysql/6.0.6 \
--sandbox_directory=msb_6_0_6 \
--install_version=6.0 \
--sandbox_port=6060 \
--no_ver_after_name \
--no_confirm
The MySQL Sandbox, version 1.21 09-Jun-2008
(C) 2006,2007,2008 Giuseppe Maxia, MySQL AB
installing with the following parameters:
home_directory = /Users/gmax/sandboxes
sandbox_directory = msb_6_0_6
sandbox_port = 6060
datadir_from = script
install_version = 6.0
basedir = /Users/gmax/opt/mysql/6.0.6
my_file =
operating_system_user = gmax
db_user = msandbox
db_password = msandbox
my_clause =
prompt_prefix = mysql
force = 0
no_ver_after_name = 1
verbose = 0
load_grants = 1
no_load_grants = 0
loading grants
sandbox server started
installation options saved to current_options.conf.
To repeat this installation with the same options,
use ./install.pl --conf_file=current_options.conf
----------------------------------------
Your sandbox server was installed in /Users/gmax/sandboxes/msb_6_0_6
[edit] Replication Sandbox
[edit] Replicated Sandbox 5.0.64
[mysql_sandbox_1.21]$ ./set_replication.pl ~/install/build/50/mysql-5.0.64-darwin9.2.2-i386.tar.gz installing and starting master installing slave 1 installing slave 2 starting slave 1 sandbox server started starting slave 2 sandbox server started initializing slave 1 initializing slave 2 replication directory installed on /Users/gmax/sandboxes/rsandbox_5_0_64
[edit] Replicated Sandbox 5.0.51
[mysql_sandbox_1.21]$ ./set_replication.pl 5.0.51 installing and starting master installing slave 1 installing slave 2 starting slave 1 sandbox server started starting slave 2 sandbox server started initializing slave 1 initializing slave 2 replication directory installed on /Users/gmax/sandboxes/rsandbox_5_0_51
[edit] Replicated Sandbox 5.1.24
[mysql_sandbox_1.21]$ ./set_replication.pl 5.1.24 installing and starting master installing slave 1 installing slave 2 starting slave 1 sandbox server started starting slave 2 sandbox server started initializing slave 1 initializing slave 2 replication directory installed on /Users/gmax/sandboxes/rsandbox_5_1_24
[edit] Replicated Sandbox 5.1.26
[mysql_sandbox_1.21]$ ./set_replication.pl 5.1.26 installing and starting master installing slave 1 installing slave 2 starting slave 1 sandbox server started starting slave 2 sandbox server started initializing slave 1 initializing slave 2 replication directory installed on /Users/gmax/sandboxes/rsandbox_5_1_26
[edit] Multiple server Sandbox
[edit] Multiple server Sandbox 5.0.64
[mysql_sandbox_1.21]$ ./set_many.pl ~/install/build/50/mysql-5.0.64-darwin9.2.2-i386.tar.gz installing node 1 installing node 2 installing node 3 group directory installed on /Users/gmax/sandboxes/multi_msb_5_0_64
[edit] Multiple server Sandbox 5.0.51, 5.1.24, 5.1.26, 6.0.6
[mysql_sandbox_1.21]$ ./set_many.pl 5.0.51 ; ./set_many.pl 5.1.24 ; ./set_many.pl 5.1.26 ; ./set_many.pl 6.0.6 installing node 1 installing node 2 installing node 3 group directory installed on /Users/gmax/sandboxes/multi_msb_5_0_51 installing node 1 installing node 2 installing node 3 group directory installed on /Users/gmax/sandboxes/multi_msb_5_1_24 installing node 1 installing node 2 installing node 3 group directory installed on /Users/gmax/sandboxes/multi_msb_5_1_26 installing node 1 installing node 2 installing node 3 group directory installed on /Users/gmax/sandboxes/multi_msb_6_0_6
[edit] How many servers so far?
[mysql_sandbox_1.21]$ pgrep mysqld_safe | wc -l
32
[edit] using a single sandbox
[mysql_sandbox_1.21]$ cd $HOME/sandboxes/msb_5_1_24/ [msb_5_1_24]$ ls COPYING clear load_grants restart README current_options.conf my start USING data my.sandbox.cnf stop VERSION grants.mysql proxy_start use
[msb_5_1_24]$ ./use test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.24-rc Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql [localhost] {msandbox} (test) > exit
Bye
[msb_5_1_24]$ cd $HOME/sandboxes/msb_6_0_6 [msb_6_0_6]$ ./use test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 6.0.6-alpha Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql [localhost] {msandbox} (test) > show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 6060 |
+---------------+-------+
1 row in set (0.00 sec)
mysql [localhost] {msandbox} (test) > exit
[edit] Using a replication system
[msb_6_0_6]$ cd $HOME/sandboxes/rsandbox_5_0_64 [rsandbox_5_0_64]$ ./m Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.0.64-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
master [localhost] {msandbox} ((none)) > use test
Database changed
master [localhost] {msandbox} (test) > create table t1 (id int);
Query OK, 0 rows affected (0.00 sec)
master [localhost] {msandbox} (test) > exit
Bye
[rsandbox_5_0_64]$ ./s1 test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.0.64-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
slave1 [localhost] {msandbox} (test) > show tables;
+----------------+
| Tables_in_test |
+----------------+
| t1 |
+----------------+
1 row in set (0.00 sec)
slave1 [localhost] {msandbox} (test) > exit
Bye
[rsandbox_5_0_64]$ ./multi_cmd "show tables from test" # master Tables_in_test t1 # server: 1: Tables_in_test t1 # server: 2: Tables_in_test t1
[rsandbox_5_0_64]$ ./multi_cmd "select @@server_id, version()" # master @@server_id version() 1 5.0.64-log # server: 1: @@server_id version() 101 5.0.64-log # server: 2: @@server_id version() 102 5.0.64-log
[rsandbox_5_0_64]$ ./clear_all executing "clear" on slave 1 /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_64/node1/my.sandbox.cnf shutdown executing "clear" on slave 2 /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_64/node2/my.sandbox.cnf shutdown executing "clear" on master /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_64/master/my.sandbox.cnf shutdown
[rsandbox_5_0_64]$ ls clear_all master needs_initialization run_proxy start_all initialize_slaves multi_cmd node1 s1 stop_all m node2 s2
[rsandbox_5_0_64]$ ./start_all executing "start" on master sandbox server started executing "start" on slave 1 sandbox server started executing "start" on slave 2 sandbox server started initializing slave 1 initializing slave 2
[rsandbox_5_0_64]$ ls clear_all master node1 s1 stop_all initialize_slaves multi_cmd node2 s2 m run_proxy start_all
[edit] Using a multiple server sandbox
[multi_msb_5_1_26]$ cd $HOME/sandboxes/multi_msb_5_1_26/
[multi_msb_5_1_26]$ ls
clear_all n1 n3 node2 start_all
multi_cmd n2 node1 node3 stop_all
[multi_msb_5_1_26]$ ./n1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.26-rc-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
node1 [localhost] {msandbox} ((none)) > exit
Bye
[multi_msb_5_1_26]$ ./multi_cmd "create table test.t1 (id int)" # server: 1: # server: 2: # server: 3: [multi_msb_5_1_26]$ ./multi_cmd "insert into test.t1 values (@@server_id)" # server: 1: # server: 2: # server: 3: [multi_msb_5_1_26]$ ./multi_cmd "select * from test.t1" # server: 1: id 101 # server: 2: id 102 # server: 3: id 103 [multi_msb_5_1_26]$ ./stop_all executing "stop" on node 1 /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_26/node1/my.sandbox.cnf shutdown executing "stop" on node 2 /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_26/node2/my.sandbox.cnf shutdown executing "stop" on node 3 /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_26/node3/my.sandbox.cnf shutdown
[multi_msb_5_1_26]$ ./start_all executing "start" on node 1 sandbox server started executing "start" on node 2 sandbox server started executing "start" on node 3 sandbox server started
[edit] using the sandbox directory commands
[sandboxes]$ cd $HOME/sandboxes/ [sandboxes]$ ls clear_all msb_5_1_26 multi_msb_5_1_24 rsandbox_5_0_64 start_all msb_5_0_51 msb_6_0_6 multi_msb_5_1_26 rsandbox_5_1_24 stop_all msb_5_0_64 multi_msb_5_0_51 multi_msb_6_0_6 rsandbox_5_1_26 use_all msb_5_1_24 multi_msb_5_0_64 rsandbox_5_0_51 sandbox_action
[sandboxes]$ ls *all clear_all start_all stop_all use_all
[sandboxes]$ ./use_all "select version(), @@server_id" | grep "^[0-9]" 5.0.51a 0 5.0.64 0 5.1.24-rc 0 5.1.26-rc 0 6.0.6-alpha 0 5.0.51a-log 101 5.0.51a-log 102 5.0.51a-log 103 5.0.64-log 101 5.0.64-log 102 5.0.64-log 103 5.1.24-rc-log 101 5.1.24-rc-log 102 5.1.24-rc-log 103 5.1.26-rc-log 101 5.1.26-rc-log 102 5.1.26-rc-log 103 6.0.6-alpha-log 101 6.0.6-alpha-log 102 6.0.6-alpha-log 103 5.0.51a-log 1 5.0.51a-log 101 5.0.51a-log 102 5.0.64-log 1 5.0.64-log 101 5.0.64-log 102 5.1.24-rc-log 1 5.1.24-rc-log 101 5.1.24-rc-log 102 5.1.26-rc-log 1 5.1.26-rc-log 101 5.1.26-rc-log 102
[sandboxes]$ ./stop_all -- executing /Users/gmax/sandboxes/msb_5_0_51/stop /Users/gmax/opt/mysql/5.0.51/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/msb_5_0_51/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/msb_5_0_64/stop /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/msb_5_0_64/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/msb_5_1_24/stop /Users/gmax/opt/mysql/5.1.24/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/msb_5_1_24/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/msb_5_1_26/stop /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/msb_5_1_26/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/msb_6_0_6/stop /Users/gmax/opt/mysql/6.0.6/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/msb_6_0_6/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/multi_msb_5_0_51/stop_all executing "stop" on node 1 /Users/gmax/opt/mysql/5.0.51/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_0_51/node1/my.sandbox.cnf shutdown executing "stop" on node 2 /Users/gmax/opt/mysql/5.0.51/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_0_51/node2/my.sandbox.cnf shutdown executing "stop" on node 3 /Users/gmax/opt/mysql/5.0.51/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_0_51/node3/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/multi_msb_5_0_64/stop_all executing "stop" on node 1 /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_0_64/node1/my.sandbox.cnf shutdown executing "stop" on node 2 /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_0_64/node2/my.sandbox.cnf shutdown executing "stop" on node 3 /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_0_64/node3/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/multi_msb_5_1_24/stop_all executing "stop" on node 1 /Users/gmax/opt/mysql/5.1.24/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_24/node1/my.sandbox.cnf shutdown executing "stop" on node 2 /Users/gmax/opt/mysql/5.1.24/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_24/node2/my.sandbox.cnf shutdown executing "stop" on node 3 /Users/gmax/opt/mysql/5.1.24/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_24/node3/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/multi_msb_5_1_26/stop_all executing "stop" on node 1 /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_26/node1/my.sandbox.cnf shutdown executing "stop" on node 2 /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_26/node2/my.sandbox.cnf shutdown executing "stop" on node 3 /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_5_1_26/node3/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/multi_msb_6_0_6/stop_all executing "stop" on node 1 /Users/gmax/opt/mysql/6.0.6/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_6_0_6/node1/my.sandbox.cnf shutdown executing "stop" on node 2 /Users/gmax/opt/mysql/6.0.6/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_6_0_6/node2/my.sandbox.cnf shutdown executing "stop" on node 3 /Users/gmax/opt/mysql/6.0.6/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/multi_msb_6_0_6/node3/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/rsandbox_5_0_51/stop_all executing "stop" on slave 1 /Users/gmax/opt/mysql/5.0.51/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_51/node1/my.sandbox.cnf shutdown executing "stop" on slave 2 /Users/gmax/opt/mysql/5.0.51/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_51/node2/my.sandbox.cnf shutdown executing "stop" on master /Users/gmax/opt/mysql/5.0.51/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_51/master/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/rsandbox_5_0_64/stop_all executing "stop" on slave 1 /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_64/node1/my.sandbox.cnf shutdown executing "stop" on slave 2 /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_64/node2/my.sandbox.cnf shutdown executing "stop" on master /Users/gmax/install/build/50/5.0.64/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_0_64/master/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/rsandbox_5_1_24/stop_all executing "stop" on slave 1 /Users/gmax/opt/mysql/5.1.24/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_1_24/node1/my.sandbox.cnf shutdown executing "stop" on slave 2 /Users/gmax/opt/mysql/5.1.24/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_1_24/node2/my.sandbox.cnf shutdown executing "stop" on master /Users/gmax/opt/mysql/5.1.24/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_1_24/master/my.sandbox.cnf shutdown -- executing /Users/gmax/sandboxes/rsandbox_5_1_26/stop_all executing "stop" on slave 1 /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_1_26/node1/my.sandbox.cnf shutdown executing "stop" on slave 2 /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_1_26/node2/my.sandbox.cnf shutdown executing "stop" on master /Users/gmax/opt/mysql/5.1.26/bin/mysqladmin --defaults-file=/Users/gmax/sandboxes/rsandbox_5_1_26/master/my.sandbox.cnf shutdown