[pgpool-general: 341] Re: Load balancing of user defined functions

Lazaro Ruben Garcia Martinez lgarciam at uci.cu
Wed Apr 4 02:41:13 JST 2012


The functions that performs any statement that change the database, such as insert, update or delete, can not be balanced? 

For these type of functions, you can use the black_function_list or white_function_list parameters in pgpool.conf file. 

Regards. 

----- Mensaje original -----

> Dear members of the mailing list,

> we have now successfully setup a full HA-solution for Postgres
> incorporating two pg-pool-II instances (heatbeat based fail-over)
> and a master-slave streaming replication.
> So far, everything works like a charm. However we would now like to
> enable the load balancing feature of pg-pool if possible.

> In general, all of our applications are not using direct SQL or
> prepared statements but instead are calling user defined functions
> to do their work.
> So basically all calls are Execute some_function(with, some,
> parameters). In the UDF we have the actual SQL statements then, the
> updates, inserts and selects…

> Is there a chance that we can do a load balancing of these functions?

> Best regards,
> Ludwig

> petaFuel GmbH
> Ludwig Adam
> Geschäftsführer

> Münchner Strasse 4
> 85354 Freising

> Tel.: +49 (0) 8161 4060 - 202 Mobil: +49 (0) 179-22 911 02
> Fax: +49 (0) 8161 4060 - 401 eMail: ludwig.adam at petafuel.de

> Geschäftsführer: Ludwig Adam, Dr. Peter Schönweitz
> Amtsgericht München, HRB 133773
> www.petaFuel.de

> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION

http://www.uci.cu
http://www.facebook.com/universidad.uci
http://www.flickr.com/photos/universidad_uci

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120403/c4817b32/attachment-0001.html>


More information about the pgpool-general mailing list