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.
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 |