<div>Thanks Miguel Molina :)<br><br>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.</div>
<div><br><br> </div>
<div class="gmail_quote">On Wed, Jul 8, 2009 at 5:27 AM, Miguel Molina <span dir="ltr"><<a href="mailto:mmolina@millenium.com.co">mmolina@millenium.com.co</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div text="#000000" bgcolor="#ffffff">Shahid Tel escribió:
<div class="im">
<blockquote type="cite">
<div>Hi Guys,<br><br>As it looks like from CLI command " show cdr mysql " , can somebody confirms that cdr-mysql creates persistent connection with in asterisk?<br><br>" show cdr mysql " shows " connected to <a href="mailto:user@dbhost" target="_blank">user@dbhost</a> from 18 hours ......."</div>
<div> </div></blockquote></div>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:<br>
<br>"cdr mysql status" CLI command shows me this:<br><br>Connected to <user>@<IP>, port 3306 using table <table> for 19 days, 19 hours, 32 minutes, 2 seconds.<br> Wrote 4256045 records since last restart and 294847 records since last reconnect.<br>
<br>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.<br>
<br>Cheers,<br><pre cols="72">--
Ing. Miguel Molina
Grupo de Tecnología
Millenium Phone Center
</pre></div><br>_______________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" target="_blank">http://www.api-digital.com</a> --<br><br>asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br>