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 2020/10/28 09:43:21 UTC

[GitHub] [shardingsphere] lwtdev opened a new issue #7944: How to use jdbc and shardingproxy together with zookeeper?

lwtdev opened a new issue #7944:
URL: https://github.com/apache/shardingsphere/issues/7944


   ## Question
   First , I use shardingsphere-proxy start with zookeeper. and create some schemas.
   
   ```bash
   [zk: localhost:2181(CONNECTED) 31] ls /governance_ds/schemas
   [ spsqltest_nosharding, spsqltest_sharding, test]
   ```
   Then, I use shardingsphere-jdbc with zookeeper, but don't know **how to configure a init schema**.
   Try to configure shardingshpere-jdbc like this:
   
   ```yaml
   governance:
     name: governance_ds
     registryCenter:
       type: ZooKeeper
       serverLists: localhost:2181
     overwrite: false
   ```
   but jdbc just use a default schema `logic_db`.
   
   ```bash
   [zk: localhost:2181(CONNECTED) 32] ls /governance_ds/schemas
   [logic_db, spsqltest_nosharding, spsqltest_sharding, test]
   ```


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] lwtdev commented on issue #7944: How to use jdbc and shardingproxy together with zookeeper?

Posted by GitBox <gi...@apache.org>.
lwtdev commented on issue #7944:
URL: https://github.com/apache/shardingsphere/issues/7944#issuecomment-718320099


   @avalon5666 5.0.0-RC1


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] kimmking commented on issue #7944: How to use jdbc and shardingproxy together with zookeeper?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7944:
URL: https://github.com/apache/shardingsphere/issues/7944#issuecomment-718397269


   Hi， @lwtdev 
   
   A proxy is as a mysql instance, so it contains multiple databases( as logic database ).
   But a sharding-jdbc application is only as a SINGLE database, so it's SPECIFIED a name "logic_db".
   
   That's the way "logic_db" designed.
   
   _Originally posted by @kimmking in https://github.com/apache/shardingsphere/issues/7939#issuecomment-717683164_
   
   
   
   integrate jdbc and proxy, you should just consider proxy as a REAL mysql server.
   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] kimmking closed issue #7944: How to use jdbc and shardingproxy together with zookeeper?

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #7944:
URL: https://github.com/apache/shardingsphere/issues/7944


   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] avalon5666 commented on issue #7944: How to use jdbc and shardingproxy together with zookeeper?

Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #7944:
URL: https://github.com/apache/shardingsphere/issues/7944#issuecomment-718287043


   Which version of the shardingjdbc and shardingproxy?


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org