How To Install proxysql on Rocky Linux 8

In this tutorial we learn how to install proxysql on Rocky Linux 8. proxysql is A high-performance MySQL proxy

Introduction

In this tutorial we learn how to install proxysql on Rocky Linux 8.

What is proxysql

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL and forks (like Percona Server and MariaDB).

We can use yum or dnf to install proxysql on Rocky Linux 8. In this tutorial we discuss both methods but you only need to choose one of method to install proxysql.

Install proxysql on Rocky Linux 8 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

After updating yum database, We can install proxysql using dnf by running the following command:

sudo dnf -y install proxysql

Install proxysql on Rocky Linux 8 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

After updating yum database, We can install proxysql using yum by running the following command:

sudo yum -y install proxysql

How To Uninstall proxysql on Rocky Linux 8

To uninstall only the proxysql package we can use the following command:

sudo dnf remove proxysql

proxysql Package Contents on Rocky Linux 8

/etc/proxysql.cnf
/usr/bin/proxysql
/usr/lib/.build-id
/usr/lib/.build-id/c4
/usr/lib/.build-id/c4/4226bb34e059b8a8f3f4c4b7c7c090b35443d0
/usr/lib/systemd/system/proxysql.service
/usr/share/doc/proxysql
/usr/share/doc/proxysql/FAQ.md
/usr/share/doc/proxysql/ProxySQL_v1.2.2.md
/usr/share/doc/proxysql/ProxySQL_v1.2.3.md
/usr/share/doc/proxysql/ProxySQL_v1.2.4.md
/usr/share/doc/proxysql/ProxySQL_v1.3.0.md
/usr/share/doc/proxysql/ProxySQL_v1.3.0g.md
/usr/share/doc/proxysql/ProxySQL_v1.3.2.md
/usr/share/doc/proxysql/ProxySQL_v1.3.3.md
/usr/share/doc/proxysql/ProxySQL_v1.4.4.md
/usr/share/doc/proxysql/README.md
/usr/share/doc/proxysql/RUNNING.md
/usr/share/doc/proxysql/Standard_ProxySQL_Admin.txt
/usr/share/doc/proxysql/Stats_API.txt
/usr/share/doc/proxysql/command_line_options.txt
/usr/share/doc/proxysql/global_variables.txt
/usr/share/doc/proxysql/query_parser.txt
/usr/share/licenses/proxysql
/usr/share/licenses/proxysql/LICENSE
/usr/share/man/man1/proxysql.1.gz
/usr/share/proxysql
/usr/share/proxysql/tools
/usr/share/proxysql/tools/proxysql_galera_checker.sh
/usr/share/proxysql/tools/proxysql_galera_writer.pl
/var/lib/proxysql

References

Summary

In this tutorial we learn how to install proxysql on Rocky Linux 8 using yum and dnf.