<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div><span>Hi All,<br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span>I was wondering if someone ever tried to put Bucardo in async master-master setup on two pgpool servers<br></span></div><div>Let`s say i have to locations, one in Europe and one in US, on both locations I will have a Pgpool2 instance. I want to use Bucardo to replicate changes between those to pgpool clusters.<br><br><br>pgPool2 US - - - - - - - - -> Bucardo Multimaster Async <- - - - - - - - - - - PgPool2 Europe<br><br><br><br></div><div>Regards,<br>Adrian Videanu</div><div><br></div> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial,
Lucida Grande, sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> Stelios Limnaios <stelios.limnaios@mekon.com><br> <b><span style="font-weight: bold;">To:</span></b> "pgpool-general@pgpool.net" <pgpool-general@pgpool.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, November 8, 2013 12:58 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> [pgpool-general: 2263] PGPool and backend CPU usage<br> </font> </div> <div class="y_msg_container"><br><div id="yiv0636538194"><style><!--
#yiv0636538194
_filtered #yiv0636538194 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv0636538194 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
#yiv0636538194
#yiv0636538194 p.yiv0636538194MsoNormal, #yiv0636538194 li.yiv0636538194MsoNormal, #yiv0636538194 div.yiv0636538194MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}
#yiv0636538194 a:link, #yiv0636538194 span.yiv0636538194MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv0636538194 a:visited, #yiv0636538194 span.yiv0636538194MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv0636538194 span.yiv0636538194EmailStyle17
{font-family:"Calibri", "sans-serif";color:windowtext;}
#yiv0636538194 span.yiv0636538194apple-converted-space
{}
#yiv0636538194 .yiv0636538194MsoChpDefault
{font-family:"Calibri", "sans-serif";}
_filtered #yiv0636538194 {margin:72.0pt 72.0pt 72.0pt 72.0pt;}
#yiv0636538194 div.yiv0636538194WordSection1
{}
--></style><div><div class="yiv0636538194WordSection1"><div class="yiv0636538194MsoNormal"><span lang="EN-US">Hi all,</span></div><div class="yiv0636538194MsoNormal"><span lang="EN-US"> </span></div><div class="yiv0636538194MsoNormal"><span lang="EN-US">We’re facing a situation that would like some expertise to be solved.</span></div><div class="yiv0636538194MsoNormal"><span lang="EN-US"> </span></div><div class="yiv0636538194MsoNormal"><span lang="EN-US">First of all, our setup consists of 3 databases Postgres 9.1, PGPool 3.2 STABLE checked out from the repository (rev </span><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">6dde744) and PGPoolAdmin 3.2.0.</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">We have setup replication and load balancing, along with scripts for online recovery.</span></div><div
class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">The cluster works fine in terms of replicating and load balancing data.</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";"> </span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">But, the servers host other applications expect of the databases.</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">Some applications require a lot of CPU when running.</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">We found recently that when CPU is high in a backend, PGPool fails to update the data on
this server and that causes a ‘</span><span style="font-size:9.0pt;font-family:"Courier New";">kind mismatch among backends’ </span><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">situation.</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";"> </span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">I know that there is a </span><span style="font-size:10.0pt;font-family:"Verdana", "sans-serif";color:black;background:white;">replication_stop_on_mismatch<span class="yiv0636538194apple-converted-space"> parameter in pgpool conf, but that will disconnect the database from the cluster and we will have to re-attach it (this could happen several times)</span></span><span
style="font-size:12.0pt;font-family:"Times New Roman", "serif";">.</span><span style="font-size:10.0pt;font-family:"Verdana", "sans-serif";color:black;background:white;"></span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";"> </span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">So I was wondering, if there is a more permanent workaround for this. </span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">Is it something we can configure in PGPool?</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">Are there any minimum memory requirements that we could set to avoid this
problem?</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">Would that be in Postgres?</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">Maybe the best option is to dedicate the server to run the database only (?).</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";"> </span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">Thanks in advance for your help and your time.</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";"> </span></div><div class="yiv0636538194MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New Roman", "serif";">Regards,</span></div><div class="yiv0636538194MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman", "serif";">Stelios</span></div></div></div></div><br>_______________________________________________<br>pgpool-general mailing list<br><a ymailto="mailto:pgpool-general@pgpool.net" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br><br><br></div> </div> </div> </div></body></html>