Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.2.9
-
None
-
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
- relates to
-
-
- Closed
-