LGHome commented on issue #18090:
URL:
https://github.com/apache/shardingsphere/issues/18090#issuecomment-1174491149
configuration:
spring:
shardingsphere:
datasource:
#数据源名称
names: filedb,platformdb
#数据源信息
filedb:
type: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbc-url:
${SPRING_DATASOURCE_URL:jdbc:mysql://xxx.xxx.xxx:3306/xxx_db?useUnicode=true&characterEncoding=utf-8&useSSL=false}
username: ${SPRING_DATASOURCE_USERNAME:xxxx}
password: ${SPRING_DATASOURCE_PASSWORD:xxxx}
#数据库连接池的其它属性
# 连接池最小空闲连接数
minimum-idle: ${SPRING_DATASOURCE_MINIMUM_IDLE:20}
# 连接池允许的最大连接数
maximum-pool-size: ${SPRING_DATASOURCE_MAXIMUM_POOL_SIZE:200}
# 等待连接池分配连接的最大时长（毫秒）
connection-timeout: ${SPRING_DATASOURCE_CONNECTION_TIMEOUT:30000}
#数据源信息
platform:
type: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbc-url:
${SPRING_DATASOURCE_URL_PLATFORM:jdbc:mysql://xxxx.xxxx.xxxx:3306/xxxx_xxx_db?useUnicode=true&characterEncoding=utf-8&useSSL=false}
username: ${SPRING_DATASOURCE_USERNAME:xxx}
password: ${SPRING_DATASOURCE_PASSWORD:xxx}
#数据库连接池的其它属性
# 连接池最小空闲连接数
minimum-idle: ${SPRING_DATASOURCE_MINIMUM_IDLE:20}
# 连接池允许的最大连接数
maximum-pool-size: ${SPRING_DATASOURCE_MAXIMUM_POOL_SIZE:200}
# 等待连接池分配连接的最大时长（毫秒）
connection-timeout: ${SPRING_DATASOURCE_CONNECTION_TIMEOUT:30000}
rules:
sharding:
tables:
xxxx_xxxx:
actual-data-nodes: filedb.xxxx_xxxx$->{0..63}
table-strategy:
hint:
sharding-algorithm-name: hfleFileHintShardingAlgorithm
props:
sql-show: true
#支持跨库join查询
sql-federation-enabled: true
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
