[pgpool-hackers: 4420] Re: [Question] : If pgpool-2 is illustrated in different DC & DR nodes and if SUBNETS are also different, Is this architecture supported?

[Sadhuprasad Patro]

On Mon, Feb 5, 2024 at 7:44 AM Sadhuprasad Patro <b.sadhu at gmail.com> wrote:
>
> Hi Everyone ,
>
> Need One Help for a new PGPOOL Customer Env setup. Please guide me...
> Details of the Architecture as below:
>
> 1 :- Customer having DC & DR Setup
> 2 :- Customer wants to place PGPOOL services in both nodes.
> 3 :- Following is Architecture Details
>
> DC [ called as PROD ]:-
>
> Standby     10.8.77.215          UP
> Primary     10.8.77.216          UP
> Witness     10.8.77.217          N/A --- PGPOOL-II
>
> DR:-
>
> Standby     10.68.1.174          UP
> Standby     10.68.1.175          UP
> Witness     10.68.1.176          N/A --- PGPOOL II
>
> 4 :- DC having IP Range 10.8
> 5 :- DR having IP Range 10.68
>
> Now the pending point here is "Delegate IP".
>
> If the Customer is going to add "Delegate IP" from DC -10.8 subnet and
> if in case PGPOOL-II node Fails from the DC side and then PGPOOL-II
> taking command for load balancing.
> However here Delegate IP range is 10.8 but DR side subnet ranging 10.68.
> Is this Delegate IP transfer using if_up_cmd & if_down_cmd where the
> subnet is different.
> 1 :- Is this architecture supported? Where PGPOOL services are
> situated in different DC & DR and subnets are also different.
> 2 :- If Yes, then how can Delegate IP be treated here ?

Hi Everyone,

Can I get some help here? This is related to architecture.

No where I could find it, it is mentioned as NOT supported.. But in
all examples I found, we use the same SUBNET for both pgpool nodes...

Please guide..

Thanks & Regards
SadhuPrasad