Checking connection status to PXC nodes can stall proxysql_galera_checker script
General
Escalation
General
Escalation
Description
Based on failover tests, when PXC connection tests connect to the MySQL node shutting down, it can cause mysql command to stall:
Because of the stall, it takes 30 seconds to failover to other nodes. I would suggest to add "timeout" to mysql connection to speed up connection check:
With this additional setting, failover time takes 10 seconds.
Based on failover tests, when PXC connection tests connect to the MySQL node shutting down, it can cause mysql command to stall:
Because of the stall, it takes 30 seconds to failover to other nodes. I would suggest to add "timeout" to mysql connection to speed up connection check:
With this additional setting, failover time takes 10 seconds.