Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.4.0
-
None
-
Debian Jessie 8.2
Maxscale 1.2.1
Description
Hi,
I tried to setup mysql monitor from maxscale on mysql replication on 3 infinidb nodes (master/slave/slave) but I have this error :
Error : No Master can be determined
|
As you can see, my replication is up on master/slaves and from maxscale mysql monitor host I can connect to all dbs nodes :
|
mysql -hum1 -umaxscalerepl -pmaxscalepass -e "show slave status"
|
mysql -hum2 -umaxscalerepl -pmaxscalepass -e "show slave status"
|
mysql -hum3 -umaxscalerepl -pmaxscalepass -e "show slave status"
|
...
|
|
|
| Waiting for master to send event | 192.168.56.10 | idbrep | 3306 | 60 | mysql-bin.000010 | 1078 | relay-bin.000003 | 251 | mysql-bin.000010 | Yes | Yes | | | | | | | 0 | | 0 | 1078 | 545 | None | | 0 | No | | | | | | 0 | No | 0 | | 0 | |
|
|
|
...
|
Here my configuration :
|
[maxscale]
|
threads=3
|
log_trace=1
|
|
|
[um1]
|
type=server
|
address=192.168.56.10
|
port=3306
|
protocol=MySQLBackend
|
|
|
[um2]
|
type=server
|
address=192.168.56.12
|
port=3306
|
protocol=MySQLBackend
|
|
|
[um3]
|
type=server
|
address=192.168.56.17
|
port=3306
|
protocol=MySQLBackend
|
|
|
[MySQL Monitor]
|
mysql51_replication=true
|
type=monitor
|
module=mysqlmon
|
servers=um1,um2,um3
|
user=maxscalerepl
|
passwd=maxscalepass
|
monitor_interval=10000
|
|
|
[RWSplitRouter]
|
type=service
|
router=readwritesplit
|
servers=um1,um2,um3
|
user=maxscalerepl
|
passwd=maxscalepass
|
|
|
[RWSplitListener]
|
type=listener
|
service=RWSplitRouter
|
protocol=MySQLClient
|
port=3306
|
and ouput from maxadmin how servers :
Server 0x3676ae0 (um1)
|
Server: 192.168.56.10
|
Status: Running
|
Protocol: MySQLBackend
|
Port: 3306
|
Server Version: 5.1.73-log
|
Node Id: 1
|
Master Id: -1
|
Slave Ids:
|
Repl Depth: -1
|
Number of connections: 0
|
Current no. of conns: 0
|
Current no. of operations: 0
|
Server 0x36769d0 (um2)
|
Server: 192.168.56.12
|
Status: Slave, Running
|
Protocol: MySQLBackend
|
Port: 3306
|
Server Version: 5.1.73-log
|
Node Id: 2
|
Master Id: -1
|
Slave Ids:
|
Repl Depth: -1
|
Number of connections: 0
|
Current no. of conns: 0
|
Current no. of operations: 0
|
Server 0x36768c0 (um3)
|
Server: 192.168.56.17
|
Status: Slave, Running
|
Protocol: MySQLBackend
|
Port: 3306
|
Server Version: 5.1.73-log
|
Node Id: 3
|
Master Id: -1
|
Slave Ids:
|
Repl Depth: -1
|
Number of connections: 0
|
Current no. of conns: 0
|
Current no. of operations: 0
|
Where is the problem please ?