Sharding Proxy的分库分表配以及读写分离置实例

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=