Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
Description
Maxscale confusingly shows master node as slave when variable read_only=ON on master. This causes confusion in support and the customer which could be resolved with a clearer status message or logged message
Can we have a clearer text like
Master (But Read Only), Running
|
or enhance the message
024-05-30 16:45:51 warning: [mariadbmon] The current primary server 'onl-actixmdb01' is no longer valid because it is in read-only mode, but there is no valid alternative to swap to. |
removing `but there is no valid alternative to swap to.` to recommend setting read_only=OFF or use --force flag to ignore
removing "no longer valid " version with "The current primary server 'onl-actixmdb01' cant accept writes because its in read-only mode"
Before: (confusing support & customer)
┌────────────────┬───────────────┬──────┬─────────────┬────────────────┬──────────┬───────────────┐
|
│ Server │ Address │ Port │ Connections │ State │ GTID │ Monitor │
|
├────────────────┼───────────────┼──────┼─────────────┼────────────────┼──────────┼───────────────┤
|
│ onl-actixmdb01 │ 209.171.0.161 │ 3306 │ 0 │ Slave, Running │ 1-1-1193 │ Actix_monitor │ |
├────────────────┼───────────────┼──────┼─────────────┼────────────────┼──────────┼───────────────┤
|
│ onl-actixmdb02 │ 209.171.0.162 │ 3306 │ 0 │ Slave, Running │ 1-1-1193 │ Actix_monitor │ |
├────────────────┼───────────────┼──────┼─────────────┼────────────────┼──────────┼───────────────┤
|
│ onl-actixmdb03 │ 209.171.0.163 │ 3306 │ 0 │ Slave, Running │ 1-1-1193 │ Actix_monitor │ |
└────────────────┴───────────────┴──────┴─────────────┴────────────────┴──────────┴───────────────┘
|
After running `set global read_only=OFF`
[root@onl-actixmed-30 ~]# maxctrl list servers |
┌────────────────┬───────────────┬──────┬─────────────┬─────────────────┬──────────┬───────────────┐
|
│ Server │ Address │ Port │ Connections │ State │ GTID │ Monitor │
|
├────────────────┼───────────────┼──────┼─────────────┼─────────────────┼──────────┼───────────────┤
|
│ onl-actixmdb01 │ 209.171.0.161 │ 3306 │ 0 │ Master, Running │ 1-1-1193 │ Actix_monitor │ |
├────────────────┼───────────────┼──────┼─────────────┼─────────────────┼──────────┼───────────────┤
|
│ onl-actixmdb02 │ 209.171.0.162 │ 3306 │ 0 │ Slave, Running │ 1-1-1193 │ Actix_monitor │ |
├────────────────┼───────────────┼──────┼─────────────┼─────────────────┼──────────┼───────────────┤
|
│ onl-actixmdb03 │ 209.171.0.163 │ 3306 │ 0 │ Slave, Running │ 1-1-1193 │ Actix_monitor │ |
└────────────────┴───────────────┴──────┴─────────────┴─────────────────┴──────────┴───────────────┘
|
[root@onl-actixmed-30 ~]# |
Attachments
Issue Links
- duplicates
-
MXS-5015 Separate read-write/read-only and master/slave
-
- Open
-