Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
Hi, using MXS 1.2.1 on Centos 6 64 bits.
I have set-up a simple Master/Slave replication with 3 routers on Maxscale:
1) Master Route
2) Slave Route
3) RW Split
My replication breaks, and I restart maxscale, it doesn't allow anymore connections.
To fix it, I disable the monitor, and set manually the flags on the "healthy" server.
If I give only the "master" flag, all 3 routers works well.
If I also give the "slave" flag, then the readwritesplit doesn't connect anymore.
I think this is a bug, but I leave the last word to you.
Cheers,
Joffrey
Scenario 1 (manually setting the server to "master" only
MaxScale> list servers
|
Servers.
|
-------------------+-----------------+-------+-------------+--------------------
|
Server | Address | Port | Connections | Status
|
-------------------+-----------------+-------+-------------+--------------------
|
vm-xxx-xxx-db-1 | 10.0.51.81 | 3306 | 0 | Running
|
vm-xxx-xxx-db-2 | 10.0.51.82 | 3306 | 0 | Running
|
-------------------+-----------------+-------+-------------+--------------------
|
|
|
MaxScale> shutdown monitor "MySQL Monitor"
|
MaxScale> set server vm-xxx-xxx-db-1 master
|
MaxScale> list servers
|
Servers.
|
-------------------+-----------------+-------+-------------+--------------------
|
Server | Address | Port | Connections | Status
|
-------------------+-----------------+-------+-------------+--------------------
|
vm-xxx-xxx-db-1 | 10.0.51.81 | 3306 | 0 | Master, Running
|
vm-xxx-xxx-db-2 | 10.0.51.82 | 3306 | 0 | Running
|
-------------------+-----------------+-------+-------------+--------------------
|
|
|
Test connectivity (all OK):
|
|
|
# mysql -BN -h10.0.51.83 -udba_user -P33306 -e "select @@hostname,'mastercon'"
|
vm-xxx-xxx-db-1 mastercon
|
|
|
# mysql -BN -h10.0.51.83 -udba_user -P33307 -e "select @@hostname,'slavecon'"
|
vm-xxx-xxx-db-1 slavecon
|
|
|
# mysql -BN -h10.0.51.83 -udba_user -P33308 -e "select @@hostname,'rwsplit'"
|
vm-xxx-xxx-db-1 rwsplit
|
|
|
Scenario 2 (manually setting the server to "master" only
|
|
MaxScale> set server vm-xxx-xxx-db-1 slave
|
MaxScale> list servers
|
Servers.
|
-------------------+-----------------+-------+-------------+--------------------
|
Server | Address | Port | Connections | Status
|
-------------------+-----------------+-------+-------------+--------------------
|
vm-xxx-xxx-db-1 | 10.0.51.81 | 3306 | 0 | Master, Slave, Running
|
vm-xxx-xxx-db-2 | 10.0.51.82 | 3306 | 0 | Running
|
-------------------+-----------------+-------+-------------+--------------------
|
|
|
Test connectivity (NOT ALL OK):
|
|
|
# mysql -BN -h10.0.51.83 -udba_user -P33306 -e "select @@hostname,'mastercon'"
|
vm-xxx-xxx-db-1 mastercon
|
|
|
# mysql -BN -h10.0.51.83 -udba_user -P33307 -e "select @@hostname,'slavecon'"
|
vm-xxx-xxx-db-1 slavecon
|
|
|
# mysql -BN -h10.0.51.83 -udba_user -P33308 -e "select @@hostname,'rwsplit'"
|
(timeout ...)
|
|
|
|
|
|
|
Nothing in the logs....
|
|
|