good to know it. Thanks for sharing. It is better to update the cloudstack document.
-Wei On Thu, May 30, 2024 at 1:22 PM Alexandru Stan <alexandru.s...@lifeincloud.com.invalid> wrote: > > 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*** > > > > > > > > > > > > > > > > > >