I got a personal mail regarding pgpool-II 3.0.3 load balancing(replication mode). To share info among community, I post this.
>> I may have to throw away pgool-II, unfortunately. Here is my story - >> http://mwrynn.blogspot.com/2011/05/pgpool-ii-load-balancing.html - do >> you have any advice on what I might be doing wrong? I have tested 3.0.3 by using pgbench and see no problem. 1. Make sure that pgpool-II write logs to somewhere. For example: pgpool -n ... >&/tmp/pgpool.log& Please note that "-n" is mandatory. 2. Run pgbench to issue trivial SELECTs via pgpool-II. pgbench -p 9999 -n -S -C -c 2 -t 1000 test 3. Grep pgpool log to find how many SELECTs being sent to each PostgreSQL. grep SELECT /tmp/pgpool.log|grep "node id: 0"|wc # number of queries sent to DB 0 grep SELECT /tmp/pgpool.log|grep "node id: 1"|wc # number of queries sent to DB 1 I see almost same number of quries being sent to each node. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
