From: | Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com> |
---|---|
To: | amador alvarez <aalvarez(at)d2(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: clustering with shared storage |
Date: | 2012-03-20 20:55:02 |
Message-ID: | CAFnxYwhDH2YARMS9_9BuVy8ML8--AB+KHg=v6eBdVy0vyJUuZQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, Mar 20, 2012 at 1:33 PM, amador alvarez <aalvarez(at)d2(dot)com> wrote:
> I wonder why are you considering this solution, as if something wrong comes
> within the data (logical corruption, user error) it will be spread on both
> locations, Would not be better a delayed standby database.
That's a risk, to be sure. That's why you also keep backups (such as a
PITR slave). If you're doing HA without also doing backups, you're
Doing It Wrong.
The benefit of Shared Storage clustering is immediate availability if
your "primary" node goes down for some reason. You simply fence off
the downed node, mount the shared volume, and bring up the db on the
secondary node. I've used commercial solutions that manage all this,
and reliably have the DB back in service in tens of seconds, at the
outside.
rls
--
:wq
From | Date | Subject | |
---|---|---|---|
Next Message | Gordon Shannon | 2012-03-20 21:02:31 | New role can connect to all dbs with no grants |
Previous Message | Devrim GÜNDÜZ | 2012-03-20 20:53:45 | Re: clustering with shared storage |