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

readconnroute router restrict reads to slave(s) only

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.0.0
    • Component/s: readconnroute
    • 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.

        Attachments

          Activity

            People

            Assignee:
            nantti Niclas Antti
            Reporter:
            muhammad.irfan Muhammad Irfan
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.