<div dir="ltr">Thank you.<div><br></div><div>Probably pgpool watchdog is the way to go for the first attempt.</div><div><br></div><div>Regarding the second point. I had thoughts.. Would be possible to add a hybrid replication, that is:</div>
<div>
<p class=""></p><ul><li>pgpool would have a list of tables that must be synchronously replicated;</li><li>synchronous replication:</li><ul><li>If DML query relates to any of the table from that list, then pgpool would use synchronous replication - send DML to all DBs;</li>
</ul><li>asynchronous replication:<br></li><ul><li>if DML query does not relate to any table from the list, then it would be sent to the master database and be replicated via streaming replication</li></ul></ul><div><br></div>
<div>Is such approach technically feasible (if I wanted to add it)? Would it be difficult?</div><div>I just had a thought, what if pgpool replicates DML query to all servers. How master's streaming replication then behaves?</div>
<div><br></div><div>Cheers,</div><div>Gintas</div><p></p>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jan 30, 2014 at 2:18 PM, Lazaro Ruben Garcia Martinez <span dir="ltr"><<a href="mailto:lgarciam@vnz.uci.cu" target="_blank">lgarciam@vnz.uci.cu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">For number one you should use watchdog functionality.<br>
<br>
Regards.<br>
________________________________________<br>
De: <a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a> [<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a>] En nombre de Athanasios | ZenGuard [<a href="mailto:athanasios@zenguard.org">athanasios@zenguard.org</a>]<br>
Enviado el: jueves, 30 de enero de 2014 6:48<br>
Para: Gintautas Sulskus<br>
CC: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
Asunto: [pgpool-general: 2505] Re: Common practices for pgpool availability and data replication<br>
<div class="im"><br>
Hi,<br>
for point 1) you can use keepalived and two pgpool machines<br>
<br>
<br>
</div><div class="im">On Thu, Jan 30, 2014 at 12:00 PM, Gintautas Sulskus <<a href="mailto:gingaz@gmail.com">gingaz@gmail.com</a><mailto:<a href="mailto:gingaz@gmail.com">gingaz@gmail.com</a>>> wrote:<br>
Dear All,<br>
<br>
I have a few questions regarding practices with pgpool:<br>
1. Typically pgpool is a single point of failure. What is the common practice to solve this?<br>
2. Some of our data (e.g. 10% tables) must be consistent across the cluster for every transaction. The rest may differ. Is it possible to have a fine-grained replication, where some DMLs would be replicated synchronously and the rest would use asynchronous replication?<br>
<br>
Thanks!<br>
<br>
Best Regards,<br>
Gintautas<br>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
</div><a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><mailto:<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
<br>
<br>
________________________________<br>
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!<br>
<a href="http://www.antiterroristas.cu" target="_blank">http://www.antiterroristas.cu</a><br>
<a href="http://justiciaparaloscinco.wordpress.com" target="_blank">http://justiciaparaloscinco.wordpress.com</a><br>
<br>
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!<br>
<a href="http://www.antiterroristas.cu" target="_blank">http://www.antiterroristas.cu</a><br>
<a href="http://justiciaparaloscinco.wordpress.com" target="_blank">http://justiciaparaloscinco.wordpress.com</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Best Regards,<br>Gintautas Sulskus
</div>