You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/11/21 04:31:21 UTC
[GitHub] [shardingsphere] Waylon-Firework commented on issue #22306: Upgrade 4.1.1 to 5.2.1, I got an error
Waylon-Firework commented on issue #22306:
URL: https://github.com/apache/shardingsphere/issues/22306#issuecomment-1321454035
```
spring:
config:
activate:
on-profile: dev
application:
name: testApp
shardingsphere:
props:
sql:
show: true
datasource:
names: test-0,test-1
whale-0:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://${my-sql-host}:${my-sql-host-port}/test-0
username: root
password:
type: com.alibaba.druid.pool.DruidDataSource
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: false
filters: stat,wall,slf4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
whale-1:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://${my-sql-host}:${my-sql-host-port}/test-1
username: root
password:
type: com.alibaba.druid.pool.DruidDataSource
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: false
filters: stat,wall,slf4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
rules:
sharding:
tables:
my_test:
key-generator:
column: id
type: SNOWFLAKE
actual-data-nodes: test-$->{0..1}.my_test_$->{0..1}
database-strategy:
inline:
shardingâcolumn: id
algorithm-expression: test-$->{id % 2}
table-strategy:
inline:
shardingâcolumn: id
algorithm-expression: my_test_$->{(Integer)((id % 4) / 2)}
key-generators:
snowflake:
column: id
type: SNOWFLAKE
```
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org