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数据表

0
2
神思者
回复
zrbf
你看报错信息,说的是ds_2_p里面不存在数据表
2022-11-15
共2条回复

多端全栈项目实战,大型商业级代驾业务全流程落地

50000+代码,300+技术点,慕课网明星讲师为你私人订制

600 学习 · 423 问题

查看课程