Install Percona Server using a binary tar package

Install Percona Server using a binary tar package

Install Percona Server using a binary tar package

InstallingPercona ServerFrom a Binary Tarball

1. Download the binary tar package

Take version 5.6 as an example. Go to the official website https://www.percona.com/downloads/percona-server-5.6/latest/and you can see the following:

# Select a specific percona server Version from the Version drop-down list

# Select the OS version, binary tar package, or source code to download from the Software drop-down box.

 

# Download the last 5.6 version here, as shown below:

It was found that when you select the version and download method (Binary tar package), more than one corresponding tar package is shown below, and their difference is: ssl098, ssl100, and ssl101. their differences are as follows:

• Ssl100-for allDebian/UbuntuVersions limit tDebian Squeeze(Libssl. so.1.0.0 =>/usr/lib/x86_64-linux-gnu/libssl. so.1.0.0 (0x00007f2e389a5000 ));
• Ssl098-onlyDebian Squeeze(Libssl. so.0.9.8 =>/usr/lib/libssl. so.0.9.8 (0x00007f9b30db6000 ));
• Ssl101-CentOS6 andCentOS7 (libssl. so.10 =>/usr/lib64/libssl. so.10 (0x00007facbe8c4000 ));
• Ssl098e-to be used onlyCentOS5 (libssl. so.6 =>/lib64/libssl. so.6 (0x20.2aed5b64d000 )).

Select RHEL6 to download the tar package corresponding to ssl101.

2. decompress the tar package

# Create basedir

# Mkdir/data/percona

# Decompress

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

# Cd/data/percona/

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

# Finally install it 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 by default. cnf. Other mysql instances already exist in the experiment environment. -- defaults-file =/tmp/my is used during initialization and startup. cnf parameter to specify the configuration file

# Cat/tmp/my. cnf

[Mysqld]

Basedir =/data/percona/mysql

Datadir =/data/percona/mysql/data

Socket =/data/percona/mysql. sock

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

Innodb_buffer_pool_size = 128 M

Port = 6603

4. initialize the database

# Because a local mysql instance exists, the cnf path is specified 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 Processes

# Netstat-antpl | grep mysqld

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

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

7. View logs

# Tail-f/data/percona/mysql/mysqld. log

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

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

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

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

10:37:03 17835 [Note] IPv6 is available.

10:37:03 17835 [Note]-': 'resolves '::';

10:37:03 17835 [Note] Server socket created on IP :'::'.

10:37:03 17835 [Note] Event schedents: Loaded 0 events

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

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

So far, the installation of percona binary tar package is simple, and it is found that the installation is almost the same as that of mysql, more configuration options, startup script configuration, and some subsequent configuration in the configuration file are similar to those in mysql.

8 uninstall percona server1. Stop Percona ServerService

# Because Other Default mysql instances are running, you must specify the current sock location and Port

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

2. Remove the data and configuration files

# Simply delete basedir and datadir.

~ # Rm-rf/data/percona/mysql/

How to install Percona Server on CentOS 7

Percona Server uses google-mysql-tools, Proven Scaling, and Open Query to transform MySQL.

An example of problem solving in CentOS compiling and installing Percona Server 5.5.42

Statistics on the differences between Percona Server 5.6 and 5.5

An example of problem solving in CentOS compiling and installing Percona Server 5.5.42

Percona Server details: click here
Percona Server: click here

This article permanently updates the link address: