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/06/20 06:22:02 UTC
[GitHub] [shardingsphere] zjcnb opened a new issue, #18441: Consider primary datasource provides query when all the replica are offline in Readwrite-Splitting Dynamic type
zjcnb opened a new issue, #18441:
URL: https://github.com/apache/shardingsphere/issues/18441
Hi community,
Execute the query throws an exception when we use `readwrite-splitting ` rule and` db-discovery` rule and all the replica are offline.
![image](https://user-images.githubusercontent.com/33742097/174536944-ae21edd6-e419-4b87-82db-a4f217a7bb61.png)
So, we consider add configuration switch in Dynamic `readwrite-splitting`, choose the primary data source by yourself to whether provide query when all the replica are offline.
--
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] zjcnb commented on issue #18441: Consider primary datasource provides query when all the replica are offline in Readwrite-Splitting Dynamic type
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #18441:
URL: https://github.com/apache/shardingsphere/issues/18441#issuecomment-1160030867
`Configuration : `
```
rules:
- !READWRITE_SPLITTING
dataSources:
readwrite_ds:
type: Dynamic
props:
auto-aware-data-source-name: replication_delay_ds
primary-data-source-allow-query: true # Default Value are true, it represents provide query when all the replica are offline.
- !DB_DISCOVERY
dataSources:
replication_delay_ds:
dataSourceNames:
- ds_0
- ds_1
- ds_2
discoveryHeartbeatName: replication_delay_heartbeat
discoveryTypeName: replication_delay
discoveryHeartbeats:
replication_delay_heartbeat:
props:
keep-alive-cron: '0/1 * * * * ?'
discoveryTypes:
replication_delay:
type: MySQL.NORMAL_REPLICATION
props:
delay-milliseconds-threshold: 1000
```
--
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] tristaZero closed issue #18441: Consider primary datasource provides query when all the replica are offline in Readwrite-Splitting Dynamic type
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #18441: Consider primary datasource provides query when all the replica are offline in Readwrite-Splitting Dynamic type
URL: https://github.com/apache/shardingsphere/issues/18441
--
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