Comment 1 for bug 1796930

Interesting idea with that ProxySQL.

We actually do more than just bare mysql-check - the user being used is dynamically enabled/disabled when node state changes via wsrep-notify.sh. Though it is broken in that the initial JOINER transition does not allow to connect to local mariadb so we usually never disable haproxy user when need be. I guess someone tested it only on a working cluster and not on boot. Race conditions were not considered either.

That said we might go either the other check method or even ProxySQL. I would be glad to move mysql away from haproxy because I suspect it to be causing issues with haproxy reporting to keepalived (which also has a nasty bug which gives extra issues all over the board due to VIP moving).