Created
August 2, 2016 14:04
-
-
Save miklos-szel/de8489a96e152a18f8bbf53dcbbc7afc to your computer and use it in GitHub Desktop.
proxysql.cnf
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #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:admin" | |
| mysql_ifaces="0.0.0.0:6032" | |
| refresh_interval=2000 | |
| # debug=true | |
| } | |
| 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;/tmp/proxysql.sock" | |
| default_schema="information_schema" | |
| stacksize=1048576 | |
| server_version="5.1.30" | |
| connect_timeout_server=10000 | |
| monitor_history=60000 | |
| monitor_connect_interval=200000 | |
| monitor_ping_interval=200000 | |
| ping_interval_server=10000 | |
| ping_timeout_server=200 | |
| commands_stats=true | |
| sessions_sort=true | |
| } | |
| # defines all the MySQL servers | |
| mysql_servers = | |
| ( | |
| # { | |
| # address = "127.0.0.1" # no default, required . If port is 0 , address is interpred as a Unix Socket Domain | |
| # port = 3306 # no default, required . If port is 0 , address is interpred as a Unix Socket Domain | |
| # hostgroup = 0 # no default, required | |
| # status = "ONLINE" # default: ONLINE | |
| # weight = 1 # default: 1 | |
| # compression = 0 # default: 0 | |
| # max_replication_lag = 10 # default 0 . If greater than 0 and replication lag passes such threshold, the server is shunned | |
| # }, | |
| # { | |
| # address = "/var/lib/mysql/mysql.sock" | |
| # port = 0 | |
| # hostgroup = 0 | |
| # }, | |
| # { | |
| # address="127.0.0.1" | |
| # port=21891 | |
| # hostgroup=0 | |
| # max_connections=200 | |
| # }, | |
| # { address="127.0.0.2" , port=3306 , hostgroup=0, max_connections=5 }, | |
| # { address="127.0.0.1" , port=21892 , hostgroup=1 }, | |
| # { address="127.0.0.1" , port=21893 , hostgroup=1 } | |
| # { address="127.0.0.2" , port=3306 , hostgroup=1 }, | |
| # { address="127.0.0.3" , port=3306 , hostgroup=1 }, | |
| # { address="127.0.0.4" , port=3306 , hostgroup=1 }, | |
| # { address="/var/lib/mysql/mysql.sock" , port=0 , hostgroup=1 } | |
| ) | |
| # defines all the MySQL users | |
| mysql_users: | |
| ( | |
| # { | |
| # username = "username" # no default , required | |
| # password = "password" # default: '' | |
| # default_hostgroup = 0 # default: 0 | |
| # active = 1 # default: 1 | |
| # }, | |
| # { | |
| # username = "root" | |
| # password = "" | |
| # default_hostgroup = 0 | |
| # max_connections=1000 | |
| # default_schema="test" | |
| # active = 1 | |
| # }, | |
| # { username = "user1" , password = "password" , default_hostgroup = 0 , active = 0 } | |
| ) | |
| #defines MySQL Query Rules | |
| mysql_query_rules: | |
| ( | |
| # { | |
| # rule_id=1 | |
| # active=1 | |
| # match_pattern="^SELECT .* FOR UPDATE$" | |
| # destination_hostgroup=0 | |
| # apply=1 | |
| # }, | |
| # { | |
| # rule_id=2 | |
| # active=1 | |
| # match_pattern="^SELECT" | |
| # destination_hostgroup=1 | |
| # apply=1 | |
| # } | |
| ) | |
| # http://www.hyperrealm.com/libconfig/libconfig_manual.html#Configuration-File-Grammar | |
| # | |
| # Below is the BNF grammar for configuration files. Comments and include directives are not part of the grammar, so they are not included here. | |
| # | |
| # configuration = setting-list | empty | |
| # | |
| # setting-list = setting | setting-list setting | |
| # | |
| # setting = name (":" | "=") value (";" | "," | empty) | |
| # | |
| # value = scalar-value | array | list | group | |
| # | |
| # value-list = value | value-list "," value | |
| # | |
| # scalar-value = boolean | integer | integer64 | hex | hex64 | float | |
| # | string | |
| # | |
| # scalar-value-list = scalar-value | scalar-value-list "," scalar-value | |
| # | |
| # array = "[" (scalar-value-list | empty) "]" | |
| # | |
| # list = "(" (value-list | empty) ")" | |
| # | |
| # group = "{" (setting-list | empty) "}" | |
| # |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment