er降级为slave，另选一个slave为master?
l 查看my_group组Mysql服务的信息：
[root@mysqlfabric ~]# mysqlfabric grouplookup_servers my_group
Command :
{ success = True
return = [{'status':'SECONDARY', 'server_uuid': 'be642e20-00d3-11e4-8d96-0050568f7be4', 'mode':'READ_ONLY', 'weight': 1.0, 'address': 'mysqlfabric.localdomain:3001'},{'status': 'SECONDARY', 'server_uuid': 'c696a608-00d5-11e4-8da3-0050568f7be4','mode': 'READ_ONLY', 'weight': 1.0, 'address': 'mysqlfabric.localdomain:3002'},{'status': 'PRIMARY', 'server_uuid': '1230c8cb-00d7-11e4-8dac-0050568f7be4','mode': 'READ_WRITE', 'weight': 1.0, 'address':'mysqlfabric.localdomain:3003'}]
activities =
}?
l 查看my_group组MySQL服务健康状态信息：
[root@mysqlfabric ~]# mysqlfabric grouphealth my_group
Command :
{ success = True
return ={'1230c8cb-00d7-11e4-8dac-0050568f7be4': {'status': 'PRIMARY', 'is_alive':True, 'threads': {}}, 'be642e20-00d3-11e4-8d96-0050568f7be4': {'status':'SECONDARY', 'is_alive': True, 'threads': {}},'c696a608-00d5-11e4-8da3-0050568f7be4': {'status': 'SECONDARY', 'is_alive':True, 'threads': {}}}
activities =
}?
l 自动检测组内MySQL服务故障：
如果想在primary失败时，secondary能自动提升为primary，执行下面步骤：
[root@mysqlfabric ~]# mysqlfabric group activate my_group
Procedure :
{ uuid = 4ee1bd23-0fab-46f0-a336-9e4731117370,
finished = True,
success = True,
return = True,
activities =
}?
【备注】如果不想让fabric自动检测故障，可以取消自动监控功能：
[root@mysqlfabric ~]# mysqlfabric group deactivate my_group
7. 故障测试
[root@mysqlfabric ~]# service mysql.3003 stop
[root@mysqlfabric ~]# mysqlfabric group lookup_servers my_group
Command :
{ success = True
return = [{'status':'SECONDARY', 'server_uuid': 'be642e20-00d3-11e4-8d96-0050568f7be4', 'mode':'READ_ONLY', 'weight': 1.0, 'address': 'mysqlfabric.localdomain:3001'}, {'status': 'PRIMARY', 'server_uuid':'c696a608-00d5-11e4-8da3-0050568f7be4', 'mode': 'READ_WRITE', 'weight': 1.0,'address': 'mysqlfabric.localdomain:3002'}, {'status': 'FAULTY','server_uuid': '1230c8cb-00d7-11e4-8dac-0050568f7be4', 'mode': 'READ_WRITE','weight': 1.0, 'address': 'mysqlfabric.localdomain:3003'}]
activities =
}?
说明已经把3002提升为primary
8. Mysqlfabric相关命令：
l 把一个MySQL服务移出组：
mysqlfabric group remove my_groupserver_uuid
如：
[root@mysqlfabric ~]#mysqlfabric groupremove my_group 1230c8cb-00d7-11e4-8dac-0050568f7be4?
master不能被移出组，必须disablemaster后才可以移出：
mysqlfabric group demote my_group?
l 删除组(组内已经没有MySQL服务)
mysqlfabric group destroy my_group?
l 强制删除组（组内有MySQL服务）
mysqlfabric group destroy my_group --force
奋斗的路非常幸苦，部署到此介绍，再接再厉。。。。