my: a command-line tool for MariaDB Clusters
I’ve posted the code for my MariaDB Cluster command-line tool called my. It does a bunch of stuff but the main purpose is to allow you to easily monitor replication cluster-wide while working in the shell.
Here’s an example of this screen…
hostname port cons u_cons role repl_detail lag gtid read_only
master1 3306 7 0 ms master2.ucid.local:3306 mysql-bin.000046 7296621 0 0-2-4715491 OFF
master2 3306 33 20 ms master1.ucid.local:3306 mysql-bin.000052 1031424 0 0-2-4715491 OFF
slave1 3306 5 0 ms master1.ucid.local:3306 mysql-bin.000052 1031424 0 0-2-4715491 ON
slave2 3306 29 19 ms master2.ucid.local:3306 mysql-bin.000046 7296621 0 0-2-4715491 ON
backup 3306 5 0 ms master2.ucid.local:3306 mysql-bin.000046 7296621 0 0-2-4715491 ON
This screen will handle hosts that are down, identify ones where MariaDB isn’t running, highlight replication lag or errors, as well as multi-master setups. See the README for more details for how to get started.