I read the post send by you in the email shown below, but I have a doubt. The number for backend_wheight is a number between 0 and 1?. Is this a probabilistic number?
Regards. ________________________________________ De: [email protected] [[email protected]] En nombre de Tatsuo Ishii [[email protected]] Enviado el: viernes, 06 de mayo de 2011 18:45 Para: [email protected] Asunto: [Pgpool-general] pgpool-II load balancing 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
