Re: [Pacemaker] Load Balancing Failover with Pacemaker

2011-06-06 Thread Serge Dubrouski
Such documentation does not exists because such configuration does not exists. What do you exactly mean b=y active/active in this case? On Sun, Jun 5, 2011 at 11:31 PM, Sachin Gokhale sysad...@indicussoftware.com wrote: Where I get active/active setup document for postgres? I searched on

Re: [Pacemaker] Load Balancing Failover with Pacemaker

2011-06-05 Thread Sachin Gokhale
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:

Re: [Pacemaker] Load Balancing Failover with Pacemaker

2011-05-20 Thread Sachin Gokhale
Hello, I didn't make configuration for failover as I was not sure about it. So, please help me with that. Load Balancing : It is required in our scenario, as database size is hugh users get connected to database using application tool. So, as records are hugh, for search or any other complex

Re: [Pacemaker] Load Balancing Failover with Pacemaker

2011-05-20 Thread Michael Schwartzkopff
Hello, I didn't make configuration for failover as I was not sure about it. So, please help me with that. Load Balancing : It is required in our scenario, as database size is hugh users get connected to database using application tool. So, as records are hugh, for search or any other

Re: [Pacemaker] Load Balancing Failover with Pacemaker

2011-05-20 Thread Serge Dubrouski
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

Re: [Pacemaker] Load Balancing Failover with Pacemaker

2011-05-20 Thread Daniel Bozeman
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

Re: [Pacemaker] Load Balancing Failover with Pacemaker

2011-05-20 Thread Serge Dubrouski
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

[Pacemaker] Load Balancing Failover with Pacemaker

2011-05-19 Thread Sachin Gokhale
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