I installed asterisk on two machine to load balance and to fail over. One is local and one is on a remote location. 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. 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. 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. I find that also the local db (on the asterisk box, very low load) misses some record. I upped the max_connection to 2000 on mysql but didn't help. What can I check to find out what cause my problem? Thanks Rosario -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050619/26cdd863/attachment.htm