Been watching this thread with interest, being a database person myself.
Asking for a database recommendation is a pretty dangerous thing to do :
debates can get just about as heated as those over preferred editor or
In many ways, the choice of DBMS comes down to two things -
- Experience (folks choose what they know and are comfortable with)
- Money (how much you are prepared to spend for the product and
I am not a MySQL person myself (my preferred DBMS is IBM’s DB2, and for
my preferred operating platform is Linux). Â I have used it on occasion,
as I have been exposed to Oracle, MS SQL Server, Sybase, Informix and
my years in the field.
My recommendation to you is that if you are generally comfortable with
then that would be where you should stay. Â The obvious advice would be
raise a problem report with MySQL support. Â I would not advise anyone
running a 24x7 database which is critical to the life of their business
run without some sort of support contract. Â I’m sure that MySQL support
would help diagnose your problem.
If you do want to consider a change, then you have the opportunity to
almost all of the databases currently available, albeit unsupported, for
these days. Â Â That’s true for DB2 (Express-C), Oracle (Express Edition)
SQL Server (Express Edition). Â But be aware that there all of these
editions have limitations on their use, some more restrictive than
The basic details of these are -
DB2 Express-C : server can have maximum of 2 processors (these can be
multi-core however) and 4 gig of RAM. Â No limit on database size
Oracle Express : server can only have 1 processor (again multi-core) and
of RAM. Â Database is limited to 4 gig in size. Â Only one database
server. Â Also no 64-bit support (e.g. AMD64 or EM64T).
SQL Server Express : will only use one CPU on a server. Â 1 gig of RAM
4 gig maximum database size. Â And, of course, only available on Windows
I think you will agree the DB2 Express-C is much less restricted than
others. Â Â I can thoroughly recommend it as an excellent platform for
operations. Â It runs beautifully on Linux, and especially on an x64-64
(AMD64 or Intel Xeon with EM64T) platform.
I’m giving a presentation in May at IDUG (http://www.idug.org) on using
with Ruby on Rails. Â It is nearly finished (the final version is due in
than a fortnight) and if any wants to help me review it then drop me
email. Â It goes through in some detail using the ibm_db2 adaptor from
Alphaworks. Â Â It doesn’t show you how to install DB2, since my audience
know this, but I can help there if you want : given a Linux box, an SSH
connection and a root password my record for going from tarball to
DB2 system, including sample database, is 12 minutes.
Anyway, as I said before : stay with what you know if you can resolve
issue. Â If you want to look elsewhere you could do a lot worse than DB2