???????MySQL Fabric????ü??????????????????????????????????
????1.????????
????a??   ??group_id-1?????????????
????mysqlfabric group lookup_servers group_id-1
????????????
Command :
{ success = True
return = [{'status': 'PRIMARY'?? 'server_uuid': '7a45f71d-7934-11e4-9e8c-782bcb74823a'?? 'mode': 'READ_WRITE'?? 'weight': 1.0?? 'address': '192.168.1.71:3306'}?? {'status': 'SECONDARY'?? 'server_uuid': '9cf162ca-7934-11e4-9e8d-782bcb1b6b98'?? 'mode': 'READ_ONLY'?? 'weight': 1.0?? 'address': '192.168.1.76:3306'}?? {'status': 'SECONDARY'?? 'server_uuid': 'ae94200b-7932-11e4-9e81-a4badb30e16b'?? 'mode': 'READ_ONLY'?? 'weight': 1.0?? 'address': '192.168.1.70:3306'}]
activities =
}
???????primary?????????192.168.1.71??3306??group_id-1?????????
????b??   ??group_id-1??????е?????
mysql -P 3306 -h 192.168.1.76 -u root -e "select * from test.subscribers"
mysql -P 3306 -h 192.168.1.71 -u root -e "select * from test.subscribers"
mysql -P 3306 -h 192.168.1.70 -u root -e "select * from test.subscribers"
?????????￡?
+--------+------------+-----------+
| sub_no | first_name | last_name |
+--------+------------+-----------+
| 500 | Billy | Joel |
| 1500 | Arthur | Askey |
| 5000 | Billy | Fish |
| 17542 | Bobby | Ball |
| 22 | Billy | Bob |
| 8372 | Banana | Man |
| 93846 | Bill | Ben |
| 15050 | John | Smith |
+--------+------------+-----------+
????c??   ????python?????????test???????subscribers?????????????
????python read_table_ha.py
?????????????￡?
(u'Billy'?? u'Bob')
(u'Billy'?? u'Fish')
(u'Billy'?? u'Joel')
(u'Arthur'?? u'Askey')
(u'Banana'?? u'Man')
(u'Billy'?? u'Fish')
(u'Bill'?? u'Ben')
(u'Jimmy'?? u'White')
(u'John'?? u'Smith')
(u'Bobby'?? u'Ball')
????2.???????
????a??  ???????????л?
???????Fabric?????master????????????master???崻????fanric?????????secondary????л??master??????????????HA????????????????л????
????mysqlfabric group activate group_id-1
????b??  ??group_id-1???е?master???????????????192.168.1.71??3306?????fabric????
????mysqlfabric group lookup_servers group_id-1
????????????
Command :
{ success = True
return = [{'status': 'FAULTY'?? 'server_uuid': '7a45f71d-7934-11e4-9e8c-782bcb74823a'?? 'mode': 'READ_WRITE'?? 'weight': 1.0?? 'address': '192.168.1.71:3306'}?? {'status': 'SECONDARY'?? 'server_uuid': '9cf162ca-7934-11e4-9e8d-782bcb1b6b98'?? 'mode': 'READ_ONLY'?? 'weight': 1.0?? 'address': '192.168.1.76:3306'}?? {'status': 'PRIMARY'?? 'server_uuid': 'ae94200b-7932-11e4-9e81-a4badb30e16b'?? 'mode': 'READ_WRITE'?? 'weight': 1.0?? 'address': '192.168.1.70:3306'}]
activities =
}
???????У?????????192.168.1.71:3306?????FAULTY??mysql fabric????????HA?????????????????slave????primary???