proxysql.cnf

datadir="/var/lib/proxysql"

admin_variables =
{
	admin_credentials="admin:admin"
	mysql_ifaces="0.0.0.0:6032"
	refresh_interval=2000

	cluster_username="admin"
	cluster_password="admin"
	checksum_admin_variables=false
	checksum_ldap_variables=false
	checksum_mysql_variables=false
	cluster_check_interval_ms=200
	cluster_check_status_frequency=100
	cluster_mysql_query_rules_save_to_disk=true
	cluster_mysql_servers_save_to_disk=true
	cluster_mysql_users_save_to_disk=true
	cluster_proxysql_servers_save_to_disk=true
	cluster_mysql_query_rules_diffs_before_sync=1
	cluster_mysql_servers_diffs_before_sync=1
	cluster_mysql_users_diffs_before_sync=1
	cluster_proxysql_servers_diffs_before_sync=1
}

mysql_variables=
{
	monitor_password="monitor"
	monitor_galera_healthcheck_interval=1000
	threads=2
	max_connections=2048
	default_query_delay=0
	default_query_timeout=10000
	poll_timeout=2000
	interfaces="0.0.0.0:3306"
	default_schema="information_schema"
	stacksize=1048576
	connect_timeout_server=10000
	monitor_history=60000
	monitor_connect_interval=20000
	monitor_ping_interval=10000
	ping_timeout_server=200
	commands_stats=true
	sessions_sort=true
	have_ssl=false
	ssl_p2s_ca=""
	ssl_p2s_cert=""
	ssl_p2s_key=""
	ssl_p2s_cipher="ECDHE-RSA-AES128-GCM-SHA256"
}