How to deploy mysql using MySQL Sandbox

This article mainly shows you "how to use MySQL Sandbox to deploy mysql", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn "how to use MySQL Sandbox to deploy mysql" this article.

Rapid deployment of mysql using MySQL Sandbox

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.

These are all the contents of the article "how to deploy mysql using MySQL Sandbox". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!