[MXS-1454] Put a master server in read_only to execute maintenance while accepting reads Created: 2017-09-26  Updated: 2022-06-05  Resolved: 2019-09-04

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Wagner Bianchi (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 1
Labels: None


 Description   

Folks,

I'm working with an environment in which the customer has two Maxscale on version 2.0.X and two sets of master/slave geo-located. we're planning a maintenance and the customer asked me if I can put the master servers in read_only mode on Maxscale in order to permit queries to be yet redirected to master, but just reads, writes should be routed to /dev/nul (e.g.) at this point.

I was thinking of something like:

$ maxadmin "remove | set server <master_servername> read_only"

This is something that a customer asked me and I think it's a good thing as we can control this behavior on the Maxscale while don't touching the configs on the server level.



 Comments   
Comment by Johan Wikman [ 2019-09-04 ]

Seems obsolete now that switchover functionality is provided.

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