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 2021/09/10 09:44:20 UTC
[GitHub] [shardingsphere] zhanghongzheng6 opened a new issue #12340: Read write separation, MySQL master-slave delay
zhanghongzheng6 opened a new issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340
When using shardingsphere read / write separation, if the master-slave synchronization is delayed, can the program automatically change the read operation to read the master library
--
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] zhanghongzheng6 removed a comment on issue #12340: Read write separation, MySQL master-slave delay
Posted by GitBox <gi...@apache.org>.
zhanghongzheng6 removed a comment on issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340#issuecomment-916775369
Well, I see
--
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] zhanghongzheng6 commented on issue #12340: Read write separation, MySQL master-slave delay
Posted by GitBox <gi...@apache.org>.
zhanghongzheng6 commented on issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340#issuecomment-916775369
Well, I see
--
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] zhanghongzheng6 commented on issue #12340: Read write separation, MySQL master-slave delay
Posted by GitBox <gi...@apache.org>.
zhanghongzheng6 commented on issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340#issuecomment-916768354
Thank you for your reply. The problem I encountered can not be completely solved.
My problem is: the database jitters. The master and slave are delayed for 10 seconds. A complete query request does not read the latest data. This leads to a serious problem.
Is there a function similar to heartbeat check that can automatically switch between master and slave when there is a certain delay?
--
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] zhanghongzheng6 commented on issue #12340: Read write separation, MySQL master-slave delay
Posted by GitBox <gi...@apache.org>.
zhanghongzheng6 commented on issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340#issuecomment-916775548
Well, I see
--
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 #12340: Read write separation, MySQL master-slave delay
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340#issuecomment-916701542
Yes, ShardingSphere-JDBC has this ability.
Please refer to the dockement: https://shardingsphere.apache.org/document/current/cn/features/readwrite-splitting/use-norms/
Set `queryConsistent ` to true to enable this feature.
example:
https://github.com/apache/shardingsphere/blob/master/examples/shardingsphere-jdbc-example/sharding-example/sharding-raw-jdbc-example/src/main/resources/META-INF/sharding-readwrite-splitting.yaml
--
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] zhanghongzheng6 closed issue #12340: Read write separation, MySQL master-slave delay
Posted by GitBox <gi...@apache.org>.
zhanghongzheng6 closed issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340
--
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 #12340: Read write separation, MySQL master-slave delay
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340#issuecomment-916770821
No.
The master-slave synchronization is done independently by the databases, and ShardingSphere cannot perceive 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.
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 #12340: 读写分离,mysql主从延迟
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12340:
URL: https://github.com/apache/shardingsphere/issues/12340#issuecomment-916688569
Hello, for English only, please translate the title and content, 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
For queries about this service, please contact Infrastructure at:
users@infra.apache.org