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

[Shahid Tel]

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 <mmolina at 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 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
>
>
> _______________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090708/dc9d5f4d/attachment.htm