ProxySQL Tool is a command line tool. Check help message for syntax and options:
$ proxysql-tool Usage: proxysql-tool [OPTIONS] COMMAND [ARGS]... Options: --debug Print debug messages --config TEXT ProxySQL Tools configuration file. [default: /etc/twindb /proxysql-tools.cfg] --version Show tool version and exit. --help Show this message and exit. Commands: aws Commands to interact with ProxySQL on AWS. galera Commands for ProxySQL and Galera integration. ping Checks the health of ProxySQL.
By default proxysql-tool
looks for a config in /etc/twindb/proxysql-tools.cfg
.
Example:
[proxysql] host=172.25.3.100 admin_port=6032 admin_username=admin admin_password=admin monitor_username=monitor monitor_password=monitor [galera] cluster_host=172.25.3.10 cluster_port=3306 cluster_username=root cluster_password=r00t load_balancing_mode=singlewriter writer_hostgroup_id=10 reader_hostgroup_id=11