ProxySQL/proxysql.cnf

datadir="/var/lib/proxysql"

admin_variables=
{
	admin_credentials="admin:admin;radmin:radmin"
	mysql_ifaces="0.0.0.0:6032"
}

global_variables=
{
	mysql-monitor_username="monitoruser"
	mysql-monitor_password="monitorpass"
	mysql-monitor_connect_interval=2000
	mysql-monitor_ping_interval=1000
	mysql-monitor_read_only_interval=2000
}

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:6033"
	default_schema="information_schema"
	stacksize=1048576
	server_version="5.5.30"
	connect_timeout_server=3000
	monitor_username="monitoruser"
	monitor_password="monitorpass"
	monitor_history=600000
	monitor_connect_interval=60000
	monitor_ping_interval=10000
	monitor_read_only_interval=1500
	monitor_read_only_timeout=500
	ping_interval_server_msec=120000
	ping_timeout_server=500
	commands_stats=true
	sessions_sort=true
	connect_retries_on_failure=10
}

mysql_servers =
(
  {
    address="mysql1"
    port=3307
    hostgroup=0
    max_connections=200
  },
  {
    address="mysql2"
    port=3308
    hostgroup=1
    max_connections=200
  }
)

mysql_users:
(
  {
    username = "monitoruser"
    password = "monitorpass"
    default_hostgroup = 0
    max_connections=1000
    default_schema="application"
    active = 1
  }
)

mysql_query_rules:
(
  {
    rule_id=1
    active=1
    match_pattern="^SELECT .* FOR UPDATE$"
    destination_hostgroup=0
    apply=1
  },
  {
    rule_id=2
    active=1
    match_pattern="^SELECT"
    destination_hostgroup=1
    apply=1
  }
)