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/04/17 10:54:38 UTC
[GitHub] [incubator-shardingsphere] tristaZero opened a new issue #5220:
JDBC url can contain Multi-hosts
tristaZero opened a new issue #5220: JDBC url can contain Multi-hosts
URL: https://github.com/apache/incubator-shardingsphere/issues/5220
MySQL Connector/J supports server failover and load balance by using a multi-hosts JDBC URL.
At present, users can not practice this MySQL feature since ShardingSphere can not analyze a multi-hosts JDBC URL.
However, a piece of good news is that we will provide this enhancement **in our incoming 4.1.0 release!**
Please follow this ISSUE to learn how it moves.
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #5220:
Tackle with JDBC URL containing Multi-hosts
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #5220: Tackle with JDBC URL containing Multi-hosts
URL: https://github.com/apache/incubator-shardingsphere/issues/5220#issuecomment-615197405
```
## failover url
jdbc:mysql://[primary host][:port],[secondary host 1][:port][,[secondary host 2][:port]]...[/[database]]»
[?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking edited a comment on issue
#5220: Tackle with JDBC URL containing Multi-hosts
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #5220: Tackle with JDBC URL containing Multi-hosts
URL: https://github.com/apache/incubator-shardingsphere/issues/5220#issuecomment-615197405
```
## failover jdbc url
jdbc:mysql://[primary host][:port],[secondary host 1][:port][,[secondary host 2][:port]]...[/[database]][?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking edited a comment on issue
#5220: Tackle with JDBC URL containing Multi-hosts
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #5220: Tackle with JDBC URL containing Multi-hosts
URL: https://github.com/apache/incubator-shardingsphere/issues/5220#issuecomment-615197405
```
## failover jdbc url
jdbc:mysql://[primary host][:port],[secondary host 1][:port][,[secondary host 2][:port]]...[/[database]]»
[?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [shardingsphere] cherrylzhao commented on issue #5220: Tackle with JDBC URL containing Multi-hosts
Posted by GitBox <gi...@apache.org>.
cherrylzhao commented on issue #5220:
URL: https://github.com/apache/shardingsphere/issues/5220#issuecomment-617023644
currently hostname and port only referenced by scalling and open-tracing, just extract primary host and port using regex to compatible with 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] [incubator-shardingsphere] kimmking edited a comment on issue
#5220: Tackle with JDBC URL containing Multi-hosts
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #5220: Tackle with JDBC URL containing Multi-hosts
URL: https://github.com/apache/incubator-shardingsphere/issues/5220#issuecomment-615197405
```
## failover jdbc url
jdbc:mysql://[primary host][:port],[secondary host 1][:port][,[secondary host 2][:port]]...[/[database]][?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tristaZero commented on issue #5220:
Tackle with JDBC URL containing Multi-hosts
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #5220: Tackle with JDBC URL containing Multi-hosts
URL: https://github.com/apache/incubator-shardingsphere/issues/5220#issuecomment-615185734
#### References
[1] https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-config-failover.html
[2] https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-jdbc-url-format.html
[3] https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-multi-host-connections.html
----------------------------------------------------------------
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
With regards,
Apache Git Services