[pgpool-general: 4522] Re: pgpool-II watchdog

Venkata Balaji N nag1010 at gmail.com
Sun Mar 6 09:02:48 JST 2016


Thank you very much. That would be helpful.

Regards,

On Sun, Mar 6, 2016 at 1:17 AM, Lucas Luengas <lucasluengas at gmail.com>
wrote:

> Hello.
>
> Your question: What will be the state of the existing application
> connections ?
> My answer: Existing application connections will be closed/disconnected.
>
> Your question: will they be taken over by the second pgpool-II server and
> the Queries continue to run as it is ?
> Existing application connections will not be taken over by the second
> server.
> New connections will be connect to second server.
>
> Your question: If i have a SELECT query currently running and the active
> pgpool-II server fails, will the SELECT query continue to run without
> interruption from the second pgpool-II server ?
> My answer: The query currently running are disconnected. After a few
> seconds, the next queries (your application connections) connect to second
> pgpool-II server.
>
> Your question: or it had to be re-executed again ?
> My answer: Yes. If you want the SELECT, you must re-execute the SELECT
> again.
>
> Regards.
>
>
>
>
>
>
> On Sat, Mar 5, 2016 at 10:45 AM, Venkata Balaji N <nag1010 at gmail.com>
> wrote:
>
>> I have a PostgreSQL clusters (master and standby) configured with
>> Streaming Replication, we are looking at setting up a pgpool-II with
>> watchdog for connection pooling and failover purposes we would also need
>> to ensure there is no single-point-of-failure threat to pgpool-II.
>>
>> My query is -
>>
>> If i have pgpool-II configured with watchdog and if the active pgpool-II crashes,
>> then, my understanding is that all the application connections will be
>> failed-over to the second pgpool-II server. What will be the state of
>> the existing application connections ? will they be taken over by the second
>> pgpool-II server and the Queries continue to run as it is ?
>>
>> Eg: If i have a SELECT query currently running and the active pgpool-II server
>> fails, will the SELECT query continue to run without interruption from
>> the second pgpool-II server ? or it had to be re-executed again ?
>>
>> Please help !
>>
>> Regards,
>> Venkata B N
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160306/d4fd7361/attachment.html>


More information about the pgpool-general mailing list