You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "liruhui (via GitHub)" <gi...@apache.org> on 2023/04/18 03:23:01 UTC
[GitHub] [shardingsphere] liruhui opened a new issue, #25204: dynamic-readwrite-split is not right
liruhui opened a new issue, #25204:
URL: https://github.com/apache/shardingsphere/issues/25204
```
mysql: one master three slave
datasourcediscovery+dynamic-readwrite-split
shardingsphere 5.3.1
````
## 1. yaml-config
```yaml
dataSources:
write:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl: jdbc:mysql://192.168.191.122:3306/aaa?serverTimezone=UTC
username: root
password: 11111
read_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl: jdbc:mysql://192.168.191.122:3307/aaa?serverTimezone=UTC
username: root
password: 11111
read_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl: jdbc:mysql://192.168.191.122:3308/aaa?serverTimezone=UTC
username: root
password: 11111
read_2:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl: jdbc:mysql://192.168.191.122:3309/aaa?serverTimezone=UTC
username: root
password: 11111
rules:
- !READWRITE_SPLITTING
dataSources:
abc:
dynamicStrategy:
autoAwareDataSourceName: xyz
loadBalancerName: balancer
loadBalancers:
balancer:
type: ROUND_ROBIN
- !DB_DISCOVERY
dataSources:
xyz:
dataSourceNames:
- write
- read_0
- read_1
- read_2
discoveryHeartbeatName: myBeart
discoveryTypeName: myType
discoveryHeartbeats:
myBeart:
props:
keep-alive-cron: '0/5 * * * * ?'
discoveryTypes:
myType:
type: MySQL.NORMAL_REPLICATION
props:
delay-milliseconds-threshold: 3000
````
## 2: problem description
```
When the slave machine is down, it will also query the down slave machine.
```
## 3. Official document
![image](https://user-images.githubusercontent.com/24687986/232662813-87bddde9-0b8b-4369-ab98-52c051ff45ae.png)
--
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] RaigorJiang commented on issue #25204: dynamic-readwrite-split is not right
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #25204:
URL: https://github.com/apache/shardingsphere/issues/25204#issuecomment-1512387213
@liruhui
Unfortunately, there is indeed some problems with dynamic readwrite-splitting, and it is no longer maintained.
Please refer to #24486.
--
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 #25204: dynamic-readwrite-split is not right
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #25204: dynamic-readwrite-split is not right
URL: https://github.com/apache/shardingsphere/issues/25204
--
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] liruhui commented on issue #25204: dynamic-readwrite-split is not right
Posted by "liruhui (via GitHub)" <gi...@apache.org>.
liruhui commented on issue #25204:
URL: https://github.com/apache/shardingsphere/issues/25204#issuecomment-1512394930
@RaigorJiang
Ok I see 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