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

          maxmether Max Mether added a comment -

          Hello YK, could you explain the use case a bit more. I am not sure I understand what the purpose of this change is.

          maxmether Max Mether added a comment - Hello YK , could you explain the use case a bit more. I am not sure I understand what the purpose of this change is.

          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.