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 02:43:42 UTC
[GitHub] [shardingsphere] lwtdev opened a new issue #7939: How to choose init schema in shardingsphere-jdbc 5.0.0-RC1 when use zookeeper ?
lwtdev opened a new issue #7939:
URL: https://github.com/apache/shardingsphere/issues/7939
## 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] kimmking commented on issue #7939: How to configure init schema in shardingsphere-jdbc 5.0.0-RC1 when use zookeeper ?
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7939:
URL: https://github.com/apache/shardingsphere/issues/7939#issuecomment-717683164
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.
----------------------------------------------------------------
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 #7939: How to configure init schema in shardingsphere-jdbc 5.0.0-RC1 when use zookeeper ?
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #7939:
URL: https://github.com/apache/shardingsphere/issues/7939
----------------------------------------------------------------
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 #7939: How to configure init schema in shardingsphere-jdbc 5.0.0-RC1 when use zookeeper ?
Posted by GitBox <gi...@apache.org>.
lwtdev commented on issue #7939:
URL: https://github.com/apache/shardingsphere/issues/7939#issuecomment-717689065
)
----------------------------------------------------------------
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 removed a comment on issue #7939: How to configure init schema in shardingsphere-jdbc 5.0.0-RC1 when use zookeeper ?
Posted by GitBox <gi...@apache.org>.
lwtdev removed a comment on issue #7939:
URL: https://github.com/apache/shardingsphere/issues/7939#issuecomment-717689065
)
----------------------------------------------------------------
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 #7939: How to configure init schema in shardingsphere-jdbc 5.0.0-RC1 when use zookeeper ?
Posted by GitBox <gi...@apache.org>.
lwtdev commented on issue #7939:
URL: https://github.com/apache/shardingsphere/issues/7939#issuecomment-717688203
@kimmking
How to use jdbc and shardingproxy together?
----------------------------------------------------------------
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