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 2022/11/11 14:45:24 UTC
[GitHub] [shardingsphere] Fanzhshuai opened a new issue, #22090: shadring jdbc HA And readwrite-splitting not effectuate
Fanzhshuai opened a new issue, #22090:
URL: https://github.com/apache/shardingsphere/issues/22090
shardingsphere-jdbc-core-spring-boot-starter： 5.2.1
type : sharding- jdbc
mysql cluster : one master two slave
HA And readwrite-splitting rules config：
rules:
readwrite-splitting:
data-sources:
replica_ds:
dynamic-strategy:
auto-aware-data-source-name: readwrite_ds
write-data-source-query-enabled: true
database-discovery:
data-sources:
readwrite_ds:
data-source-names: ds1,ds2,ds3
discovery-heartbeat-name: mgr-heartbeat
discovery-type-name: mgr
discovery-heartbeats:
mgr-heartbeat:
props:
keep-alive-cron: '0/5 * * * * ?'
discovery-types:
mgr:
type: MySQL.NORMAL_REPLICATION
props:
delay-milliseconds-threshold: 1000
Problem 1: When a salve MySQL server stops service from the database, the read request traffic cannot be switched to another available salve MySQL server
Problem 2: Both MySQL slave databases stop service, and the read request traffic cannot be switched to the available MySQL master server
I hope everybody can help me with this. Thank you
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sandynz commented on issue #22090: shadring jdbc HA And readwrite-splitting not effectuate
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #22090:
URL: https://github.com/apache/shardingsphere/issues/22090#issuecomment-1342710353
Hi @Fanzhshuai , thanks for you feedback. Suggest to use code block to paste configuration.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #22090: shadring jdbc HA And readwrite-splitting not effectuate
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #22090: shadring jdbc HA And readwrite-splitting not effectuate
URL: https://github.com/apache/shardingsphere/issues/22090
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #22090: shadring jdbc HA And readwrite-splitting not effectuate
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #22090:
URL: https://github.com/apache/shardingsphere/issues/22090#issuecomment-1407543716
This issue has been inactive for too long, and ShardingSphere has released several new versions, so I will close it.
Users are advised to try the latest version, and if the problem reproduces, please reopen it or submit a new one.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sandynz commented on issue #22090: shadring jdbc HA And readwrite-splitting not effectuate
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #22090:
URL: https://github.com/apache/shardingsphere/issues/22090#issuecomment-1342711035
Hi @zhaojinchao95 , could you help to have a look at this issue?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org