asterisk users - Jul 2009 - asterisk addon mysql - is mysql connection persistent

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 from 18
hours ......."
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20090708/6dbb7880/attachment.htm

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