[RADIATOR] NoSQL databases support

[Michael]

I use monthly tables for sql accounting.  works good for me.

ie. AccountingTable `acct_%f%g` for the AuthSQL

So, as the month changes, radiator starts to insert into a different table.  Of course, you have to have these tables created before the month starts.  A quick script and a cron job handles this to make sure the tables are created a few months ahead of time.  Also makes it easy to rotate out and archive old data (ie. old sql tables).


Michael




On 11-10-17 05:43 AM, Leigh Porter wrote:
> 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
> ______________________________________________________________________
>
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator