I agree that any SQL solution for storing accounting and logs is somewhat crazy
when you get a little busy. We store up to one weeks accounting logs in an SQL
database for billing and customer care but all other logs (i.e. data retention
for law enforcement) are stored as gzip text files in a hierarchical directory
tree on a NFS mount. It makes searching a bit time consuming, but scripts do
all the work for us.
I'll have a look at Mongo though as it would be handy to be able to index say
the IP addresses..
--
Leigh Porter
From: [email protected] [mailto:[email protected]] On
Behalf Of Mike Puchol
Sent: 17 October 2011 10:17
To: [email protected]
Subject: [RADIATOR] NoSQL databases support
Greetings,
I have started looking into NoSQL solutions (mentioned in a recent thread) for
storage of accounting data & other logging details, as storing them in SQL is
wasting space and ending up with huge tables that take eons to sift through.
My choice so far is MongoDB, and here is some info on Perl driver & tools to
support it:
http://www.mongodb.org/display/DOCS/Perl+Language+Center
I'd like to share experiences with anyone trying to go this route too.
Cheers,
Mike
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
