proxysql.cnf

datadir="/var/lib/proxysql"

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

mysql_variables=
{
        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
}



mysql_servers =
 (
        {
                address="MYSQL_HOST"
                port=3306
                hostgroup=0
                max_connections=200
        }
 )

 mysql_users:
 (
        {
                username = "MYSQL_USER"
                password = "MYSQL_USER_PASSWORD"
                default_hostgroup = 0
                max_connections=1000
                active = 1
        }
 )