[pgpool-general: 6280] load balance between hosts with same FQDN

[Bino Oetomo]

Dear All.

lets say Currently I have 3 psql hosts, 2 of them have the same 'fqdn' but
different IP.

master.pgcluster.service.bino.inc. 0 IN    A    10.10.10.3
replica.pgcluster.service.bino.inc. 0 IN A    10.10.10.1
replica.pgcluster.service.bino.inc. 0 IN A    10.10.10.2

(note: DNS server is by Consul)

My pgpool.conf :

#MASTER
backend_hostname0 = 'master.pgcluster.service.bino.inc'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/psqldata'
backend_flag0 = 'ALWAYS_MASTER'
#REPLICAs
backend_hostname1 = '10.10.10.2'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/psqldata'

My question is, will the SELECT (read) being loadbalanced between all three
hosts ?

Sincerely
-bino-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181117/040583f4/attachment.html>