[asterisk-users] asterisk addon mysql - is mysql connection persistent

[Miguel Molina]

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 user at dbhost 
> <mailto:user at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090707/1dfb8976/attachment.htm