系統(tǒng)拓?fù)?/p>

?

?	?	?	Server id	Gtid	?
Shard1	10.0.0.201:3306	Root/chenhf123&*(	1	Auto.cnf	/usr/local/mysql3306/
?	10.0.0.201:3307	?	2	?	/usr/local/mysql3307
?	?	?	?	?	?
Shard2	10.0.0.202:3306	?	3	?	/usr/local/mysql3306/
?	10.0.0.202:3307	?	4	?	/usr/local/mysql3307
?	?	?	?	?	?
global	10.0.0.203:3306	?	5	?	/usr/local/mysql3306/
?	10.0.0.203:3307	?	6	?	/usr/local/mysql3307
?	?	?	?	?	?
Backing store	10.0.0.203:3308	?	?	?	/usr/local/mysqlbackingstore
?	?	?	?	?	?
Fabric manage	10.0.0.203:32274	?	?	?	?

?

10.0.0.201:3306

scripts/mysql_install_db --basedir=/usr/local/mysql3306--datadir=/usr/local/mysql3306/data --user=mysql

?

編輯/usr/local/mysql3306/my.cnf

?

Bin/mysqld_safe –user=mysql &

Bin/mysql –uroot –socket=./mysql.sock

Bin/mysqladmin –uroot shutdown

?

10.0.0.201:3307

scripts/mysql_install_db --basedir=/usr/local/mysql3307--datadir=/usr/local/mysql3307/data --user=mysql

?

編輯/usr/local/mysql3307/my.cnf

?

Bin/mysqld_safe –user=mysql &

Bin/mysql –uroot –socket=./mysql.sock

Bin/mysqladmin –uroot shutdown

?

10.0.0.202:3306

Server-id=3

10.0.0.202:3307

Server-id=4

10.0.0.203:3306

Server-id=5

10.0.0.203:3307

Server-id=6

?

Backing store

scripts/mysql_install_db--basedir=/usr/local/mysqlbackingstore --datadir=/usr/local/mysqlbackingstore/data--user=mysql

?

CREATE USER 'fabric'@'%' IDENTIFIED BY 'fabric';

GRANT ALL ON fabric.* TO 'fabric'@'%';

?

Fabric

/etc/mysql/fabric.cfg

?

?

?

Mysqlfabric manage setup

?

所有節(jié)點(diǎn)創(chuàng)建用戶fabric

CREATE USER 'fabric'@'%' IDENTIFIED BY 'fabric';

GRANTALL ON *.* TO 'fabric'@'%';

Mysqlfabric manage start

?

mysqlfabric group create shard-grp-1

mysqlfabric group create shard-grp-2

mysqlfabric group create shard-grp-global

?

mysqlfabricgroup add shard-grp-1 10.0.0.201:3306

mysqlfabricgroup add shard-grp-1 10.0.0.201:3307

?

?

mysqlfabricgroup add shard-grp-2 10.0.0.202:3306

mysqlfabricgroup add shard-grp-2 10.0.0.202:3307

?

mysqlfabricgroup add shard-grp-global 10.0.0.203:3306

mysqlfabricgroup add shard-grp-global 10.0.0.203:3307

?

?

mysqlfabricgroup promote shard-grp-global

mysqlfabricgroup promote shard-grp-1

mysqlfabricgroup promote shard-grp-2

?

mysqlfabricgroup lookup_servers shard-grp-global

mysqlfabricgroup lookup_servers shard-grp-1

mysqlfabricgroup lookup_servers shard-grp-2

?

mysqlfabric group health shard-grp-global

mysqlfabric group health shard-grp-1

mysqlfabric group health shard-grp-2

?

?

?

定義分片策略

mysqlfabricsharding create_definition RANGE shard-grp-global

?

添加分片表和字段

mysqlfabricsharding add_table 2 test.account account_id

mysqlfabricsharding add_table 2 account account_id

mysqlfabricsharding add_table 1 employees.employees emp_no

?

?

定義分片信息

mysqlfabricsharding add_shard 1 “shard-grp-1/1, shard-grp-2/1000“ --state=ENABLED

mysqlfabricsharding add_shard 2 ”shard-grp-1/1, shard-grp-2/1000“ --state=ENABLED

?

?

驗(yàn)證

mysqlfabricsharding lookup_servers test.account 1

mysqlfabricsharding lookup_servers account 1

mysqlfabricsharding lookup_servers employees.employees 1

?

停止順序

Mysqlfabric manage stop

停止所有的mysql實(shí)例

啟動(dòng)順序

啟動(dòng)所有的mysql master實(shí)例

啟動(dòng)所有的mysql slave實(shí)例

Mysqlfabric manage start

總結(jié)

以上是生活随笔為你收集整理的MySQL Sharding DB （基于Fabric）的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。