From: | Rambabu V <ram(dot)wissen(at)gmail(dot)com> |
---|---|
To: | kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com> |
Cc: | Karthik Yellapragada <karthik(dot)yellapragada(at)gmail(dot)com>, Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Need inputs on postgresql HA with consul cluster |
Date: | 2023-12-21 01:49:36 |
Message-ID: | CADtiZxr1KFVG-fR-wwL5iF2dFuR3sQksmQciVxBX2-r9_LVmpA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>>>>
>>>
From | Date | Subject | |
---|---|---|---|
Next Message | jacob ndinkwa | 2023-12-21 13:29:07 | LDAP (AD) Configuration |
Previous Message | kaido vaikla | 2023-12-20 18:30:02 | Re: Need inputs on postgresql HA with consul cluster |