proxysql-1.4.8-conf

#file proxysql.cfg

# This config file is parsed using libconfig , and its grammar is described in:
# http://www.hyperrealm.com/libconfig/libconfig_manual.html#Configuration-File-Grammar
# Grammar is also copied at the end of this file

datadir="/var/lib/proxysql"

admin_variables=
{
	admin_credentials="admin:admin"
	mysql_ifaces="0.0.0.0:6032"
#	refresh_interval=2000
#	debug=true
}

mysql_variables=
{
	threads=4
	max_connections=2048
	default_query_delay=0
	default_query_timeout=36000000
	have_compress=true
	poll_timeout=2000
	interfaces="0.0.0.0:3306"
	default_schema="information_schema"
	stacksize=1048576
	server_version="5.5.30"
	connect_timeout_server=3000
	monitor_history=600000
	monitor_connect_interval=60000
	monitor_ping_interval=10000
	monitor_read_only_interval=1500
	monitor_read_only_timeout=500
	ping_interval_server=120000
	ping_timeout_server=500
	commands_stats=true
	sessions_sort=true
	connect_retries_on_failure=10
}

# defines all the MySQL servers
mysql_servers =
(
	{
		address = "127.0.0.1"
		port = 3306
		hostgroup = 0
		status = "ONLINE"
		weight = 1
		compression = 0
        max_replication_lag = 0
	}
)


# defines all the MySQL users
mysql_users:
(
	{
		username = "user"
		password = "pass"
		default_hostgroup = 0
		default_schema="db"
		active = 1
	}
)

mysql_query_rules:
()

scheduler=
()

mysql_replication_hostgroups=
()