Cluster solution for Postgresql 9.5

From: Poul Kristensen <bcc5226(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Cluster solution for Postgresql 9.5
Date: 2016-10-05 11:56:22
Message-ID: CAAOuvVoosWkuc7tFwJArMhxjwNmfJ5JUmypVQBfFiK6BT72Ngg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi !

According to the documentation a shared disk failover is possible as shown
below.
According to discussions on the Internet it is a problem missing 1-2 seconds
in a failover situation.
Does anyone know of the latest news in this case?

Comparison of Different Solutions
Shared Disk Failover

Shared disk failover avoids synchronization overhead by having only one
copy of the database. It uses a single disk array that is shared by
multiple servers. If the main database server fails, the standby server is
able to mount and start the database as though it were recovering from a
database crash. This allows rapid failover with no data loss.

Shared hardware functionality is common in network storage devices. Using a
network file system is also possible, though care must be taken that the
file system has fullPOSIX behavior (see Section 17.2.2
<https://www.postgresql.org/docs/9.5/static/creating-cluster.html#CREATING-CLUSTER-NFS>).
One significant limitation of this method is that if the shared disk array
fails or becomes corrupt, the primary and standby servers are both
nonfunctional. Another issue is that the standby server should never access
the shared storage while the primary server is running.
TIA !

Poul

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Mead 2016-10-05 12:22:51 Re: Cluster solution for Postgresql 9.5
Previous Message Thomas SIMON 2016-10-05 10:14:36 Re: Wrong stat on pg_stat_user_tables