Where I get active/active setup document for postgres? I searched on clusterlabs site...but didn't get any help.
sachin On Fri, 20 May 2011 08:12:09 -0600 Serge Dubrouski <serge...@gmail.com> wrote: > On Fri, May 20, 2011 at 7:56 AM, Daniel Bozeman < > daniel.boze...@americanroamer.com> wrote: > > > Sachin, > > > > Check out pgpool-II (http://pgpool.projects.postgresql.org/). Using > > pgpool, you can use postgres 9.0 streaming replication to set up a master > > server and a hot-standby which can accept read-only queries. pgpool will > > automatically send read-only transactions to the hot-standby, while writes > > will be sent to the master database and replicated to the standby using > > postgres streaming replication. Pgpool will also manage failover and online > > recovery of your postgres instances. You can then use Pacemaker to make > > pgpool and a virtual IP pointing to it highly available. > > > > That being said, implementing a reliable active/passive cluster with > > Pacemaker is not trivial. I am currently using LSB to manage pgpool, but I > > plan to write my own OCF resource or test/modify the one provided with the > > older pgpool-ha project. > > > > Depends on what you call active/passive. Active/Passive can be easily > implemented with DRBD replication and there is at least 2 HOW-TO documents > on clusterlabs web site. Streaming replication is more like Active/Active > and this one isn't trivial at all. And not because of Pacemaker but because > of the way how Streaming replication is implemented in PostgreSQL. If it was > close to Oracle DataGuard for example it would be much easier. > > > > Take care, > > > > Daniel > > > > On May 20, 2011, at 7:37 AM, Serge Dubrouski wrote: > > > > > > > > On Thu, May 19, 2011 at 11:07 PM, Sachin Gokhale < > > sysad...@indicussoftware.com> wrote: > > > >> Hello, > >> > >> I have two nodes active/passive cluster created using documentation from > >> clusterlabs. Replication is working fine on my setup. I am using this > >> for Postgresql database. > >> > >> But, I am getting how I configure or test Faileover scenario & how can I > >> add load balancing feature for my Postgres database. > >> > > > > Do you need read only load balancing or read/write? First one is possible > > with PGSQL hot-standby databases, second one isn't possible in PGSQL AFAIK. > > > > > >> > >> Looking for your kine help. > >> Thanks in advance. > >> > >> Regards, > >> > >> Sachin > >> ****************************************************** > >> Sachin N. Gokhale > >> System Administrator > >> <sysad...@indicussoftware.com> > >> Indicus Software Pvt. Ltd. > >> 28' Varshanand Society. > >> Sinhgad Road Pune - 411038 > >> Tel. No. - 91-20-24341287/88 > >> Fax No. - 91-20-24341289 > >> ****************************************************** > >> > >> > >> _______________________________________________ > >> Pacemaker mailing list: Pacemaker@oss.clusterlabs.org > >> http://oss.clusterlabs.org/mailman/listinfo/pacemaker > >> > >> Project Home: http://www.clusterlabs.org > >> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > >> Bugs: > >> http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker > >> > > > > > > > > -- > > Serge Dubrouski. > > _______________________________________________ > > Pacemaker mailing list: Pacemaker@oss.clusterlabs.org > > http://oss.clusterlabs.org/mailman/listinfo/pacemaker > > > > Project Home: http://www.clusterlabs.org > > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: > > http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker > > > > > > > > > > > > _______________________________________________ > > Pacemaker mailing list: Pacemaker@oss.clusterlabs.org > > http://oss.clusterlabs.org/mailman/listinfo/pacemaker > > > > Project Home: http://www.clusterlabs.org > > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: > > http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker > > > > > > > -- > Serge Dubrouski. ****************************************************** Sachin N. Gokhale System Administrator <sysad...@indicussoftware.com> Indicus Software Pvt. Ltd. 28' Varshanand Society. Sinhgad Road Pune - 411038 Tel. No. - 91-20-24341287/88 Fax No. - 91-20-24341289 ****************************************************** _______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
