asterisk users - Jun 2009 - 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

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




_______________________________________________
-- 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

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...

j

Gustavo A Gonzalez escribi?:
> 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
>
>   
Well, this sounds fairly simple. Can you do it by configuring each 
asterisk server (cdr_mysql.conf) to connect to the same MySQL core 
database server. Inside it, you can have each server CDR in a separate 
database, or in a single database for all of them using different table 
names. How to configure it, depends on performance inside the MySQL 
server, and how do you want to store the information. Maybe is not a 
good idea to have all the CDRs on the same database if the tables are 
going to be too big. But having all of them in a single database server, 
shouldn't be a problem.

Cheers,

-- 
Ing. Miguel Molina
Grupo de Tecnolog?a
Millenium Phone Center