Writing Jobs Files to Database Not Files

[Michael Hull]

Hello,

I am new to coding and development. I have a specific goal in mind to create an accounting system with CUPS. One of the first things I want to do is have the "Jobs Files" and "Log Files" (In the high level diagram) logging to a database rather than the file system.

I can't see it too difficult to add the jobs as blobs to a database but I am concerned about performance, will adding another data retrieval layer adversely affect CUPS performance?

I want to do it this way for clustering purposes, rather than clustering CUPS software (Which I realise that I will have to do anyway if your using more than one print server on a site), I think it would be easier to run a database cluster and have multiple independent CUPS front ends. (Hit print on one site, collect on another).

I would appreciate and feedback about this approach and any tips anyone may have.

Thanks,

Michael Hull
Hull Innovations