pgpool question

From: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pgpool question
Date: 2016-10-07 12:29:18
Message-ID: DM2PR05MB622ECDECC833A61785F60508CC60@DM2PR05MB622.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I posted this in the pgpool mailing list and so far has not recvd any response. Looks like that mailing list is hardly active.
=========================================

I am researching pgpool technology. Let us say we want to use it as an alternative to streaming replication of PG. Apparently in replication mode, pgpool can replicate to all participating nodes, which presumably will be in raw mode (non replicating mode).

My questions:

1 - Do we have a choice of limiting number of nodes for sync writes (and remaining one in async), so that overall performance impact is limited.
2 - If a node is down, does pgpool has the ability to resync from the last known transaction that was committed. How does it do it? Does it maintain
a state information or save all transactions that need to be replayed later on.
3 - Is app-stickiness possible. By app-stickiness I mean, a given app or session always goes to the same node. This helps in avoiding stale reads.
4- Is the failover transparent to the client. Meaning, if a node goes down, do clients have to use a new connection string.
5 - How about high availability of pgpool itself. Can we have multiple pgpools?

If there is a documentation to answer these questions, please let me know.

thanks.

Browse pgsql-general by date

  From Date Subject
Next Message arnaud gaboury 2016-10-07 13:01:19 Libpq functions & string to obtain connection parameters
Previous Message Thomas Kellerer 2016-10-07 08:54:01 Re: import_bytea function