From: Greg Smith <greg@2ndquadrant.com>
To: Anibal David Acosta <anibal.acosta@edge.com.py>
Cc: Kasia Tuszynska <ktuszynska@esri.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: question about HA in PG 9.0
Date: Fri, 24 Sep 2010 23:29:28 -0400
Message-ID: <4C9D6C98.804@2ndquadrant.com> (raw)
In-Reply-To: <000b01cb58d3$f1cabad0$d5603070$@edge.com.py>
References: <232B5217AD58584C87019E8933556D110214AB147C@redmx2.esri.com>
<000b01cb58d3$f1cabad0$d5603070$@edge.com.py>
Anibal David Acosta wrote:
>
> Windows server enterprise has the Microsoft Cluster Services.
>
> This enable fail-over scenario between two computers.
>
> So, when one of them go offline, the other is activated, this involve
> many steps, including IP changing, the slave become the master IP
> address .
>
> But you can choose between has a replication between both postgres or
> maybe you can put your postgresql DATA directory to an external
> storage shared between those two servers.
>
> If this case, when the second server become available the Cluster
> service map map the DATA unit and starts the postgres service.
>
> So, you have everything running and working in aprox. 10 seconds.
>
All of the Windows Server stuff via Microsoft Cluster Services I'm aware
of does its shared storage node fencing via sending specific SCSI calls
(PERSISTENT RESERVE) to the storage. That probably works fine if you
have a Fiber Channel array that supports that. But I don't think
there's any flexibility for alternative types of deployments. As for
the complexity of the setup time, while they have put a bunch of GUIs on
it I've never see anything that tries to do complicated storage array
arrangements work in any time that isn't measure in large multiples of
hours, so "10 seconds" I'm skeptical of.
--
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance" Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: greg@2ndquadrant.com, anibal.acosta@edge.com.py, ktuszynska@esri.com
Subject: Re: question about HA in PG 9.0
In-Reply-To: <4C9D6C98.804@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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