Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
2.1.10
-
None
-
2017-46
Description
We have setup where server A is a master of slave, server B. Server A has database X, which is replicating to slave B. We have configured Maxscale to monitor server A and server B, and as expected the list servers command shows:
-------------------+-----------------+-------+-------------+--------------------
|
Server | Address | Port | Connections | Status
|
-------------------+-----------------+-------+-------------+--------------------
|
server_01 | xxx.xxx.xxx.67 | 3306 | 0 | Master, Running
|
server_02 | xxx.xxx.xxx.68 | 3306 | 0 | Slave, Running
|
-------------------+-----------------+-------+-------------+--------------------
|
We also have a database Y in server C which is replicating to server A and server B.Therefore server C is a master of server A and server B, and server B now has multi-source replication setup. When we do this the list server command on Maxscale shows:
-------------------+-----------------+-------+-------------+--------------------
|
Server | Address | Port | Connections | Status
|
-------------------+-----------------+-------+-------------+--------------------
|
server_01 | xxx.xxx.xxx.67 | 3306 | 0 | Master, Slave, Slave of External Server, Stale Status, Running
|
server_02 | xxx.xxx.xxx.68 | 3306 | 0 | Slave, Slave of External Server, Running
|
-------------------+-----------------+-------+-------------+--------------------
|
However, when we restart Maxscale, the status changes to :
-------------------+-----------------+-------+-------------+--------------------
|
Server | Address | Port | Connections | Status
|
-------------------+-----------------+-------+-------------+--------------------
|
server_01 | xxx.xxx.xxx.67 | 3306 | 0 | Slave, Slave of External Server, Running
|
server_02 | xxx.xxx.xxx.68 | 3306 | 0 | Slave, Slave of External Server, Running
|
-------------------+-----------------+-------+-------------+--------------------
|
Also the maxscle log has the following entry:
error : [mysqlmon] No Master can be determined
|
A rough diagram of the setup:
+------------+| || Seen by || MaxScale || || +---+ | +---+| | | | | || | A <-----+ C || | | | | || +-+-+ | +-+-+| | | || | | || | | || +-v-+ | || | | | || | B <-------+| | | || +---+ || |+------------+Here we would want to label the server A as the master even if it's replicating from an external server that is not configured in MaxScale.