1.15学习 Sharding-Proxy-分表、分库、读写分离、权限加密

Sharding-Proxy配置

将server.yaml里面的注释打开

Sharding-Proxy分表配置

1. 创建一个数据库，名为“edu_db_1”
   
   2.进入conf目录下的config-sharding.yaml，进行分表配置（打开注释即可），配置代码如下

schemaName: sharding_db
//配置数据库的用户密码
dataSourceCommon:
 username: root
 password: root
 connectionTimeoutMilliseconds: 30000
 idleTimeoutMilliseconds: 60000
 maxLifetimeMilliseconds: 1800000
 maxPoolSize: 50
 minPoolSize: 1
 maintenanceIntervalMilliseconds: 30000
dataSources:
 ds_0:
   url: jdbc:mysql://127.0.0.1:3306/edu_db_1?serverTimezone=UTC&useSSL=false

rules:
- !SHARDING
 tables:
   t_order:
     actualDataNodes: ds_${
   0..1}.t_order_${
   1..2}
     tableStrategy:
       standard:
         shardingColumn: order_id
         shardingAlgorithmName: t_order_inline
     keyGenerateStrategy:
       column: order_id
       keyGeneratorName: snowflake

 
 bindingTables:
   - t_order
   
 defaultDatabaseStrategy:
   standard:
     shardingColumn: user_id
     shardingAlgorithmName: database_inline
 defaultTableStrategy:
   none:
 
 shardingAlgorithms:

   database_inline:
     type: INLINE
     props:
       algorithm-expression: ds_${
   user_id % 2}

   t_order_inline:
     type: INLINE
     props