[pgpool-general: 3588] Re: Master-Slave and white_function_list

[Сергей Мелехин]

Hi!
We are using this feature. Pgpool does not support schema specification in
white/black lists so beware!
The easiest way is to write comma separated list of your readonly
functions. Only names, without schemas!
Here's my settings:

white_function_list           = 'parse_vac_query,get.*,rated_search'
black_function_list           = ''

all functions starting with "get" and parse_vac_query and rated_search are
been balanced between master and slave. All other stored procedures execute
on master only.

С Уважением, Сергей Мелехин.

2015-04-01 6:10 GMT+10:00 Alex Toth <atoth at gravity.com>:

>  If I understand  your question correctly you want to balance functions
> in the schema stored_functions_v0.  I believe the only way is to list all
> of the functions, but you can use regex pattern matching to make life
> easier.  For example, if all those functions have "_v0" at the end of the
> name you could do something like this:
>
> white_function_list = '.*_v0'
> black_function_list = '.*'
>
> To see the load balancing happen you'll have to turn on query logging on
> the backends and watch the postgres logs.  Remember, the load balancing is
> by connection rather than by query so you'll have to disconnect and
> reconnect each time to see the queries distribute across both backends.
>
>
>   alex
>
>
>
> On 3/31/15 7:27, Mephysto wrote:
>
>  Hi there,
> I'm using Postgres 9.4 and pgpool-II 3.4 in Master-Slave configuration and
> streaming replication between nodes (two at the moment).
>
>  In my database I'm using a schema only for stored_functions, its name il
> stored_functions_v0. I need some example to coonfigure white_function_list
> parameter in pgpool.conf in order to balance readonly stored functions
> beetween my nodes.
>
>  Can someone provide me these examples?
>
>  In case of load balancing of stored functions is feasible, how can I
> check if load balancing work done?
>
>  Thanks in advance.
>
>  Kind regards.
>
>  Meph
>
>
> _______________________________________________
> pgpool-general mailing listpgpool-general at pgpool.nethttp://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150401/29357c64/attachment.html>