Brevet/dev/provisioning/ansible/roles/proxysql/templates/proxysql-admin.cnf.j2

# proxysql admin interface credentials.
export PROXYSQL_USERNAME='admin'
export PROXYSQL_PASSWORD='AdminStrongPassword'
export PROXYSQL_HOSTNAME='localhost'
export PROXYSQL_PORT='6032'
export PROXYSQL_DATADIR='/var/lib/proxysql'


# ProxySQL read/write hostgroup
export HOSTGROUP_WRITER_ID=10
export HOSTGROUP_READER_ID=11

# Writer-is-reader configuration
export WRITER_IS_READER="ondemand"

# ProxySQL read/write configuration mode : loadbal|singlewrite
export MODE="singlewrite"

# max_connections default (used only when INSERTing a new mysql_servers entry)
export MAX_CONNECTIONS=1000