[ClusterLabs] Required guidance w.r.t pacemaker

[Sridhar K]

Thank you Andrei, for the response

All the databases(1 primary, other will be replica) will be part of
SqlServer Availability group which will have an Availability  listener IP ,
this IP will be the Virtual IP resource added in PCS , which clients connect

When PCS or DB container in VM1 dies . the Virtual IP will route traffic to
AG listener and PCS should ideally promote replica to act as primary. (this
will handle by the sql ha resource agent)

Screen Shot : Able to setup HA when both PCS and sqlserver are in same
container.

PCS cluster process with sqlserver process in a docker container.
the cluster is made of two docker containers

Not getting how to make HA working when PCS and sqlserver are running as
different containers

Regards
Sridharan












On Wed, 8 Jun 2022 at 18:52, Andrei Borzenkov <arvidjaar at gmail.com> wrote:

> On Wed, Jun 8, 2022 at 4:01 PM Sridhar K <sriatk at gmail.com> wrote:
> >
> > Hi Team,
> >
> > Required guidance w.r.t below problem statement
> >
> > Need to have a HA setup for SQLServer running as a docker container and
> HA managed by the Pacemaker which is running as a separate docker container.
> >
>
> It is very unlikely to be useful in a production environment (see
> below). What is your actual use case?
>
> > I have done a setup where pacemaker and SQL Server are running as a
> single docker container, able to achieve HA.
> >
> > How to achieve the same when Pacemaker , and Sqlserver are running in
> different containers.
> >
> > Checked remote node,bundle  concepts in Pacemaker unable to make HA
> setup work.
> >
>
> "Unable to make it work" does not provide much information about what
> you did and what problem you encountered. But at the very least,
> pacemaker needs to control docker to manage containers. And docker
> does not run inside of containers, does it? So how is the pacemaker in
> the PCS container supposed to access docker that runs on host?
>
> Remote node should work as long as connectivity between containers is
> available.
>
> > Please let me know whether the above scenario can be handled, any links,
> examples would be of great help.
> >
> > Attaching a picture that depicts the scenario.
> >
>
> The PCS container on VM1 dies. How exactly are you going to ensure
> that the DB container on VM1 is stopped so that DB on VM2 can take
> over?
>
> > Please do the needful, Thank you
> >
> > Regards
> > Sridhar
> > _______________________________________________
> > Manage your subscription:
> > https://lists.clusterlabs.org/mailman/listinfo/users
> >
> > ClusterLabs home: https://www.clusterlabs.org/
> _______________________________________________
> Manage your subscription:
> https://lists.clusterlabs.org/mailman/listinfo/users
>
> ClusterLabs home: https://www.clusterlabs.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20220608/0799d74c/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PCS_Sql_samecontainer.jpg
Type: image/jpeg
Size: 251783 bytes
Desc: not available
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20220608/0799d74c/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PCS_Cluster.jpg
Type: image/jpeg
Size: 275470 bytes
Desc: not available
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20220608/0799d74c/attachment-0003.jpg>