Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
MXS-SPRINT-218, MXS-SPRINT-219
Description
MariaDB Monitor sets "Slave of External Server" when a server is replicating from a non-monitored server. The replication threads must both be running to get this status. For IO thread, "Connecting"-state is also interpreted as running, as the thread is not stopped. However, this can give the user the wrong impression, as the external master may even be down with no change in "Slave of External Server". This same logic is in effect for normal "Slave"-status as well, but in that case a downed master can be seen in "maxctrl list servers". This issue can be fixed by changing the status to "Slave of External Server (connecting)" when IO thread is attempting to connect. The slave_conditions-setting can be ignored in this case as the setting is meant to affects real server roles and not informational status messages.
Original description:
When there is an External replication, maxscale is able to handle it in case of switch/failover, but is not able to report if the " Slave of External " has replication broke from the monitor.
looking at:
┌─────────┬──────────────────────────────┬──────┬─────────────┬───────────────────────────────────────────┬────────────────────┬─────────────────┐
|
│ Server │ Address │ Port │ Connections │ State │ GTID │ Monitor │
|
├─────────┼──────────────────────────────┼──────┼─────────────┼───────────────────────────────────────────┼────────────────────┼─────────────────┤
|
│ dublin1 │ reporting-stage-euw1-mdbe-01 │ 3306 │ 5 │ Master, Running, Slave of External Server │ 0-10261116-4808849 │ MariaDB-Monitor │ |
├─────────┼──────────────────────────────┼──────┼─────────────┼───────────────────────────────────────────┼────────────────────┼─────────────────┤
|
│ dublin2 │ reporting-stage-euw1-mdbe-02 │ 3306 │ 5 │ Slave, Running │ 0-10261116-4808849 │ MariaDB-Monitor │ |
├─────────┼──────────────────────────────┼──────┼─────────────┼───────────────────────────────────────────┼────────────────────┼─────────────────┤
|
│ dublin3 │ reporting-stage-euw1-mdbe-03 │ 3306 │ 5 │ Slave, Running │ 0-10261116-4808849 │ MariaDB-Monitor │ |
└─────────┴──────────────────────────────┴──────┴─────────────┴───────────────────────────────────────────┴────────────────────┴─────────────────┘
|
the replication is not working on reporting-stage-euw1-mdbe-01 as External (broken), it will be great if the monitor could report that as well (may with reasonable timing check)