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.

Python, kinterbasdb and 64bit MacOSX 10.5

Now we have 64bit builds of Firebird 2.1 for MacOSX 10.5, we have issues trying to test them properly using the Firebird QMTest QA suite. This QA suite relies on Python and kinterbasdb. Currently Philippe Makowski has been able to run the tests from a 64bit Linux client. But is unable to run the tests locally. Well currently the python framework that comes with MacOSX 10.5 is only 32bit and this forces a 32bit build of kinterbasdb, since the build environment of kinterbasdb uses distutils to use the same compile switches as python. So I thought I would have a look at the issue and see if I could build a 64bit version of kinterbasdb for MacOSX 10.5.

This is how I did it…

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 214 215 216 217 218 294