Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL cluster solution

From: Pushpendra Singh Thakur <thakur(at)corexprts(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL cluster solution
Date: 2009-12-23 14:31:38
Message-ID: d6a413080912230631y48349810j4611c632cc5a00a0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
There is no single solution for your requirement. I am also looking for the
same since last 3 years. Recently I got a mail from Continuent Tungsten
Enterprise, they said they have the solution. This is their link
http://www.continuent.com/solutions/overview/tungsten-for-postgresql
<http://www.continuent.com/solutions/overview/tungsten-for-postgresql>


2009/12/23 Serge Fonville <serge(dot)fonville(at)gmail(dot)com>

> For a while now I am looking for a suitable cluster solution.
>
> I want a multi-master solution since that would best spread the write load.
>
> I looked into pgpool, pgcluster, cybercluster
> They all seem very suiotable.
>
> I had a strong preference towards pgpool until I read in the docs that
> serial values aren't equal unless table-loking is enabled.
> > Replicating a table with SERIAL data type, the SERIAL column value may
> differ between the backends. This problem is avoidable by locking the table
> explicitly (although,
> > transactions' parallelism will be lost). To achieve this, however, the
> following change must be made:
>
> Does anyone here have a good idea which would be best?
>
> What I want
> Mutli master
> Failover and failback (if that makes sense for a multimaster solution...)
> Synchronize after downtime
> Load-balancing
> Once a client is connected it stays connected to that server (possibly
> through LVS)
>
> Thanks a lot in advance
>
> Regards,
>
> Serge Fonville
>
>
> --
> http://www.sergefonville.nl
>
> Convince Google!!
> They need to support Adsense over SSL
> https://www.google.com/adsense/support/bin/answer.py?hl=en&answer=10528
>
> http://www.google.com/support/forum/p/AdSense/thread?tid=1884bc9310d9f923&hl=en
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>



-- 
Pushpendra Singh Thakur

COREEXPERTS Technologies Private Limited
Business Process Automation & IT Support Services
http://www.corexprts.com
Phone - 91-761-4070036
Fax - 91-761-4010530
SMS - 91-799-66554

In response to

pgsql-novice by date

Next:From: Greg Sabino MullaneDate: 2009-12-23 18:02:16
Subject: Re: PostgreSQL cluster solution
Previous:From: Serge FonvilleDate: 2009-12-23 07:31:01
Subject: PostgreSQL cluster solution

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group