Install Percona Server in rpm package

Install Percona Server in rpm package

Percona XtraDBIt is an enhanced version of the InnoDB Storage engine and is designed to better use and update the performance of computer hardware systems. It also contains some new features in high-performance environments. The XtraDB storage engine is completely backward compatible, so you can use XtraDB to replace the InnoDB Storage engine.

Percona XtraDB includes all InnoDB's robustness, ACID Compatibility Design, and advanced MVCC architecture that can be relied on. XtraDB is built on the solid foundation of InnoDB, so that XtraDB has more features, better calls, more parameter indicators and more extensions.

In particular, XtraDB is designed to use the memory more effectively and conveniently and more available with multiple cores. It also removes many InnoDB restrictions and provides more configuration and performance monitoring parameters than InnoDB.

Percona XtraDBEngine is included inPercona ServerAndMariaDBMedium.

Installing Percona ServerOn Red Hat Enterprise Linux

Percona Server has multiple installation methods like MySQL: yum Repositories, rpm, Binary Tarball, Source Tarball, Git Source Tree, etc. You can select the appropriate method based on the actual environment. For detailed installation steps, see the official documentation. The following describes how to install the rpm package on RHEL 6.

Installing Percona ServerUsing rpm packages1 download package

Wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.29-76.2/binary/redhat/6/x86_64/Percona-Server-5.6.29-76.2-rddf26fe-el6-x86_64-bundle.tar

2. decompress the tar package

# Tar-xvf Percona-Server-5.6.29-76.2-rddf26fe-el6-x86_64-bundle.tar

# Ls *. rpm

Percona-Server-56-debuginfo-5.6.29-rel76.2.el6.x86_64.rpm

Percona-Server-server-56-5.6.29-rel76.2.el6.x86_64.rpm

Percona-Server-tokudb-56-5.6.29-rel76.2.el6.x86_64.rpm

Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64.rpm

Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64.rpm

Percona-Server-devel-56-5.6.29-rel76.2.el6.x86_64.rpm

Percona-Server-test-56-5.6.29-rel76.2.el6.x86_64.rpm

3. Install Percona Server

# Rps-ivh Percona-Server-server-56-5.6.29-rel76.2.el6.x86_64.rpm \

Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64.rpm \

Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64.rpm

# The above three rpm packages are only used to install the Percona server

# If you need to (including debugging, testing, etc), directly install all the rpm packages.

# Rpm-ivh *. rpm

Appendix: Error in RHEL6 installation: libcrypto. so.10 and libssl. so.10

Error: Failed dependencies:

Libcrypto. so.10 (libcrypto. so.10) (64bit) is needed by Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64

Libssl. so.10 (libssl. so.10) (64bit) is needed by Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64

Libcrypto. so.10 (libcrypto. so.10) (64bit) is needed by Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64

Libssl. so.10 (libssl. so.10) (64bit) is needed by Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64

# RedHat EL6 comes with the openssl-1.0.0 version, for Percona-Server should install the openssl-1.0.1 version, after installing the new version, the problem solved

# Rpm-ivh openssl10-libs-1.0.1e-1.ius.el6.x86_64.rpm -- force

Warning: openssl10-libs-1.0.1e-1.ius.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 9cd4953f: NOKEY

Preparing... ######################################## ### [100%]

1: openssl10-libs ####################################### #### [100%]

4. Configuration File

Percona ServerThe default data file path is under/var/lib/mysql /.

# Edit the configuration file/etc/my. cnf

# Cat/etc/my. cnf

[Mysqld]

Datadir =/var/lib/mysql

Socket =/var/lib/mysql. sock

Log-error =/var/log/mysqld. log

Innodb_buffer_pool_size = 128 M

Note: There are many options in the configuration file. The specific configuration is based on actual needs. Here is a simple configuration.

5. Run Percona Server1. Starting the service

#/Etc/init. d/mysql start

Starting MySQL (Percona Server) .......... [OK]

2. Confirming that service is running

#/Etc/init. d/mysql status

MySQL (Percona Server) running (3369) [OK]

3. Stopping the service

#/Etc/init. d/mysql stop

Shutting down MySQL (Percona Server) .. [OK]

4. Restarting the service

#/Etc/init. d/mysql restart

Shutting down MySQL (Percona Server) .. [OK]

Starting MySQL (Percona Server) ...... [OK]

6. View logs

# Tail-f/var/log/mysqld. log

16:28:23 3595 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 1626007

16:28:23 3595 [Note] RSA private key file not found:/var/lib/mysql // private_key.pem. Some authentication plugins will not work.

16:28:23 3595 [Note] RSA public key file not found:/var/lib/mysql // public_key.pem. Some authentication plugins will not work.

16:28:23 3595 [Note] Server hostname (bind-address): '*'; port: 3306

16:28:23 3595 [Note] IPv6 is available.

16:28:23 3595 [Note]-': 'resolves '::';

16:28:23 3595 [Note] Server socket created on IP :'::'.

16:28:23 3595 [Note] Event schedents: Loaded 0 events

16:28:23 3595 [Note]/usr/sbin/mysqld: ready for connections.

Version: '5. 6.29-76.2 'socket:'/var/lib/mysql. sock 'port: 3306 Percona Server (GPL), Release 76.2, Revision ddf26fe

7 uninstall Percona Server1. Stop Percona ServerService

#/Etc/init. d/mysql stop

Shutting down MySQL (Percona Server) .. [OK]

2. Remove the packages

# Rpm-qa | grep-I percona

Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64

Percona-Server-server-56-5.6.29-rel76.2.el6.x86_64

Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64

# Rpm e Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64 \

Percona-Server-server-56-5.6.29-rel76.2.el6.x86_64 \

Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64

# Rpm-qa | grep-I percona

3. Remove the data and configuration files

# Rm-rf/var/lib/mysql // etc/my. cnf

Note: All data files (databases, tables, logs, etc.) will be deleted .), maybe the location of datafile in your environment is not the default/var/lib/mysql, but another directory. delete the file according to the actual situation during uninstallation.

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: