[pgpool-general: 2874] Re: pgpool on app servers - how to setup the heartbeats
ishii at postgresql.org
Fri May 23 23:34:01 JST 2014
> Dear Guys!
> This is just strange, that when I met a situation, like "how to setup
> pgpool without the extra IP address", the list fills up the same topic
> immediately, and without having to ask any question? :)
> Just great!! We took a try using Azure, but quit because of the
> restirictions - the lack of network transparency was one of them.
> Anyway, my current question is:
> Let's suppose
> - I setup my databas backends on several nodes, they just run the
> postgresql, at least two of them
> - I setup a pgpool node on all hosts ever need to access the database
> - configure all nodes for all the DB backends above (lets say I use pgpools
> own replication)
> - every application connects "localhost", which is the pool
> Is it guaranteed the db is consistent all the time?
Yes, if you set configurations properly.
> How should I setup the pools where I should have to tell them abount the
> pgpool cluster, like configure other-pgpool, or heartbeat-destination?
You need to setup both.
> Is there any limit for the number of the pgpool nodes?
The max number of pgpool nodes is 128.
> How much network traffic should I count with?
Most network traffic is caused by PostgreSQL frontend/backend
protocol. That means, it really depends on that how your database is
SRA OSS, Inc. Japan
More information about the pgpool-general