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/05/08 18:26:32 UTC
[GitHub] [shardingsphere] ppourali opened a new issue #5482: Connecting to multiple databases through sharding proxy fails
ppourali opened a new issue #5482:
URL: https://github.com/apache/shardingsphere/issues/5482
Hi,
I have question regarding sharding proxy in transparent mode. Can we connect to multiple databases at the same time in the transparent mode?
This is my configuration.yaml:
```
schemaName: pgadventureworks
dataSource:
url: jdbc:postgresql://localhost:5432/Adventureworks?serverTimezone=UTC&useSSL=false&useUnicode=true&allowEncodingChanges=true
username: postgres
password: password
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
schemaName: adventureworks
dataSource:
url: jdbc:mysql://127.0.0.1:3306/adventureworks?serverTimezone=UTC&useSSL=false&useUnicode=true&allowEncodingChanges=true
username: mysqluser
password: password
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
```
I have two rules: one for a mysql database and the other one for postgresql database. When I use mysql and psql from command line, only one of them works. Most of the times, I can connect to psql but the mysql fails.
Am I configuring them incorrectly? Let's say I have different databases on different DBMS types and I want them to be proxied by one instance of sharding proxy.
Any help would be appreciated,
Thanks
Parsa
----------------------------------------------------------------
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] cherrylzhao commented on issue #5482: Connecting to multiple databases through sharding proxy fails
Posted by GitBox <gi...@apache.org>.
cherrylzhao commented on issue #5482:
URL: https://github.com/apache/shardingsphere/issues/5482#issuecomment-626087002
agree with @dongzl sharding-proxy only support one database type currently, maybe we can round-robin the database types to select the active one in runtime.
----------------------------------------------------------------
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] ppourali closed issue #5482: Connecting to multiple databases through sharding proxy fails
Posted by GitBox <gi...@apache.org>.
ppourali closed issue #5482:
URL: https://github.com/apache/shardingsphere/issues/5482
----------------------------------------------------------------
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] ppourali commented on issue #5482: Connecting to multiple databases through sharding proxy fails
Posted by GitBox <gi...@apache.org>.
ppourali commented on issue #5482:
URL: https://github.com/apache/shardingsphere/issues/5482#issuecomment-630198529
Got it! Thanks guys.
----------------------------------------------------------------
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 #5482: Connecting to multiple databases through sharding proxy fails
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #5482:
URL: https://github.com/apache/shardingsphere/issues/5482#issuecomment-626094766
And more, @ppourali you can try some things to support it.
----------------------------------------------------------------
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] ppourali commented on issue #5482: Connecting to multiple databases through sharding proxy fails
Posted by GitBox <gi...@apache.org>.
ppourali commented on issue #5482:
URL: https://github.com/apache/shardingsphere/issues/5482#issuecomment-626653567
Hi guys,
Thanks for the reply. OK, I just wanted to make sure that I am not doing anything wrong. But it would be good if there was a feature to orchestrate different types of databases with one single instance.
Thanks,
Parsa
----------------------------------------------------------------
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] dongzl commented on issue #5482: Connecting to multiple databases through sharding proxy fails
Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #5482:
URL: https://github.com/apache/shardingsphere/issues/5482#issuecomment-630091577
Hi @ppourali , `The feature to orchestrate different types of databases with one single instance` doesn't support, and we are no plan to support this feature recently.
You can pay attention to ShardingSphere.
Do you have any other questions? if not, can you close this issue, thanks.
----------------------------------------------------------------
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