Sharding Proxy分表实例
schemaName: sharding_db
dataSources:
ds_0:
url: jdbc:mysql://127.0.0.1:3306/user_database_1?serverTimezone=UTC&useSSL=false
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
tables:
user_account:
actualDataNodes: ds_${0}.user_account_${1..2}
tableStrategy:
inline:
shardingColumn: Account
algorithmExpression: user_account_${Account % 2+1}
keyGenerator:
type: SNOWFLAKE
column: Account
bindingTables:
- user_account,
defaultDatabaseStrategy:
inline:
shardingColumn: Account
algorithmExpression: ds_${0}
defaultTableStrategy:
none:
Sharding Proxyd的分库实现
schemaName: sharding_db
dataSources:
ds_0:
url: jdbc:mysql://127.0.0.1:3306/user_database_1?serverTimezone=