<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} .ms-cui-menu {background-color:#ffffff;border:1px rgb(171, 171, 171) solid;font-family:"Microsoft YaHei UI", "Microsoft YaHei", ????, SimSun, ??, sans-serif;font-size:11pt;color:rgb(51, 51, 51);} .ms-cui-menusection-title {display:none;} .ms-cui-ctl {vertical-align:text-top;text-decoration:none;color:rgb(51, 51, 51);} .ms-cui-ctl-on {background-color:rgb(223, 237, 250);opacity: 0.8;} .ms-cui-img-cont-float {display:inline-block;margin-top:2px} .ms-cui-smenu-inner {padding-top:0px;} .ms-owa-paste-option-icon {margin: 2px 4px 0px 4px;vertical-align:sub;padding-bottom: 2px;display:inline-block;} .ms-rtePasteFlyout-option:hover {background-color:rgb(223, 237, 250) !important;opacity:1 !important;} .ms-rtePasteFlyout-option {padding:8px 4px 8px 4px;outline:none;} .ms-cui-menusection {float:left; width:85px;height:24px;overflow:hidden}--></style>
</head>
<body>
<div style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 15px; background-color: #ffffff;">Hi Hackers,</span><br>
</p>
<p><span> </span>As Usama Muhammad said in his email before,we should enhance/add the PCP utilities more cluster-mode friendly.</p>
<p>There are four commands which need to be added or enhanced.The first command which should be added is pcp_reload_config.<br>
</p>
<p><span> </span><br>
</p>
<p><span> <span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">1- pcp_reload_config</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">==================</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">The utility to make the whole Pgpool-II cluster to reload the</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">configuration files at once.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">I think this is required because currently if some installation has</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">let say 3 node Pgpool-II cluster</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">and we want to change one specific configuration parameter ( for</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">example: adding a new backend node)</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">we would require to go on and edit Pgpool configuration files on each</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">node separately and then</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">issue pgpool reload on each node one by one.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">In my opinion, we need multiple enhancement in this area.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">We need some mechanisms to let pgpool-II cluster use the centralized</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">configuration</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">( except watchdog config) or at least a mechanism to push the</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">configuration settings using some</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">new utility like "pcp_load_config" that could take a pgpool.conf file</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">and propagate it to all nodes</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">using watchdog.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">The centralized configuration part of the problem is a big task and I</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">believe we could take it on after the</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">"simplifying watchdog config" feature that Peng is working on.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">Meanwhile, I think we can work on pcp_reload_config utility in</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">parallel to make reloading part easier.</span></span><br>
</p>
<p><span><br>
</span></p>
<p><span><br>
</span></p>
<p><span>I tried to solve this command.And I realized reloading the configuration of an individual node.After Peng's working on </span></p>
<p><span>watchdog config,we can eventually realize the reloading the configurations of all nodes.</span></p>
<p><span><br>
</span></p>
<p><span>How to use the patch,</span></p>
<p>1、do patch under the directory of pgpool-II-4.1.1<br>
</p>
<p>patch -p1 < pcp_reload_config.patch<br>
</p>
<p>2、you should need automake and autoconf<br>
</p>
<p><br>
</p>
<pre style="white-space: pre-wrap;">for example:
$ autoheader
$ aclocal
$ automake -a -c
$ autoconf<br></pre>
<p>3、then to do make and make install</p>
<p><br>
</p>
<p>4、under the directory of bin，you can find the pcp_reload_config ,try is as ./pcp_reload_config<br>
</p>
<p><span> </span></p>
<p><span><br>
</span></p>
<p><span>Comments and suggestions are welcome.</span></p>
<p><span><br>
</span></p>
<p><span><span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">Thanks</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">Best regards</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
Zhou Jianshen</span></p>
<p><span><span style="font-family: verdana; font-size: 13.3333px; background-color: #ffffff;">zhoujianshen@highgo.com</span><br>
</span></p>
<p><span><br>
</span></p>
</div>
</body>
</html>