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 <sri...@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 <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/