<div dir="ltr">We were considering the option to implement this functionality. Do you think such configuration (my previous mail) is feasible on top of the current pgool code base? Would be it difficult to implement?<div><br>
</div><div>Cheers,</div><div>Gintas</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Feb 3, 2014 at 1:33 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">An hybrid replication is not possible in this moment. Pgpool works in one specific mode, master-slave mode or syncronous replication.<br>
<br>
Regards.<br>
________________________________________<br>
De: Gintautas Sulskus [<a href="mailto:gingaz@gmail.com">gingaz@gmail.com</a>]<br>
Enviado el: domingo, 02 de febrero de 2014 14:05<br>
Para: Lazaro Ruben Garcia Martinez<br>
CC: Athanasios | ZenGuard; <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
Asunto: Re: [pgpool-general: 2505] Re: Common practices for pgpool availability and data replication<br>
<div class="im"><br>
Thank you.<br>
<br>
Probably pgpool watchdog is the way to go for the first attempt.<br>
<br>
Regarding the second point. I had thoughts.. Would be possible to add a hybrid replication, that is:<br>
<br>
</div> * pgpool would have a list of tables that must be synchronously replicated;<br>
* synchronous replication:<br>
* If DML query relates to any of the table from that list, then pgpool would use synchronous replication - send DML to all DBs;<br>
* asynchronous replication:<br>
* 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<br>
<div class="im"><br>
Is such approach technically feasible (if I wanted to add it)? Would it be difficult?<br>
I just had a thought, what if pgpool replicates DML query to all servers. How master's streaming replication then behaves?<br>
<br>
Cheers,<br>
Gintas<br>
<br>
<br>
</div><div class="im">On Thu, Jan 30, 2014 at 2:18 PM, Lazaro Ruben Garcia Martinez <<a href="mailto:lgarciam@vnz.uci.cu">lgarciam@vnz.uci.cu</a><mailto:<a href="mailto:lgarciam@vnz.uci.cu">lgarciam@vnz.uci.cu</a>>> wrote:<br>
For number one you should use watchdog functionality.<br>
<br>
Regards.<br>
________________________________________<br>
</div>De: <a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a><mailto:<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><mailto:<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><mailto:<a href="mailto:athanasios@zenguard.org">athanasios@zenguard.org</a>>]<br>
<div class="im">Enviado el: jueves, 30 de enero de 2014 6:48<br>
Para: Gintautas Sulskus<br>
</div>CC: <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>
<div class="im">Asunto: [pgpool-general: 2505] Re: Common practices for pgpool availability and data replication<br>
<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>><mailto:<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>><mailto:<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>
<div class="HOEnZb"><div class="h5"><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>
<br>
<br>
<br>
--<br>
Best Regards,<br>
Gintautas Sulskus<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>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Best Regards,<br>Gintautas Sulskus
</div>