check_mysqlrouter.sh

Project Notes

Simple script shell (dash) to check/monitor the mysql-router status (as service) and connection (as cluster).
Default mysql-router ports are 6446 and 6447 (edit the script to change upon your needs).

Tested on: Ubuntu 18, 20, 22 and Debian 11/12

note: remember to assign execute permission to the script (chmod +x check_mysqlrouter.sh)

=======

Usage: check_mysqlrouter.sh -H Host/IP -u User -p Password

example => check_mysqlrouter.sh -u MyUser -p MyPassword
example => check_mysqlrouter.sh -H10.10.0.125 -uMyUser -pMyPassword

=arguments and default values if arg is missing=

-H = host/IP {def: 127.0.0.1}
-u = UserName {def: MyCoolUser}
-p = Password {def: MyCoolPasswd}
-h = this help

.:: notes ::.

.: arguments order is not relevant
.: between argument and value can be a space or not