[Shell Command] MySQL cluster global list, mysql Cluster
Author: skate
Time: 2015/01/19
Global list of MySQL Clusters
Usage:
# Monrep-h
Usage: monrep [-d dbname]
-D Database Cluster name
-H Display basic help
#
For example, if a cluster named dbx is used as follows:
# Monrep-d dbx
Purpose:
When there are many hosts and you want to view the basic real-time status of all the hosts in a MySQL cluster and replication, it is quite troublesome. If you log on to each host to view the details, that's too out.
You can use the monitoring platform to view the data globally (if any ). For convenience, I can directly use commands on the host machine to view them. Similar to the above situation,
Implementation language: linux shell
Features:
1. Refresh every two seconds
2. To increase the display speed, use a process pool containing 40 processes to achieve concurrency (avoid network factors as much as possible) to collect information about all hosts.
3. To provide simultaneous use by multiple users, use a temporary file named by the pid of each operation to save the Temporary Information.
-------- End --------