Usage

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.

Configuration file

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