How to Install Percona Server for MySQL on Linux server

Install Percona Server for MySQL on Linux server

Percona Server for MySQL is an enhanced, open-source alternative to MySQL, offering better performance, reliability, and scalability. If you’re looking to optimize your database infrastructure, it’s crucial to install Percona Server for MySQL, especially for high-traffic applications. In this guide, we will walk you through the steps to get it set up on a Linux server.

Percona MySQL includes advanced features like improved query optimization, enterprise-grade security, and superior replication support. It ensures efficient database management with minimal downtime, making it an ideal choice for businesses in need of a powerful MySQL solution.

Prerequisites

Before installing Percona for MySQL, ensure that:

• You have a Linux-based system (Ubuntu, Debian, CentOS, or RHEL).
• You have root or sudo privileges.
• No other MySQL/MariaDB version is running (or you have taken a backup before replacing it).

Step 1: Install Percona Repository

To install Percona for MySQL, first, you need to enable the Percona repository. Run the following commands to install the latest Percona MySQL release package:

For Ubuntu/Debian, download the repository package using curl:

curl -O https://repo.percona.com/apt/percona-release_latest.generic_all.deb

Once downloaded, install the package and update the repository list:

dpkg -i percona-release_latest.generic_all.deb  

apt update

For RHEL/CentOS, run:

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

This command downloads and installs the Percona repository, which contains Percona MySQL,  and other useful database tools.

Step 2: Enable Percona Repositories

After installing the repository, enable the required Percona repository by running:

percona-release enable tools

You can also enable the MySQL repository if you need to install Percona Server for MySQL:

percona-release setup ps80

#Use ps57 for MySQL 5.7, ps80 for MySQL 8.0

This ensures that the package manager fetches Percona packages from the correct repository.

Step 3: Install Percona Server for MySQL

Once the repository is enabled, install Percona Server for MySQL using:

For Ubuntu/Debian:

apt install percona-server-server

For RHEL/CentOS, run:

yum install percona-server-server

Step 4: Start and Enable MySQL Service

systemctl start mysql  
systemctl enable mysql 

Step 5: Secure MySQL Installation

Run the security script to set up a root password and remove unwanted defaults:

mysql_secure_installation

Step 6: Verify Installation

To verify Percona Server for MySQL, check the MySQL version:

mysql --version

Or log in to MySQL and check:

mysql -u root -p  
SELECT VERSION(); 

Conclusion

Percona Server for MySQL is an excellent choice To handle databases quickly and efficiently. By following this guide, you have successfully installed Percona MySQL on your server. Now you can utilize its advanced features to optimize and scale your database operations.

If you encounter any issues or need further assistance with the process of installing Percona Server for MySQL on a Linux server, feel free to reach out to our expert team. We specialize in Linux Server Management Services, ensuring that your server is set up efficiently and securely.