GitHub user Luskan777 added a comment to the discussion: DB connection is
interrupted with multiple management servers
@weizhouapache and @DaanHoogland , it seems that the problem is in my HAproxy
configuration. Since it is a MariaDB Galera, I use HAproxy to do load balancing
between the database servers, which is common when using MariaDB Galera. It
seems that HAproxy was closing the connections unexpectedly, which is why the
MariaDB logs recorded the error (Got an error reading communication packets).
So, to solve the problem, I changed some HAproxy configuration parameters, such
as maxconn and timeout.
In case someone else has the same problem one day, I will leave my current
HAproxy configuration below.
```
global
log /dev/log local0
daemon
defaults
log global
mode tcp
timeout client 1h
timeout server 1h
timeout connect 10s
frontend mysql_front
bind *:33306
mode tcp
default_backend mysql_backend
backend mysql_backend
mode tcp
balance source
option tcp-check
timeout client 1h
timeout server 1h
timeout connect 10s
server db1 192.168.77.10:3306 check
server db2 192.168.77.11:3306 check
server db3 192.168.77.12:3306 check backup
server db4 192.168.77.13:3306 check backup
```
Anyway, even though the problem is not with Cloudstack, but with HAproxy +
MariaDB Galera, I hope I have helped in some way.
Thank you for your time @weizhouapache and @DaanHoogland
GitHub link:
https://github.com/apache/cloudstack/discussions/10471#discussioncomment-12375947
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
