replication-manager icon indicating copy to clipboard operation
replication-manager copied to clipboard

When the slave sets maintenance, there is a problem with the status change of proxysql.

Open peterpan104 opened this issue 7 months ago • 9 comments

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

image image

I set 172.24.44.182 as maintenance, the status of repman and proxysql is as follows:

image image

Then set 172.24.47.188 as maintenance, the status of repman and proxysql is as follows:

image image

Now set 172.24.47.188 as online, the status of repman and proxysql is as follows:

image image

then set 172.24.43.182 as online, the status of repman and proxysql is as follows:

image image

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:

image image

I set 172.24.43.182 as maintenance, the status of repman and proxysql is as follows:

image image

Then set 172.24.47.188 maintenance, the status of repman and proxysql is as follows:

image image

You can see that 172.24.43.182 is online in the proxysql status!

Now I restore the status to after switchover:

image image

I set 172.24.47.188 as maintenance, the status of repman and proxysql is as follows:

image image

Then set 172.24.43.183 as maintenance, the status of repman and proxysql is as follows:

image image

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:

image image

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?

peterpan104 avatar Jul 22 '24 09:07 peterpan104