安装ProxySQL

官网：https://www.proxysql.com/documentation/installing-proxysql/

介绍：ProxySQL is a high performance, high availability, protocol aware proxy for MySQL and forks (like Percona Server and MariaDB). All the while getting the unlimited freedom that comes with a GPL license.

一、配置YUM源头

[root@node1 yum.repos.d]# ls
CentOS-Base.repo CentOS-fasttrack.repo CentOS-Vault.repo epel.repo
CentOS-CR.repo CentOS-Media.repo CentOS-x86_64-kernel.repo epel-testing.repo
CentOS-Debuginfo.repo CentOS-Sources.repo docker-ce.repo
[root@node1 yum.repos.d]#
[root@node1 yum.repos.d]#
[root@node1 yum.repos.d]#
[root@node1 yum.repos.d]# cat > /etc/yum.repos.d/proxysql.repo << EOF

[proxysql]
name=ProxySQL YUM repository
baseurl=https://repo.proxysql.com/ProxySQL/proxysql-2.4.x/centos/\$releasever
gpgcheck=1
gpgkey=https://repo.proxysql.com/ProxySQL/proxysql-2.4.x/repo_pub_key
EOF
[root@node1 yum.repos.d]# ls
CentOS-Base.repo CentOS-fasttrack.repo CentOS-Vault.repo epel.repo
CentOS-CR.repo CentOS-Media.repo CentOS-x86_64-kernel.repo epel-testing.repo
CentOS-Debuginfo.repo CentOS-Sources.repo docker-ce.repo proxysql.repo
[root@node1 yum.repos.d]# yum install proxysql

[root@node1 yum.repos.d]# service proxysql status
Redirecting to /bin/systemctl status proxysql.service
● proxysql.service – High Performance Advanced Proxy for MySQL
Loaded: loaded (/etc/systemd/system/proxysql.service; enabled; vendor preset: disabled)
Active: inactive (dead)
[root@node1 yum.repos.d]# service proxysql start
Redirecting to /bin/systemctl start proxysql.service
[root@node1 yum.repos.d]# service proxysql status
Redirecting to /bin/systemctl status proxysql.service
● proxysql.service – High Performance Advanced Proxy for MySQL
Loaded: loaded (/etc/systemd/system/proxysql.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2024-01-10 22:44:51 EST; 3s ago
Process: 1418 ExecStart=/usr/bin/proxysql –idle-threads -c /etc/proxysql.cnf $PROXYSQL_OPTS (code=exited, status=0/SUCCESS)
Main PID: 1420 (proxysql)
CGroup: /system.slice/proxysql.service
├─1420 /usr/bin/proxysql –idle-threads -c /etc/proxysql.cnf
└─1421 /usr/bin/proxysql –idle-threads -c /etc/proxysql.cnf

Jan 10 22:44:51 node1 systemd[1]: Starting High Performance Advanced Proxy for MySQL…
Jan 10 22:44:51 node1 proxysql[1418]: 2024-01-10 22:44:51 [INFO] Using config file /etc/proxysql.cnf
Jan 10 22:44:51 node1 proxysql[1418]: 2024-01-10 22:44:51 [INFO] Current RLIMIT_NOFILE: 102400
Jan 10 22:44:51 node1 proxysql[1418]: 2024-01-10 22:44:51 [INFO] Using OpenSSL version: OpenSSL 3.0.8 7 Feb 2023
Jan 10 22:44:51 node1 proxysql[1418]: 2024-01-10 22:44:51 [INFO] No SSL keys/certificates found in datadir (/var…cates.
Jan 10 22:44:51 node1 systemd[1]: Started High Performance Advanced Proxy for MySQL.
Hint: Some lines were ellipsized, use -l to show in full.
[root@node1 yum.repos.d]#