Re: [Postgres-xc-general] XC as an HA solution

[Mason S. <ma...@st...>]

Hi Ray,

I would not think of Postgres-XC as an HA solution. Think of it as a write
scalability solution (and to some extent, simple reads). If you are just
looking for HA, you could consider using streaming replication with
pgpool-II.  In the architecture you suggested, it might be ok for a
read-heavy workload, but you will still have to externally manage HA.

If however you do need the scalability, then please do consider XC and
distribute your tables.  For HA, manage that external to Postgres-XC using
something like Corosync/Pacemaker.

Regards,


On Fri, Jun 7, 2013 at 3:35 PM, Ray Stell <st...@vt...> wrote:

> I've never touched XC, but I'm considering a HA/postgresql solution. XC
> docs indicate it provides the benefit of multi-master writes which is very
> attractive.  I would want to have the data replicated to all the datanodes
> to guard services against node failure.  Is this considered a production
> safe design or are adopters generally using a partitioning configuration?
> I scanned http://wiki.postgresql.org/images/4/44/Pgxc_HA_20121024.pdf and I'm gathering resources for a trial run.  Can this be demonstrated
> well enough in three VM nodes: 1. GTM;  2. GTM proxy, cooridinator,
> datanode; 3. GTM proxy, cooridinator, datanode.   I get the impression that
> many more nodes are really ideal for a complete HA solution  What would be
> the base starting point suggested?  Maybe there is a cookbook I've not
> seen.  Thanks, Ray
>
> ------------------------------------------------------------------------------
> How ServiceNow helps IT people transform IT departments:
> 1. A cloud service to automate IT design, transition and operations
> 2. Dashboards that offer high-level views of enterprise services
> 3. A single system of record for all IT processes
> http://p.sf.net/sfu/servicenow-d2d-j
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>



-- 
Mason Sharp

StormDB - http://www.stormdb.com
The Database Cloud
Postgres-XC Support and Services