Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

i managed to bypass that error by increasing wait_timeout from default 600 to 28800 and connect_timeout from 5 to 20 in mysql config. I am not getting any errors since!

Also i dropped haproxy for galera since it doesnt load balance anything in activa/backup/backup. I instead use keepalive VIP on all mysql servers and point all openstack services to that VIP for database section.

The drawback for this is that mysql will keep connections opened for a much longer time! I had no problems untill now but i'm only in half production with the system so not so many queries are made!