asterisk users - Oct 2006 - CDR stats to one mysql database, multiple webstats packages

Have a number of asterisk servers and want to get some good stats tracking
going (with Asterisk-Stat) -- but this requires cdr logging to mysql, apache
and the stats software running on each server.

Or does it?  Of course, I can either run the stats package on the webserver
and direct it to each individual server's local mysql db --- or have each
asterisk server logging to an external mysql db somewhere.....(on the
webserver I suppose)

Thoughts on this?  Good idea/Bad idea to log to an external source?  One
thing that might be an issue is if for some reason the external source
becomes unreachable or goes offline ...then what happens to the CDR data for
that time period?

Suggestions appreciated

--
Chris

In article <efujg7$qbi$1@sea.gmane.org>, cearle@cbltech.ca
says...
> Have a number of asterisk servers and want to get some good stats tracking
> going (with Asterisk-Stat) -- but this requires cdr logging to mysql,
apache
> and the stats software running on each server.
> 
> Or does it?  Of course, I can either run the stats package on the webserver
> and direct it to each individual server's local mysql db --- or have
each
> asterisk server logging to an external mysql db somewhere.....(on the
> webserver I suppose)
> 
> Thoughts on this?  Good idea/Bad idea to log to an external source?  One
> thing that might be an issue is if for some reason the external source
> becomes unreachable or goes offline ...then what happens to the CDR data
for
> that time period?
> 
> Suggestions appreciated
Hi Chris!

I have three Asterisk and every one of them is logging CDR's to MSSQL
database that is on same location (same room) as Asterisk. So, there is only
switch between them. Two of three MSSQL servers are doing log shipping on third
MSSQL server on new database. That way every * logs to database which is close
to him - should be stable enough. Because of secure log shipping I have all data
from every Asterisk in one database. I calculate everything from that one
database.

Hope this helps.

P.S.
If any MSSQL fails, then I import data from Master.scv


--
Tomislav Par?ina
Lama Computers Split
Stinice 12, 21000 Split
Tel.: +385(21)495148
Mob.: +385(91)1212148
SIP: tomo@sip.lama.hr
e-mail: tparcina#lama.hr
http://www.lama.hr