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
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
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
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
On Thu, Jun 4, 2009 at 6:42 PM, Jeff LaCoursiere 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
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
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
[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