|
Test is:
- configure some servers (server1...server4, .106...109) and mysqlmon, do some tests
- change maxscale.cnf: same server names, but different IPs (server1...server4, .111...114), galeramon
- SIGHUP to Maxscale
result is:
MaxScale> show servers
Server 0x31076c0 (server1)
Server: 192.168.122.111
Status: Running
Protocol: MySQLBackend
Port: 3306
Node Id: -1
Master Id: -1
Repl Depth: -1
Number of connections: 0
Current no. of conns: 0
Current no. of operations: 0
Server 0x31075d0 (server2)
Server: 192.168.122.112
Status: Running
Protocol: MySQLBackend
Port: 3306
Node Id: -1
Master Id: -1
Repl Depth: -1
Number of connections: 0
Current no. of conns: 0
Current no. of operations: 0
Server 0x30faa80 (server3)
Server: 192.168.122.113
Status: Running
Protocol: MySQLBackend
Port: 3306
Node Id: -1
Master Id: -1
Repl Depth: -1
Number of connections: 0
Current no. of conns: 0
Current no. of operations: 0
Server 0x30fa970 (server4)
Server: 192.168.122.114
Status: Running
Protocol: MySQLBackend
Port: 3306
Node Id: -1
Master Id: -1
Repl Depth: -1
Number of connections: 0
Current no. of conns: 0
Current no. of operations: 0
Server 0x30e78e0 (server1)
Server: 192.168.122.106
Status: Master, Running
Protocol: MySQLBackend
Port: 3306
Server Version: 5.5.43-MariaDB-log
Node Id: 106
Master Id: 107
Repl Depth: 0
Number of connections: 3
Current no. of conns: 0
Current no. of operations: 0
Server 0x30e77d0 (server2)
Server: 192.168.122.107
Status: Master, Running
Protocol: MySQLBackend
Port: 3306
Server Version: 5.5.43-MariaDB-log
Node Id: 107
Master Id: 106
Repl Depth: 0
Number of connections: 243
Current no. of conns: 0
Current no. of operations: 0
MaxScale>
server1 and server2 are listed twice!
other commands also show strange things:
MaxScale> show monitors
Monitor: 0x30f2a10
Name: MySQL Monitor
Monitor running
Sampling interval: 8000 milliseconds
Detect Stale Master: disabled
Monitored servers: 192.168.122.106:3306, 192.168.122.107:3306
MaxScale>
MaxScale> show services
Service 0x3108030
Service: Read Connection Router
Router: readconnroute (0x7ff6d0f645e0)
State: Allocated
Started: Tue Jun 2 23:40:09 2015
Root user access: Disabled
Backend databases
192.168.122.114:3306 Protocol: MySQLBackend
192.168.122.113:3306 Protocol: MySQLBackend
192.168.122.112:3306 Protocol: MySQLBackend
192.168.122.111:3306 Protocol: MySQLBackend
Users data: 0x3109040
Total connections: 0
Currently connected: 0
Service 0x31077d0
Service: HTTPD Router
Router: testroute (0x7ff6b43e8520)
State: Allocated
Started: Tue Jun 2 23:40:09 2015
Root user access: Disabled
Backend databases
192.168.122.114:3306 Protocol: MySQLBackend
192.168.122.113:3306 Protocol: MySQLBackend
192.168.122.112:3306 Protocol: MySQLBackend
192.168.122.111:3306 Protocol: MySQLBackend
Users data: 0x31083b0
Total connections: 1
Currently connected: 1
Service 0x30e9570
Service: RW Split Router
Router: readwritesplit (0x7ff6d0d3f0a0)
State: Started
Number of router sessions: 124
Current no. of router sessions: 0
Number of queries forwarded: 44
Number of queries forwarded to master: 28
Number of queries forwarded to slave: 16
Number of queries forwarded to all: 124
Started: Tue Jun 2 21:59:56 2015
Root user access: Disabled
Filter chain: QLA
Backend databases
192.168.122.114:3306 Protocol: MySQLBackend
192.168.122.113:3306 Protocol: MySQLBackend
192.168.122.112:3306 Protocol: MySQLBackend
192.168.122.111:3306 Protocol: MySQLBackend
192.168.122.107:3306 Protocol: MySQLBackend
192.168.122.106:3306 Protocol: MySQLBackend
Users data: 0x30f3380
Total connections: 125
Currently connected: 1
Service 0x30e93e0
Service: Read Connection Router Slave
Router: readconnroute (0x7ff6d0f645e0)
State: Started
Number of router sessions: 0
Current no. of router sessions: 0
Number of queries forwarded: 0
Started: Tue Jun 2 21:59:56 2015
Root user access: Disabled
Filter chain: QLA
Backend databases
192.168.122.107:3306 Protocol: MySQLBackend
192.168.122.106:3306 Protocol: MySQLBackend
Users data: 0x30ff7a0
Total connections: 1
Currently connected: 1
Service 0x30e8af0
Service: Read Connection Router Master
Router: readconnroute (0x7ff6d0f645e0)
State: Started
Number of router sessions: 120
Current no. of router sessions: 0
Number of queries forwarded: 120
Started: Tue Jun 2 21:59:56 2015
Root user access: Disabled
Filter chain: QLA
Backend databases
192.168.122.107:3306 Protocol: MySQLBackend
192.168.122.106:3306 Protocol: MySQLBackend
Users data: 0x30ffd60
Total connections: 121
Currently connected: 1
Service 0x30e8280
Service: Debug Interface
Router: debugcli (0x7ff6d118d6e0)
State: Started
Started: Tue Jun 2 21:59:56 2015
Root user access: Disabled
Backend databases
Users data: 0x3105200
Total connections: 1
Currently connected: 1
Service 0x30e79f0
Service: CLI
Router: cli (0x7ff6d13b9c00)
State: Started
Started: Tue Jun 2 21:59:56 2015
Root user access: Disabled
Backend databases
Users data: 0x3103b00
Total connections: 9
Currently connected: 2
MaxScale>
|