????c??    ??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.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 |
+--------+------------+-----------+
????d??    ????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')
????????????????????????????????HA?饗group_id-1???е?master?????????mysql fabric???????????slave????master???????????????????????????mysql fabric????ü????????????????????????????????????
????PS????????FAULT????????????
????mysql fabric????ü???е???????????????primary??secondary??faulty??spare
???????primary??primary????????????????????mysqlfabric group demote group_id-1????????е?primary?????????????????μ?master????????????????
????a??    ?????е??????????????????????????????????????????????????????????????????????????磺
????mysqlfabric group remove group_id-1 7a45f71d-7934-11e4-9e8c-782bcb74823a
????mysqlfabric group add group_id-1 192.168.1.71:3306
????mysqlfabric group lookup_servers group_id-1
????????????
????Command :
????{ success = True
????return = [{'status': 'SECONDARY'?? 'server_uuid': '7a45f71d-7934-11e4-9e8c-782bcb74823a'?? 'mode': 'READ_ONLY'?? '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 =
????}
????b??    ??HA??????????????崻???????????fabric????????????????????????????mysqlfabric group demote group_id-1???????????????server??????faulty?secondary?????????????spare??????secondary?????￡?
????mysqlfabric group demote group_id-1
????mysqlfabric group deactivate group_id-1
????mysqlfabric server set_status 7a45f71d-7934-11e4-9e8c-782bcb74823a spare
????mysqlfabric server set_status 7a45f71d-7934-11e4-9e8c-782bcb74823a secondary
????###?????е????????????secondary??????????master????????????￡?
????mysqlfabric group promote group_id-1
????????MySQL Fabric????ü???洢????
????1.????????
????a??    ??????
cat test_add_subs_shards.py
import mysql.connector
from mysql.connector import fabric
import math
def add_subscriber(conn?? sub_no?? first_name?? last_name):
conn.set_property(tables=["test.subscribers"]?? key=sub_no??
mode=fabric.MODE_READWRITE)
cur = conn.cursor()
cur.execute(
"INSERT INTO subscribers VALUES (%s?? %s?? %s)"??
(sub_no?? first_name?? last_name)
)
conn = mysql.connector.connect(
fabric={"host" : "localhost"?? "port" : 32274?? "username": "admin"??
"password" : "admin"}??
user="root"?? database="test"?? password=""??
autocommit=True
)
conn.set_property(tables=["test.subscribers"]?? scope=fabric.SCOPE_LOCAL)
for num in range(10):
add_subscriber(conn?? "%s" % num?? "k%s" % num?? "kw%s" % num)
   2.???hash???????
????a??????10?????????group_id-1??????????????????group_id-2????????????????????????
????group_id-1??????????￡?

????b??    ???????1?????????group_id-1???group_id-2?鶼???????????????????
?????????group_id-1?????????????????￡?
????mysql -P 3306 -h 192.168.1.70 -u root -e "select count(*) from test.subscribers"
????????????
????+----------+
????| count(*) |
????+----------+
????| 7138 |
????+----------+
?????????group_id-2?????????????????￡?
????mysql -P 3309 -h 192.168.1.76 -u root -e "select count(*) from test.subscribers"
????????????
????+----------+
????| count(*) |
????+----------+
????| 2903 |
????+----------+
????c??     ???????10?????????group_id-1???group_id-2?鶼???????????????????
?????????group_id-1?????????????????￡?
????mysql -P 3306 -h 192.168.1.70 -u root -e "select count(*) from test.subscribers"
????????????
????+----------+
????| count(*) |
????+----------+
????| 78719 |
????+----------+
????mysql -P 3309 -h 192.168.1.76 -u root -e "select count(*) from test.subscribers"
????????????
????+----------+
????| count(*) |
????+----------+
????| 31321 |
????+----------+
????d??    ???????100?????????group_id-1???group_id-2?鶼???????????????????