Douglas Garstang wrote: > >I personally can tell you I've never had a problem with either the > >PostgreSQL or MySQL cdr apps themselves losing records. However, I can't > >say personally how well the ODBC method works. I'll just stick to saying > >that if you're considering using the cdr_mysql addon, I would highly > >suggest it as I've used it with MUCH success on high load servers. > > Oh... Also... does your system have idle periods? You said your > servers where under high load. The issue seems to be that Asterisk > does not re-establish the database connection after it is disconnected > do to being idle. If you don't have idle periods, you'd never see this > problem anyway. > > ------------------------------------------------------------------------ > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users True, I should have also mentioned that I have used it on low load testing servers and it did not have a problem with reconnecting. Like I said, I haven't used the ODBC method, but the cdr_mysql addon reconnected for me. Currently, however, I'm operating a high load (1K calls per hour or more) server with cdr_pgsql with no keep alive, but as far as I remember I never had to institute a keep_alive of any sort on my other servers. However, don't take this as gold, it's been more than 6 months since I worked with a low load server.
Sherwood McGowan _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
