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/07/23 04:21:47 UTC

[GitHub] [shardingsphere] lishijun121910 opened a new issue #6412: sharding-jdbc failover when master node is down

lishijun121910 opened a new issue #6412:
URL: https://github.com/apache/shardingsphere/issues/6412


   ## Question
   how sharding-jdbc support failover when master node is down when config a master-slave rule.
   
   the situation is when master is down, the slave node upgrade to be a new master.
   


----------------------------------------------------------------
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 #6412: sharding-jdbc failover when master node is down

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


   


----------------------------------------------------------------
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] zhaopinglu commented on issue #6412: sharding-jdbc failover when master node is down

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


   I read the links in your answer above, but I still can't be sure if ShardingSphere-JDBC (or -Proxy) support Master-Slave failover or not. Could you please answer this question directly? 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



[GitHub] [shardingsphere] zhaopinglu edited a comment on issue #6412: sharding-jdbc failover when master node is down

Posted by GitBox <gi...@apache.org>.
zhaopinglu edited a comment on issue #6412:
URL: https://github.com/apache/shardingsphere/issues/6412#issuecomment-667127243


   Hi @tristaZero, I read the links in your answer above, but I still can't be sure if ShardingSphere-JDBC (or -Proxy) support the Master-Slave failover or not. Could you please give a straight answer for the PO's question? 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



[GitHub] [shardingsphere] tristaZero commented on issue #6412: sharding-jdbc failover when master node is down

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


   @zhaopinglu Simply speaking, ShardingSphere can not handle the failover of MySQL, but it can push the info of new masters and slaves to all the proxy or JDBC clients online.


----------------------------------------------------------------
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] zhaopinglu edited a comment on issue #6412: sharding-jdbc failover when master node is down

Posted by GitBox <gi...@apache.org>.
zhaopinglu edited a comment on issue #6412:
URL: https://github.com/apache/shardingsphere/issues/6412#issuecomment-667127243


   Hi @tristaZero, I read the links in your answer above, but I still can't be sure if ShardingSphere-JDBC (or -Proxy) support the Master-Slave failover or not. Could you please answer this question directly? 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



[GitHub] [shardingsphere] tristaZero commented on issue #6412: sharding-jdbc failover when master node is down

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


   Hi @lishijun121910 
   
   Please refer to [Orchestration](https://shardingsphere.apache.org/document/legacy/4.x/document/cn/features/orchestration/)
   All the relationships of data sources and sharding rules are stored in registry center.
   You or your program need to update `the new master info` on the registry center, and it will push this event online.


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