Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

database selection help requested

4 views
Skip to first unread message

mark

unread,
Apr 29, 2009, 7:25:40 AM4/29/09
to
Hi All,
I have been asked to investigate the possibility of replacing our current
flat-file logging process with a database solution. The database will reside
in an enterprise that contains approximately 20 servers and the db will be
the logging destination for all these servers. The 20 servers will send
approximately 2.3 million write requests per day with a peak load of about
950 writes requests/second. Also, I estimate that the total data storage
will be about 60 GBytes per day.
I was asked to investigate an open source solution, such as one of the open
source db's running on Linux. However, this is not a deal breaker as we do
currently use DB2 and Oracle in house today.
Does anyone have any suggestions that may steer me to or away a particular
database?
TIA


Sabine Dinis Blochberger

unread,
May 5, 2009, 5:40:45 AM5/5/09
to
mark wrote:

As a gut feeling I would recommend PostgreSQL[1] over MySQL[2]. MySQL is
very popular, but I read about some quirks that dissuade me from using
it in our company.

We did use PostgreSQL for a bit, but back then it didn't support UTF-8
on Windows well, so we switched to FirebirdSQL[3]. FirebirdSQL is very
good, but there's not as much information to be found online, and so
it's a little more hassle sometimes.

[1]<http://www.postgresql.org/>
[2]<http://www.mysql.com/>
[3]<http://www.firebirdsql.org/>

0 new messages