Thank you very much for your answer. Regards ________________________________________ De: [email protected] [[email protected]] En nombre de Erwan [[email protected]] Enviado el: viernes, 20 de mayo de 2011 11:36 Para: [email protected] Asunto: Re: [Pgpool-general] About load balancing!!!
Hi Lazaro On 05/20/2011 05:34 PM, Lazaro Rubén García Martinez wrote: > Tatsuo, thank you very much for your answer, I read some topics about this > and I found the answer. One question. Backend_weight is a probabilistic > number from 0 to 1?? You can use any integers you want, then pgpool-II will compute the "load balancing" ratio for each of your backend nodes. E.g: Imagine I have the following settings in my pgpool-II conf: ... backend_hostname0 = 'node-main' backend_port0 = 5432 backend_weight0 = 1000 backend_hostname1 = 'node-rescue' backend_port1 = 5432 backend_weight1 = 1 ... After restarted pgpool-II, you will be able to check the "load balancing" ratio thanks to the pcp commands: $ pcp_node_info 10 127.0.0.1 9898 login password 1 node-rescue 5432 1 0.000999 $ pcp_node_info 10 127.0.0.1 9898 login password 0 node-main 5432 2 0.999001 So here, 99% of the requests will be executed on 'node-main' (theoretically). Hope this will help. /Erwan > Thank you very much for your time. > Regards. > ________________________________________ > De: Tatsuo Ishii [[email protected]] > Enviado el: martes, 17 de mayo de 2011 4:50 > Para: Lazaro Rubén García Martinez > CC: [email protected] > Asunto: Re: [Pgpool-general] About load balancing!!! > > It's precisely explained in the pgpool-II document. Have you read it? > Especially figures? > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > >> Hello every one in the list, Recently I need to make a presentation in my >> work about replication solutions for PostgreSQL, and I need to know how >> works the algoritms for making load balancing in Pgpool-II. This answer is >> very important for my. >> >> Thank you very much for your time. >> Regards. >> _______________________________________________ >> 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 _______________________________________________ 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
