Using ProxySQL to Access and Manage Percona XtraDB Cluster
We will use ProxySQL as a gateway to access our Percona XtraDB Cluster. ProxySQL is a high-performance SQL proxy. ProxySQL runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime. The daemon accepts incoming traffic from MySQL clients and forwards it to backend MySQL servers. Installing ProxySQL Node configuration Node Host IP Node 1 db1 192.168.50.31 Node 2 db2 192.168.50.32 Node 3 db3 192.168.50.33 Node 4 proxysql 192.168.50.34 Prerequisites Install CentOS 7 ...