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.

 

  • 0

Install Wine on Linux Distribution

Install Wine on Linux Distribution In this tutorial, we can check how to Install Wine on Linux...

Install Apache Tomcat on Ubuntu 18.04

Install Apache Tomcat on Ubuntu 18.04 The Apache Tomcat is a free, open-source Java-based web...

How to Install and Setup Angular CLI

How to Install and Setup Angular CLIAngular is an open-source framework for your web...

How to Install Jenkins on CentOS and Ubuntu Server?

How to Install Jenkins on CentOS and Ubuntu Server? Jenkins is a free and open-source automation...

Setup ILIAS LMS on Ubuntu 18.04/16.04 with Nginx

ILIAS is an Open-Source Learning Management System. ILIAS LMS offers to develop and realizing...