How To Install Percona on Rocky Linux 9

In this tutorial, we will show you how to install Percona on Rocky Linux 9. Are you looking for a powerful database management system that can handle complex workloads with ease? Percona might be the solution you’ve been searching for! Percona is a popular MySQL and MariaDB alternative that offers enhanced performance, scalability, and security. Whether you’re deploying Percona for the first time or migrating from an existing database platform, we’ve got you covered. In this article, we’ll cover everything you need to know about installing and configuring Percona on Rocky Linux 9. We’ll walk you through the installation process, show you how to configure the database and introduce you to some useful Percona commands. So, if you’re ready to take your database management skills to the next level, let’s get started with the installation of Percona on Rocky Linux 9!

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step installation of the Percona database on Rocky Linux 9 or RHEL-based.

Prerequisites

• A server running one of the following operating systems: Rocky Linux 9.
• It’s recommended that you use a fresh OS install to prevent any potential issues.
• SSH access to the server (or just open Terminal if you’re on a desktop).
• An active internet connection. You’ll need an internet connection to download the necessary packages and dependencies for Percona.
• A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install Percona on Rocky Linux 9

Step 1. The first step is to update your system to the latest version of the package list. To do so, run the following commands:

sudo dnf check-update

Step 2. Installing Percona on Rocky Linux 9.

By default, Percona is not available on Rocky Linux 9 AppStream repository. Now run the following command below to add the Percona repository to your system:

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

After the Percona repository is added to your system, you can proceed with the installation of the Percona server and client packages:

sudo dnf install percona-server percona-server-client

Step 3. Configuring Percona.

Once the installation of the Percona server and client packages are, you need to configure Percona. Run the following command to configure Percona:

sudo /usr/bin/mysql_secure_installation

This command will guide you through the configuration process, including setting up a root password and removing anonymous users.

Step 4. Securing the Percona Installation.

Percona should be secured to protect your database from unauthorized access. You can secure your Percona installation by editing the MySQL configuration file. Run the following command to open the MySQL configuration file:

nano /etc/my.cnf

Add the following lines to the configuration file:

[mysqld]
bind-address=127.0.0.1
default_authentication_plugin=mysql_native_password

Save and close the configuration file. Then, restart the Percona server with the following command:

sudo systemctl restart mysqld

To verify that Percona has been installed correctly on Rocky Linux 9, you can connect to the Percona server and run basic queries to test its functionality. Run the following command to connect to the Percona server:

mysql -u root -p

Congratulations! You have successfully installed Percona. Thanks for using this tutorial for installing the Percona database on your Rocky Linux 9 system. For additional help or useful information, we recommend you check the official Percona website.