[asterisk-users] Question about core CDR system for multilpe servers

[Atis Lezdins]

On Thu, Jun 4, 2009 at 6:42 PM, Jeff LaCoursiere <jeff at jeff.net> wrote:
>
>
> On Thu, 4 Jun 2009, Danny Nicholas wrote:
>
>> Do you want a "live repository" or just a common gathering of the data?  If
>> LR then you should set up a deamon on each box to transfer records as they
>> occur using something like the DBI functionality of PERL.  If not, then just
>> do a mysql dump periodically and ssh the files to the common server.
>>
>> -----Original Message-----
>> From: asterisk-users-bounces at lists.digium.com
>> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Gustavo A
>> Gonzalez
>> Sent: Thursday, June 04, 2009 10:23 AM
>> To: asterisk-users at lists.digium.com
>> Subject: [asterisk-users] Question about core CDR system for multilpe
>> servers
>>
>> Hi all! I?m not sure if it is the correct place but, I?ve five boxes running
>> asterisk and each one with his own cdr mysql database. What Im looking for
>> is to get a core CDR system that holds information stored on each asterisk
>> server. Have you any suggestion/process to accomplish that?. Thanks!!!
>>
>> Gustavo A. Gonz?lez
>>
>
> How about just configuring cdr_mysql.conf to connect to the one machine
> you want to collect the records?  No need to keep them on all the machines
> and have some complex copying setup...
>

Exactly my point.

There's a system name (or something similar) option in asterisk.conf
which would prepend system name to ${UNIQUEID}, so You just have to
make sure that uniqueid is enabled in cdr_addon_mysql, so each CDR in
database will be marked from specific system.

However I would suggest not doing heavy SELECT's on this database, set
up another slave for reports, as each table lock will cause asterisk
posting a CDR to wait (and current call posting a CDR will wait in
silence)

Regards,
Atis

-- 
Atis Lezdins,
VoIP Project Manager / Developer,
IQ Labs Inc,
atis at iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835