Re: [asterisk-users] Question about core CDR system for multilpe servers
Danny Nicholas schrieb: -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Miguel Molina Sent: Thursday, June 04, 2009 11:01 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Question about core CDR system for multilpe servers 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, This all sounds very nice and do-able, but doesn't this sound like a high-odds scenario for creating a single point-of-failure especially if the 5 machines are all creating a high volume of calls? True - so use a MySQL cluster instead. Chris ___ -- 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
[asterisk-users] Question about core CDR system for multilpe servers
Hi all! Im not sure if it is the correct place but, Ive 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
Re: [asterisk-users] Question about core CDR system for multilpe servers
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-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Gustavo A Gonzalez Sent: Thursday, June 04, 2009 10:23 AM To: asterisk-users@lists.digium.com Subject: [asterisk-users] Question about core CDR system for multilpe servers Hi all! Im not sure if it is the correct place but, Ive 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 ___ -- 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
Re: [asterisk-users] Question about core CDR system for multilpe servers
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-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Gustavo A Gonzalez Sent: Thursday, June 04, 2009 10:23 AM To: asterisk-users@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 ___ -- 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
Re: [asterisk-users] Question about core CDR system for multilpe servers
On Thu, Jun 4, 2009 at 6:42 PM, Jeff LaCoursiere j...@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-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Gustavo A
Gonzalez
Sent: Thursday, June 04, 2009 10:23 AM
To: asterisk-users@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,
a...@iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835
___
-- 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
Re: [asterisk-users] Question about core CDR system for multilpe servers
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 ___ -- 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
Re: [asterisk-users] Question about core CDR system for multilpe servers
This all sounds very nice and do-able, but doesn't this sound like a high-odds scenario for creating a single point-of-failure especially if the 5 machines are all creating a high volume of calls? -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Miguel Molina Sent: Thursday, June 04, 2009 11:01 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Question about core CDR system for multilpe servers Gustavo A Gonzalez escribió: Hi all! Im not sure if it is the correct place but, Ive 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 ___ -- 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 ___ -- 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
Re: [asterisk-users] Question about core CDR system for multilpe servers
Un-top-posting...
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Gustavo A
Gonzalez Sent: Thursday, June 04, 2009 10:23 AM
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!!!
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.
A few snippets from a production script...
# mark the records to be exported
mysql ${USER_AUTH}\
--database example\
--execute=update cdrs set disposition = 'EXPORTING'
# dump the cdrs
mysqldump\
${USER_AUTH}\
--skip-opt\
--no-create-info\
--where=disposition = 'EXPORTING'\
example\
cdrs\
${HOST_DOMAIN}.sql
# compress the dump file
gzip ${HOST_DOMAIN}.sql
mv ${HOST_DOMAIN}.sql.gz ${HOST_DOMAIN}.sql.gz-${DATE}
# scp the compressed dump file
scp ${HOST_DOMAIN}.sql.gz-${DATE} exam...@example.com
# delete the exported records
mysql ${USER_AUTH}\
--database example\
--execute=delete cdrs where disposition = 'EXPORTING'
Thanks in advance,
Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST
Newline Fax: +1-760-731-3000___
-- 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
