[GitHub] [shardingsphere] kfwang90 commented on issue #8736: Support mysql jdbc's loadbalance

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

kfwang90 commented on issue #8736:
URL: https://github.com/apache/shardingsphere/issues/8736#issuecomment-752860247


   > Hi @xunyard ,
   > 
   > Currently, we suggest users achieve the load-balance of Sharding Proxy by `LVS` or `F5` . On the other hand, I am interested in your approach. Could you provide a more detailed log about the exception when the configuration is `mysql:loadbalance`?
   > I am considering how to load balance leveraging the power of the database. Do you think PostgreSQL has a similar JDBC driver property?
   
   I have a similar question, our project deployed in two data centers. PG clusters is async replication mode(**Not HA Cluster**). I try to use shardingsphere-jdbc config with this: "jdbc:postgresql://node1,node2,node3/accounting?targetServerType=master", but get exception: **UnrecognizedDatabaseURLException**. 
   My purpose is one PG node down, async switch to master byhand, but the application don't have to change config and restart.


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