Shulou(Shulou.com)05/31 Report--

This article is about how to install Percona server using binary tar packages. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Installing Percona Server from a Binary Tarball1 downloads the binary tar package using version 5.6 as an example, which can be found on the official website https://www.percona.com/downloads/Percona-Server-5.6/LATEST/ as follows:

# Select a specific version of percona server in the Version drop-down box

# Select the corresponding OS version or binary tar package or source code download in the Software drop-down box

# download the last version 5.6 here, as follows:

From the above picture, we can see that when the version and download method (binary tar package) are selected, more than one corresponding tar package is shown below, and their differences are: ssl098, ssl100, ssl101. The differences are as follows:

Ssl100-for all Debian/Ubuntu versions except Debian Squeeze (libssl.so.1.0.0 = > / usr/lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007f2e389a5000))

Ssl098-only for Debian Squeeze (libssl.so.0.9.8 = > / usr/lib/libssl.so.0.9.8 (0x00007f9b30db6000))

Ssl101-for CentOS 6 and CentOS 7 (libssl.so.10 = > / usr/lib64/libssl.so.10 (0x00007facbe8c4000))

Ssl098e-to be used only for CentOS 5 (libssl.so.6 = > / lib64/libssl.so.6 (0x00002aed5b64d000)).

Choose to install to RHEL6 here and download the tar package corresponding to ssl101

2 extract tar package # create basedir

] # mkdir / data/percona

# decompression

] # tar-zxvf Percona-Server-5.6.29-rel76.2-Linux.x86_64.ssl101.tar.gz-C / data/percona/

] # cd / data/percona/

] # mv Percona-Server-5.6.29-rel76.2-Linux.x86_64.ssl101/ mysql

# finally installed to the / data/percona/mysql/ directory

] # ls / data/percona/mysql/

] # chown mysql:mysql / data/percona/mysql/-R

3 Edit the configuration file # read / etc/my.cnf by default. Other mysql instances already exist in the experimental environment. The-- defaults-file=/tmp/my.cnf parameter is used to specify the configuration file during initialization and startup.

] # cat / tmp/my.cnf

[mysqld]

Basedir=/data/percona/mysql

Datadir=/data/percona/mysql/data

Socket=/data/percona/mysql/mysql.sock

Log-error=/data/percona/mysql/mysqld.log

Innodb_buffer_pool_size = 128m

Port=6603

4 initialize db#. Since another mysql instance exists locally, the specified cnf path is considered here.

] #. / scripts/mysql_install_db-- defaults-file=/tmp/my.cnf

5 start percona mysql] # / data/percona/mysql/bin/mysqld_safe-- defaults-file=/tmp/my.cnf &

160504 10:37:02 mysqld_safe Adding'/ data/percona/mysql/lib/mysql/libjemalloc.so.1' to LD_PRELOAD for mysqld

160504 10:37:02 mysqld_safe Logging to'/ data/percona/mysql/mysqld.log'.

160504 10:37:02 mysqld_safe Starting mysqld daemon with databases from / data/percona/mysql/data

6 View process] # netstat-antpl | grep mysqld

Tcp 0 0: 6603: * LISTEN 17835/mysqld # percona mysql

Tcp 0 0: 3306: * LISTEN 23233/mysqld # mysql running by default

7 View log] # tail-f / data/percona/mysql/mysqld.log

2016-05-04 10:37:03 17835 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.29-rel76.2 started; log sequence number 1625997

2016-05-04 10:37:03 17835 [Note] RSA private key file not found: / data/percona/mysql/data//private_key.pem. Some authentication plugins will not work.

2016-05-04 10:37:03 17835 [Note] RSA public key file not found: / data/percona/mysql/data//public_key.pem. Some authentication plugins will not work.

2016-05-04 10:37:03 17835 [Note] Server hostname (bind-address):'*'; port: 6603

2016-05-04 10:37:03 17835 [Note] IPv6 is available.

2016-05-04 10:37:03 17835 [Note] -:: 'resolves to'::'

2016-05-04 10:37:03 17835 [Note] Server socket created on IP:':'

2016-05-04 10:37:03 17835 [Note] Event Scheduler: Loaded 0 events

2016-05-04 10:37:03 17835 [Note] / data/percona/mysql/bin/mysqld: ready for connections.

Version: '5.6.29-76.2' socket:'/ data/percona/mysql/mysql.sock' port: 6603 Percona Server (GPL), Release 76.2, Revision ddf26fe

At this point, the installation of percona's binary tar package is easy to complete, and it is found that it is almost the same as the installation of mysql, with more options for configuration files, startup script configuration, and some subsequent configurations are all similar to mysql's.

8. Uninstall percona server1. Stop the Percona Server service# here because there are other default mysql instances running, you need to specify the current sock location and port

~] # / data/percona/mysql/bin/mysqladmin-S / data/percona/mysql/mysql.sock-P 6603 shutdown

2. Remove the data and configuration files# can delete basedir and datadir directly.

~] # rm-rf / data/percona/mysql/

Thank you for reading! This is the end of the article on "how to install Percona server using binary tar package". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.