RE: Open Source Database Questions
- From: "Matthew Zito" <mzito@xxxxxxxxxxx>
- To: <Richard.Goulet@xxxxxxxxxxx>, <regdba@xxxxxxxxx>, "Oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Jun 2009 11:14:16 -0400
The open-source database options at this point - postgres, mysql, ingres, etc.
all have totally valid use cases in the enterprise today. Basically, Postgres
is the most stable, as Dick says, similar concepts to Oracle, but not nearly as
flexible as MySQL and with fewer features. MySQL offers a couple of different
kinds of replication and clustering, different types of tablespaces,
interchangeable storage engines, etc., but is comparably stable to Postgres.
Ingres is a little more nichey, but definitely workable.
The big differentiation is the amount of community knowledge - there's a lot of
good information on tuning, configuring MySQL out in the wild, and if you
wanted to purchase commercial support for MySQL there's a couple of different
avenues. For PostgreSQL your best bet is to go get EnterpriseDB, which claims
Oracle compatibility, though my understanding is that "compatibility" is
relative.
The reason that they're using JTPCC is that it costs money to have an "audited"
TPC-C run, and non-trivial amounts. Consequently, a lot of open-source
projects can't afford or don't want to try to compete with certified
benchmarks, so instead they use non-audited reimplementations of the various
benchmarks.
Matt
--
Matthew Zito
Chief Scientist
GridApp Systems
P: 646-452-4090
mzito@xxxxxxxxxxx
http://www.gridapp.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Goulet, Richard
Sent: Tue 6/9/2009 11:06 AM
To: regdba@xxxxxxxxx; Oracle-l
Subject: RE: Open Source Database Questions
Peter,
From past experience (which had the same motives) take a serious
look at PostGreSql(http://www.postgresql.org/). The latest versions
have a lot in common with Oracle, though not everything, so it's a lot
easier to transition from one to the other.
Dick Goulet
Senior Oracle DBA
PAREXEL International
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Peter Barnett
Sent: Tuesday, June 09, 2009 10:53 AM
To: Oracle-l
Subject: Open Source Database Questions
Because of the current economy we are being encouraged to consider open
source databases.
One of the vendors has referenced a JTPCC benchmark which is an open
source Java version of TPCC. Has anyone heard of JTPCC? Is it in any
way truly comparable to TPCC? Keep in mind that I am skeptical of TPCC
so this may be a loaded question.
Is anyone currently using open source databases in production? Our
typical database is approximately 200G but the range is 50G to 3.5T.
One of our typical databases has approximately 200 distinct users at any
one time. Any thoughts on a sweet spot for open source databases?
This does all come down to money! I am pretty sure that we will have an
open source database inhouse by year end. The major question is how
best to use it.
Thanks,
Pete Barnett
Database Technologies Lead
Regence
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
