proxysql.cnf.example

datadir="/var/lib/proxysql"
errorlog="/var/lib/proxysql/proxysql.log"

admin_variables=
{
    admin_credentials="radmin:tztz"
    stats_credentials="ststs:ztztz"
    mysql_ifaces="0.0.0.0:6032"
    admin-web_enabled=true
	web_enabled=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" #6033"
    default_schema="information_schema"
    stacksize=1048576
    server_version="5.5.30"
    connect_timeout_server=3000
    monitor_username="monitor"
    monitor_password="23456fv"
    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="8.4.3.2"
    port=3306
    hostgroup=0
    max_connections=400
  }
)

mysql_users:
(
	{
		username = "xx1" # no default , required
		password = "xyz!n" # default: ''
		default_hostgroup = 0 # default: 0
		active = 1            # default: 1
	}
)

mysql_query_rules =
(
    
    { 
    # SELECT xxx LIMIT ?,?
        rule_id=150
        active=1
        digest="0x546f69afd7019043"
        destination_hostgroup=0
        apply=1
        cache_ttl=20000
    }
    
    
    
    
)