# This configuration file is used to configure proxysql.
#
# Admin_variables: https://proxysql.com/documentation/global-variables/admin-variables
# Mysql_variables: https://proxysql.com/documentation/global-variables/mysql-variables
# Mysql_servers: https://proxysql.com/documentation/main-runtime/#mysql_servers
# Mysql_galera_hostgroups: https://proxysql.com/documentation/main-runtime/#mysql_galera_hostgroups

datadir: "/var/lib/proxysql"
errorlog: "/var/log/kolla/proxysql/proxysql.log"

admin_variables:
   admin_credentials: "kolla-admin:sIIOC3rDTMVYFlkRwgST92TxzvhwhamvGGaezFpb"
   mysql_ifaces: "192.0.2.1:6032;192.0.2.10:6032;/var/lib/kolla/proxysql/admin.sock"
   stats_credentials: "kolla-stats:eVbkFflfKc4tnQeOUanj3Gjbc6AEPQ7kINoGE2XD"
   restapi_enabled: "False"
   restapi_port: "6070"
   prometheus_memory_metrics_interval: "60"

mysql_variables:
   threads: 2
   max_connections: 40000
   interfaces: "192.0.2.10:3306"
   connect_retries_delay: 1000
   connect_retries_on_failure: 20
   monitor_connect_interval: 60000
   monitor_connect_timeout: 180000
   monitor_galera_healthcheck_timeout: "30000"
   monitor_ping_interval: "60000"
   monitor_ping_timeout: "10000"
   monitor_ping_max_failures: "10"
   monitor_read_only_interval: 30000
   monitor_username: "monitor"
   monitor_password: "9nnXRDg6noXGtj9w9C0ppdwWoslZnhP5HXqEfcp3"
   shun_on_failures: 10
   verbose_query_error: true
   ssl_p2s_ca: "/etc/proxysql/certs/root.crt"
   ssl_p2s_cert: "/etc/proxysql/certs/mariadb-cert.pem"
   ssl_p2s_key: "/etc/proxysql/certs/mariadb-key.pem"
   have_ssl: true

mysql_servers:
  - address: "192.0.2.1"
    port :  3306
    hostgroup :  0
    max_connections: 10000
    max_replication_lag: 0
    weight :  100
    comment :  "Writer primary"
    use_ssl: 1

mysql_galera_hostgroups:
  - writer_hostgroup: 0
    backup_writer_hostgroup: 1
    reader_hostgroup: 2
    offline_hostgroup: 3
    max_connections: 10000
    max_writers: 1
    writer_is_also_reader: 0
    comment: "Galera cluster for shard 0"