proxysql.cnf

datadir="/var/lib/proxysql"
errorlog="/var/lib/proxysql/proxysql.log"
admin_variables=
{
  admin_credentials="admin:admin;radmin:radmin"
  mysql_ifaces="0.0.0.0:6032"
  admin-web_enabled=true
  debug=true
}

mysql_variables=
{
  threads=4
  mysql-auditlog_filename="mysql.log"
  max_connections=2048
  default_query_delay=0
  default_query_timeout=36000000
  have_compress=false
  poll_timeout=2000
  mysql-autocommit_false_is_transaction=true
  interfaces="0.0.0.0:6033"
  default_schema="information_schema"
  stacksize=1048576
  server_version="8.0.0"
  mysql-forward_autocommit=true
  connect_timeout_server=3000
  monitor_username="monitor"
  monitor_password="monitor"
  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="leftoverstoday-dev-01"
    port=3306
    hostgroup=0
    max_connections=200
  },
)

mysql_users=
(
  {
    username = "root"
    password = "Jxv5dx6kdbrt!"
    default_hostgroup = 0
    max_connections=1000
    default_schema="information_schema"
    active = 1
  },
  {
    username = "mariadb"
    password ="Jxv5dx6kdb!"
    default_hostgroup = 4
    max_connections=1000
    default_schema="default"
    active = 1
    transaction_persistent=0
  },
)