MySQL Router mysqlrouter commands

MySQL Router

MySQL Router is part of the InnoDB Cluster and is lightweight middleware to provide transparent routing between applications and MySQL Servers.

mysqlrouter --help

mysqlrouter --bootstrap root@localhost:3310 --directory /tmp/router

mysqlrouter --bootstrap localhost:3310 --directory /opt/myrouter --user snoopy

mysqlrouter --bootstrap root@localhost:3310 --directory /tmp/myrouter -conf-use-sockets --account routerfriend --account-create always

mysqlrouter --bootstrap foo@bar.com --connect-timeout=20

mysqlrouter --bootstrap foo@bar.com --conf-set-option=logger.level=debug --conf-set-option=DEFAULT.unknown_config_option=warning --conf-set-option=DEFAULT.connect_timeout=20 --connect-timeout=10

mysqlrouter --bootstrap=127.0.0.1:3310 --master-key-reader=./reader.sh   --master-key-writer=./writer.sh

mysqlrouter --bootstrap localhost:3310 --account-host host1 --account-host host2  --account-host host3

mysqlrouter --bootstrap root@localhost:3310 --conf-base-port 0

mysqlrouter -c /tmp/myrouter/mysqlrouter.conf

mysqlrouter --config /custom/path/to/router.conf --extra-config /another/config.conf

Related MySQL Articles: mysqlsh - MySQL Shell utility