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

The Desynced state of Galera Node is not given in maxctrl server list

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 6.0.0
    • galeramon

    Description

      The Desynced state of Galera Node is not given in maxctrl server list

      When Galera Node was desynced from the group with setting up wsrep_desync,
      the maxctrl is displaying just Running.
      It would be more clear if give in addition the Desynced state in the maxctrl server list.

      on server2 set wsrep_desync and FTWRL
      check that Node gets in Desynced state
      check the State of server2 from MaxScale Node via maxctrl list servers

      MariaDB [(none)]> set global wsrep_desync=1 ;
      Query OK, 0 rows affected (0.001 sec)
       
      MariaDB [(none)]> flush tables with read lock ;
      Query OK, 0 rows affected (0.000 sec)
      

      check locally on server2 the wsrep state

       
      MariaDB [(none)]> show status like "%state%" ;
      +-------------------------------------------+--------------------------------------+
      | Variable_name                             | Value                                |
      +-------------------------------------------+--------------------------------------+
      | Max_statement_time_exceeded               | 0                                    |
      | Performance_schema_statement_classes_lost | 0                                    |
      | wsrep_cluster_state_uuid                  | 3c15149f-5766-11e8-9a99-22bc53d40581 |
      | wsrep_evs_state                           | OPERATIONAL                          |
      | wsrep_local_state                         | 2                                    |
      | wsrep_local_state_comment                 | Donor/Desynced                       |
      | wsrep_local_state_uuid                    | 3c15149f-5766-11e8-9a99-22bc53d40581 |
      +-------------------------------------------+--------------------------------------+
      7 rows in set (0.001 sec)
      
      

      The wsrep Desynced state of server is not displayed from the MaxScale Node

      [root@t4w1 /]#  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  │      │
      └─────────┴─────────────────┴──────┴─────────────┴─────────────────────────┴──────┘
      
      

      Attachments

        Activity

          People

            markus makela markus makela
            winstone Zdravelina Sokolovska (Inactive)
            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.