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

Queries are not always counted as reads with router_options=slave

    XMLWordPrintable

Details

    Description

      If readconnroute is configured with router_options=slave but it ends up choosing a server labeled as Master, Running for the connection, all queries will be counted as writes for the statistics.

      The reason this happens is because the internal bitmask value is modified with SERVER_MASTER to accept the server even it doesn't have the SERVER_SLAVE bit on. Since the code checks for the SERVER_MASTER bit when incrementing the counters, it falsely counts it as a write when it should be counted as a read due to router_options=slave.

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.