Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
MXS-SPRINT-99, MXS-SPRINT-100, MXS-SPRINT-118
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 │ │
|
└─────────┴─────────────────┴──────┴─────────────┴─────────────────────────┴──────┘
|
|