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