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

This article mainly introduces how to use the rpm package to install Percona server, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Percona XtraDB is an enhanced version of the InnoDB storage engine, designed to better use to update the performance of computer hardware systems, but also includes some new features in high-performance environments. The XtraDB storage engine is fully backward compatible, so you can use XtraDB instead of the InnoDB storage engine.

Percona XtraDB contains all the InnoDB's robustness, dependable ACID-compatible designs and advanced MVCC architectures. XtraDB is built on the solid foundation of InnoDB, so that XtraDB has more features, easier to call, more parameter metrics and more extensions.

In particular, XtraDB is designed to use memory more efficiently and to be more convenient and available under multi-core conditions. It also removes many of the limitations of InnoDB; it provides more configuration and performance monitoring parameters than InnoDB.

Percona XtraDB engine is included in Percona Server and MariaDB.

Like MySQL, Installing Percona Server on Red Hat Enterprise LinuxPercona Server has a variety of installation methods: yum Repositories, rpm, Binary Tarball, Source Tarball, Git Source Tree, etc., which can be selected according to the actual environment. For specific installation steps, please refer to the official documentation. The following mainly takes the installation of the rpm package on RHEL 6 as an example to illustrate the main steps

Installing Percona Server using 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 extract 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] # rpm-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 just to complete the installation of Percona server

# if necessary (including debugging, testing,etc, etc.), install all rpm packages directly

] # rpm-ivh * .rpm

Attached: installation error on RHEL6: 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 openssl-1.0.0 version. For Percona-Server, the version of openssl-1.0.1 should be installed. After installing the new version, the problem will be 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 the default data file path of the configuration file Percona Server is under / var/lib/mysql/

# Edit configuration file / etc/my.cnf

] # cat / etc/my.cnf

[mysqld]

Datadir=/var/lib/mysql

Socket=/var/lib/mysql/mysql.sock

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

Innodb_buffer_pool_size = 128m

Note: there are many options in the configuration file, which are specifically configured according to the actual requirements. Here is only 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 log] # tail-f / var/log/mysqld.log

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

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

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

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

2016-05-03 16:28:23 3595 [Note] IPv6 is available.

2016-05-03 16:28:23 3595 [Note] -:: 'resolves to'::'

2016-05-03 16:28:23 3595 [Note] Server socket created on IP:':'

2016-05-03 16:28:23 3595 [Note] Event Scheduler: Loaded 0 events

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

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

7. Uninstall Percona Server1. Stop the Percona Server service

] # / 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 here. Maybe the location of datafile in your environment is not the default / var/lib/mysql, but other directories. Delete files according to the actual situation when uninstalling.

Thank you for reading this article carefully. I hope the article "how to install Percona server using rpm package" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.