Install Percona Server in Linux

Install Percona Server in Linux

Percona Server is an enhanced version of the MySQL database server. It is much faster and more scalable, easier to monitor and tune. It also offers improved scalability on modern hardware, such as SSD and Flash storage. It is a replacement for MySQL with some extra features. Some of the features are listed below.

• Improved Buffer Pool Scalability
• Handler Socket included by default
• InnoDB Data Dictionary Size Limit
• Dynamic Row Format Memory Tables
• Extra slow query log statistics and configuration options

The Percona yum repository supports popular RPM-based operating systems, including the Amazon Linux AMI. The easiest way to install the Percona Yum repository is to install an RPM that configures yum and installs the Percona GPG key.

 

Supported Releases:

• CentOS 6 and RHEL 6
• CentOS 7 and RHEL 7
• Amazon Linux AMI (works the same as CentOS 6)

The CentOS repositories should work well with Red Hat Enterprise Linux too, provided that yum is installed on the server.

 

Supported Platforms:

• x86
• x86_64

 

Installing Percona on Servers

1) Login as root and run the given below commands:

# wget https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.10-3/binary/redhat/7/x86_64/Percona-Server-5.7.10-3-r63dafaf-el7-x86_64-bundle.tar

2) Unpack the bundle to get the packages run:

# tar xvf Percona-Server-5.7.10-3-r63dafaf-el7-x86_64-bundle.tar

# yum install Percona-Server-server-57.x86_64 -y

 

Running Percona Server

Percona Server stores the data files in /var/lib/mysql/ by default.

You can find the configuration file that is used to manage Percona Server in /etc/my.cnf.

 

Starting the service

Percona Server isn’t started automatically on RHEL and CentOS after it gets installed. You should start it by running:

# systemctl start mysql

# systemctl enable mysql

 

Confirming that service is running

# systemctl status mysql

 

Stopping the service

# systemctl stop mysql

 

Restarting the service

# systemctl restart mysql

 

Uninstalling Percona Server

To completely uninstall Percona Server you’ll need to remove all the installed packages and data files.

1) Stop the Percona Server service

# systemctl stop mysql

2) Remove the packages

# yum remove Percona-Server*

3) Remove the data and configuration files.

# rm -rf /var/lib/mysql

# rm -f /etc/my.cnf

 

If you need any further assistance please contact our support department.