Thanks Miguel Molina :) I was bit curious about that as I am using few asterisk boxes connected to a mysql server. And that mysql server sometimes gets lots of connections from other sides ( other than asterisk boxes) . So if asterisk-mysql holds dedicated persistant connection , it means cdr are being pushed to database as in normal way.
On Wed, Jul 8, 2009 at 5:27 AM, Miguel Molina <mmol...@millenium.com.co>wrote: > Shahid Tel escribió: > > Hi Guys, > > As it looks like from CLI command " show cdr mysql " , can somebody > confirms that cdr-mysql creates persistent connection with in asterisk? > > " show cdr mysql " shows " connected to u...@dbhost from 18 hours ......." > > > Yes, the MySQL CDR addon creates a persistent connection to the database. > If the database server goes down, the addon tries to reconnect so if it > succeeds no records are lost or only a few, I'm not sure. The addon won't > die, neither asterisk. For example: > > "cdr mysql status" CLI command shows me this: > > Connected to <user>@<IP>, port 3306 using table <table> for 19 days, 19 > hours, 32 minutes, 2 seconds. > Wrote 4256045 records since last restart and 294847 records since last > reconnect. > > Restart is the last asterisk restart. Last reconnect, is the last time the > connection went down and reconnected because the server went down or you > killed the connection from the MySQL monitor. So if for any reason you need > to do a quick restart of MySQL, you won't lose CDR records if no calls are > hungup during the MySQL restart cycle. > > Cheers, > > -- > Ing. Miguel Molina > Grupo de Tecnología > Millenium Phone Center > > > _______________________________________________ > -- 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 >
_______________________________________________ -- 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
