GitHub user weizhouapache added a comment to the discussion: DB connection is interrupted with multiple management servers
> > I tested mariadb for pr #9941 on rocky8/9, it worked fine. However the pr > > is targeted to 4.19 so it does not use hikaricp, I will test with > > 4.20-snapshot. > > Based on your suspicion, can you change some settings in db.properties to > > dbcp2, then restart management server ? > > db.cloud.connectionPoolLib db.cloud_usage.connectionPoolLib > > db.simulator.connectionPoolLib > > Refer to > > https://docs.cloudstack.apache.org/en/4.20.0.0/adminguide/tuning.html#selecting-database-connection-pool-library > > Hi @weizhouapache , thanks for your contribution. > > Perfect, I will test the configuration with dbcp2, I will get back to you > with the result soon I run smoke tests with two OL8 management server, two OL8 hosts and mariadb server 11.7 (not mariadb galera cluster). ``` [root@pr10006-t12509-kvm-ol8-mgmt1 ~]# mysql -uroot -p cloud mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 4374 Server version: 11.7.2-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [cloud]> ``` it uses default hikaricp library. The test results look good https://github.com/apache/cloudstack/pull/10006#issuecomment-2691067265 GitHub link: https://github.com/apache/cloudstack/discussions/10471#discussioncomment-12354011 ---- This is an automatically sent email for users@cloudstack.apache.org. To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
