[MXS-3091] readconnroute router restrict reads to slave(s) only Created: 2020-07-23  Updated: 2021-09-27  Resolved: 2020-11-24

Status: Closed
Project: MariaDB MaxScale
Component/s: readconnroute
Affects Version/s: None
Fix Version/s: 6.0.0

Type: New Feature Priority: Major
Reporter: Muhammad Irfan Assignee: Niclas Antti
Resolution: Fixed Votes: 0
Labels: None

Sprint: MXS-SPRINT-117, MXS-SPRINT-118, MXS-SPRINT-119

 Description   

Maxscale with router=readconnroute to allow read traffic to be served even when the replication is broken (i.e slave IO or SQL process stopped). As per documentation we can do this by setting the router_options=running. However, with this setting this also sends traffic to the Master DB which we do not want. We want the read traffic to only go to the slaves even if the replication is broken. Master DB should only be chosen as a read candidate if none of the slave servers are available.
It seems like it's not possible to configure readconnroute to use all other servers except the master.


Generated at Thu Feb 08 04:18:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.