[pgpool-hackers: 3606] add the command of pcp_reload_config

[周建身]

Hi Hackers,

    As Usama Muhammad said in his email before,we should enhance/add the PCP utilities more cluster-mode friendly.

There are four commands which need to be added or enhanced.The first command which should be added is pcp_reload_config.



    1- pcp_reload_config
==================
The utility to make the whole Pgpool-II cluster to reload the
configuration files at once.
I think this is required because currently if some installation has
let say 3 node Pgpool-II cluster
and we want to change one specific configuration parameter ( for
example: adding a new backend node)
we would require to go on and edit Pgpool configuration files on each
node separately and then
issue pgpool reload on each node one by one.

In my opinion, we need multiple enhancement in this area.
We need some mechanisms to let pgpool-II cluster use the centralized
configuration
( except watchdog config) or at least a mechanism to push the
configuration settings using some
new utility like "pcp_load_config" that could take a pgpool.conf file
and propagate it to all nodes
using watchdog.
The centralized configuration part of the problem is a big task and I
believe we could take it on after the
"simplifying watchdog config" feature that Peng is working on.
Meanwhile, I think we can work on pcp_reload_config utility in
parallel to make reloading part easier.



I tried to solve this command.And I realized reloading the configuration of an individual node.After Peng's working on

watchdog config,we can eventually realize the reloading the configurations of all nodes.


How to use the patch,

1、do patch under the directory of pgpool-II-4.1.1

patch -p1 < pcp_reload_config.patch

2、you should need automake and autoconf


for example:
 $ autoheader
 $ aclocal
 $ automake -a -c
 $ autoconf

3、then to do make and make install


4、under the directory of bin，you can find the pcp_reload_config ,try is as  ./pcp_reload_config




Comments and suggestions are welcome.


Thanks
Best regards
Zhou Jianshen

zhoujianshen at highgo.com​

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200429/1ab07bcf/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pcp_reload_config.patch
Type: application/octet-stream
Size: 6103 bytes
Desc: pcp_reload_config.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200429/1ab07bcf/attachment-0001.obj>