schemaName: sharding_db

dataSourceCommon:
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
maintenanceIntervalMilliseconds: 30000

dataSources:
ds_0:
url: jdbc:mysql://localhost:3316/myshop1?useUnicode=true&characterEncoding=utf-8
ds_1:
url: jdbc:mysql://localhost:3326/myshop2?useUnicode=true&characterEncoding=utf-8

rules:
- !SHARDING
tables:
t_product:
actualDataNodes: ds_${0..1}.t_product_${0..1}
tableStrategy:
standard:
shardingColumn: create_time
shardingAlgorithmName: t_product_inline
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
bindingTables:
- t_product
defaultDatabaseStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: database_inline
defaultTableStrategy:
none:

shardingAlgorithms:
database_inline:
type: INLINE
props:
algorithm-expression: ds_${id % 2}
t_product_inline:
type: INLINE
props:
algorithm-expression: t_product_${create_time % 2}

keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123

governance:
name: governance_ds
registryCenter:
type: ZooKeeper
serverLists: localhost:2181
props:
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
overwrite: false

authentication:
users:
root:
password: root
sharding:
password: sharding
authorizedSchemas: sharding_db

props:
max-connections-size-per-query: 1
acceptor-size: 16 # The default value is available processors count * 2.
executor-size: 16 # Infinite by default.
proxy-frontend-flush-threshold: 128 # The default value is 128.
# LOCAL: Proxy will run with LOCAL transaction.
# XA: Proxy will run with XA transaction.
# BASE: Proxy will run with B.A.S.E transaction.
proxy-transaction-type: LOCAL
proxy-opentracing-enabled: false
proxy-hint-enabled: false
query-with-cipher-column: true
sql-show: false
check-table-metadata-enabled: false