If I run galera without haproxy and point everything to 1 server, it seems to work fine, but we want to load-balance it with haproxy. After setting up haproxy we had lots of errors in nova, neutron and keystone, but I got rid of those by setting haproxy timeout values to 10 minutes. The remaining errors are in keystone. In /var/log/keystone/keystone-wsgi-public.log I see “Loaded 2 Fernet keys” every 5 minutes and this is frequently accompanied by a mysql error 'Lost connection to MySQL server during query'

I tried changing various config items in haproxy, galera and keystone, but nothing seems to help. How can I fix these errors?

Errors:

https://f.perl.bot/p/pbq26k

https://f.perl.bot/p/1tnh78

https://f.perl.bot/p/fuxmwo

Haproxy config:

https://f.perl.bot/p/gu2lil

Mysql timeout values:

https://f.perl.bot/p/i6l7tn

Keystone config (minus commented lines):

https://f.perl.bot/p/o6fdht