Mysql-sandbox Installation Configuration Notes

The sandbox installation can be used on GitHub, or it can be installed using CPAN.

It is recommended to use the CPAN one-click installation.

# Install Mysqlsanbox

Yum Install cpan Perl-yaml perl-test-simple-y
CPAN Mysql::sandbox
echo ' Export sandbox_as_root=1 ' >>/ROOT/.BASHRC
Source/root/.bashrc

Put several common MySQL generic binaries ready for use in the/opt/directory. As follows:

[Email protected]/opt]# ll
Total 1035444
-rw-r--r--1 root root 640650826 2017-07-27 20:53 mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
-rw-r--r--1 root root 419634124 2017-07-27 20:53 mariadb-10.3.0-linux-x86_64.tar.gz

Create a 10.3.0 version of the MARIADB instance

Make_sandbox mariadb-10.3.0-linux-x86_64.tar.gz

The process is as follows: unpacking/opt/mariadb-10.3.0-linux-x86_64.tar.gz

Executing Low_level_make_sandbox--basedir=/opt/10.3.0 \

--SANDBOX_DIRECTORY=MSB_10_3_0 \

--install_version=10.3 \

--SANDBOX_PORT=10300 \

--no_ver_after_name \

--my_clause=log-error=msandbox.err

The MySQL Sandbox, version 3.2.13

(C) 2006-2017 Giuseppe Maxia

Installing with the following parameters:

Upper_directory =/root/sandboxes

Sandbox_directory = Msb_10_3_0

Sandbox_port = 10300

Check_port =

No_check_port =

Datadir_from = Script

Install_version = 10.3

Basedir =/opt/10.3.0

Tmpdir =

My_file =

Operating_system_user = root

Db_user = Msandbox

Remote_access = 127.%

Bind_address = 127.0.0.1

Ro_user = Msandbox_ro

Rw_user = MSANDBOX_RW

Repl_user = Rsandbox

Db_password = Msandbox

Repl_password = Rsandbox

My_clause = Log-error=msandbox.err

Init_options =

INIT_MY_CNF =

INIT_USE_CNF =

master =

Slaveof =

High_performance =

Gtid =

Pre_start_exec =

Pre_grants_exec =

Post_grants_exec =

Pre_grants_sql =

Post_grants_sql =

Pre_grants_file =

Post_grants_file =

Load_plugin =

PLUGIN_MYSQLX =

Mysqlx_port =

Expose_dd_tables =

Custom_mysqld =

Prompt_prefix = MySQL

Prompt_body = [\h] {\u} (\d) >

force =

No_ver_after_name = 1

VERBOSE =

Load_grants = 1

No_load_grants =

No_run =

No_show =

Keep_uuid =

History_dir =

Do you agree? ([Y],n) Y

# Starting Server

.. Sandbox server started

# Loading Grants

Your Sandbox server is installed in $HOME/sandboxes/msb_10_3_0

Then, enter Y to agree to the configuration parameters above.

After waiting for 20s, it will automatically generate a directory like Msb_10_3_0 in the/root/sandboxes directory.

The default is to listen on the address of the 127.0.0.1. If we're going to switch to an external address,

Cd/root/sandboxes/msb_10_3_0 (This directory has a lot of scripts, you can see the contents of it to know how to use it)

VIM/ROOT/SANDBOXES/MSB_10_3_0/MY.SANDBOX.CNF comment out listen that line of code,

Then execute the./restart.

./use can log in to MySQL

./MYCLI can log in with MYCLI (CentOS6 need to compile and install python27 for normal use MYCLI)

Create a set of Gtid replicated 5.7.19 Master and Slave instances

cd/opt/# # # need to first switch to the MySQL source package that path under the line Make_replication_sandbox--gtid--how_many_slaves=1 5.7.19 Create a set of Gtid replication 5.7.19 Master Cases

Wait 20s, you can start 1 sets of master-slave mysql5.7.19 environment.

Ss-lntp|grep MySQL can be verified.

How to use the Gtid master-slave machine created above:

CD/ROOT/SANDBOXESCD Rsandbox_5_7_19[[email protected]/root/sandboxes/rsandbox_5_7_19]#./test_replication Check Master-slave replication status

# Master Log:mysql-bin.000001-position:11309-rows:20

# testing Slave #1

Ok-slave #1 acknowledged reception of transactions from master

Ok-slave #1 IO Thread is running

Ok-slave #1 SQL Thread is running

ok-table T1 found on slave #1

ok-table T1 has () rows on #1

# Tests:5

# failed:0 (0%)

# Passed:5 (100%)

# Exit code:0

In this directory, both M and N1 are connection scripts that connect to the main library. Both S1 and N2 are scripts that connect from the library.

#####################################

If you need to build several identical instances at once and do not need to have a replication relationship, you can use the following command

Cd/opt/make_multiple_sandbox--how_many_nodes=3 mariadb-10.3.0-linux-x86_64.tar.gz # Default one-time build 3 instances

# # # # # # #还有些常用的命令, it's simple shell scripts, open up and see what you mean. Don't explain it.

This article is from the "notes of a Chicken" blog, please be sure to keep this source http://lee90.blog.51cto.com/10414478/1951579

Mysql-sandbox Installation Configuration Notes