[GitHub] [shardingsphere] zjcnb opened a new issue #15016: Consider optimize the `schemaName` of `ShardingSphere-JDBC`.

[GitBox <gi...@apache.org>]

zjcnb opened a new issue #15016:
URL: https://github.com/apache/shardingsphere/issues/15016


   Hi community,
   
   Consider optimizing the `schemaName` of `ShardingSphere-JDBC`. Currently, it 's read the logic database created by `ShardingSphere-Proxy` DistSQL. If we use `ShardingSphere` `Standalone` or `Cluster` mode. It configuration such as:
   
   `Standalone mode:`
   
   ```
   schemaName: test
   
   mode:
     type: Standalone
     repository:
       type: File
     overwrite: false
   ```
   
   `Cluster mode:`
   
   ```
   schemaName: test
   
   mode:
     type: Cluster
     repository:
       type: ZooKeeper
       props:
         namespace: governance_ds
         server-lists: localhost:2181
         retryIntervalMilliseconds: 500
         timeToLiveSeconds: 60
         maxRetries: 3
         operationTimeoutMilliseconds: 500
     overwrite: false
   ```
   
   We think the `schemaName` configuration is not flexible, it cannot satisfy to dynamic switch to other databases created by `ShardingSphere-Proxy` DistSQL. So we plan to optimize it.
   
   ### How to adjust
   
   If you use schemaName in your configuration file, `ShardingSphere` according your schemaName to load one. If you not configuration it, all schemaNames will be loaded. 
   
   ### How to use
   
   We can use `use database xx` to choose database.


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

[GitHub] [shardingsphere] TeslaCN commented on issue #15016: Consider optimize the `schemaName` of `ShardingSphere-JDBC`.

[GitBox <gi...@apache.org>]

TeslaCN commented on issue #15016:
URL: https://github.com/apache/shardingsphere/issues/15016#issuecomment-1081422651


   Hi @zjcnb 
   Any update here? Could we finish this in 5.1.1?


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