datadir="/var/lib/proxysql"
admin_variables=
{
admin_credentials="admin:admin"
mysql_ifaces="0.0.0.0:6032"
}
mysql_variables=
{
threads=4
max_connections=2048
default_query_delay=0
default_query_timeout=36000000
have_compress=true
poll_timeout=2000
interfaces="0.0.0.0:6033"
default_schema="information_schema"
stacksize=1048576
server_version="8.0.27"
connect_timeout_server=3000
monitor_history=60000
monitor_connect_interval=200000
monitor_ping_interval=200000
ping_interval_server_msec=120000
ping_timeout_server=200
commands_stats=true
sessions_sort=true
monitor_username="monitor"
monitor_password="9!qpzs.C0m"
monitor_read_only_interval=1500
monitor_read_only_timeout=500
set_query_lock_on_hostgroup=0
}
mysql_replication_hostgroups =
(
{
writer_hostgroup=10
backup_writer_hostgroup=20
reader_hostgroup=30
offline_hostgroup=9999
max_writers=1
writer_is_also_reader=2
max_transactions_behind=30
active=1
}
)
mysql_servers =
(
{ address="192.168.0.101" , port=3306 , hostgroup=10, weight=1, max_connections=100 },
{ address="192.168.0.101" , port=3306 , hostgroup=30, weight=1, max_connections=100 },
{ address="192.168.0.102" , port=3306 , hostgroup=30, weight=20, max_connections=100 },
{ address="192.168.0.103" , port=3306 , hostgroup=30, weight=20, max_connections=100 }
)
mysql_query_rules =
(
{
rule_id=100
active=1
match_pattern="^SELECT .* FOR UPDATE$"
destination_hostgroup=10
apply=1
},
{
rule_id=200
active=1
match_pattern="^SELECT"
destination_hostgroup=30
apply=1
}
)
mysql_users =
(
{ username = "root", password = "123456", default_hostgroup = 10, transaction_persistent = 0, active = 1 }
)
