Author:skate
Time:2015/01/19
MySQL Cluster global list
Usage:
# monrep-h
Usage:monrep [-D dbname]
-D Database Cluster name
-H Display Basic Help
#
For example, one of my clusters is called DBX, which is used as follows:
# monrep-d DBX
Purpose of implementation:
When the host is more, and you want to see all the hosts in a MySQL cluster and replication basic real-time situation, it is more troublesome, if you log on to each host to see, it is too out, generally
You can view it globally (if any) by monitoring the platform. I am here for convenience, directly on the router with the command to view, similar to the above situation,
Implementation language: Linux shell
Characteristics:
1. Refresh every two seconds
2. In order to increase the speed of the presentation, we use a process pool with 40 processes to implement concurrency (to avoid network factors) to capture all host information
3. In order to provide multi-user simultaneous use, the use of each running PID named temporary files to save temporary information
--------End--------
[Shell Command] MySQL Cluster global list