Postgres HA using Shared Disk Solution

From: Purav Chovatia <puravc(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres HA using Shared Disk Solution
Date: 2017-08-04 08:00:24
Message-ID: CADrzpjFdmN=mV9hp5BkkRD9CiHpZYPsYYg3-xey8y0BLGLcF-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello All,

I have been researching for possible HA solutions for postgres. I find
shared disk solution (either using Linux-HA or RHCS) to be a very good
solution. Especially for us, because our databases are big and they do a
lot of IO so we deploy a lot of disks.

However, research on the internet shows that a shared disk solution is not
very commonly deployed when it comes to postgres. People mostly go for
Streaming Replication/Warm/Hot-Standby which to me are more like DR
solutions.

Is my research correct or that is not so? for e.g. this was the only post
that I came across, and that too as old as 2012:
https://www.postgresql.org/message-id/4F68E989.7080101%40d2.com

Given our IO requirement, if we go for Streaming Replication instead, then
our storage needs double and that increases the cost.

Can someone confirm, if shared disk clustering is fairly common or no in
the postgres world? If no, why is it so - can somebody enlighten me pls.

Many Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jehan-Guillaume (ioguix) de Rorthais 2017-08-04 09:54:08 Re: Postgres HA using Shared Disk Solution
Previous Message Tom Lane 2017-08-03 22:04:58 Re: rfc: DROP column and replication impact