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

The GTID of Galera Nodes is not displayed by maxctrl server list

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.9
    • Fix Version/s: 2.4.0
    • Component/s: galeramon
    • Labels:
      None
    • Environment:
      3 Mater-Master Galera Nodes; CentOS 7.4

      Description

      The GTID of Galera Nodes is not displayed by maxctrl server list

      depend on the gelera docs the GTID of galera Node consists of 2 components: State UUID and Ordinal Sequence Number
      State UUID:Ordinal Sequence Number

      it would be useful to display the GTID in galera GTID format for the monitored galera servers

      #  maxctrl list  servers
      ┌─────────┬─────────────────┬──────┬─────────────┬─────────────────────────┬──────┐
      │ Server  │ Address         │ Port │ Connections │ State                   │ GTID │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server1 │ 192.168.104.193 │ 3306 │ 0           │ Master, Synced, Running │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server2 │ 192.168.104.195 │ 3306 │ 0           │ Running                 │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server3 │ 192.168.104.196 │ 3306 │ 0           │ Slave, Synced, Running  │      │
      └─────────┴─────────────────┴──────┴─────────────┴─────────────────────────┴──────┘
      [root@t4w1 /]#
      
      

      the GTID taken from server1 and server3
      3c15149f-5766-11e8-9a99-22bc53d40581:26987

      MariaDB [(none)]>  show status like '%wsrep_local_state_uuid%';
      +------------------------+--------------------------------------+
      | Variable_name          | Value                                |
      +------------------------+--------------------------------------+
      | wsrep_local_state_uuid | 3c15149f-5766-11e8-9a99-22bc53d40581 |
      +------------------------+--------------------------------------+
      1 row in set (0.001 sec)
       
      
      

      MariaDB [(none)]> show status like '%wsrep_last_committed%';
      +----------------------+-------+
      | Variable_name        | Value |
      +----------------------+-------+
      | wsrep_last_committed | 26987 |
      +----------------------+-------+
      1 row in set (0.001 sec)
      
      

      the GTID taken from server2
      3c15149f-5766-11e8-9a99-22bc53d40581:26985

      MariaDB [(none)]> show status like '%wsrep_local_state_uuid%';
      +------------------------+--------------------------------------+
      | Variable_name          | Value                                |
      +------------------------+--------------------------------------+
      | wsrep_local_state_uuid | 3c15149f-5766-11e8-9a99-22bc53d40581 |
      +------------------------+--------------------------------------+
      1 row in set (0.001 sec)
       
      MariaDB [(none)]> show status like '%wsrep_last_committed%';
      +----------------------+-------+
      | Variable_name        | Value |
      +----------------------+-------+
      | wsrep_last_committed | 26985 |
      +----------------------+-------+
      1 row in set (0.001 sec)
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              winstone Zdravelina Sokolovska
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: