ProxySQL

 

wget https://github.com/sysown/proxysql/releases/download/v2.0.13/proxysql-2.0.13-1-centos7.x86_64.rpm

[root@mysqldb2 ~]# rpm -ivh proxysql-2.0.13-1-centos7.x86_64.rpm 
warning: proxysql-2.0.13-1-centos7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 79953b49: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:proxysql-2.0.13-1                warning: group proxysql does not exist - using root
warning: group proxysql does not exist - using root
################################# [100%]
Created symlink from /etc/systemd/system/multi-user.target.wants/proxysql.service to /etc/systemd/system/proxysql.service.

[root@mysqldb2 ~]# service proxysql start
Redirecting to /bin/systemctl start proxysql.service
[root@mysqldb2 ~]# 
[root@mysqldb2 ~]# 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 Tue 2020-07-21 14:49:07 CST; 2s ago
  Process: 27843 ExecStart=/usr/bin/proxysql --idle-threads -c /etc/proxysql.cnf $PROXYSQL_OPTS (code=exited, status=0/SUCCESS)
 Main PID: 27847 (proxysql)
    Tasks: 24
   CGroup: /system.slice/proxysql.service
           ├─27847 /usr/bin/proxysql --idle-threads -c /etc/proxysql.cnf
           └─27848 /usr/bin/proxysql --idle-threads -c /etc/proxysql.cnf

Jul 21 14:49:06 mysqldb2 systemd[1]: Starting High Performance Advanced Proxy for MySQL...
Jul 21 14:49:07 mysqldb2 proxysql[27843]: 2020-07-21 14:49:07 [INFO] Using config file /etc/proxysql.cnf
Jul 21 14:49:07 mysqldb2 proxysql[27843]: 2020-07-21 14:49:07 [INFO] Using OpenSSL version: OpenSSL 1.1.1d  10 Sep 2019
Jul 21 14:49:07 mysqldb2 proxysql[27843]: 2020-07-21 14:49:07 [INFO] No SSL keys/certificates found in datadir (/var/lib/proxysql). Generating new keys/certificates.
Jul 21 14:49:07 mysqldb2 systemd[1]: Started High Performan