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

readconnroute router restrict reads to slave(s) only

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 6.0.0
    • readconnroute
    • None
    • 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

            nantti Niclas Antti
            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.