GitHub user weizhouapache added a comment to the discussion: DB connection is 
interrupted with multiple management servers

thanks @Luskan777 for the sharing

In my opinion, you can use mariadb galera cluster without haproxy
you can test with the following config in db.properties

`
db.cloud.uri=jdbc:mariadb:sequential://xx.xx.xx.1:3306,xx.xx.xx.2:3306,xx.xx.xx.3:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC
`



GitHub link: 
https://github.com/apache/cloudstack/discussions/10471#discussioncomment-12377352

----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org

Reply via email to