How To Install proxysql on Fedora 34

proxysql is A high-performance MySQL proxy

Introduction

In this tutorial we learn how to install proxysql on Fedora 34.

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 Fedora 34. In this tutorial we discuss both methods but you only need to choose one of method to install proxysql.

Install proxysql on Fedora 34 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

The output should look something like this:

Fedora 34 - x86_64                               20 kB/s | 6.6 kB     00:00
Fedora 34 openh264 (From Cisco) - x86_64        1.4 kB/s | 989  B     00:00
Fedora Modular 34 - x86_64                       68 kB/s | 6.5 kB     00:00
Fedora 34 - x86_64 - Updates                    3.5 kB/s | 6.2 kB     00:01
Fedora Modular 34 - x86_64 - Updates             17 kB/s | 5.9 kB     00:00
Metadata cache created.

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

sudo dnf -y install proxysql

Install proxysql on Fedora 34 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

The output should look something like this:

Fedora 34 - x86_64                               20 kB/s | 6.6 kB     00:00
Fedora 34 openh264 (From Cisco) - x86_64        1.4 kB/s | 989  B     00:00
Fedora Modular 34 - x86_64                       68 kB/s | 6.5 kB     00:00
Fedora 34 - x86_64 - Updates                    3.5 kB/s | 6.2 kB     00:01
Fedora Modular 34 - x86_64 - Updates             17 kB/s | 5.9 kB     00:00
Metadata cache created.

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 Fedora 34

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

sudo dnf remove proxysql

proxysql Package Contents on Fedora 34

/etc/proxysql.cnf
/usr/bin/proxysql
/usr/lib/.build-id
/usr/lib/.build-id/13
/usr/lib/.build-id/13/08e828ca7fb7061dd66e594b8e3d94c7809c9a
/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 Fedora 34 using yum and dnf.