sql状态查看，sql状态

sql状态查看，sql状态

[root@controller2 ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 106
Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show status ;
| wsrep_local_state_comment                | Synced                                       |
| wsrep_cert_index_size                    | 2                                            |
| wsrep_causal_reads                       | 0                                            |
| wsrep_cert_interval                      | 0.000000                                     |
| wsrep_incoming_addresses                 | 10.66.0.3:3306,10.66.0.4:3306,10.66.0.2:3306 |
[root@controller2 ~]# rabbitmqctl cluster_status
Cluster status of node rabbit@controller2 ...
[{nodes,[{disc,[rabbit@controller2]},
         {ram,[rabbit@controller4,rabbit@controller3]}]},
 {running_nodes,[rabbit@controller4,rabbit@controller3,rabbit@controller2]},
 {cluster_name,<<"rabbit@controller2">>},
 {partitions,[]}]
...done.
[root@controller2 ~]# mongo
MongoDB shell version: 2.6.10
connecting to: test
Welcome to the MongoDB shell.
For interactive help, type "help".
For more comprehensive documentation, see
    http://docs.mongodb.org/
Questions? Try the support group
    http://groups.google.com/group/mongodb-user
Server has startup warnings:
2018-01-04T20:57:53.032+0800 [initandlisten]
2018-01-04T20:57:53.032+0800 [initandlisten] ** WARNING: You are running on a NUMA machine.
2018-01-04T20:57:53.032+0800 [initandlisten] **          We suggest launching mongod like this to avoid performance problems:
2018-01-04T20:57:53.032+0800 [initandlisten] **              numactl --interleave=all mongod [other options]
2018-01-04T20:57:53.032+0800 [initandlisten]
ws_mongo:PRIMARY> rs.status()
{
    "set" : "ws_mongo",
    "date" : ISODate("2018-01-04T12:59:44Z"),
    "myState" : 1,
    "members" : [
        {
            "_id" : 0,
            "name" : "controller2:27017",
            "health" : 1,
            "state" : 1,
            "stateStr" : "PRIMARY",
            "uptime" : 111,
            "optime" : Timestamp(1515070684, 2),
            "optimeDate" : ISODate("2018-01-04T12:58:04Z"),
            "electionTime" : Timestamp(1515070674, 1),
            "electionDate" : ISODate("2018-01-04T12:57:54Z"),
            "self" : true
        },
        {
            "_id" : 1,
            "name" : "controller3:27017",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 100,
            "optime" : Timestamp(1515070684, 2),
            "optimeDate" : ISODate("2018-01-04T12:58:04Z"),
            "lastHeartbeat" : ISODate("2018-01-04T12:59:42Z"),
            "lastHeartbeatRecv" : ISODate("2018-01-04T12:59:42Z"),
            "pingMs" : 0,
            "syncingTo" : "controller2:27017"
        },
        {
            "_id" : 2,
            "name" : "controller4:27017",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 100,
            "optime" : Timestamp(1515070684, 2),
            "optimeDate" : ISODate("2018-01-04T12:58:04Z"),
            "lastHeartbeat" : ISODate("2018-01-04T12:59:42Z"),
            "lastHeartbeatRecv" : ISODate("2018-01-04T12:59:42Z"),
            "pingMs" : 0,
            "syncingTo" : "controller2:27017"
        }
    ],
    "ok" : 1
}
[root@controller2 ~]# echo "show stat" | nc -U /var/lib/haproxy/stats
# pxname,svname,qcur,qmax,scur,smax,slim,stot,bin,bout,dreq,dresp,ereq,econ,eresp,wretr,wredis,status,weight,act,bck,chkfail,chkdown,lastchg,downtime,qlimit,pid,iid,sid,throttle,lbtot,tracked,type,rate,rate_lim,rate_max,check_status,check_code,check_duration,hrsp_1xx,hrsp_2xx,hrsp_3xx,hrsp_4xx,hrsp_5xx,hrsp_other,hanafail,req_rate,req_rate_max,req_tot,cli_abrt,srv_abrt,comp_in,comp_out,comp_byp,comp_rsp,lastsess,last_chk,last_agt,qtime,ctime,rtime,ttime,
galera_cluster,FRONTEND,,,0,0,3000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,2,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,
galera_cluster,controller1,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,206,0,,1,2,1,,0,,2,0,,0,L7OK,200,15,,,,,,,0,,,,0,0,,,,,-1,OK,,0,0,0,0,
galera_cluster,controller2,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,0,1,0,0,206,0,,1,2,2,,0,,2,0,,0,L7OK,200,16,,,,,,,0,,,,0,0,,,,,-1,OK,,0,0,0,0,
galera_cluster,controller3,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,0,1,0,0,206,0,,1,2,3,,0,,2,0,,0,L7OK,200,15,,,,,,,0,,,,0,0,,,,,-1,OK,,0,0,0,0,
galera_cluster,BACKEND,0,0,0,0,300,0,0,0,0,0,,0,0,0,0,UP,1,1,2,,0,206,0,,1,2,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,

马威-网宿科技  21:05:29
[root@controller2 ~]# redis-trib.rb check 127.0.0.1:6570
>>> Performing Cluster Check (using node 127.0.0.1:6570)
M: 26cec60ebdc13521e7dc9ccaedfc33d691c6dacf 127.0.0.1:6570
   slots:0-5460 (5461 slots) master
   1 additional replica(s)
M: c8a2ea0cbde0a5115ab59fcbbb115f688f79aa4b 10.60.0.4:6570
   slots:10923-16383 (5461 slots) master
   1 additional replica(s)
S: 3e28a333d14076660502940c43fd5d46ce907bc3 10.60.0.4:6571
   slots: (0 slots) slave
   replicates c8a2ea0cbde0a5115ab59fcbbb115f688f79aa4b
M: 81fa28c0f8f3853952756e2a33a0984aceee7209 10.60.0.3:6570
   slots:5461-10922 (5462 slots) master
   1 additional replica(s)
S: 2ef6bad41fb82dce190adfc585950aff72e01f24 10.60.0.2:6571
   slots: (0 slots) slave
   replicates 81fa28c0f8f3853952756e2a33a0984aceee7209
S: 605e382ca3df43be2bf58cb4ee272c9eab278a25 10.60.0.3:6571
   slots: (0 slots) slave
   replicates 26cec60ebdc13521e7dc9ccaedfc33d691c6dacf
[OK] All nodes agree about slots configuration.
>>> Check for open slots...
>>> Check slots coverage...
[OK] All 16384 slots covered.
[root@controller2 ~]#