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

Add columnstore primary in "list servers"

    XMLWordPrintable

Details

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

    Description

      Maxscale shows slave and master with "list servers"

       maxctrl list servers
      ┌─────────────┬──────────────┬──────┬─────────────┬─────────────────┬───────────┬─────────────────┐
      │ Server      │ Address      │ Port │ Connections │ State           │ GTID      │ Monitor         │
      ├─────────────┼──────────────┼──────┼─────────────┼─────────────────┼───────────┼─────────────────┤
      │ S54         │ xxx.xx.xx.5433060           │ Slave, Running  │ 0-3-12    │ MariaDB-Monitor │
      ├─────────────┼──────────────┼──────┼─────────────┼─────────────────┼───────────┼─────────────────┤
      │ S55         │ xxx.xx.xx.5533060           │ Master, Running │ 0-3-12    │ MariaDB-Monitor │
      ├─────────────┼──────────────┼──────┼─────────────┼─────────────────┼───────────┼─────────────────┤
      │ S56         │ xxx.xx.xx.5633060           │ Slave, Running  │ 0-3-12    │ MariaDB-Monitor │
      └─────────────┴──────────────┴──────┴─────────────┴─────────────────┴───────────┴─────────────────┘
      

      This is the async master.

      User also assumed it is identical with the columnstore primary mode, but this is not the case.

      So adding the information, if it is a columnstore node, which node is primary (maybe also if readwriteflag is set)

      The information can be grabbed from cmapi api from status in json format.

      "xxx.xx.xx.54": 
        "dbrm_mode": "master",
         "cluster_mode": "readwrite",
         
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.