Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1454

Put a master server in read_only to execute maintenance while accepting reads

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • Icebox
    • N/A
    • 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.

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            wagnerbianchi Wagner Bianchi (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.