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: