3.2.18 29-Nov-2018 - Add support dor MariaDb 10.4+ (merge PR from pali) 3.2.17 16-Apr-2018 - Added deprecation notice for MySQL-Sandbox. 3.2.16 04-Jan-2018 - Added backward compatibility options for authentication plugin in MySQL 8.0.4. The default authentication was changed from mysql_native_password to caching_sha2_password To keep the new default, use --keep_auth_plugin. 3.2.15 18-Nov-2017 - Changed grants to support new users in 5.7.19 and 8.0.4 - Improved tests to deal with new default users 3.2.14 05-Sep-2017 - Added a conditional delay in ./use, as a temporary workaround for changed replication defaults in MySQL 8.0.x. - Added a global check to stop operations if ~/.mylogin.cnf is detected 3.2.13 24-Jul-2017 - Updated --expose_dd_tables procedure to deal with DD changes in 8.0.2 3.2.12 18-Jul-2017 - Changed initial check for system tables: MySQL 8.0.2 has a tablespace instead 3.2.11 16-Jul-2017 - Removed "--socket" from mysqlsh script 3.2.10 03-May-2017 - Fixed error in --custom_mysqld handling 3.2.09 01-May-2017 - Merged Guriandoro's change to check port numbers in change_ports - Added change directory command to change_ports - Added test for data dictionary tables 3.2.08 27-Apr-2017 - Added option --expose_dd_tables to show and use MySQL 8.0 data dictionary hidden tables. - Also available is an option --custom_mysqld to start the server with a different mysqld from the same directory. 3.2.07 21-Apr-2017 - Changed detection of USER variable to pass tests in unfriendly environments 3.2.06 16-Apr-2017 - Added tmpdir option to mysql_install_db and 'mysqld --initialize' - Cleanup and test improvement (add option to skip tarball tests) - Changed description in MySQL::Sandbox.pm to include MariaDB when needed - Added MariaDB 10.3 to allowed versions (untested, as I could not find binaries) 3.2.05 31-Dec-2016 - Merged Dennis Becker improved search for libraries in make_sandbox_from_installed - Added version 10.2 among the supported ones 3.2.04 14-Dec-2016 - Fixed intolerant behavior of mysqld_safe introduced in MySQL 5.7.17. 3.2.03 02-Nov-2016 - Added option --init_option to add options at initialization time. - Added option --init_my_cnf to load $sandbox_dir/my.sandbox.cnf during initialization instead of --no-defaults. - Added option --init_use_cnf to load a custom options file during initialization instead of --no-defaults. 3.2.02 12-Sep-2016 - Fixed download parameter for make_sandbox_from_url 3.2.01 10-Sep-2016 - Added early check for USER, HOME, and PWD variables. - Added early check for spaces in HOME variable. - Fixed wrong server_id when using both --slaveof and --check_port - Added test for server_id with --check_port - Updated make_sandbox_from_url to use MySQL 8.0 remote builds (when available) - Added remote catalog to make_sandbox_from_url 3.2.00 28-Aug-2016 - Add compatibility with MySQL 8.0.0 - Adapt tests to use MySQL 8.0.0 - Added options: - plugin_mysqlx : installs the X-plugin permanently - mysqlx_port : with the above option, sets the X-plugin port - Changed mysqlsh script to use --sql or --js options. 3.1.13 21-Aug-2016 - added --master_ip to make_replication_sandbox 3.1.12 07-Aug-2016 - added syntax for make_sandbox get:#.# (invokes make_sandbox_from_url) - Added check for wrong requested version in make_sandbox_from_url - removed duplicate function from test_sandbox 3.1.11 11-Jul-2016 - Added make_sandbox_from_url to the installation list - Use https for GitHub URLs (contributed by D. Van Eeden) 3.1.10 10-Jul-2016 - Fixed a test error that made the package not-installable 3.1.09 08-Jul-2016 - Added make_sandbox_from_url, which installs a sandbox from the web - Fixed a warning about negative length of options (only fires in recent versions of Perl) - Cleaned up test execution for environments where it can't run properly. 3.1.08 04-Jun-2016 - Fixed major issue with XPlugin installation. The grants script was removing the account created by the X-plugin. Now this account is whitelisted. (https://bugs.mysql.com/bug.php?id=81257) - Fixed minor naming in MANIFEST - Fixed compatibility issues in deploy_to_remote_sandboxes.sh 3.1.07 15-May-2016 - Added support for $NOPASSWORD variable in ./use script. When this variable is enabled, the client runs without a password. Useful to call it before grants are loaded. - Added option to install plugin right after the installation --load_plugin=plugin_name[=filename] - Added options to execute SQL before and after loading grants --pre_grants_sql --pre_grants_file --post_grants_sql --post_grants_file - Similar options can execute shell commands --pre_start_exec --pre_grants_exec --post_grants_exec - Added test cases for the above options 3.1.06 09-May-2016 - Added explicit return code to test_replication script - Enables sbtool to remove incomplete group sandboxes - Test_Helper now cleans environment variables before starting a test - Added temporary support for mysqlsh - merge contribution by kaiwangchen to fix make_sandbox_from source and make_sandbox with mysqld-debug - Added --gtid option dor make_sandbox, make_replication_sandbox, and make_multiple_sandbox 3.1.05 17-Jan-2016 - Fixed mismatch in version checking to determnine whether to use mysql_install_db or mysqld --initialize - Updated copyright notice - Added test for installation method used - Added test for generated UUID - Merged pull request from Alexandr Ciornii : "Display repository URL on MetaCPAN" 3.1.04 07-Dec-2015 - Fixed wrong version comparison (affects usage of MySQL 5.7.10) - Changed tests to use smarter version comparison 3.1.03 04-Dec-2015 - Increased timeout for 'start' script, needed when restart requires a longer time. 3.1.02 21-Nov-2015 - Fixed error in UUID generation for server-id=110 - Merged change by Mark Leith to preserve mysql.sys user - Adapted privileges test for the above change 3.1.01 04-Oct-2015 - Removed message that should only appear with debug - Modified Makefile.PL to generate correct licensing metadata - Added port info to replication status and check-slaves (Thanks to Mark Leith) - Changed 'create schema' to 'create' database to allow installation in MySQL 4.1 (thanks to Daniël van Eeden) - Updated sbtool to prevent deletion of the whole sandboxes directory - Minor changes to semi-sync plugin test - Added debug message in make_sandbox_from_source - Tested with MySQL 5.7.9 and MariaDB 10.1.6 3.1.00 22-Aug-2015 - Migrated repository to github (github.com/datacharmer/mysql-sandbox) - Changed license to Apache 2.0 - Limited workaround for bug#77732 to MySQL 5.7.8 only - Added usability feature for Server-UUID. Whenever server-id is used, the server-uuid is converted into an easy-to-read string of numbers - Simplified './clear' script. Does not attempt to remove stored routines. Makes the intrusive mysqldump that was running with load_grants unnecessary - Changed location for MySQL history in group sandboxes to be shared between single ones. 3.0.66 07-Aug-2015 - Added MYSQL_EDITOR variable to ./use script - Added ./mycli script to invoke the mycli command 3.0.65 06-Aug-2015 - Added show_relaylog script, similar to show_binlog 3.0.64 05-Aug-2015 - Fixed quoting error in show_binlog script 3.0.63 04-Aug-2015 - Modified test add_option.sb.pl so that it can also run on MySQL 5.0 - modified sandbox script json_in_db to use type JSON when version >= 5.7.8 - Simplified grants.mysql and show_binlogs scripts 3.0.62 02-Aug-2015 - Added default name for relay log files. - Added 'show_binlog' and 'add_option' scripts in each sandbox - improved tests by getting all the version components from a single function call - Added GTID initialization options for MySQL 5.6, 5.7, and MariaDB 10 - Added GTID enabling test for MySQL 5.6 and 5.7 - added and improved more tests 3.0.61 27-Jul-2015 - Simplified workaround for Bug#77732. No defaults are changed. The only addition is a GRANT SELECT on a given table to the replication user for MySQL 5.7.6+ - Removed unnecessary FLUSH PRIVILEGES 3.0.60 25-Jul-2015 - Changed installation method for MySQL 5.7.6 and later. Using 'mysqld --initialize' instead of deprecated mysql_install_db. Installation for earlier MySQL versions and MariaDB still use mysql_install_db. - Due to the above change, low_level_make_sandbox will now filter the "error" message in the output for the text '[Warning]'. If an "error" appears as warning, the installation is not halted. - Incompatible change: when using --force to install on top of an existing sandbox, the old data directory is copied to 'old_data' instead of being overwritten. This is due to the different behavior of 'mysqld --initialize' that does not support initializing an existing data directory. - Added more tests. Improved a few of the existing ones. - Fixed test for user privileges that was broken in 5.7.6+ 3.0.57 to 3.0.59 not released 3.0.56 20-Jul-2015 - Adjusted credis date 3.0.55 19-Jul-2015 - Fixed issue with the latest script added to the test suite. 3.0.54 19-Jul-2015 - Added test_replication script to test both regular and circular replication. It is also used in the test suite 3.0.53 16-Jul-2015 - Improved workaround for Bug#77732. Deployments with --master would only work within the test suite, but would fail in standalone installations. 3.0.52 15-Jul-2015 - Added a workaround for Bug#77732 in MySQL 5.7.8 -- https://bugs.mysql.com/bug.php?id=77732 -- 3.0.51 14-Jul-2015 - Added ability of opening tarball with name like 123456.mysql*.tar.gz - Added many tests for tarball name checking 3.0.50 11-Apr-2015 - Fixed issue with the 'clear' script in MySQL 5.7.7. Since a new default database was added ('sys') and the clear command did not know about it, the new database was being removed. 3.0.49 08-Apr-2015 - Fixed version detection to support also MySLQL 5.7.7 and MySQL 5.7.8. A more resilient patch will follow. Notice that, due to a change (possibly a bug) in MySQL 5.7.7, circular replication and in general any topology containing a relay slave may fail. 3.0.48 09-Mar-2015 - Added provisional support for MySQL 5.7.6 (changed syntax for SET PASSWORD but keep using deprecated mysql_install_db) 3.0.47 19-Oct-2014 - Added support for MySQL with data dictionary (5.7.5 labs edition) 3.0.46 25-Sep-2014 - Modified smoke test in test_sandbox to check correctly older and newer versions - Changes to allow installation of MySQL 5.7.5: - added creation of 'test' database - moved lower_case_table_names to the my.sandbox.cnf file (mysql_install_db does not support this option) - allow for changed syntax --insecure instead of --skip-random-password - removed tmpdir from options to mysql_install_db - Updated test_sandbox to avoid a 'skip-innodb' test with MariaDB 10.x - Updated test_sandbox to detect correctly MariaDB versions 3.0.45 30-Aug-2014 - Fixing bug#1361851 "start/stop/status scripts don't actually check if running" - Fixing freshly submitted but long overdue Bug#1362014 "Sandbox scripts can't deal with stale PID files" 3.0.44 29-Apr-2014 - Fixing bug#1313672 : MySQL Sandbox can't install with MySQL 5.7.4 - Removed some deprecated options that were removed in latest version of MySQL 3.0.43 24-Oct-2013 - Fixed bug#1155517 The "my" scripts excludes mysql_upgrade from --default-options incorrectly - Also added mysql_config_editor to the scripts that should not get defaults-options 3.0.42 30-Sep-2013 - Fixed bug in sb renaming. The new name was not updated in the MANIFEST 3.0.41 30-Sep-2013 - INCOMPATIBLE CHANGE: Renamed 'sb' to 'msb' to avoid name clashes in - INCOMPATIBLE CHANGE: Renamed 'sb' to 'msb' to avoid name clashes in Linux distributions 3.0.40 12-Jul-2013 - enhanced deploy_to_remote_sandboxes.sh with the ability of using a template my.cnf for remote deployment (-y file-name) 3.0.39 29-May-2013 - added server_id option to deploy_to_remote_sandboxes - added info about group directory to multiple sandbox 'start/stop/clear' scripts - added ruby connection info to connection.json - Fixed display bug in credits (were reported twice in replication README) 3.0.38 05-May-2013 - Fixed typos and formatting in embedded docs. 3.0.37 05-May-2013 - Added connection samples (for PHP, Perl, Python, Java, shell) to 'connection.json' - Added validation tests for JSON contents 3.0.36 04-May-2013 - IMPORTANT CHANGES: - Added connection.json to each sandbox (simple or multiple) The file contains information to use the sandbox with third party applications. - Added default_connection.json to each sandbox (it has only the default items from connection.json) - Added README file to each sandbox (simple or multiple) - enhanced check_slaves. It now includes "show master status"; - Fixed bug in circular replication: enable_gtid was not created; - Added 25 more integrity tests; - Changed default version for testing. It now looks for MySQL 5.5.31 3.0.35 03-May-2013 - Fixed bug in the 'check_slaves' script created with circular replication - Fixed bug in 'clear_all' script created in circular replication - added 50 new integrity tests to test_sandbox 3.0.34 29-Apr-2013 - Added option --bind_address, to define how MySQL::Sandbox servers connect to TCP/IP - Fixed bug with handling 5.7 builds. Replicated systems did not create the script enable_gtid (BUG#1171977) - The changes made by enable_gtid are now durable (Bug#1171986) - Fixed various patterns that prevented MariaDB 10.0 builds from being recognized. - Fixed bug in test_sandbox, where warning messages were mixed with the test output in MYSQL 5.5.30+ - Fixed bug in test_sandbox, where a test that skips innodb was being wrongly applied to MySQL 5.7 - Added 10.0 among supported versions - Added documentation about remote sandboxes (in MySQL::Sandbox::Recipes) - Added a test that checks if enable_gtid is created when needed. 3.0.33 11-Apr-2013 - Fixed Bug #1167794 '--log option deprecated' - fixed minot working issue in deploy_to_remote_sandboxes.sh 3.0.32 12-Mar-2013 - Fixed minor bug in deploy_to_remote_sandboxes.sh - Added deploy_to_remote_sandboxes.sh to the list of scripts to install 3.0.31 08-Mar-2013 - Fixed Bug#1133186 make_sandbox_from_source does not recognize version - removed diagnostic lines that printed MySQL version and temporary directory - removed diagnostic lines that printed ports and directories being searched when the option --check_port was used - added bin/deploy_to_remote_sandboxes.sh, which installs sandboxes to remote hosts 3.0.30 06-Feb-2013 - Fixed Bug#1116760 Uninitalized $ENV{"SANDBOX_BINARY"} - Removed obnoxious warning introduced in MySQL 5.5.30 when using mysqldump 3.0.29 24-Jan-2013 - fixed bug#1103918 (affects sandboxes using MySQL 4.1) 3.0.28 06-Jan-2013 - changed initialization scripts to avoid most of the annoying messages that MySQL 5.6 creates during tests - Added script to enable GTID in MySQL 5.6 3.0.27 05-Jan-2013 - added compatibility features to use MySQL 5.6 # improved 'clear' and 'start' scripts to handle innodb tables in the 'mysql' database # fixed usage of deprecated features in tests # removed obnoxious listing when data directory is created 3.0.26 30-Sep-2012 - Removed dependency on table mysql.host, which can't be found anymore in MySQL 5.6.7 3.0.25 01-Feb-2012 - fixed typos and credits. (Thanks to Mateusz Kijowski for noticing) 3.0.24 17-Dec-2011 - added --master option to low_level_make_sandbox (enables binlogs and server-ID) - added --slaveof option to low_level_make_sandbox (creates a slave of another sandbox or regular server) - added tests for the above ones 3.0.23 13-Dec-2011 - fixed bug in prefixed version names (e.g.: now you can use make_sandbox ps5.1.57 or mp5.2.10) - Added arguments to deal with node options in replication and multiple sandbox. --node_options, --slave_options, --master_options, --one_slave_options, --one_node_options - added --high_performance option to low_level_make_sandbox: adds the following features to the configuration file: innodb-thread-concurrency=0 sync_binlog=0 innodb-log-buffer-size=50M innodb-additional-mem-pool-size=100M max-connections=350 max_allowed_packet=48M innodb_buffer_pool_size=512M innodb-log-file-size=50M innodb-flush-method=O_DIRECT 3.0.22 26-Oct-2011 - Add support for directories named after a prefixed version (my5.1.56, ps5.1.56, giuseppe_5.1.56, etc) 3.0.21 10-Oct-2011 - Added test to MANIFEST (and to tarball). Forgotten in previous version 3.0.20 10-Oct-2011 - Fixed bug in make_sandbox. "--add_prefix" did not work in combination with "--export_binaries" - changed port checking tests to not depend on a specific MySQL version 3.0.19 09-Oct-2011 - INCOMPATIBLE CHANGE: make_sandbox now requires '--' before adding options supported by low_level_make_sandbox - INCOMPATIBLE CHANGE: the option --export_binaries for make_sandbox must be inserted BEFORE the tarball name - make_sandbox now recognizes Percona and MariaDB binaries - make_sandbox accepts the option --add_prefix=NAME, which will be added to the version number of the rename expanded tarball. (e.g. --add_prefix=yell mysql-5.1.8-linux.tar.gz will create yell5.1.58) 3.0.18 08-Oct-2011 - fixed CPAN Ticket 70470 MySQL::Sandbox - make_sandbox warns with Perl 5.14 and 5.14.1 - Fixed report-port in replication. The port used was the master's, but it should be the slave's 3.0.17 07-Jan-2011 - incompatible change: default mask for msandbox user is now '127.%' instead of '%'. You can resume the old mask with --remote_access='%' - added low privilege users msandbox_ro (SELECT EXECUTE), msandbox_rw (SELECT INSERT UPDATE CREATE DROP LOCK EXECUTE), and rsandbox (REPLICATION SLAVE) - fixed bug in test_smoke (assumed 2 directories after cleaning, but 5.5 has also performance_schema) 3.0.16 30-Dec-2010 - fixed bug in TestHelper (wrong assumption on all directories in $SANDBOX_BINARIES containing MySQL files) - added information to check_slaves to report master logfile and position 3.0.15 23-Dec-2010 - added a 'msb' script to each sandbox, to mimick the mysql.server script - fixed test visualization bug for Mac OSX with case insensitive storage - fixed algorithm to convert version number to ports - fixed test suite for MySQL 5.5 (can't disable innodb for testing) 3.0.14 31-Aug-2010 (not released) - Added a 'rsandbox' user with REPLICATION SLAVE grants for replication systems 3.0.13 28-Jun-2010 (not released) - fixed minor problems in the test suite about testing on Windows - added a prototype for MySQL Cluster integration 3.0.12 29-May-2010 - Fixed bug in test_sandbox. When a test evaluates only the result code and there is no output from a failing command, test_result was not able to detect the failure. - fixed bug in test_sandbox. Due to a change in behavior in the mysql client, where './use -B -N' with a \G terminated query does not show the headers since 5.1.43, We need to take into account the pre and post fix behaviors in the test. - Integrated set_plugins into sbtool - Updated documentation - added tests for innodb plugin installation - added tests for semi-synch plugin installation - Fixed bug in 'stop' script. It did not accept $MYCLIENT_OPTION - Fixed bug#487864 - tar was using '--help' instead of '--version' to detect the supported version. - Fixed bug in sbtool. It did not display credits in the help. - Added test to skip testing on Windows. - added instrumentation to all MySQL Sandbox scripts. If you set the $SBINSTR environment variable with the name of a file, all sandbox scripts will write an entry to that file with their run time params. 3.0.11 24-May-2010 - Fixed bug in ./clear script. In version 5.5 and bigger, it erased the performance_schema database, which should not be removed. If it exists, its tables are now truncated. - Fixed bug in ./clear script. The removal of databases was not executed in a clean mode. - Added a script to install plugins in ./drafts 3.0.10 04-May-2010 - Fixed the help() function. It displayed an example that was only appropriate for a single sandbox, but not for group ones. 3.0.09 25-Mar-2010 - added a check in the 'start' script to verify that mysqld_safe exists and can run properly. - Added an exit code to the 'start' script to alert when the server does not start - added help to make_sandbox_from_installed. Added /usr/sbin as source directory - added instructions to the 'clear' script to remove functions and plugins 3.0.08 17-Feb-2010 - Fixed make_sandbox_from_source failure due to changes in modified configure.in (Thanks to Padraig O'Sullivan for noticing) - modified the "USING" file, which now includes the Sandbox version - Changed default test version from 5.0.77 to 5.0.86 3.0.07 08-Jan-2010 - Fixed bud in make_multiple_custom_sandbox. With some versions of bash, it broke on tests with "use_all" - fixed bug on symlink access on some platforms. - Fixed Bug#504789 export_binaries fails on some OS when crossing file systems 3.0.06 03-Jan-2010 - Fixed bug in prompt definition. A stray quote was added at the start of each user-defined prompt. - Fixed Bug#456949 "each sandbox should have a dedicated temporary directory". - Fixed Bug#439226 "sandbox_action script uses wrong version of Perl" - Improved documentation to resolve Bug#392996 "make install Sandbox.pm path issues". - added 'status' script to sandboxes - fixed db_user definition, which could write trail character to the option file. 3.0.05 12-Sep-2009 - Fixed Bug#428274 make_sandbox fails on Mac OSX 10.6 "snow Leopard" - Increased starting timeout from 20 to 60, because some recent versions of MySQL are quite slower to start. - Added a dedicated history file per each sandbox (Thanks to Gerardo Narvaja for suggesting it) - fixed bug in make_sandbox when dealing with a non-standard answer to the "which" Unix utility - added error checking for 'bash' to low_level_make_sandbox - improved error checking for mysql_install_db script - renamed 'sandbox' tool -> 'msandbox' to prevent clash with existing tool in Linux distros - Added "--no_run" option to low_level_make_sandbox, to stop the server when using the "--load_grants" option. The purpose is to end the command without leaving any running sub-process. 3.0.04 14-Jun-2009 - fixed bug in test_sandbox. A "$" sign in a directory name was not escaped properly - added the "--no_show" option to low_level_make_sandbox - fixed a bug in the "sb" script. Calling it in "create mode" did fail if $SANDBOX_HOME does not exist yet. 3.0.03 11-Jun-2009 - added the 'sb' shortcut script to create and invoke sandboxes easily. 3.0.02 30-May-2009 - Added a check for all scripts, to prevent MySQL::Sandbox from running as root without explicit awareness 3.0.01 28-May-2009 - Fixed Bug#381044 "my" script fails on some executables - moved function "exists_in_path" to MySQL::Sandbox module 3.0.00 09-May-2009 - GA release - no code modification. Same codebase as 2.0.99f - completed cookbook (41 recipes in MySQL::Sandbox::Recipes) - added script_templates directory (No modification in current version, just preparation for 3.1.xx) - added drafts directory 2.0.99f 03-May-2009 - fixed bug in make_sandbox_from_installed. Some system use /lib64 instead of /lib - added more recipes to MySQL::Sandbox::Recipes 2.0.99e 03-May-2009 - added make_sandbox_from_installed to install from binaries already installed via packages such as .deb, .rpm. - added sample perl test script to MANIFEST. Missed during the previous release - added MySQL::Sandbox::Recipes, a cookbook with short How-To tutorials - cleaned up tests. Added 8 more test to check replication parameters 2.0.99d 02-May-2009 - Added user defined test in Perl, in addition to the ones written in the test_sandbox script language - Updated documentation 2.0.99c 01-May-2009 - Fixed conceptual bug in "start" and "restart". Group sandboxes were not allowing it - added "restart_all" in group sandboxes - Added 18 new tests to check the above problem - Added documentation about port checking and parameters accepted by 'start' and 'restart' 2.0.99b 26-Apr-2009 - added group port checking to make_replication_sandbox and make_multiple_sandbox - added 2 new tests to the test suite to test singkle and group port checking - added documentation on port checking 2.0.99a 12-Apr-2009 - fixed bug in make_replication_sandbox and make_multiple_sandbox. If a group sandbox was the first to be created under $SANDBOX_HOME, it failed. - added check_replication.sb as user defined sample test 2.0.99 11-Apr-2009 - implemented user defined test modules - fixed some documentation glitches - Added documentation about user defined tests 2.0.98i 09-Apr-2009 - added script make_sandbox_from_source, which will create a sandbox from a build directory - Extended maximum port to 64000 - added MySQL versions 5.[2345] as accepted for a Sandbox 2.0.98h 08-Apr-2009 - Changed test_sandbox to use IPC::Open3 instead of qx, when available. This will make the 'make test' output more readable. - added Test_Helper.pm to the test suite 2.0.98g 07-Apr-2009 - added --master_node option to sbtool - added 'preserve' and 'unpreserve' options to sbtool - made test_sandbox TAP compatible - updated the test suite - written the documentation on sbtool to MySQL::Sandbox POD 2.0.98f 06-Apr-2009 - added 'delete' action to sbtool - introduced --export_binaries to make_sandbox - added 03_test_sandbox.t, which uses test_sandbox within the test suite - fixed bug in sbtool. Moving sandbox failed becaus of wrong regular expression - added a test suite for sbtool to test_sandbox test_sandbox --tests=sbtool 2.0.98e 02-Apr-2009 - fixed error in low_level_make_sandbox --interactive. Array values were not preserved correctly wit a default - implemented interactive confirmation for group sandboxes 2.0.98d 01-Apr-2009 - Deprecated "query_analyzer" option :) - moved the POD to MySQL::Sandbox - produced mew README from the POD - implemented --no_check_port (to use as a safeguard with group sandboxes) 2.0.98c 01-Apr-2009 - added query_analyzer option 2.0.98b 31-Mar-2009 - taken most function from sbtool to MySQL::Sandbox module - implemented --check_port for single sandboxes - fixed bug#352222 "report-port incorrect with --master-master" - cleaned up code for parse_options in all scripts - enhanced test case with some tests for the script correctness 2.0.98 29-Mar-2009 - Preparation for version 3.0 - refactoring code to use with ExtUtilis::MakeMaker and install a proper Perl module - updated README - fixed sandbox_action to support 'send_kill' - added $VERSION to both modules 2.0.18 22-Mar-2009 - added change_port script to installed sandboxes - added 'port' operation to sbtool - added --new_port option to sbtool 2.0.17 15-Mar-2009 - improved sbtool error checking - improved sbtool built-in help - added "report-port" to replication slave setup 2.0.16 14-Mar-2009 - added 'copy' option to sbtool, to clone a sandbox data directory into another. 2.0.15 09-Mar-2009 - added "report-host" option to slave creation - fixed server_id for values larger than 10. Instead of folding from 109 to 100, it was doing 109 to 1010. 2.0.15 19-Feb-2009 - added sbtool, a multi purpose program to do administrative tasks with the sandbox. Supported operations: port list, replication tree, moving single and multiple sandboxes 2.0.14 08-Feb-2009 - added code to the "clear" script to truncate the table logs if they exist - improved error messages when using wrong directories or tarballs - added a "change_paths" script to change the sandbox paths quickly when moving the sandbox to a new location. 2.0.13 27-Jan-2009 - added parameters to "start" and "restart" scripts. If you pass an option, it will be passed directly to mysqld_safe. e.g. "start --log=mylog.log" - fixed bug in test_sandbox.pl. Using "ls -d /path/*/" doesn't work on Solaris. Replaced with a more robust routine. - Allow the unpacking of tarballs to work on Solaris if "gtar" is found. 2.0.12 16-Oct-2008 - Fixed small bug in 'clear' script. When the server is not responsive, it was calling the wrong 'kill' script - Applied Greg Haase patch to fix a bug in --datadir_from=dir:xxxx 2.0.11 05-Oct-2008 - Fixed bug#278394, "character '-' in database names" (added backticks to 'clear' script) - added a command to change read attributes inside expanded tarballs to avoid a possible failure in MySQL test suite, should a user run it 2.0.10 27-Aug-2008 - fixed minor bug in make_multiple_sandbox and make_replication_sandbox when passing additional parameters. No space were added at the end. Further parameters were glued together, resulting in a startup error. - added NODE_OPTIONS to work in make_replication_sandbox (it adds options to both MASTER_OPTIONS and SLAVE_OPTIONS) 2.0.9 22-Aug-2008 - fixed bug#260265 "installation fails with log-error option and version < 5" - removed "log-error" from default file - added this option conditionally only if major version > 4 2.0.8 16-Aug-2008 - fixed problem with "~" not being expanded as $HOME - fixed problem with not existent path for tarball - fixed bug#258523 Mysql Sandbox looks for tar.gz in wrong location in make_replication_sandbox, make_sandbox, make_multiple_sandbox, make_multiple_custom_sandbox, and in the test suite - fixed minor problem in MyScripts.pm. log-slow-queries was misspelled, although commented. 2.0.7 06-Aug-2008 - added shortcut option "--circular=N" to make_replication_sandbox corresponding to "--topology=circular --how_many_nodes=N" - added Falcon creation to smoke test (if version >= 6) 2.0.6 20-Jul-2008 - added "check_slaves" script to replication sandboxes 2.0.5 14-Jul-2008 - added named error log to configuration file - add removal of *.err-old files in "clear" script - Fixed bug in circular replication. Unnecessary initialization after stop_all. Added the same check used in standard replication - fixed bug in circular replication. start_all and set_circular_replication.sh were not stopping and starting the slaves in the righ order. - improved 'stop' script. If the server is a slave, calls "stop slave" before closing down. 2.0.4 12-Jul-2008 - fixed bug in test suite. Parameter passing to check routine was often failing on negative tests. Added subroutine prototype to fix the problem. 2.0.3 12-Jul-2008 - Fixed smoke test bugs in test suite. - fixed race condition while checking the pid file - added cleanup of extracted binary with smoke test - added stricter check for InnoDB tables - added some replication tests to test suite 2.0.2 6-Jul-2008 - Fixed minor bugs in low_level_make_sandbox. - When started with --force and --load grants, it said that it failed to comply. In fact, the grants were already loaded. - when started with --force, it invokes $sandbox_dir/start without checking if such script exists 2.0.1 5-Jul-2008 - fixed minor bug on test suite. It fails on Solaris with "ps -ea". Changed to "ps -ef" - added README.wiki - added "smoke" test to test suite - added --no_confirm to all single sandbox testing 2.0.0 2-Jul-2008 - fixed minor bug in generated scripts. Removed bash-specific operator "==" 1.99.10 1-Jul-2008 - Fixed bug in test suite. Process count was not taking into account the pre-test processes. - Fixed bug in test suite. Portability. ps was being used with non portable options. - added --prompt_body option to low_level_make_sandbox - added $SANDBOX_BINARY environment variable, to replace default $HOME/opt/mysql - fixed error message of make_sandbox when invoked without options - added a check in make_sandbox to make sure that we are using GNU tar. 1.99.9 30-Jun-2008 - Fixed bug #244236 (low_level_make_sandbox accepts unnecessary arguments) - Fixed bug in low_level_make_sandbox. sandbox_home was not checked for correctness. It is a simple name, and it should not accept full paths. - INCOMPATIBLE CHANGE home_directory was not supposed to be home. Its name is misleading, and thus it was changed to upper_directory. - Fixed typos in README - Initial fix for bug #239630 (possible failure on non-GNU tar) - fixed script names in "sandbox" script - (Thanks to John Embretsen for most of the reports on today's changes) 1.99.8 29-Jun-2008 - INCOMPATIBLE CHANGE $HOME/sandboxes is now the default SANDBOX_HOME, which users however can override. - INCOMPATIBLE CHANGE "multi_cmd" was renamed "use_all" for name consistency - added a call to low_level_make_sandbox --help when make_sandbox is invoked without the proper syntax. - README has been completely rewritten - added a ./docs directory with the README.pod source for README - added POD to ./sandbox script, to show the documentation when called as "./sandbox manual|help" 1.99.7 28-Jun-2008 - added configurable options for test suite users can now choose which versions and which tests to run from the command line - removed deprecated test_sandbox.sh - moved test suite to ./tests directory - added tests/README - improved "stop" script by combining it with the "kill" script - adjusted make_dist script to use the ./test directory - improved test suite with the ability of running from one or more tarballs instead of the default directories ([$HOME]/opt/mysql) 1.99.6 28-Jun-2008 - enhanced the "clear" script. Now it removes all databases form the data directory, first trying via SQL, then using the OS. - added tests to the test suite to check on this feature 1.99.5 27-Jun-2008 - INCOMPATIBLE CHANGE make_sandbox renamed low_level_make_sandbox easy_sandbox renamed make_sandbox - fixed bug in make_replication_sandbox (base port was not isolated) - added test for circular replication - improved testing for number of processes in the test suite - added circular replication features to make_multiple_sandbox with options --master_master and --circular (this should not be used directly) - added circular replication features to make_replication_sandbox with options --master_master and --topology={standard|circular} . This feature uses make_multiple_sandbox internally. - circular replication uses a separate directory name and port - fixed bug in make_multiple_sandbox. It did not use the $SANDBOX_HOME directory. 1.99.4 21-Jun-2008 - added more extensive test suite in Perl - fixed bug in make_multiple_custom_sandbox (install directory was not set when calling easy_sandbox) 1.99.3 21-Jun-2008 - INCOMPATIBLE CHANGE all Perl script names were changed to make them more intuitive install.pl -> make_sandbox express_install.pl -> easy_sandbox set_replication.pl -> make_replication_sandbox set_many -> make_multiple_sandbox set_custom_many.pl -> make_multiple_custom_sandbox - created a './sandbox' script that lists all applications and eventually executes the one that is passed as argument - mapped "stop" script to faster and safer "kill" script - replaced "sleep 3" with a loop + timeout in shell scripts - removed "sleep" commands from Perl scripts - fixed bug in get_help() : parse_options were not passed to the $msb object 1.99.2 20-Jun-2008 - fixed minor bug. mysql_install_db script in some cases is found in the "bin" directory rather than "scripts" - added ability to log start operations into a log file 1.99.1 19-Jun-2008 - added "kill" script to each sandbox - replace call to "stop" with "kill" in "clear" script 1.99.0 15-Jun-2008 - Started new development branch for Sandbox 2.0 - added MySandbox.pm module, to use the same routines across scripts 1.22 15-Jun-2008 - added support for default options file ($HOME/.msandboxrc) - fixed minor bug in set_replication.pl. Added #master to multi_cmd output. - fixed bug related to location of sample option files. The installer was only looking under "./support-files" while recent packaging use "./share/mysql" - fixed Bug#240121, with a collision between my_file and replication. - added the execution of a "./clear" command when "--force" was used to avoid overwriting a running server. - cleaned up current_changes to contain only not empty options - created a basic test suite (not in distribution yet, only in RCS) 1.21 09-Jun-2008 - added SANDBOX_HOME environmental variable to override $HOME - default sandbox home is now $HOME/sandboxes (if exists) or else it is $HOME, as before - added scripts to start/stop/clear/use all sandboxes at once (if $SANDBOX_HOME != $HOME) 1.20 11-Apr-2008 - Added set_custom_many.pl to install different versions of the server in one go. (Thanks to Ronald Bradford for the idea) - enhanced "multi_cmd" to say which server is running - added support for MYCLIENT_OPTION user variable to pass options to the client (./use and ./multi_cmd) 1.19 06-Apr-2008 - changed installer files so that they can be called from outside the installation directory. 1.18 02-Apr-2008 - Fixed bug in set_many and set_replication. Undefined group directory when setting custom port - Added help to ./express_install 1.17 16-Mar-2008 (not released) - fixed minor bug in "clear: script. It did not remove subdirectories in test db - fixed minor bug on the choice od source dir. If $HOME/opt/mysql exists, it is preferred to /opt/mysql 1.16 04-Jan-2008 (not released) - added stronger check on the result of mysql_install_db. - added removal of general log files and falcon files with the "clear" command. 1.15 09-Dec-2007 - fixed bug in grants.mysql. Removed anonymous users from mysql.db - added $HOME/opt/mysql as possible default for binaries. - added proxy_start script to start a MySQL Proxy instance using the sandboxed server 1.14 24-Oct-2007 - added a set_many.pl command to create several servers not in replication - fixed bug in replication ports assignment. Two replication systems using adjacent versions (e.g. 5.1.22 and 5.1.23) would have clashing port numbers. 1.13 23-Oct-2007 - (INCOMPATIBLE CHANGE) removed '.sh' suffix from all scripts - added version differentiation to replication port and directory. Instead of being always the same, now they are based on the version number, unless modified by the user. - added a multi_cmd script to the replication system, to send a query to each node. - added a 'my' script to call mysql* tools - fixed bug about using 6.0 binaries on Mac OS X (dynamic library path requires a different environment variable) - fixed bug in replication. After a "clear_all", the replication did not start again. Added a "initialize_slaves" script that get called by "start_all" if a clear_all was called. 1.12 17-Oct-2007 - hidden mysql_install_db output on successful execution - fixed argument handling bug in replication scripts 1.11 16-Oct-2007 - all shell scripts are now created from install.pl (not copied) - changed default username, password, and sandbox directory name - forbid using a relative path of tarball 1.10 16-Oct-2007 (not released) - fixed bug on mysql_install_db usage 1.9 15-Oct-2007 (not released) - deprecated the 'archive' method of installation and removed the compressed data directories - express_install can now expand a server tarball. - added support for replicated servers (set_replication.pl) using CHANGE MASTER TO rather than replication options - added 'load_grants' option to install.pl - added 'prompt_prefix' option to install.pl - fixed bug about client library not being available due to LD_LIBRARY_PATH not set 1.8 14-Sep-2007 - Added support for MySQL 6.0 1.7 05-Jul-2006 (not released) - Added support for Mysql 5.2-alpha 1.6 27-May-2006 - Added 'my_clause' command line option to define my.cnf file parameters; - changed interactive routine to allow multi-item options; - changed the shell scripts to be less bash specific. the sandbox should be now more cross-platform than before. During the installation, if bash is not found, then tcsh is used. - new Tutorial available at http://datacharmer.org/#tutorials - bugs fixed: -- clear.sh was using $HOME directory instead of _HOME_DIR_ -- install_version calculated by express_install.pl could be lower than 1024. -- install_version was added twice when loading options from 'current_options.conf' (Thanks to Imran Chaudhry for reporting it) 1.5 24-May-2006 - added 'back' and 'quit' keywords in interactive mode - added express_install.pl, to install quickly from a binary package - Bug fixed. 'start.sh' and 'stop.sh' scripts where using the actual $HOME dorectory instead of the user's defined _HOME_DIR_ 1.4 17-May-2006 (not released) - added support for 3.23, 4.0 and 4.1 installs - default install is now 5.0 - default addition of version to sandbox directory name - added option "no_ver_after_name" to control the above change 1.3 05-May-2006 - added "interactive" option to install through a sort of a wizard - added current_options.conf to record the options used for installing - fix bug in configuration file 1.2 02-May-2006 - minor bug fixes 1.1 19-Apr-2006 - added multiple sources for data directory 1.0 18-Apr-2006 - initial release.