asterisk users - Sep 2014 - Realtime ERROR

Hi Guys,

 

I have recently moved my database servers to a different database cluster
that runs on haproxy.

Every minute or so I get the following error in asterisk

 

MySQL RealTime: Ping failed (2006).  Trying an explicit reconnect

 

The strange thing is if I do realtime mysql status

It shows as connected just the timer resets.

 

Any idea why this is occurring?

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20140925/3fe89045/attachment.html>

Am 25.09.2014 um 16:24 schrieb Andrew Colin:
>
> Hi Guys,
>
> I have recently moved my database servers to a different database 
> cluster that runs on haproxy.
>
> Every minute or so I get the following error in asterisk
>
> MySQL RealTime: Ping failed (2006).  Trying an explicit reconnect
>
> The strange thing is if I do realtime mysql status
>
> It shows as connected just the timer resets.
>
> Any idea why this is occurring?
>
>
>
Hi Andrew,

what balancing algorithm you use in haproxy.cfg  ?
balance source
balance roundrobin
or
balance leastconn


-- 
*Rainer Piper*
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: +49 228 97167161 <callto:004922897167161>
P2P: sip:rainer at sip.soho-piper.de:5072 (pjsip-test)
XMPP: rainer at xmpp.soho-piper.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20140925/5ef4a501/attachment.html>