Re: Database High Availability

2022-05-03 Thread Jayanth Reddy
Sure, thanks a lot! On Tue, May 3, 2022 at 12:53 PM Ivan Kudryavtsev wrote: > Well, > > You would better consult with real-life mysql experts, as for me, I > referred to great severalnines.com articles like: > > https://severalnines.com/resources/database-management-tutorials/galera-cluster-mysq

Re: Database High Availability

2022-05-03 Thread Ivan Kudryavtsev
Well, You would better consult with real-life mysql experts, as for me, I referred to great severalnines.com articles like: https://severalnines.com/resources/database-management-tutorials/galera-cluster-mysql-tutorial https://severalnines.com/database-blog/avoiding-deadlocks-galera-setting-haprox

Re: Database High Availability

2022-05-03 Thread Jayanth Reddy
Hi, Thanks again for the tips! Below is the current configuration, please suggest changes if any. HAProxy frontend galera-fe mode tcp bind 10.231.4.112:3306 use_backend galera-be backend galera-be balance source mode tcp option tcpka

Re: Database High Availability

2022-05-03 Thread Ivan Kudryavtsev
Sounds cool, Just ensure that in any failure case (db, haproxy, OS or hardware crash) all the Management servers are switched to the same Galera instance, otherwise, this could lead to operational problems. Also, backups are still mandatory, recommend doing them from one of Galera's hot-swap nodes

Re: Database High Availability

2022-05-02 Thread Jayanth Reddy
Hi, Thank you. Have set up MariaDB Galera Cluster with the required HAProxy configuration with MYSQL health checks. Everything is working fine. On Mon, May 2, 2022 at 10:48 AM Ivan Kudryavtsev wrote: > Hi, I use MariaDB Galera cluster. > > But you have to pin all the CS management to the s

Re: Database High Availability

2022-05-01 Thread Ivan Kudryavtsev
Hi, I use MariaDB Galera cluster. But you have to pin all the CS management to the same galera node to make cloudstack transactioned operations work correctly. HAproxy or shared common ip solve that. пн, 2 мая 2022 г., 7:34 AM Jayanth Reddy : > Hello guys, > > How are you doing database High

Re: database high availability question vs haproxy

2015-06-05 Thread Andrija Panic
#x27;s not likely to > happen often at all. > > - Si > > From: Andrija Panic > Sent: Friday, June 5, 2015 9:07 AM > To: users@cloudstack.apache.org > Cc: d...@cloudstack.apache.org > Subject: Re: database high availability question vs haproxy > >

Re: database high availability question vs haproxy

2015-06-05 Thread Simon Weller
5, 2015 9:07 AM To: users@cloudstack.apache.org Cc: d...@cloudstack.apache.org Subject: Re: database high availability question vs haproxy Exactly...thanks Simon for the time and help :) Is there any mysql timeout/retry parameter that is set in db.properties (like db.cloud.queriesBeforeRetryMaster

Re: database high availability question vs haproxy

2015-06-05 Thread Andrija Panic
over complicating it with the CS Management > configuration. > > - Si > > > From: Andrija Panic > Sent: Friday, June 5, 2015 8:37 AM > To: users@cloudstack.apache.org > Cc: d...@cloudstack.apache.org > Subject: Re: database high av

Re: database high availability question vs haproxy

2015-06-05 Thread Simon Weller
Management configuration. - Si From: Andrija Panic Sent: Friday, June 5, 2015 8:37 AM To: users@cloudstack.apache.org Cc: d...@cloudstack.apache.org Subject: Re: database high availability question vs haproxy Thanks Simon - that is what I thought... So m

Re: database high availability question vs haproxy

2015-06-05 Thread Andrija Panic
e native > MySQL cluster, it's expected that you are setup for cross master-master > replication. > > - Si > > From: Andrija Panic > Sent: Friday, June 5, 2015 2:41 AM > To: d...@cloudstack.apache.org > Cc: users@cloudstack.apa

Re: database high availability question vs haproxy

2015-06-05 Thread Simon Weller
for cross master-master replication. - Si From: Andrija Panic Sent: Friday, June 5, 2015 2:41 AM To: d...@cloudstack.apache.org Cc: users@cloudstack.apache.org Subject: Re: database high availability question vs haproxy Hi Simon, thanks for the link

Re: database high availability question vs haproxy

2015-06-05 Thread Andrija Panic
around to > it yet. > > - Si > > > From: Andrija Panic > Sent: Thursday, June 4, 2015 9:08 AM > To: d...@cloudstack.apache.org; users@cloudstack.apache.org > Subject: Re: database high availability question vs haproxy > >

Re: database high availability question vs haproxy

2015-06-04 Thread Simon Weller
- Si From: Andrija Panic Sent: Thursday, June 4, 2015 9:08 AM To: d...@cloudstack.apache.org; users@cloudstack.apache.org Subject: Re: database high availability question vs haproxy Anyone :) ? On 31 May 2015 at 00:26, Andrija Panic wrote: > Hi, > > I would h

Re: database high availability question vs haproxy

2015-06-04 Thread Andrija Panic
Anyone :) ? On 31 May 2015 at 00:26, Andrija Panic wrote: > Hi, > > I would have a question on database HA feature in db.properties ( > http://cloudstack-administration.readthedocs.org/en/latest/reliability.html#configuring-database-high-availability > ) > > If I understand correctly, it is up t