[pgpool-general: 7977] Re: pgpool in Kubernetes

[Nikolay Mastilo (HM)]

Hello,

Thank you for your responses.

There is another question.

Our Pgpool runs in k8s pod. All services in k8s are connected to the 
database through this Pgpool.

The addresses of the backend hostnames for master and replica nodes in 
the Pgpool settings are specified as a dns name, for example 
"master.patrcluster.services.consul".

DNS name resolution occurs in the DNS Consul. We also use Consul as a 
discovery service and key/value storage.
And Cosul DNS receives the following DNS requests every second:

------

Jan 14 08:53:53 dbnode0 consul[860]:     2022-01-14T08:53:53.473Z 
[ERROR] agent.dns: all resolvers failed for question from client: 
question="{12.32.150.10.in-addr.arpa. 12 1}" client=10.210.53.107:55640 
client_network=udp
Jan 14 08:53:53 dbnode0 consul[860]: 2022-01-14T08:53:53.473Z [ERROR] 
agent.dns: all resolvers failed for question from client: 
question="{12.32.150.10.in-addr.arpa. 12 1}" client=10.210.53.107:55640 
client_network=udp

------

Here the address 10.210.53.107 is the k8s address where Pgpool works. 
Apparently, these requests are sent by Pgpool, but only when it works in 
Kubernetes.

When we run Pgpool just in a separate docker image, this does not happen.

Have you noticed such behavior of Pgpool? And how can we remove these 
requests or leave as is?  I would be grateful for any comment or advice.

Best regards,
Nikolay

14.01.2022 3:39, Bo Peng пишет:
> Hello,
>
> On Thu, 13 Jan 2022 18:06:28 +0200
> "Nikolay Mastilo (HM)"<nikm71 at hotmail.com>  wrote:
>
>> Hello,
>>
>> Could you please tell us aboun pgpool deployment in kubernetes.
>>
>> We are interested to know:
>>
>> 1. Are there the correct helms for deploying pgpool to kubernetes. If
>> so, where can we get them?
> No. Pgpool-II community doesn't provide a Helm for deploying pgpool in k8s.
> Below is the documentation to deploy pgpool in k8s.
>
>    https://www.pgpool.net/docs/latest/en/html/example-kubernetes.html  
>
>> 2. What strategy should be used to ensure high availability of the
>> pgpool service in k8s - the same as for other services in k8s, or should
>> there be any special HA configuration for pgpool in k8s?
> You don't need special HA configurations for pgpool in k8s.
> You can use the functionality of k8s to ensure high availability of pgpool,
> just same as for other services in k8s
>
>> Thanks in advance.
>>
>> -- 
>> Regards, Nikolay
>>
>> _______________________________________________
>> 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.pgpool.net/pipermail/pgpool-general/attachments/20220114/7e04ae73/attachment.htm>