1 能同步操作mysql_query_rules mysql_serversmysql_users proxysql_servers
2 不能同步操作 admin_variables mysql_variables
3 认证用户
update global_variables set variable_value='<REPLACE-HERE>' where variable_name='admin-admin_credentials';
update global_variables set variable_value='<REPLACE-HERE>' where variable_name='admin-cluster_username';
update global_variables set variable_value='<REPLACE-HERE>' where variable_name='admin-cluster_password'
4 变量设置与命令
广播变量
update global_variables set variable_value='true' where variable_name='admin-checksum_mysql_query_rules'
update global_variables set variable_value='true' where variable_name='admin-checksum_mysql_servers'
update global_variables set variable_value='true' where variable_name='admin-checksum_mysql_users'
集群同步命令
LOAD MYSQL QUERY RULES TO RUNTIME
LOAD MYSQL SERVERS TO RUNTIME
LOAD MYSQL USERS TO RUNTIME
LOAD PROXY SERVERS TO RUNTIME
持久化变量
update global_variables set variable_value='true' where variable_name='admin-cluster_mysql_query_rules_save_to_disk';
update global_variables set variable_value='true' where variable_name='admin-cluster_mysql_servers_save_to_disk';
update global_variables set variable_value='true' where variable_name='admin-cluster_mysql_users_save_to_disk';
update global_variables set variable_value='true' where variable_name='admin-cluster_proxysql_servers_save_to_disk';
5 proxy_servers-全局proxysql配置该表是配置表，定义了集群中互相监控着的ProxySQL实例的列表。
hostname ==>集群中同伴ProxySQL实例的主机名
port ==>集群中同伴ProxySQL实例的端口
weight ==>集群中同伴ProxySQL实例的权重
comment ==>集群中同伴ProxySQL实例的备注信息
一个新的节点可以在连接后立即提取配置，但不能将自己作为真实信息的来源进行传播。为了让其他proxysql实例知道存在一个新节点，只需在当前集群的任何节点的PROXYSQL服务器中添加该新节点，并执行 LOAD PROXYSQL SERVERS TO RUNTIME 即可
6 检测集群健康
SELECT hostname, port, name, version, FROM_UNIXTIME(epoch) epoch, checksum, diff_check FROM stats_proxysql_servers_checksums ORDER BY epoch;
7 补充-新命令
- LOAD PROXYSQL SERVERS FROM MEMORY / LOAD PROXYSQL SERVERS TO RUNTIME
从内存数据库中加载proxysql servers配置到runtime数据结构
- SAVE PROXYSQL SERVERS TO MEMORY / SAVE PROXYSQL SERVERS FROM RUNTIME
将proxysql servers配置从runtime数据结构持久化保存到内存数据库中
- LOAD PROXYSQL SERVERS TO MEMORY / LOAD PROXYSQL SERVERS FROM DISK
从磁盘数据库中加载proxysql servers配置到内存数据库中
- LOAD PROXYSQL SERVERS FROM CONFIG
从传统配置文件中加载proxysql servers配置到内存数据库中
- SAVE PROXYSQL SERVERS FROM MEMORY / SAVE PROXYSQL SERVERS TO DISK
将proxysql servers配置从内存数据库中持久化保存到磁盘数据库中