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

Add option for preventing writes with router_options=slave

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • readconnroute

    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.

      Attachments

        Issue Links

          Activity

            People

              johan.wikman Johan Wikman
              markus makela markus makela
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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