<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style id="owaParaStyle" type="text/css"></style>
</head>
<body ocsi="0" fpstyle="1" bgcolor="#FFFFFF">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Hi Alex,<br>
<br>
I think one problem was a stonith device that did a reboot only and as you said, there was no alarm.<br>
Now there is a Nagios check that look for the nodes states via pcp_node_info ;) <br>
<br>
Thank you.<br>
Klaus<br>
<br>
<br>
<br>
<div style="font-family: Times New Roman; color: rgb(0, 0, 0); font-size: 16px;">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF66775"><font face="Tahoma" color="#000000" size="2"><b>Von:</b> pgpool-hackers-bounces@pgpool.net [pgpool-hackers-bounces@pgpool.net]" im Auftrag von "alex [alex@smalldemons.com]<br>
<b>Gesendet:</b> Donnerstag, 8. November 2012 18:19<br>
<b>An:</b> pgpool-hackers@pgpool.net<br>
<b>Betreff:</b> [pgpool-hackers: 154] Re: persisting pgpool status<br>
</font><br>
</div>
<div></div>
<div>
<div class="moz-cite-prefix">I think the problem you should be trying to solve is that you didn't know about the failover.<br>
<br>
You have several options for monitoring that. I have the failover_command in pgpool.conf send an alert as well as perform the failover. In case that somehow doesn't make it through, I have another script tailing the pgpool logs for "health_check: (\d+) th
DB node status: (\d)$" and if the second number isn't 2, it sends an alert. It also makes sure the health check is in the last two minutes, which assures me the health checks are running. You could get the same information from pcp_pool_status if you'd prefer
to monitor remotely through Nagios or something.<br>
<br>
<br>
alex<br>
<br>
<br>
On 11/8/12 12:57 AM, Meister, Klaus wrote:<br>
</div>
<blockquote type="cite"><style>
<!--
@font-face
        {font-family:"Cambria Math"}
@font-face
        {font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline}
span.E-MailFormatvorlage17
        {font-family:"Calibri","sans-serif";
        color:windowtext}
@page Section1
        {margin:70.85pt 70.85pt 2.0cm 70.85pt}
-->
BODY {direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;}P {margin-top:0;margin-bottom:0;}BODY {scrollbar-base-color:undefined;scrollbar-highlight-color:undefined;scrollbar-darkshadow-color:undefined;scrollbar-track-color:undefined;scrollbar-arrow-color:undefined}</style>
<div class="Section1">
<p class="MsoNormal">Hi pgpool-hackers,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">we are using pgpool2-3.1.3 in a productive environment with streaming replication.</p>
<p class="MsoNormal">For the single point of failure pgpool we have a corosync/pacemaker configuration on each database machine.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Once we had an automatic failover (because of a network failure) wich worked fine but which we did not realize!(?)</p>
<p class="MsoNormal">2 weeks later there was another failover (wich worked fine too :) and we were back on the obsolete database which was still up and open.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">To prevent this we are planning to use the pgpool_status file on a shared storage and use it on startup/failover/switchover …</p>
<p class="MsoNormal">This file seems to be written only in case of cleanly stopping the ppool.</p>
<p class="MsoNormal">I think it would be useful to do this every time the status of a node is being changed.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Maybe is there another recommended way to solve our problem.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">With kind regards</p>
<p class="MsoNormal">Klaus Meister</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-- </p>
<p class="MsoNormal">Dipl.-Phys. Klaus Meister</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Datenbankadministrator</p>
<p class="MsoNormal">mecom Medien-Communikations-Gesellschaft mbH</p>
<p class="MsoNormal">Mittelweg 143</p>
<p class="MsoNormal">D 20148 Hamburg</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Tel: +49 40 4113-32824</p>
<p class="MsoNormal">Fax: +49 40 451962</p>
<p class="MsoNormal">Web: <a class="moz-txt-link-rfc2396E" href="http://www.mecom.de/" target="_blank">
<http://www.mecom.de/></a></p>
<p class="MsoNormal">Registergericht Hamburg, HRB 43177</p>
<p class="MsoNormal">Geschäftsführer: Ulrich Wiehsalla, Barbara Bliefert</p>
<p class="MsoNormal">--------------------------------------------------------------</p>
<p class="MsoNormal">Sollten Sie nicht der beabsichtigte Empfänger sein, </p>
<p class="MsoNormal">informieren Sie bitte den Absender dieser E-Mail entsprechend.</p>
<p class="MsoNormal"> </p>
</div>
<br>
<fieldset class="mimeAttachmentHeader" target="_blank"></fieldset> <br>
<pre>_______________________________________________
pgpool-hackers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-hackers@pgpool.net" target="_blank">pgpool-hackers@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</body>
</html>