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-boun...@open.com.au [mailto:radiator-boun...@open.com.au] *On > Behalf Of *Mike Puchol > *Sent:* 17 October 2011 10:17 > *To:* radiator@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@open.com.au > http://www.open.com.au/mailman/listinfo/radiator _______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
