How To Install Percona on Fedora 39

In this tutorial, we will show you how to install Percona on Fedora 39. Percona, a renowned name in the realm of database management and performance optimization, offers a suite of open-source software tools designed to ensure optimal performance, high availability, and improved manageability of MySQL, MariaDB, MongoDB, and PostgreSQL databases.

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 on a Fedora 39.

Prerequisites

Before diving into the installation process, let’s ensure that you have everything you need:

• A server running one of the following operating systems: Fedora 39.
• It’s recommended that you use a fresh OS install to prevent any potential issues.
• You will need access to the terminal to execute commands. Fedora 39 provides the Terminal application for this purpose. It can be found in your Applications menu.
• You’ll need an active internet connection to download Percona and its dependencies.
• 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 Fedora 39

Step 1. Before diving into the installation process, it’s crucial to ensure your Fedora system meets the necessary requirements. Fedora 39 should be your operating system, and it should be updated to the latest version. To update your Fedora system, use the following commands:

sudo dnf clean all
sudo dnf update

Step 2. Installing Percona on Fedora 39.

The Percona repository is a storage location from which software packages can be retrieved and installed on a computer. To install the Percona repository on Fedora 39, use the following commands:

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

Percona Server for MySQL is a free, fully compatible, enhanced, and open-source drop-in replacement for MySQL that provides superior performance, scalability, and instrumentation. To install Percona Server for MySQL on Fedora 39, use the following commands:

sudo dnf install Percona-Server-server-80
sudo systemctl start mysql
sudo systemctl enable mysql

Run the following command to secure your Percona installation:

sudo mysql_secure_installation

Follow the prompts to set a root password, remove anonymous users, disable remote root login, and reload the privileges. This will harden the security of your MySQL installation.

Step 3. Configuring Percona Server for MySQL.

Proper configuration of Percona Server for MySQL is essential for achieving optimal performance. To configure Percona Server for MySQL on Fedora 39, you’ll need to edit the MySQL configuration file, typically located at /etc/my.cnf. Use a text editor of your choice to open and modify this file.

sudo nano /etc/my.cnf

Add or modify the following parameters:

innodb_buffer_pool_size = 2G # Set as per available RAM
innodb_log_file_size = 512M # Double the default size
innodb_flush_log_at_trx_commit = 0 # Disable sync for commits

Save the file and restart Percona for the changes to take effect:

sudo systemctl restart mysqld

Step 4. Installing Percona Toolkit.

Percona Toolkit is a collection of advanced command-line tools used by both system administrators and DBAs for a variety of MySQL and system tasks. To install Percona Toolkit on Fedora 39, use the following commands:

sudo dnf install percona-toolkit

After the installation process, it’s crucial to verify that Percona and its components have been correctly installed. You can check the status of the Percona Server for MySQL using the following command:

sudo systemctl status mysql

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