Chaps, I am thinking about writing a database Audit logger - bouncing some ideas here:
The rationale for doing this is that we plan to keep all message audit data (for compliance/legal reasons) and we have the infrastructure around our database servers to deal with this kind of data volume (archiving, data retention, filesystem space, etc).
Current Audit manager is pretty intimately tied to XML fileystem logs
Doesnt seem to be a simple way to “plug” a new one in without changing XMPPServer code
As am implementation, I am not so keen on batching messages up - would just an asynch write (ala SingleThreadScheduledExecutor) be enough (for xml and database Auditor)? Would reduce memory footprint. Have I missed a detail here?