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

Allow MariaDB Monitor route read_query to the slave(s) of external server if needed

Details

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

    Description

      There is a proprietary request for the maxscale monitor "router_options" to label any server with [Slave of External Server] -> [Slave] so it can be used for read queries.

      This is for topologies where MaxScale does not see the real primary and is only configured with the replicas. Currently, the state for any replica that appears to be successfully replicating is Slave of External Server, Running which is not a true status bit from the router's point of view. The desires feature request is to mark these sorts of servers as Slave, Running instead.

                   ┌─────────┐              
              ┌───►│ Primary │◄───┐         
              │    └─────────┘    │         
              │                   │         
      ┌───────┼───────────────────┼────────┐
      │   ┌───┴─────┐        ┌────┴────┐   │
      │   │ Replica │        │ Replica │   │
      │   └─────────┘        └─────────┘   │
      │       ▲                   ▲        │
      │       │    ┌──────────┐   │        │
      │       └────┤ MaxScale ├───┘        │
      │            └──────────┘            │
      └────────────────────────────────────┘
      

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Max Mether made transition -
          Open Needs Feedback
          18d 17h 56m 1
          Yakov Kushnirsky made transition -
          Needs Feedback Open
          1d 4h 29m 1

          People

            YK Yakov Kushnirsky
            YK Yakov Kushnirsky
            Votes:
            0 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.