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

Bino Oetomo bino at jogjacamp.co.id
Sun Nov 18 08:02:35 JST 2018


Dear Tatsuo.

My Vault ....

What if :

#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 = 'replica.pgcluster.service.bino.inc'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/psqldata'

Sincerely
-bino-

On Sat, Nov 17, 2018 at 3:52 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > 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 ?
>
> I'm not a network expert but I guess 10.10.10.1 will never be used by
> Pgpool-II, since either 10.10.10.1 or
> replica.pgcluster.service.bino.inc does not appears in pgpool.conf.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181118/4684b4c7/attachment.html>


More information about the pgpool-general mailing list