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:
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.
