DBD2 inserts database records from TCP input. It is a companion project to Syslgod2 and an application in its own right.
It ships with a backgrounding client for generic use. The client sends whatever information the user puts on the command-line to the back-end daemon via TCP. Upon successful transmission, the client exits. On failure, it backs off and retries until its life-time timer expires.
The back-end daemon accepts data from Syslogd2 or its own client and inserts that data (and envelope information) into one or more databases using MySql client library or dbi drivers (also on SourceForge).
The client needs no configuration (all input is via command-line). It is intended for hosts to make database entries without needing database client or interface code.
Syslogd2 integration allows DBD2 to act as Syslogd2's database back-end for MySql and other databases supported by the dbi drivers.
Original purpose was to track Linux cluster job status but other uses exist.
Features
- Multi-threaded server supports user-defined SQL to multiple databases.
- Backgrounding client provides light-weight interface for remote hosts
- Designed to provide high-speed throughput for logging / tracking databases.
- Multi-Home -- Multiple host interfaces allow database updates via private vlan.
- Project is usable now with MySql client library. Needs stress-testing and validation for production status.