<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2668" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I installed asterisk on two machine to load balance
and to fail over. One is local and one is on a remote location.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The record the cdr I use the mysql module and odbc.
So I update a local (on each asterisk box) mysql db using mysql module and also
I update a centralized mysql db using ODBC.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I tought in this way I couldn't loose any record.
But this is not true. Even with 2 updating process I loose around 1%-2% of the
records. I'm still in a testing enviroment so it is not a problem........but
asap i will be in production.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have a cdr report from my upstream and also I log
the sip INVITE ACK and BYE messages so I am pretty sure that the reports from my
upstream is accurate and my mysql cdr misses some record.</FONT></DIV>
<DIV><FONT face=Arial size=2>I find that also the local db (on the asterisk box,
very low load) misses some record.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I upped the max_connection to 2000 on mysql but
didn't help.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What can I check to find out what cause my
problem?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks</FONT></DIV>
<DIV><FONT face=Arial size=2>Rosario</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>