sb shortcuts don't work with replication sandboxes

[Stéphane Combaudon]

Hi Giuseppe,

I'm using MySQL Sandbox 3.0.30 on Debian Wheezy.

After installing a replication sandbox, I'm not able to use sb shortcuts to connect to the sandboxes:

stephane@wheezy:~$ make_replication_sandbox /home/stephane/mysql-5.5.29-linux2.6-i686.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 in $HOME/sandboxes/rsandbox_mysql-5_5_29
stephane@wheezy:~$ sb r5529
can't find a matching sandbox for 5529

However, all servers are running fine and I can connect to them "manually":

stephane@wheezy:~$ cd sandboxes/rsandbox_mysql-5_5_29/
stephane@wheezy:~/sandboxes/rsandbox_mysql-5_5_29$ ./m
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.29-log MySQL Community Server (GPL)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

master [localhost] {msandbox} ((none)) >

If I install a single server sandbox, the sb shortcut works as expected.

--
Stephane

[Giuseppe Maxia (giuseppe-maxia)]

Try this: sb r5.5.29

[Stéphane Combaudon (stephane-combaudon)]

Thanks for the tip, but I still think there's an issue as "sb r5.5.29" will create another replication sandbox, which you can see here:

stephane@wheezy:~/sandboxes$ ls -l
[...]
drwxr-xr-x 5 stephane stephane 4096 févr. 8 15:17 rsandbox_5_5_29
drwxr-xr-x 5 stephane stephane 4096 févr. 8 12:27 rsandbox_mysql-5_5_29
[..]

The rsandbox_mysql-5_5_29/ directory was created with make_replication_sandbox while the rsandbox_5_5_29/ directory was created with sb r5.5.29.

And sb r5529 now works but it is still not a shortcut for the sandboxes created with make_replication_sandbox.

--
Stephane

[Giuseppe Maxia (giuseppe-maxia)]

Stephane,
The purpose of the sb shortcut is to add an advanced layer of command shortening, on top of something like

make_replication_sandbox 5.5.29

This only works if you are using $SANDBOX_BINARY. If not, the shortcuts may backfire.

To take advantage of this feature, the recommended procedure is:

mkdir -p $HOME/opt/mysql
# or set SANDBOX_BINARY to the place where you have expanded the tarballs

make_sandbox --export_binaries /home/stephane/mysql-5.5.29-linux2.6-i686.tar.gz

# when asked for confirmation, say 'n'

Then, you can run

sb r5.5.29

[Stéphane Combaudon (stephane-combaudon)]

Giuseppe,

Thanks for you time and your explanations.

I've been using the sb shortcuts with single sandboxes for years, without taking extra precaution. So I wasn't aware of the requirements.

--
Stephane