RAID 10 performance tradeoffs and firebird

I have been configuring a fair number of Linux database servers for a line-of-business application; it runs the Firebird SQL database in server mode only (no application code at all – just DB).

All of these are the wonderful Dell PowerEdge 2950 units with the PERC6i RAID controller, and my typical configuration is 6x 146G 15k SAS drives. These are the highest-performance, highest capacity solution in 3.5″ drives.

Generic Database Output Module for rsyslog

An introductory article about using the new Generic Database Output Module

This modules supports a large number of database systems via libdbi. Libdbi abstracts the database layer and provides drivers for many systems. Drivers are available via the libdbi-drivers project. As of this writing, the following drivers are available:

rsyslog 3.11.2 (Development) with firebird support added

Rsyslog is an enhanced multi-threaded syslogd. Among other features, it offers support for on-demand disk buffering, reliable syslog over TCP, writing to MySQL and PostgreSQL databases, fully configurable output formats (including great timestamps), the ability to filter on any part of the syslog message, and on-the-wire message compression. It is designed as a drop-in replacement for stock syslogd and thus is able to work with the same configuration file syntax. Of course, some enhanced features require changing the configuration file, but in general, this should be fairly easy.

Release focus: Major feature enhancements

1 12 13 14 15 16 18