[pgpool-general: 3588] Re: Master-Slave and white_function_list
cpro29a at gmail.com
Wed Apr 1 15:48:43 JST 2015
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.
> 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.
> pgpool-general mailing listpgpool-general at pgpool.nethttp://www.pgpool.net/mailman/listinfo/pgpool-general
> pgpool-general mailing list
> pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general