[MXS-1404] Create MySQL Group replication monitoring Created: 2017-09-12 Updated: 2017-12-01 Resolved: 2017-09-21 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | N/A |
| Affects Version/s: | None |
| Fix Version/s: | 2.2.0 |
| Type: | New Feature | Priority: | Major |
| Reporter: | bart vrancken | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
requirements:
On each node do: <> show variables like 'server_uuid'; Get the UUID of the host you are looking at, which matches the MEMBER_ID value <> SELECT * FROM performance_schema.replication_group_members\G; Example (1 row per node, unless self node is offline, then only 1 result for self stating OFFLINE) CHANNEL_NAME: group_replication_applier When the MEMBER_STATE == ONLINE, the node is healthy default -> UNKNOWN (so if node 1 says 3x online, but node 2 says there is 1 offline, then that node is offline) <> SELECT @@global.read_only\G; Output:
Only 1 should be master. You can confirm this by running on all nodes SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= 'group_replication_primary_member'; then check if the UUID returned by all the nodes is the same. Then match the UUID to the MEMBER_ID from the first query |
| Comments |
| Comment by markus makela [ 2017-09-21 ] |
|
Created an experimental Group Replication monitor which will be included in the experimental module package of 2.2.0. |