rules:
 - !AUTHORITY
   users: # 配置連接shardingsphere-proxy的用戶
     - root@127.0.0.1:root
     - sharding@:sharding
   provider: # 授權(quán)模式
     type: ALL_PERMITTED # 不用授權(quán)，獲取所有權(quán)限

# windows
# 指定端口號(hào)和配置文件目錄, 默認(rèn)端口為3307
bin/start.bat ${proxy_port} ${proxy_conf_directory}

# 拉取鏡像
docker pull apache/shardingsphere-proxy

# 啟動(dòng)臨時(shí)容器
docker run -d --name tmp --entrypoint=bash apache/shardingsphere-proxy:5.2.0

# 配置文件拷貝
docker cp tmp:/opt/shardingsphere-proxy/conf /mnt/data/shardingsphere-proxy/
#刪除臨時(shí)容器
docker rm tmp

# 注意鏡像的擴(kuò)張依賴需要放在ext-lib目錄，不能直接覆蓋lib目錄
docker run --name shardingsphere-proxy -d -v /mnt/data/shardingsphere-proxy/conf:/opt/shardingsphere-proxy/conf -v /mnt/data/shardingsphere-proxy/ext-lib:/opt/shardingsphere-proxy/ext-lib -e PORT=3307 -p 33307:3307 apache/shardingsphere-proxy:5.2.0

docker run --name shardingsphere-proxy -d -v /mnt/data/shardingsphere-proxy/conf:/opt/shardingsphere-proxy/conf -e PORT=3307 -p 33307:3307 apache/shardingsphere-proxy:5.2.0

databaseName: sharding_db ##邏輯庫。配置多個(gè)邏輯庫時(shí)需要?jiǎng)?chuàng)建其他的配置文件，并且配置文件格式需為config-sharding***.yaml

dataSources: ## 數(shù)據(jù)源，連接真實(shí)物理庫，注意物理庫必須有相應(yīng)的庫存在，負(fù)責(zé)proxy無法啟動(dòng)。
ds_0:
url: jdbc:mysql://127.0.0.1:13307/demo_ds_0?serverTimezone=UTC&useSSL=false
username: root
password: sunday
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_1:
url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
username: root
password: sunday
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1

databaseName: sharding_db

dataSources: ## 數(shù)據(jù)源，連接真實(shí)物理庫，注意物理庫必須有相應(yīng)的庫存在，負(fù)責(zé)proxy無法啟動(dòng)。
ds_0:
url: jdbc:mysql://127.0.0.1:13307/demo_ds_0?serverTimezone=UTC&useSSL=false
username: root
password: sunday
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_1:
url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
username: root
password: sunday
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
## 分片規(guī)則配置
rules:
- !SHARDING
tables:
t_order: # 分片表
actualDataNodes: ds_${0..1}.t_order${0..1}
databaseStrategy: # 分庫規(guī)則
standard: # 標(biāo)準(zhǔn)類型分片，目前官方有四種分片類型
shardingColumn: user_id
shardingAlgorithmName: alg_mod # 算法名稱
tableStrategy: # 分表規(guī)則
standard:
shardingColumn: order_no
shardingAlgorithmName: alg_hash_mod # 算法名稱，具體使用哪一種算法下面會(huì)根據(jù)算法名稱配置
keyGenerateStrategy: # 主鍵生成規(guī)則
column: id
keyGeneratorName: snowflake
# bindingTables: # 綁定表。對(duì)于相同分片算法的表，設(shè)置綁定，避免相互關(guān)聯(lián)時(shí)產(chǎn)生笛卡爾關(guān)聯(lián)
# broadcastTables: # 廣播表

keyGenerators: # 主鍵生成規(guī)則配置
snowflake:
type: SNOWFLAKE

shardingAlgorithms: # 分片算法配置，根據(jù)上面的算法名稱配置算法的類型和算法接收的參數(shù)
alg_mod:
type: MOD
props:
sharding-count: 2
alg_hash_mod:
type: HASH_MOD
props:
sharding-count: 2

CREATE TABLE `t_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`order_no` varchar(30) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`amount` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=779468255126355969 DEFAULT CHARSET=utf8mb4;

INSERT INTO `sharding_db`.`t_order`(`id`, `order_no`, `user_id`, `amount`) VALUES (779468213359476737, '22', 22, 22.00);
INSERT INTO `sharding_db`.`t_order`(`id`, `order_no`, `user_id`, `amount`) VALUES (779468285585391617, '44', 44, 44.00);
INSERT INTO `sharding_db`.`t_order`(`id`, `order_no`, `user_id`, `amount`) VALUES (779468168534949888, '11', 11, 11.00);
INSERT INTO `sharding_db`.`t_order`(`id`, `order_no`, `user_id`, `amount`) VALUES (779468255126355968, '33', 33, 33.00);