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