API tools faq
paste
Guest User

Untitled

a guest
Jan 17th, 2018
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.13 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cc_timestamp":1515492118,
  3. "data":[
  4. {
  5. "cdt_path":"\/cluster_1",
  6. "class_name":"CmonGaleraHost",
  7. "clusterid":1,
  8. "configfile":[
  9. "\/etc\/mysql\/my.cnf"
  10. ],
  11. "connected":true,
  12. "container":false,
  13. "datadir":"\/var\/lib\/mysql\/",
  14. "distribution":{
  15. "codename":"xenial",
  16. "name":"ubuntu",
  17. "release":"16.04",
  18. "type":"debian"
  19. },
  20. "errorcode":0,
  21. "errormsg":"Up and running.",
  22. "galera":{
  23. "certsdepsdistance":0,
  24. "cluster_address":"gcomm:\/\/",
  25. "clustername":"my_wsrep_cluster",
  26. "clustersize":2,
  27. "flowctrlpaused":0,
  28. "flowctrlrecv":0,
  29. "flowctrlsent":0,
  30. "galerastatus":"Primary",
  31. "lastcommitted":12,
  32. "localrecvqueue":0,
  33. "localrecvqueueavg":0,
  34. "localsendqueue":0,
  35. "localsendqueueavg":0,
  36. "localstatus":4,
  37. "localstatusstr":"Synced",
  38. "ready":"ON",
  39. "segmentid":0,
  40. "socketssl":false
  41. },
  42. "hostId":1,
  43. "hostname":"10.10.10.11",
  44. "hostname_data":"10.10.10.11",
  45. "hoststatus":"CmonHostOnline",
  46. "ip":"10.10.10.11",
  47. "isgalera":true,
  48. "lastseen":1515492118,
  49. "log_bin":"OFF",
  50. "logfile":"\/var\/log\/mysql\/mysqld.log",
  51. "maintenance_mode_active":false,
  52. "message":"Up and running",
  53. "mysqlstatus":0,
  54. "nodeid":1,
  55. "nodetype":"galera",
  56. "owner_group_id":1,
  57. "owner_user_id":1,
  58. "performance_schema":false,
  59. "pid":21728,
  60. "pidfile":"\/var\/lib\/mysql\/mysql.pid",
  61. "pingstatus":1,
  62. "pingtime":253,
  63. "port":"3306",
  64. "readonly":false,
  65. "replication_master":{
  66. "binlog_do_db":"",
  67. "binlog_ignore_db":"",
  68. "exec_gtid":"",
  69. "file":"",
  70. "position":"",
  71. "semisync_status":"ON"
  72. },
  73. "replication_slave":{
  74. "exec_master_log_pos":19369363,
  75. "executed_gtid_set":"",
  76. "gtid_binlog_pos":"",
  77. "linkstatus":7,
  78. "master_host":"",
  79. "master_log_file":"",
  80. "master_port":"",
  81. "read_master_log_pos":"0",
  82. "retrieved_gtid_set":"",
  83. "seconds_behind_master":"",
  84. "semisync_status":"OFF",
  85. "slave_io_running":"",
  86. "slave_io_state":"",
  87. "status":"Slave is not intialized. Change Master or Rebuild it."
  88. },
  89. "role":"none",
  90. "serverid":1,
  91. "skip_name_resolve":true,
  92. "slaves":[
  93.  
  94. ],
  95. "slow_query":{
  96. "log_not_using_idxs":"OFF",
  97. "long_query_time":"0.500000",
  98. "slow_query_log":"ON",
  99. "slow_query_log_file":"\/var\/log\/mysql\/mysql-slow.log"
  100. },
  101. "sshfailcount":0,
  102. "ssl_certs":{
  103. "replication":{
  104. "ca":"",
  105. "id":0,
  106. "key":"",
  107. "path":""
  108. },
  109. "server":{
  110. "ca":"",
  111. "id":0,
  112. "key":"",
  113. "path":"",
  114. "ssl_enabled":false
  115. }
  116. },
  117. "timestamp":1515492118,
  118. "unique_id":1,
  119. "uptime":454,
  120. "version":"10.2.12-MariaDB-10.2.12+maria~xenial",
  121. "wallclock":1515492081,
  122. "wallclocktimestamp":1515492081
  123. },
  124. {
  125. "cdt_path":"\/cluster_1",
  126. "class_name":"CmonHost",
  127. "clusterid":1,
  128. "configfile":"\/etc\/cmon.d\/cmon_1.cnf",
  129. "connected":true,
  130. "container":false,
  131. "distribution":{
  132. "codename":"xenial",
  133. "name":"ubuntu",
  134. "release":"16.04",
  135. "type":"debian"
  136. },
  137. "hostId":2,
  138. "hostname":"10.10.10.10",
  139. "hoststatus":"CmonHostOnline",
  140. "ip":"10.10.10.10",
  141. "lastseen":1515492110,
  142. "logfile":"\/var\/log\/cmon_1.log",
  143. "maintenance_mode_active":false,
  144. "message":"Up and running",
  145. "nodetype":"controller",
  146. "owner_group_id":1,
  147. "owner_user_id":1,
  148. "pid":28874,
  149. "pingstatus":1,
  150. "pingtime":36,
  151. "port":9500,
  152. "role":"controller",
  153. "timestamp":1515492110,
  154. "unique_id":2,
  155. "uptime":1003,
  156. "version":"1.5.1.2299",
  157. "wallclock":1515492081,
  158. "wallclocktimestamp":1515492081
  159. },
  160. {
  161. "cdt_path":"\/cluster_1",
  162. "class_name":"CmonGaleraHost",
  163. "clusterid":1,
  164. "configfile":[
  165. "\/etc\/mysql\/my.cnf"
  166. ],
  167. "connected":true,
  168. "container":false,
  169. "datadir":"\/var\/lib\/mysql\/",
  170. "distribution":{
  171. "codename":"xenial",
  172. "name":"ubuntu",
  173. "release":"16.04",
  174. "type":"debian"
  175. },
  176. "errorcode":0,
  177. "errormsg":"Up and running.",
  178. "galera":{
  179. "certsdepsdistance":0,
  180. "cluster_address":"gcomm:\/\/10.10.10.11,10.10.10.12",
  181. "clustername":"my_wsrep_cluster",
  182. "clustersize":2,
  183. "flowctrlpaused":0,
  184. "flowctrlrecv":0,
  185. "flowctrlsent":0,
  186. "galerastatus":"Primary",
  187. "lastcommitted":12,
  188. "localrecvqueue":0,
  189. "localrecvqueueavg":0,
  190. "localsendqueue":0,
  191. "localsendqueueavg":0,
  192. "localstatus":4,
  193. "localstatusstr":"Synced",
  194. "ready":"ON",
  195. "segmentid":0,
  196. "socketssl":false
  197. },
  198. "hostId":3,
  199. "hostname":"10.10.10.12",
  200. "hoststatus":"CmonHostOnline",
  201. "ip":"10.10.10.12",
  202. "isgalera":true,
  203. "lastseen":1515492118,
  204. "log_bin":"OFF",
  205. "logfile":"\/var\/log\/mysql\/mysqld.log",
  206. "maintenance_mode_active":false,
  207. "message":"Up and running",
  208. "mysqlstatus":0,
  209. "nodeid":3,
  210. "nodetype":"galera",
  211. "owner_group_id":1,
  212. "owner_user_id":1,
  213. "performance_schema":false,
  214. "pid":26988,
  215. "pidfile":"\/var\/lib\/mysql\/mysql.pid",
  216. "pingstatus":1,
  217. "pingtime":266,
  218. "port":3306,
  219. "readonly":false,
  220. "replication_master":{
  221. "binlog_do_db":"",
  222. "binlog_ignore_db":"",
  223. "exec_gtid":"",
  224. "file":"",
  225. "position":"",
  226. "semisync_status":"OFF"
  227. },
  228. "replication_slave":{
  229. "exec_master_log_pos":19369363,
  230. "executed_gtid_set":"",
  231. "gtid_binlog_pos":"",
  232. "linkstatus":7,
  233. "master_host":"",
  234. "master_log_file":"",
  235. "master_port":"",
  236. "read_master_log_pos":"0",
  237. "retrieved_gtid_set":"",
  238. "seconds_behind_master":"",
  239. "semisync_status":"OFF",
  240. "slave_io_running":"",
  241. "slave_io_state":"",
  242. "status":"Slave is not intialized. Change Master or Rebuild it."
  243. },
  244. "role":"none",
  245. "serverid":2,
  246. "skip_name_resolve":true,
  247. "slaves":[
  248.  
  249. ],
  250. "slow_query":{
  251. "log_not_using_idxs":"OFF",
  252. "long_query_time":"2.000000",
  253. "slow_query_log":"ON",
  254. "slow_query_log_file":"\/var\/log\/mysql\/mysql-slow.log"
  255. },
  256. "sshfailcount":0,
  257. "ssl_certs":{
  258. "replication":{
  259. "ca":"",
  260. "id":0,
  261. "key":"",
  262. "path":""
  263. },
  264. "server":{
  265. "ca":"",
  266. "id":0,
  267. "key":"",
  268. "path":"",
  269. "ssl_enabled":false
  270. }
  271. },
  272. "timestamp":1515492118,
  273. "unique_id":3,
  274. "uptime":59,
  275. "version":"10.2.12-MariaDB-10.2.12+maria~xenial",
  276. "wallclock":1515492081,
  277. "wallclocktimestamp":1515492081
  278. }
  279. ],
  280. "requestStatus":"ok",
  281. "total":3,
  282. "success":true
  283. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!