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 <[email protected]> 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 <[email protected]> > Sent: Wednesday, May 29, 2024 11:29 PM > To: [email protected] > 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 > <[email protected]> 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 <[email protected]> > > Sent: Wednesday, May 29, 2024 11:20 PM > > To: [email protected] > > Subject: Re: HA for management server > > > > Have you setup the database by cloudstack-setup-database? > > > > > > > > On Wednesday, May 29, 2024, Alexandru Stan > > <[email protected]> > > wrote: > > > > > Yes, I can login with the cloud user just fine via the virtual ip. > > > > > > > > > -----Original Message----- > > > From: Wei ZHOU <[email protected]> > > > Sent: Wednesday, May 29, 2024 10:45 PM > > > To: [email protected] > > > 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 > > > <[email protected]> > > > 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 <[email protected]> > > > > Sent: Wednesday, May 29, 2024 10:28 PM > > > > To: [email protected] > > > > 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 > > > > <[email protected]> > > > > 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-clust > > > > > 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 <[email protected]> > > > > > Sent: Monday, May 27, 2024 12:28 PM > > > > > To: [email protected] > > > > > 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-availabili > > > > > ty > > > > > > > > > > Thanks, > > > > > Jayanth > > > > > ________________________________ > > > > > From: Alexandru Stan <[email protected]> > > > > > Sent: Monday, May 27, 2024 2:48 PM > > > > > To: [email protected] <[email protected]> > > > > > 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 <[email protected]> > > > > > Sent: Monday, May 27, 2024 12:12 PM > > > > > To: [email protected] > > > > > 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=YzVlNDk3YjI5NTEwM > > > > > TM > > > > > 5M > > > > > g= > > > > > =&h= > > > > > OTBmN2Q4ZjA3YzRlOTAxZDk1YzcwMmExMTAzYTY4N2VmYjg5MGZkZGQyMDE2 > > > > > NTM3MTU4MGUxNDRjNzMzN2E0ZQ==&p=Y3AxZTpueHRnZW5pbmZpbml0ZWRhdG > > > > > FjZW50ZXI6YzpvOmY0ZWFkYmU5NDkzMjMyMjdjY2EyM2IxN2YzOGZiMWE4OnYxOn > > > > > A6 > > > > > VA > > > > > == > > > > > > > > > > Regards, > > > > > Jayanth Reddy > > > > > Engineering Manager > > > > > > > > > > From: Alexandru Stan <[email protected]> > > > > > Date: Monday, 27 May 2024 at 2:38 PM > > > > > To: [email protected] <[email protected]> > > > > > 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*** > > > > > > > > > > > > > >
