check_innodbcluster.sh

Project Notes

This simple but effective script shell (dash) will return detailed information about the status of an InnoDB Cluster node, including status (online, recovering, offline, etc...), node type (primary/secondary) and Lag.

This script shell requires the netcat package (apt install netcat). Tested on Debian 11/12 and Ubuntu 18/20/22.

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

=======

Usage: check_innodbcluster.sh -H Host/IP -P Port -u User -p Password

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

=arguments and default values if arg is missing=

-H = host/IP {def: 127.0.0.1}
-P = Port {def: 3306}
-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