#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:XXXXXXXXXX;radmin:XXXXXXXXXX"
  stats_credentials="stats:XXXXXXXXXX;rstats:XXXXXXXXXX"
  mysql_ifaces="0.0.0.0:6032;/tmp/proxysql_admin.sock"
}


mysql_variables=
{
  log_unhealthy_connections=false
  log_mysql_warnings_enabled=true
  verbose_query_error=true
  threads=4
  max_connections=2048
  default_query_delay=0
  default_query_timeout=36000000
  have_compress=true
  poll_timeout=2000
  max_allowed_packet=67108864
  interfaces="0.0.0.0:3306;0.0.0.0:3307;/tmp/proxysql.sock"
  stacksize=1048576
  server_version="5.7.36"
  connect_timeout_server=10000
  monitor_history=600000
  monitor_connect_interval=60000
  monitor_ping_interval=30000
  monitor_username="monitor"
  monitor_password="XXXXXXXXXX"
  ping_interval_server_msec=10000
  ping_timeout_server=200
  commands_stats=true
  sessions_sort=true
  eventslog_filename="/var/lib/proxysql/queries.log"
  eventslog_filesize=104857600
  eventslog_format=2
  wait_timeout=7200000
  use_tcp_keepalive=1
  tcp_keepalive_time=120
}

@include "/etc/proxysql.cnf.d/users.cnf"

mysql_servers =
(
  {
    address = "int.mysql57-indra-mitra-0.dev.secondlife.io"
    hostgroup = 1
    max_connections = 200
  },
  {
    address = "int.mysql57-indra-mitra-1.dev.secondlife.io"
    hostgroup = 1
    max_connections = 200
  },
  {
    address = "int.mysql57-indra-mitra-1.dev.secondlife.io"
    hostgroup = 2
    max_connections = 200
  },
  {
    address = "int.mysql57-indra-mitra-2.dev.secondlife.io"
    hostgroup = 2
    max_connections = 200
    weight = 1000
  }
)

mysql_replication_hostgroups=
(
  {
    writer_hostgroup=0
    reader_hostgroup=1
    comment="ALL"
  }
)

mysql_query_rules:
(
  {
    rule_id=10000
    active=1
    proxy_port=3306
    schemaname="indra"
    destination_hostgroup=0
    apply=1
    comment="indra writes"
  },
  {
    rule_id=10020
    active=1
    proxy_port=3307
    schemaname="indra"
    destination_hostgroup=2
    apply=1
    comment="indra reads"
  }
)