[求解] 如何在mysql cluster使用awk&sed格式化状态列表

kevinbin

[root@spocproxy ~]# ndb_mgm -e show
Connected to Management Server at: 192.168.2.4:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2    @192.168.2.4  (mysql-5.1.56 ndb-7.1.17, Nodegroup: 0, Master)
id=3    @192.168.2.5  (mysql-5.1.56 ndb-7.1.17, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.2.4  (mysql-5.1.56 ndb-7.1.17)

[mysqld(API)]   4 node(s)
id=100  @192.168.2.4  (mysql-5.1.56 ndb-7.1.17)
id=101  @192.168.2.5  (mysql-5.1.56 ndb-7.1.17)
id=102 (not connected, accepting connect from any host)
id=103 (not connected, accepting connect from any host)

将以上输出格式化成下面格式
[
{"type":"ndbd","id":"2","hostname":"192.168.2.4"},
{"type":"ndbd","id":"3","hostname":"192.168.2.5"},
{"type":"ndb_mgmd","id":"1","hostname":"192.168.2.4"},
{"type":"mysqld","id":"100","hostname":"192.168.2.4"},
{"type":"mysqld","id":"101","hostname":"192.168.2.5"},
]

我现在的方法是:

ndb_mgm -c $connectstring -e show |sed -e '/mysqld(API)/,$!d' -e '/@[0-9].*/!d' -e 's/id=//;s/@//' |awk  'BEGIN {print "["};{printf ("{\"type\":\"mysqld\",\"id\":\"%s\",\"hostname\":\"%s\"},\n",$1,$2)};END {print "]"}'

ndb_mgm -c $connectstring -e show |sed -e '/ndbd(NDB)/,/ndb_mgmd/!d' -e '/@[0-9].*/!d' -e 's/id=//;s/@//'|awk  'BEGIN {print "["};{printf ("{\"type\":\"ndbd\",\"id\":\"%s\",\"hostname\":\"%s\"},\n",$1,$2)};END {print "]"}'

ndb_mgm -c $connectstring -e show |sed -e '/ndb_mgmd/,/mysqld(API)/!d' -e '/@[0-9].*/!d' -e 's/id=//;s/@//' |awk  'BEGIN {print "["};{printf ("{\"type\":\"ndb_mgmd\",\"id\":\"%s\",\"hostname\":\"%s\"},\n",$1,$2)};END {print "]"}'
分成三次去格式化,得到的结果是:
[
{"type":"ndbd","id":"2","hostname":"192.168.2.4"},
{"type":"ndbd","id":"3","hostname":"192.168.2.5"},
]
[
{"type":"ndb_mgmd","id":"1","hostname":"192.168.2.4"},
]
[
{"type":"mysqld","id":"100","hostname":"192.168.2.4"},
{"type":"mysqld","id":"101","hostname":"192.168.2.5"},
]

问题是如何通过一行命令得到我想要的结果
[
{"type":"ndbd","id":"2","hostname":"192.168.2.4"},
{"type":"ndbd","id":"3","hostname":"192.168.2.5"},
{"type":"ndb_mgmd","id":"1","hostname":"192.168.2.4"},
{"type":"mysqld","id":"100","hostname":"192.168.2.4"},
{"type":"mysqld","id":"101","hostname":"192.168.2.5"},
]

不使用shell脚本. 有兴趣的朋友可以研究下.

jiejie455

1. awk '/^\[/{type=$1;next}/\@/{split(type,a,"[\(|\[]");gsub(/id=/,"",$1);gsub(/@/,"",$2);print a[2],$1,$2}' data
   
2. 
   
3. 输出格式你自己再整一下吧

复制代码

kevinbin

佩服佩服,能帮忙解释下么

jason680

回复 1# kevinbin

t for type

$ awk -F'[]() @=[]+' 'BEGIN{print "["}/^\[/{t=$2}/^id=/&&$3~/[0-9]/{print "{\"type\":\""t"\",\"id\":\""$2"\",\"hostname\":\""$3"\"},"}END{print "]"}' ndb_mgm.txt
[
{"type":"ndbd","id":"2","hostname":"192.168.2.4"},
{"type":"ndbd","id":"3","hostname":"192.168.2.5"},
{"type":"ndb_mgmd","id":"1","hostname":"192.168.2.4"},
{"type":"mysqld","id":"100","hostname":"192.168.2.4"},
{"type":"mysqld","id":"101","hostname":"192.168.2.5"},
]

   

mpstat

1. sed -rn '/\[([^(]+).+$/{s//{"type:","\1",/;h;:a;g;N;s/^([^\n]+)\nid=([0-9]+) +@([^ ]+).+$/\1"id:","\2","hostname:","\3"},/p;ta}'

复制代码