1. select rocketmq_id,broker_name,ip,count(*) as num from t_rocketmq_node group by rocketmq_id,broker_name,ip having num>1 order by rocketmq_id; 查找主从在同一IP的集群和节点
2. select rocketmq_id,ip,port,type,count(*) as num from t_rocketmq_node where type=‘namesrv‘ group by rocketmq_id having count(rocketmq_id) > 1 order by rocketmq_id; 查找所有集群对应的namesrv
3.