[MXS-4820] Add option for preventing writes with router_options=slave Created: 2023-10-19  Updated: 2024-01-30

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

Type: New Feature Priority: Major
Reporter: markus makela Assignee: Joe Cotellese
Resolution: Unresolved Votes: 0
Labels: CS0692282

Issue Links:
Duplicate
is duplicated by MXS-4918 Readconnroute router allows starting ... Closed

 Description   

If applications are using a MaxScale service that uses a readconnroute configured with router_option=slave without being aware of this fact, the applications may end up doing writes. This will break replication and cause the data on the servers to diverge.

To prevent these kinds of situations, the default behavior should be changed so that if router_options has slave in it, writes result in an error being sent to the client.

A new option (e.g. prevent_writes) would allow the new behavior to be disabled in those cases where it is not needed. This new option might not even be necessary: existing Galera setups could use router_options=synced if they were using router_options=slave for load balancing mixed workloads.


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