[pgpool-general: 2521] Re: Common practices for pgpool availability and data replication

[Gintautas Sulskus]

Thank you.

Probably pgpool watchdog is the way to go for the first attempt.

Regarding the second point. I had thoughts.. Would be possible to add a
hybrid replication, that is:


   - pgpool would have a list of tables that must be synchronously
   replicated;
   - synchronous replication:
      - If DML query relates to any of the table from that list, then
      pgpool would use synchronous replication - send DML to all DBs;
   - asynchronous replication:
   - 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


Is such approach technically feasible (if I wanted to add it)? Would it be
difficult?
I just had a thought, what if pgpool replicates DML query to all servers.
How master's streaming replication then behaves?

Cheers,
Gintas



On Thu, Jan 30, 2014 at 2:18 PM, Lazaro Ruben Garcia Martinez <
lgarciam at vnz.uci.cu> wrote:

> For number one you should use watchdog functionality.
>
> Regards.
> ________________________________________
> De: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net]
> En nombre de Athanasios | ZenGuard [athanasios at zenguard.org]
> Enviado el: jueves, 30 de enero de 2014 6:48
> Para: Gintautas Sulskus
> CC: pgpool-general at pgpool.net
> Asunto: [pgpool-general: 2505] Re: Common practices for pgpool
> availability and data replication
>
> Hi,
> for point 1) you can use keepalived and two pgpool machines
>
>
> On Thu, Jan 30, 2014 at 12:00 PM, Gintautas Sulskus <gingaz at gmail.com
> <mailto:gingaz at gmail.com>> wrote:
> Dear All,
>
> I have a few questions regarding practices with pgpool:
> 1. Typically pgpool is a single point of failure. What is the common
> practice to solve this?
> 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?
>
> Thanks!
>
> Best Regards,
> Gintautas
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
>
> ________________________________
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE
> ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
>
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE
> ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
>



-- 
Best Regards,
Gintautas Sulskus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140202/d730e561/attachment.html>