<br><br><div class="gmail_quote">On Fri, May 20, 2011 at 7:56 AM, Daniel Bozeman <span dir="ltr"><<a href="mailto:daniel.bozeman@americanroamer.com">daniel.bozeman@americanroamer.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div style="word-wrap: break-word;">Sachin,<div><br></div><div>Check out pgpool-II (<a href="http://pgpool.projects.postgresql.org/" target="_blank">http://pgpool.projects.postgresql.org/</a>). 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.</div>
<div><br></div><div>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.</div>
</div></blockquote><div><br>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.<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;"><div><br></div><div>Take care,</div><div><br></div>
<font color="#888888"><div>Daniel</div></font><div><div></div><div class="h5"><div><br><div><div>On May 20, 2011, at 7:37 AM, Serge Dubrouski wrote:</div><br><blockquote type="cite"><br><br><div class="gmail_quote">On Thu, May 19, 2011 at 11:07 PM, Sachin Gokhale <span dir="ltr"><<a href="mailto:sysadmin@indicussoftware.com" target="_blank">sysadmin@indicussoftware.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hello,<br>
<br>
I have two nodes active/passive cluster created using documentation from<br>
clusterlabs. Replication is working fine on my setup. I am using this<br>
for Postgresql database.<br>
<br>
But, I am getting how I configure or test Faileover scenario & how can I<br>
add load balancing feature for my Postgres database.<br></blockquote><div><br>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.<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Looking for your kine help.<br>
Thanks in advance.<br>
<br>
Regards,<br>
<br>
Sachin<br>
******************************************************<br>
Sachin N. Gokhale<br>
System Administrator<br>
<<a href="mailto:sysadmin@indicussoftware.com" target="_blank">sysadmin@indicussoftware.com</a>><br>
Indicus Software Pvt. Ltd.<br>
28' Varshanand Society.<br>
Sinhgad Road Pune - 411038<br>
Tel. No. - 91-20-24341287/88<br>
Fax No. - 91-20-24341289<br>
******************************************************<br>
<br>
<br>
_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org/" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Serge Dubrouski.<br>
_______________________________________________<br>Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br><a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br></blockquote></div><br><div><br></div>
<br></div></div></div></div><br>_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Serge Dubrouski.<br>