[ClusterLabs] Required guidance w.r.t pacemaker

[Andrei Borzenkov]

On 08.06.2022 16:57, Sridhar K 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)
> 

pacemaker cannot promote replica until it knows that primary is no more
running.

> 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/
>>
> 
> 
> _______________________________________________
> Manage your subscription:
> https://lists.clusterlabs.org/mailman/listinfo/users
> 
> ClusterLabs home: https://www.clusterlabs.org/