[pgpool-general: 2119] Re: Suggestion about two datacenters connected through WAN
Michal.Mistina at virte.sk
Wed Sep 11 17:59:32 JST 2013
>> Hi Tatsuo.
>>> One thing you might want to use for this is, "trusted_servers".
>> you register router IPs you trust (pgpool should be able to reach the
>> router) for this. In the split brain case, if pgpool in TC1 or TC2
>> finds that it cannot reach the IP anymore, it sucides to avoid going
>> the split brain.
>> I will definetely try trusted_servers option.
Is it the requirement to have a watchdog enabled for trusted_servers option
>> It's working now. I tested easy fail-over to the secondary technical
>> center (TC2). However I have found out I need to set
>> health_check_period. If I leave it disabled (0) the pgpool does not
>> know the PostgreSQL master is down. Is this correct behaviour? I
>> couldn't find it in the manual pages. I thought only sr_check_period
>> should be enabled for successful failure detection.
>It's documented in the doc.
> This parameter specifies the interval between the health checks in
> seconds. Default is 0, which means health check is disabled.
>> I'm using pgpool-II 3.3.0.
>> Best regards,
>> Michal Mistina
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 3076 bytes
Desc: not available
More information about the pgpool-general