sharingsphere proxy插入失败
来源:2-5 体验MySQL集群

zrbf
2022-11-14
自己尝试使用sharingsphere proxy时,连接成功后可以查询,但是写入数据提示
server.yaml基本照搬,如下是我的config-sharding.yaml配置文件:
schemaName: zc_proxy
dataSources:
ds_1_p:
url: jdbc:mysql://192.168.239.129:3306/ds_0?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
username: root
password: mysqlyyds123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_2_p:
url: jdbc:mysql://192.168.239.129:3306/ds_1?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
username: root
password: mysqlyyds123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
tables:
tb_demo:
actualDataNodes: ds_${1..2}_p.tb_demo
# 分表策略
tableStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: demo_inline
# 主键生成方式
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
bindingTables:
- tb_demo
defaultDatabaseStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: database_inline
defaultTableStrategy:
none:
shardingAlgorithms:
# 自定义切分规则
demo_inline:
type: INLINE
props:
algorithm-expression: ds_${(id % 2)+1}_p
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
写回答
1回答
-
神思者
2022-11-14
你的数据库里面没有tb_demo数据表
022022-11-15
相似问题