[ClusterLabs] Required guidance w.r.t pacemaker

[Sridhar K]

Hi Andrei,

Use case is to have a HA setup for SQL Server with pacemaker. where
pacemaker and sql server are running as different docker containers

regads
Sridharan

On Wed, 8 Jun 2022 at 19:27, Sridhar K <sriatk at gmail.com> wrote:

> 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/80d6135e/attachment.htm>