Reputation: 8297
We have a PHP/MySQL application and I want to setup a logging mechanism to log all financial related actions into this table.
I was thinking of a simple file based mechanism, but due to the risk of two instances conflicting with each other, I suppose a database based mechanism would be better.
Can anyone recommend a class / toolkit that can encapsulates simple logging mechanisms, but with a database backend?
Upvotes: 1
Views: 1948
Reputation: 48387
I'm guessing that you want to log changes to data which is stored in a database.
Why not just use the DBMS audit tracking facilities?
(with mysql, just set up a dummy slave to consume the replication logs).
Upvotes: 2