EarthXuan commented on issue #13930:
URL: 
https://github.com/apache/shardingsphere/issues/13930#issuecomment-986169597


   > > 
[proxy-config.zip](https://github.com/apache/shardingsphere/files/7655256/proxy-config.zip)
   > 
   > thanks~
   
   it works when i use your configuration.
   but i wonder why my configuration does'nt work.
   
   this is my configuration:
   
   ```
   
   schemaName: sharding_db
   dataSources:
     ds_0:
       url: 
jdbc:mysql://192.168.56.102:3307/platform?serverTimezone=UTC&useSSL=false
       username: root
       password: 123456
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
     ds_1:
       url: 
jdbc:mysql://192.168.56.102:3308/platform?serverTimezone=UTC&useSSL=false
       username: root
       password: 123456
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
   
   rules:
   - !SHARDING
     tables:
       test_sc:
         actualDataNodes: ds_${0..1}.test_sc${0..1}
         tableStrategy:
           standard:
             shardingColumn: guid
             shardingAlgorithmName: test_sc_inline
     bindingTables:
       - test_sc
     defaultDatabaseStrategy:
       standard:
         shardingColumn: guid
         shardingAlgorithmName: database_inline
     defaultTableStrategy:
       none:
     shardingAlgorithms:
       database_inline:
         type: INLINE
         props:
           algorithm-expression: ds_{guid % 2}
       test_sc_inline:
         type: INLINE
         props:
           algorithm-expression: test_sc${guid % 2}
   
   ```


-- 
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]


Reply via email to