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 <arvidj...@gmail.com> wrote: > >> On Wed, Jun 8, 2022 at 4:01 PM Sridhar K <sri...@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/ _______________________________________________ Manage your subscription: https://lists.clusterlabs.org/mailman/listinfo/users ClusterLabs home: https://www.clusterlabs.org/