Re: Need inputs on postgresql HA with consul cluster

Attachment for the same.

On Sat, Dec 23, 2023, 14:11 Rambabu V <ram(dot)wissen(at)gmail(dot)com> wrote:

> Hi Kaido,
>
> Using patroni 3+ version, even though enabled failsafe_mide, still if
> consul cluster down, master db going down. Replicas remaining same.
>
> On Thu, Dec 21, 2023, 09:49 Rambabu V <ram(dot)wissen(at)gmail(dot)com> wrote:
>
>> thanks Kaido, applied to the above option. getting good result.
>>
>> On Thu, Dec 21, 2023 at 2:30 AM kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
>> wrote:
>>
>>> @Rambabu
>>> You can try this: DCS Failsafe Mode
>>> https://patroni.readthedocs.io/en/master/dcs_failsafe_mode.html#id2
>>> https://speakerdeck.com/cyberdemn/failsafe-patroni-3-dot-0
>>> br
>>> Kaido
>>>
>>>
>>> On Wed, 20 Dec 2023 at 19:42, kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
>>> wrote:
>>>
>>>> Consul is DCS for patroni. If consul cluster is completely down, then
>>>> patroni is unaware of state of cluster.
>>>> And "In above case if consul down , db master node going down, replica
>>>> nodes remains recovery mode"
>>>> is expected. Actually this behave protects database from split brain
>>>>
>>>> br
>>>> Kaido
>>>>
>>>>
>>>> On Wed, 20 Dec 2023 at 03:52, Rambabu V <ram(dot)wissen(at)gmail(dot)com> wrote:
>>>>
>>>>> Hi Karthik,
>>>>>
>>>>> This is docker based Postgtresql, behavior is different than our
>>>>> normal one for failover and promotion.
>>>>>
>>>>> On Wed, Dec 20, 2023, 03:05 Karthik Yellapragada <
>>>>> karthik(dot)yellapragada(at)gmail(dot)com> wrote:
>>>>>
>>>>>> May be you can pg auto failover..
>>>>>>
>>>>>> On Tue, Dec 19, 2023 at 9:33 AM Rambabu V <ram(dot)wissen(at)gmail(dot)com>
>>>>>> wrote:
>>>>>>
>>>>>>> Thanks, any alternative solution for my requirement .
>>>>>>>
>>>>>>> In above case if consul down , db master node going down, replica
>>>>>>> nodes remains recovery mode.its complete downtime.
>>>>>>>
>>>>>>> On Tue, Dec 19, 2023, 22:23 Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> > On Dec 19, 2023, at 7:12 AM, Rambabu V <ram(dot)wissen(at)gmail(dot)com>
>>>>>>>> wrote:
>>>>>>>> >
>>>>>>>> > Hi Team,
>>>>>>>> >
>>>>>>>> > We have implemented postgresql HA with Patroni + Consul cluster
>>>>>>>> on Docker based PostgreSQL Setup.
>>>>>>>> >
>>>>>>>> > We are seeing the issue below.
>>>>>>>> >
>>>>>>>> > our consul cluster built with 3 nodes, if consul cluster
>>>>>>>> completely down, Patroni triggering failover.
>>>>>>>> > Is there any option to prevent this failure even if the consul
>>>>>>>> cluster is down also?
>>>>>>>> >
>>>>>>>> > and also any effective alternative for HA for docker based
>>>>>>>> PostgreSQL setup?
>>>>>>>>
>>>>>>>> How do you expect to have working HA without working networking?
>>>>>>>>
>>>>>>>> --
>>>>>> Thanks & Regards
>>>>>> Karthik Yellapragada
>>>>>> +1 860 830 5235
>>>>>>
>>>>>