pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres HA using Shared Disk Solution
3+ messages / 3 participants
[nested] [flat]
* Postgres HA using Shared Disk Solution
@ 2017-08-04 08:00 Purav Chovatia <puravc@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Purav Chovatia @ 2017-08-04 08:00 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres HA using Shared Disk Solution
@ 2017-08-04 09:54 Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
parent: Purav Chovatia <puravc@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jehan-Guillaume (ioguix) de Rorthais @ 2017-08-04 09:54 UTC (permalink / raw)
To: Purav Chovatia <puravc@gmail.com>; +Cc: pgsql-admin
On Fri, 4 Aug 2017 13:30:24 +0530
Purav Chovatia <puravc@gmail.com> wrote:
> 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.
Shared disk is totally fine. It just requires a warm node useless for
day-to-day usage compare to HA on a streaming replication architecture where
the standby can be involved as a RO node.
Just make sure that:
* your SAN does not allow more than one server at a time to access the data
* you are able to fence the other node or its access to the disk
* extensive failover scenarios has been tested
* all required documentation has been written on your side to manage the cluster
As a bonus, make sure to use Pacemaker, with a recent distro (RHEL 7, CentOS 7,
Debian 9).
Regards,
--
Jehan-Guillaume de Rorthais
Dalibo
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres HA using Shared Disk Solution
@ 2017-08-04 10:03 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Purav Chovatia <puravc@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2017-08-04 10:03 UTC (permalink / raw)
To: 'Purav Chovatia *EXTERN*' <puravc@gmail.com>; pgsql-admin
Purav Chovatia wrote:
> 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.
This is just my opinion, but I'd say that shared storage cluster solutions
have fallen from favor with the advent of streaming replication.
The less you share between cluster nodes, the fewer single points of failure you have.
I personally have seen a shared storage cluster fail because a hardware
problem caused the file system to get corrupted, and the file system
is a single point of failure with all shared storage solutions.
But yes, you'd have to double the storage.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2017-08-04 10:03 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-08-04 08:00 Postgres HA using Shared Disk Solution Purav Chovatia <puravc@gmail.com>
2017-08-04 09:54 ` Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
2017-08-04 10:03 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox