[pgpool-general: 2294] Re: About load balance

Fri Nov 15 23:57:39 JST 2013

Sorry for late response:

In this moment I am working in the development of a web appilcation in drupal. This app has 2 database, the sms's database and a second database for business implementation. The problem is drupal executes many queries like insert and select in a short time, as a result, if load balance functionality is used with streaming replication, the web app does not work as expected because the minimun delay between master and standby.

If load balance could be distributed using only one database node (Database A ---> Node A (Based in database), Database B ---> Node A and Node B (Based in queries)), the SMS database queries would be sent to only one server and the other database makes use of load balance among the servers.

A postgresql instance with more than one database, is an scenario for using the load balance functionality in two different ways, based in queries and based only in database. This functionality could be used when the replication is asyncronous like streaming replication.

Thank you very much for your time.
Regards.

________________________________________
De: Tatsuo Ishii [ishii at postgresql.org]
Enviado el: martes, 12 de noviembre de 2013 18:26
Para: Lazaro Ruben Garcia Martinez
CC: pgpool-general at pgpool.net
Asunto: Re: [pgpool-general: 2277] About load balance

> Could be posible load balancing only specified databases in future versions of pgpool?

That means we need to have weight parameter per database, not per
database cluster. Techinicaly it's doable, but I'm interested in what
use cases exist for that. Can you elaborate more?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com