Ways to quickly deploy a mysql environment using MySQL Sandbox

What should I do to quickly deploy a mysql environment using MySQL Sandbox? Many people don't know much about it. Today, in order to let you know more about MySQL Sandbox, the editor summarizes the following contents. Let's look down together.

MySQL Sandbox is a very simple and quick tool suite for deploying MySQL technology, which allows you to achieve your ultimate goal more quickly and without interference on the same machine. For example, as a software tester, you just need to test the goodness of the software system without having to struggle with the installation of mysql or have too much experience with MySQL databases. Sometimes we are just interested in some of the features of the new version, finish the installation and deployment as quickly as possible, but focus on experiencing some of its features; we can use sandbox to deploy the database application architecture (ReplicationCluster) we need in the shortest time to match the performance test of our existing application system.

1. Install cpan

Yum install cpan-y

two。 Install packages that the software depends on

Yum install perl-Test-Simple-y

3. Install MySQL Sandbox

Cpan MySQL::Sandbox

4. Set the environment variable (otherwise it will be thrown wrong)

[root@localhost ~] # echo 'export SANDBOX_AS_ROOT=1' > > / root/.bash_ profile [root @ localhost ~] # source / root/.bash_profile

5. Download the mysql binary package (I download mysql5.6 here. I suggest you get into the habit of downloading the package from the official website, which I have downloaded here, as follows)

Download link: https://dev.mysql.com/downloads/mysql/

6. Run our mysql instance in a sandbox environment

Start the installation:

[root@localhost] # make_sandbox mysql-5.6.19-linux-glibc2.5-x86_64.tar.gz

The following installs multiple instances:

You can execute make_multiple_sandbox-- help to view one of its usage

The default is 3 nodes, which means three instances

[root@localhost] # make_multiple_sandbox mysql-5.6.19-linux-glibc2.5-x86_64.tar.gzinstalling node 1 installing node 2 installing node 3

After execution, a folder of multi_msb_mysql-5_6_19 will be generated.

The above is a brief introduction to the method of using MySQL Sandbox to quickly deploy the mysql environment. Of course, the differences in the detailed use of the above have to be understood by everyone. If you want to know more, welcome to follow the industry information channel!