mysql-operator icon indicating copy to clipboard operation
mysql-operator copied to clipboard

mysql TCP long connect not broken

Open xiaozhuang-a opened this issue 2 years ago • 3 comments

after orchestrator switch,mysql master ‘s service connect should hava a change,but old master not dead and old long connect to old master not broken。 this problem hava cause problems。 that connection before switching still hava a write in,so hava a error about “mysql is Read-only,cat's ****”. new conncetion is good。 this is a bug,need to take,please give me an answer

xiaozhuang-a avatar May 09 '22 06:05 xiaozhuang-a

This is not operator bug.

kubernetes/kubernetes#100698 kubernetes/kubernetes#108523

w33dw0r7d avatar Aug 27 '22 21:08 w33dw0r7d

This problem can be solved with orchestrator hooks. You can use PostGracefulTakeoverProcesses to reset all connections on old master via script.

w33dw0r7d avatar Aug 27 '22 21:08 w33dw0r7d

yes,it's kubernetes ’s problem,I'm already aware of it。thanks

xiaozhuang-a avatar Aug 28 '22 13:08 xiaozhuang-a