I did not change anything on that file until today when I modified that driver and all was fine after - so following that documentation for multiple management servers deployment results in fail if we leave it with the defaults. So I don't have an issue anymore, the HA is handled by galera for the DB and by a load balancer for the management server instance. It works fine.
-----Original Message----- From: Wei ZHOU <ustcweiz...@gmail.com> Sent: Thursday, May 30, 2024 1:12 PM To: users@cloudstack.apache.org Subject: Re: HA for management server I thought you did not change the db.properties. if you use mariadb driver, you can use "db.cloud.uri". the failover mode is not supported in db.properties, which could be the root cause of your issue https://mariadb.com/kb/en/failover-and-high-availability-with-mariadb-connector-j/ -Wei On Thu, May 30, 2024 at 11:48 AM Alexandru Stan <alexandru.s...@lifeincloud.com.invalid> wrote: > > Hello, > > I actually managed to get it to work just by modifying the db.cloud.driver in > db.properties on the management servers to jdbc:mariadb instead of the > default jdbc:mysql. Maybe I didn't search properly but I really think this is > not mentioned in any documentation of multi-management servers deployment. > Anyway, all good now. > > Thank you! > > > > -----Original Message----- > From: Wei ZHOU <ustcweiz...@gmail.com> > Sent: Wednesday, May 29, 2024 11:29 PM > To: users@cloudstack.apache.org > Subject: Re: HA for management server > > Looks good > Can you try db.cloud.uri in db.properties? > See https://github.com/apache/cloudstack/pull/7895 > > -Wei > > > On Wednesday, May 29, 2024, Alexandru Stan > <alexandru.s...@lifeincloud.com.invalid> wrote: > > > Yes. On the first management server with --deploy-as=root:password > > and on the second one without. All successful. The I ran > > cloudstack-setup-management and that was it. But in the browser I > > get the > > 503 error... > > > > > > -----Original Message----- > > From: Wei ZHOU <ustcweiz...@gmail.com> > > Sent: Wednesday, May 29, 2024 11:20 PM > > To: users@cloudstack.apache.org > > Subject: Re: HA for management server > > > > Have you setup the database by cloudstack-setup-database? > > > > > > > > On Wednesday, May 29, 2024, Alexandru Stan > > <alexandru.s...@lifeincloud.com.invalid> > > wrote: > > > > > Yes, I can login with the cloud user just fine via the virtual ip. > > > > > > > > > -----Original Message----- > > > From: Wei ZHOU <ustcweiz...@gmail.com> > > > Sent: Wednesday, May 29, 2024 10:45 PM > > > To: users@cloudstack.apache.org > > > Subject: Re: HA for management server > > > > > > Yes. > > > Are you able to access the db vip or the two db nodes using mysql > > > command from management server? > > > > > > > > > > > > On Wednesday, May 29, 2024, Alexandru Stan > > > <alexandru.s...@lifeincloud.com.invalid> > > > wrote: > > > > > > > You're right. This is the actual problem: > > > > > > > > Caused by: com.cloud.utils.exception.CloudRuntimeException: > > > > Unable to initialize a connection to the database for locking > > > > purposes Caused > > > > by: java.sql.SQLNonTransientConnectionException: Could not > > > > create connection to database server. Attempted reconnect 3 times. > > > > Giving up. > > > > > > > > But everything seems right in the db.properties file. The host > > > > should be the virtual ip of the load balancer, right? > > > > > > > > > > > > -----Original Message----- > > > > From: Wei ZHOU <ustcweiz...@gmail.com> > > > > Sent: Wednesday, May 29, 2024 10:28 PM > > > > To: users@cloudstack.apache.org > > > > Subject: Re: HA for management server > > > > > > > > Hi, > > > > > > > > The exception is misleading > > > > > > > > You can check the real exception by grep Exception > > > > management-server.log | grep -v NoSuchBeanDefinitionException > > > > > > > > I guess the root cause is database configuration or db.properties. > > > > > > > > By the way, it is better mariadb galera cluster have 3 servers. > > > > > > > > > > > > -Wei > > > > > > > > > > > > On Wednesday, May 29, 2024, Alexandru Stan > > > > <alexandru.s...@lifeincloud.com.invalid> > > > > wrote: > > > > > > > > > Hello, > > > > > > > > > > There seems to be issues with installing the management server > > > > > databases on a separate server, I setup a galera cluster with > > > > > 2 servers and tried to install the management server on a > > > > > different server using (where it still > > > > > applies) this guide: https://www.shapeblue.com/how- > > > > > to-deploy-high-availability-cloudstack-with-mariadb-galera-clu > > > > > st > > > > > er > > > > > / > > > > > > > > > > However, while the database setup seems to be fine and > > > > > everything after, the cloudstack-management service is running > > > > > but there's no > > UI. > > > > > Checking the status shows this: > > > > > > > > > > Failed to start module [redfish] due to: [Error creating bean > > > > > with name 'org.springframework.beans.factory.config. > > > > PropertyPlaceholderConfigurer#0' > > > > > defined in URL [jar:file:/usr/share/cloudstack-management/lib/ > > > > > cloudstack-4.19.0.1.jar!/META-INF/cloudstack/bootstrap/ > > > > > spring-bootstrap-context-inheritable.xml]: Cannot resolve > > > > > reference to bean 'DefaultConfigResources' while setting bean > > > > > property 'locations'; nested exception is org.springframework.beans. > > factory. > > > > NoSuchBeanDefinitionException: > > > > > No bean named 'DefaultConfigResources' available]. > > > > > > > > > > Any idea why this happens? > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Jayanth Babu A <jayanth.b...@nxtgen.com.INVALID> > > > > > Sent: Monday, May 27, 2024 12:28 PM > > > > > To: users@cloudstack.apache.org > > > > > Subject: Re: HA for management server > > > > > > > > > > Hello, > > > > > Yes, DB clustering with Galera or some other sort should be > > > > > looked > > > into. > > > > > I'm not sure if [1] has worked for someone so far. > > > > > > > > > > [1] https://docs.cloudstack.apache.org/en/latest/ > > > > > adminguide/reliability.html#configuring-database-high-availabi > > > > > li > > > > > ty > > > > > > > > > > Thanks, > > > > > Jayanth > > > > > ________________________________ > > > > > From: Alexandru Stan <alexandru.s...@lifeincloud.com.INVALID> > > > > > Sent: Monday, May 27, 2024 2:48 PM > > > > > To: users@cloudstack.apache.org <users@cloudstack.apache.org> > > > > > Subject: RE: HA for management server > > > > > > > > > > Hi, > > > > > > > > > > Actually no, I'm just documenting the process so far, so > > > > > nothing was done for the DB. For this I assume the info in the > > > > > official documentation would be ok? Or something more advanced > > > > > would be needed, > > > > like a galera cluster? > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Jayanth Babu A <jayanth.b...@nxtgen.com.INVALID> > > > > > Sent: Monday, May 27, 2024 12:12 PM > > > > > To: users@cloudstack.apache.org > > > > > Subject: Re: HA for management server > > > > > > > > > > Hello Alexandru, > > > > > Please see [1] and [2]. I assume your DB HA is taken care of. > > > > > > > > > > [1] https://checkpoint.url-protection.com/v1/url?o=https% > > > > > 3A//docs.cloudstack.apache.org/en/latest/adminguide/reliability. > > > > > ht ml &g = > > > > > ZmEwYjAwNmYwMjIxNTU5ZQ==&h=NmQyMzY5Nzc5YTU2ZDkyYjc4N2ExND > > > > > U4Y2Q0OWFkMjQ4OGRhMGZiZjdiNDA5N2NmNmRhM2EwYjUzZGEwMmI2Mg==&p= > > > > > Y3AxZTpueHRnZW5pbmZpbml0ZWRhdGFjZW50ZXI6YzpvOmY0ZWFkYmU5NDkz > > > > > MjMyMjdjY2EyM2IxN2YzOGZiMWE4OnYxOnA6VA== > > > > > [2] https://checkpoint.url-protection.com/v1/url?o=https% > > > > > 3A//github.com/apache/cloudstack/issues/8221&g=YzVlNDk3YjI5NTE > > > > > wM > > > > > TM > > > > > 5M > > > > > g= > > > > > =&h= > > > > > OTBmN2Q4ZjA3YzRlOTAxZDk1YzcwMmExMTAzYTY4N2VmYjg5MGZkZGQyMDE2 > > > > > NTM3MTU4MGUxNDRjNzMzN2E0ZQ==&p=Y3AxZTpueHRnZW5pbmZpbml0ZWRhdG > > > > > FjZW50ZXI6YzpvOmY0ZWFkYmU5NDkzMjMyMjdjY2EyM2IxN2YzOGZiMWE4OnYx > > > > > On > > > > > A6 > > > > > VA > > > > > == > > > > > > > > > > Regards, > > > > > Jayanth Reddy > > > > > Engineering Manager > > > > > > > > > > From: Alexandru Stan <alexandru.s...@lifeincloud.com.INVALID> > > > > > Date: Monday, 27 May 2024 at 2:38 PM > > > > > To: users@cloudstack.apache.org <users@cloudstack.apache.org> > > > > > Subject: HA for management server Hello, > > > > > > > > > > Is there any documentation on deployment of multiple > > > > > management servers in high availability? Or does anyone have good > > > > > info on this? > > > > > The official documentation does not contain anything relevant > > > > unfortunately. > > > > > > > > > > Thank you! > > > > > Disclaimer *** This e-mail contains PRIVILEGED AND > > > > > CONFIDENTIAL INFORMATION intended solely for the use of the > > > > > addressee(s). If you are not the intended recipient, please > > > > > notify the sender by e-mail and delete the original message. > > > > > Further, you are not authorised to copy, disclose, or > > > > > distribute this e-mail or its contents to any other person and > > > > > any such actions are unlawful and strictly prohibited. This > > > > > e-mail may contain viruses. NxtGen Datacenter & Cloud > > > > > Technologies Private Ltd (“NxtGen”) has taken every reasonable > > > > > precaution to minimize this risk but is not liable for any > > > > > damage you may sustain as a result of any virus in this > > > > > e-mail. You should carry out your own virus checks before > > > > > opening the e-mail or attachment. NxtGen reserves the right to > > > > > monitor and review the content of all messages sent to or from > > > > > this > > e-mail address. > > > > > Messages sent to or from this e-mail address may be stored on > > > > > the NxtGen e-mail system. *** End of Disclaimer > > > > > ***NXTGEN*** Disclaimer *** This e-mail contains PRIVILEGED > > > > > AND > > > > CONFIDENTIAL INFORMATION intended solely for the use of the > > addressee(s). > > > > > If you are not the intended recipient, please notify the > > > > > sender by e-mail and delete the original message. Further, you > > > > > are not authorised to copy, disclose, or distribute this > > > > > e-mail or its contents to any other person and any such > > > > > actions are unlawful and strictly prohibited. This e-mail may > > > > > contain viruses. NxtGen Datacenter & Cloud Technologies > > > > > Private Ltd > > > > > (“NxtGen”) has taken every reasonable precaution to minimize > > > > > this risk but is not liable for any damage you may sustain as > > > > > a result of any virus in this e-mail. You should carry out > > > > > your own virus checks before opening the e-mail or attachment. > > > > > NxtGen reserves the right to monitor and review the content of > > > > > all messages sent to or from this e-mail address. Messages > > > > > sent to or from this e-mail address may be > > > > stored on the NxtGen e-mail system. > > > > > *** End of Disclaimer ***NXTGEN*** > > > > > > > > > > > > > >
