[RADIATOR] NoSQL databases support

[Leigh Porter]

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: radiator-bounces at open.com.au [mailto:radiator-bounces at open.com.au] On Behalf Of Mike Puchol
Sent: 17 October 2011 10:17
To: radiator at open.com.au
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 
______________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20111017/a5b2da65/attachment.html