Enable proxysql cluster sync

[optimadba]

In case there are multiple ProxySQL servers part of a setup you could make use of cluster sync functionality. To enable this add the following commands to the setup of proxysql:
INSERT INTO proxysql_servers (hostname,port,weight,comment) VALUES ('************',6032,0,'************'); INSERT INTO proxysql_servers (hostname,port,weight,comment) VALUES ('************',6032,0,'************'); LOAD PROXYSQL SERVERS TO RUNTIME; SAVE PROXYSQL SERVERS TO DISK; SET admin-cluster_username = 'cluster'; SET admin-cluster_password = '******'; UPDATE global_variables SET variable_value='admin:******;cluster:******' WHERE variable_name='admin-admin_credentials'; update global_variables set variable_value='cluster' where variable_name='admin-cluster_username'; update global_variables set variable_value='********' where variable_name='admin-cluster_password'; LOAD ADMIN VARIABLES TO RUNTIME ; SAVE ADMIN VARIABLES TO DISK ;
Maybe additional firewall rules are needed between the proxysql nodes.