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
option mysql-check user haproxy
server galera-0 10.231.4.36:3306 check
server galera-1 10.231.4.37:3306 check
server galera-2 10.231.4.38:3306 check
---- Keepalived ----
vrrp_script check_backend {
script "killall -0 haproxy"
weight -20
interval 2
rise 2
fall 2
}
vrrp_instance DB_0 {
state MASTER # BACKUP on others
priority 100
interface enp1s0
virtual_router_id 50
advert_int 1
unicast_peer {
10.231.4.87 # Relevant on others
10.231.4.88 # Relevant on others
}
virtual_ipaddress {
10.231.4.112/24
}
track_script {
check_backend
}
}
Best Regards,
Jayanth
On Tue, May 3, 2022 at 12:33 PM Ivan Kudryavtsev <i...@bw-sw.com> wrote:
> 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, not from the main operational node.
>
> Best wishes, Ivan
>
> On Tue, May 3, 2022 at 9:53 AM Jayanth Reddy <jayanthreddy5...@gmail.com>
> wrote:
>
> > 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 <i...@bw-sw.com> wrote:
> >
> > > 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 <jayanthreddy5...@gmail.com>:
> > >
> > > > Hello guys,
> > > >
> > > > How are you doing database High Availability? Any inputs on DB
> > > > Clustering and CloudStack configuration would really help me.
> > > >
> > >
> >
>
