Re: Need inputs on postgresql HA with consul cluster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Attachment for the same.

On Sat, Dec 23, 2023, 14:11 Rambabu V <ram.wissen@xxxxxxxxx> 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.wissen@xxxxxxxxx> wrote:
thanks Kaido, applied to the above option. getting good result. 

On Thu, Dec 21, 2023 at 2:30 AM kaido vaikla <kaido.vaikla@xxxxxxxxx> wrote:

On Wed, 20 Dec 2023 at 19:42, kaido vaikla <kaido.vaikla@xxxxxxxxx> 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.wissen@xxxxxxxxx> 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.yellapragada@xxxxxxxxx> wrote:
May be you can pg auto failover..

On Tue, Dec 19, 2023 at 9:33 AM Rambabu V <ram.wissen@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> wrote:
> On Dec 19, 2023, at 7:12 AM, Rambabu V <ram.wissen@xxxxxxxxx> 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

Attachment: IMG_20231223_141258.jpg
Description: JPEG image


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux