replication-manager
replication-manager copied to clipboard
When the slave sets maintenance, there is a problem with the status change of proxysql.
This is the state when repman parameters, repman and proxysql are first start:
## repman parameter
proxy-servers-read-on-master = false
proxy-servers-read-on-master-no-slave = true
I set 172.24.44.182 as maintenance, the status of repman and proxysql is as follows:
Then set 172.24.47.188 as maintenance, the status of repman and proxysql is as follows:
Now set 172.24.47.188 as online, the status of repman and proxysql is as follows:
then set 172.24.43.182 as online, the status of repman and proxysql is as follows:
proxy-servers-read-on-master-no-slave seems to have no effect, but proxysql status is normal
Now I trigger the switchover, the status of repman and proxysql is as follows:
I set 172.24.43.182 as maintenance, the status of repman and proxysql is as follows:
Then set 172.24.47.188 maintenance, the status of repman and proxysql is as follows:
You can see that 172.24.43.182 is online in the proxysql status!
Now I restore the status to after switchover:
I set 172.24.47.188 as maintenance, the status of repman and proxysql is as follows:
Then set 172.24.43.183 as maintenance, the status of repman and proxysql is as follows:
At this time, proxysql status is still normal.
Now set 172.24.47.188 as online, the status of repman and proxysql is as follows:
You can see that 172.24.43.182 is online in the proxysql status!
I tried setting proxysql-bootstrap=true
,
It just allows proxy-servers-read-on-master-no-slave
to work,
However, the status of proxysql will still be the same as the above test. Can this problem be fixed?