proxySQL設定チート

プロセス操作

init script run	systemd	Admin>
service proxysql start	systemctl start proxysql
service proxysql stop	systemctl stop proxysql	proxysql stop
service proxysql restart	systemctl restart proxysql	proxysql restart
/etc/init.d/proxysql initial service proxysql initial	systemctl start proxysql-initial service proxysql-initial start

テーブル一覧とコピペ用コマンド

RUNTIME	MEMORY	LOAD and Save	SELECT	DELETE
runtime_global_variables	global_variables	LOAD MYSQL VARIABLES TO RUNTIME;SAVE MYSQL VARIABLES TO DISK	SELECT * FROM global_variables;	DELETE * FROM global_variables;
runtime_mysql_aws_aurora_hostgroups	mysql_aws_aurora_hostgroups		SELECT * FROM mysql_aws_aurora_hostgroups;	DELETE * FROM mysql_aws_aurora_hostgroups;
runtime_mysql_firewall_whitelist_rules	mysql_firewall_whitelist_rules		SELECT * FROM mysql_firewall_whitelist_rules;	DELETE * FROM mysql_firewall_whitelist_rules;
runtime_mysql_firewall_whitelist_sqli_fingerprints	mysql_firewall_whitelist_sqli_fingerprints		SELECT * FROM mysql_firewall_whitelist_sqli_fingerprints;	DELETE * FROM mysql_firewall_whitelist_sqli_fingerprints;
runtime_mysql_firewall_whitelist_users	mysql_firewall_whitelist_users		SELECT * FROM mysql_firewall_whitelist_users;	DELETE * FROM mysql_firewall_whitelist_users;
runtime_mysql_galera_hostgroups	mysql_galera_hostgroups		SELECT * FROM mysql_galera_hostgroups;	DELETE * FROM mysql_galera_hostgroups;
runtime_mysql_group_replication_hostgroups	mysql_group_replication_hostgroups		SELECT * FROM mysql_group_replication_hostgroups;	DELETE * FROM mysql_group_replication_hostgroups;
runtime_mysql_query_rules	mysql_query_rules	LOAD MYSQL QUERY RULES TO RUNTIME;SAVE MYSQL QUERY RULES TO DISK;	SELECT * FROM mysql_query_rules;	DELETE * FROM mysql_query_rules;
runtime_mysql_query_rules_fast_routing	mysql_query_rules_fast_routing		SELECT * FROM mysql_query_rules_fast_routing;	DELETE * FROM mysql_query_rules_fast_routing;
runtime_mysql_replication_hostgroups	mysql_replication_hostgroups		SELECT * FROM mysql_replication_hostgroups;	DELETE * FROM mysql_replication_hostgroups;
runtime_mysql_servers	mysql_servers	LOAD MYSQL SERVERS TO RUNTIME;SAVE MYSQL SERVERS TO DISK;	SELECT * FROM mysql_servers;	DELETE * FROM mysql_servers;
runtime_mysql_users	mysql_users	LOAD MYSQL USERS TO RUNTIME;SAVE MYSQL USERS TO DISK;	SELECT * FROM mysql_users;	DELETE * FROM mysql_users;
runtime_proxysql_servers	proxysql_servers		SELECT * FROM proxysql_servers;	DELETE * FROM proxysql_servers;
runtime_restapi_routes	restapi_routes		SELECT * FROM restapi_routes;	DELETE * FROM restapi_routes;
runtime_scheduler	scheduler		SELECT * FROM scheduler;	DELETE * FROM scheduler;

コンフィグ確認

cat /etc/proxysql.cnf

ログ確認

less /var/lib/proxysql/proxysql.log