[RADIATOR] MongoDB \ Accounting

[Joe Hughes]

Hi

Simple question really.

I want to introduce MongoDB as a "test" server for storing accounting and
session data.

We currently use MSSQL, it works well, but the large amount of data (and
related joins into other data islands) can become unwieldy over time -
especially for historic reporting. I have done some work with MongoDB and
other systems (with relatively straight forward schemas), and storing
accounting\session seems well suited for this.  Don't get me wrong, its not
that MSSQL\MySQL aren't up to the task, I just think this is well suited
for NoSQL and I am keen to satisfy my technical curiosity..

I am considering the best ways of getting the accounting data from our
RADIUS servers \ SQL databases into MongoDB.

Looking for some feedback\comments.

Some options;

a) Write a accounting hook to break apart the accounting message, construct
a JSON request and send it off to a remote application server. * Downside
is the risk of blocking\disrupting the main process.

b) Spool the messages to disk, have an out-of-process script parse the
files, construct a JSON (or MongoDB request) , send it to a remote server
and delete the file. Downside is some disk\write IO, nothing too taxing. *
Out of process = good.

c) At the DB level, clone the accounting messages into another table.
Script reads the rows, processes as above, then deletes the rows. * Some
extra DB load.

d) Possibly silently forwarding (or replicating) the accounting message to
another server and doing one of the above

Anything I have missed. I am leaning towards b) or c)

Is anybody else using NoSQL for this type of application? Any feedback?

Regards

Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20130728/28bd456d/attachment.html