How To Install proxysql on CentOS 8
Introduction
In this tutorial we learn how to install proxysql on CentOS 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 CentOS 8. In this tutorial we discuss both methods but you only need to choose one of method to install proxysql.
Install proxysql on CentOS 8 Using dnf
Update yum database with dnf using the following command.
sudo dnf makecache --refresh
The output should look something like this:
CentOS Linux 8 - AppStream 43 kB/s | 4.3 kB 00:00
CentOS Linux 8 - BaseOS 65 kB/s | 3.9 kB 00:00
CentOS Linux 8 - ContinuousRelease 43 kB/s | 3.0 kB 00:00
CentOS Linux 8 - Extras 23 kB/s | 1.5 kB 00:00
CentOS Linux 8 - FastTrack 40 kB/s | 3.0 kB 00:00
CentOS Linux 8 - HighAvailability 36 kB/s | 3.9 kB 00:00
CentOS Linux 8 - Plus 24 kB/s | 1.5 kB 00:00
CentOS Linux 8 - PowerTools 50 kB/s | 4.3 kB 00:00
Extra Packages for Enterprise Linux Modular 8 - x86_64 13 kB/s | 9.2 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 kB/s | 8.5 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 CentOS 8 Using yum
Update yum database with yum using the following command.
sudo yum makecache --refresh
The output should look something like this:
CentOS Linux 8 - AppStream 43 kB/s | 4.3 kB 00:00
CentOS Linux 8 - BaseOS 65 kB/s | 3.9 kB 00:00
CentOS Linux 8 - ContinuousRelease 43 kB/s | 3.0 kB 00:00
CentOS Linux 8 - Extras 23 kB/s | 1.5 kB 00:00
CentOS Linux 8 - FastTrack 40 kB/s | 3.0 kB 00:00
CentOS Linux 8 - HighAvailability 36 kB/s | 3.9 kB 00:00
CentOS Linux 8 - Plus 24 kB/s | 1.5 kB 00:00
CentOS Linux 8 - PowerTools 50 kB/s | 4.3 kB 00:00
Extra Packages for Enterprise Linux Modular 8 - x86_64 13 kB/s | 9.2 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 kB/s | 8.5 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 CentOS 8
To uninstall only the proxysql package we can use the following command:
sudo dnf remove proxysql
proxysql Package Contents on CentOS 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 CentOS 8 using yum and dnf.