[pgpool-general: 1780] Re: Master-Slave, load bancing and memory cache questions

Tatsuo Ishii ishii at postgresql.org
Tue May 28 08:15:31 JST 2013


> Hi,
> 
> We have experimented an abnormal situation when set on memory
> cache. We have configured PgPool 3.2.3 version, in master-slave mode
> and disabled load balancing.
> I understand reading the documentation, if we have set on master-slave
> mode, although load balancing parameter was disabled, it has no
> effect, and Pgpool applied load query balancing. This is true?
> 
> Agree, the configuration set master-slave mode with stream
> replication, and load balancing set off. The abnormal situation
> appears when I have set on or off memory cache. If we have disabled
> memory cache, Pgpool no applied load query balancing. In otherwise,
> when memory cache is enabled, PgPool applied load query
> balancing. This is normal situation, or there may be an bug?

Are you saying that "load_balance_mode = off" does not take effect if
"memory_cache_enabled = on"? Did not reproduce here. Can you please
show us more details.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the pgpool-general mailing list