469,268 Members | 1,032 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,268 developers. It's quick & easy.

mySQL vs Oracle, no problem?

We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.

Are there any particular pitfalls of using mySQL instead of Oracle?

I'm a novice when it comes to evaluting different SQL solutions.

We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.

Data integrity is important, we have once had an MS Access system with
just 1GB data, and frequently discovered that data became corrupted
when data was accessed/written via the LAN.

If mySQL have similar problems or perform very sluggishly or crashes
freqenutly when compared to Oracle, I guess I can't argue for mySQL...
Jul 23 '05 #1
4 1879
Jan Olsen wrote:
We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.

Are there any particular pitfalls of using mySQL instead of Oracle?
Certainly there are some tasks that Oracle products can do, which MySQL
cannot. However, a great majority of projects fall into a category that
both MySQL and Oracle can support successfully. And the price
difference is so great (even assuming you pay for a commercial license
for MySQL) that you should really consider carefully if MySQL can do the
job for you.
We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.


Try reading through the case studies on the MySQL.com web site:
http://www.mysql.com/it-resources/case-studies/

There are quite a few real-world installations that use MySQL for data
volume similar to what you're describing, and where stability is crucial.

No database system can work magic, however. Both Oracle and MySQL--and
any other RDBMS--require good design, good administration practices, and
regular maintenance to keep things running well.

Regards,
Bill K.
Jul 23 '05 #2
Jan Olsen wrote:
We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.

Are there any particular pitfalls of using mySQL instead of Oracle?

I'm a novice when it comes to evaluting different SQL solutions.

We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.

Data integrity is important, we have once had an MS Access system with
just 1GB data, and frequently discovered that data became corrupted
when data was accessed/written via the LAN.

If mySQL have similar problems or perform very sluggishly or crashes
freqenutly when compared to Oracle, I guess I can't argue for mySQL...


Jan,

The key issue you have to resolve is your organization's
priorities. It sounds as though data integrity is the number
one priority. If, when using product X, your database crashes
and you can recover within a satisfactory time (from a business
point of view) that product meets your requirements.

I can't speak for MySQL since I don't know it well enough to
comment.

When it comes to Oracle the ability to take hot back ups used in
conjunction with transaction logging allows very fast recovery.
If needed, and the budget permits, it is possible to set up a
24 by 7 Oracle setup that will probably by 100% available and
will definitely meet 99.999% availability. With Oracle it isn't
cheap, but it is doable.

HTH

Jerry
Jul 23 '05 #3
Jan
In all of this, how does MS SQL compare with mySQL or Oracle? I suppose
perhaps no better than mySQL?

jerry gitomer wrote:
Jan Olsen wrote:
We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.

Are there any particular pitfalls of using mySQL instead of Oracle?

I'm a novice when it comes to evaluting different SQL solutions.

We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.

Data integrity is important, we have once had an MS Access system with
just 1GB data, and frequently discovered that data became corrupted
when data was accessed/written via the LAN.

If mySQL have similar problems or perform very sluggishly or crashes
freqenutly when compared to Oracle, I guess I can't argue for mySQL...


Jan,

The key issue you have to resolve is your organization's
priorities. It sounds as though data integrity is the number
one priority. If, when using product X, your database crashes
and you can recover within a satisfactory time (from a business
point of view) that product meets your requirements.

I can't speak for MySQL since I don't know it well enough to
comment.

When it comes to Oracle the ability to take hot back ups used in
conjunction with transaction logging allows very fast recovery.
If needed, and the budget permits, it is possible to set up a
24 by 7 Oracle setup that will probably by 100% available and
will definitely meet 99.999% availability. With Oracle it isn't
cheap, but it is doable.

HTH

Jerry


Jul 23 '05 #4
Jan wrote:
In all of this, how does MS SQL compare with mySQL or Oracle? I suppose
perhaps no better than mySQL?

jerry gitomer wrote:
Jan Olsen wrote:
We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.

Are there any particular pitfalls of using mySQL instead of Oracle?

I'm a novice when it comes to evaluting different SQL solutions.

We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.

Data integrity is important, we have once had an MS Access system with
just 1GB data, and frequently discovered that data became corrupted
when data was accessed/written via the LAN.

If mySQL have similar problems or perform very sluggishly or crashes
freqenutly when compared to Oracle, I guess I can't argue for mySQL...


Jan,

The key issue you have to resolve is your organization's
priorities. It sounds as though data integrity is the number
one priority. If, when using product X, your database crashes
and you can recover within a satisfactory time (from a business
point of view) that product meets your requirements.

I can't speak for MySQL since I don't know it well enough to
comment.

When it comes to Oracle the ability to take hot back ups used in
conjunction with transaction logging allows very fast recovery.
If needed, and the budget permits, it is possible to set up a
24 by 7 Oracle setup that will probably by 100% available and
will definitely meet 99.999% availability. With Oracle it isn't
cheap, but it is doable.

HTH

Jerry



Jan,

If you are talking about a "You bet your company" database you
are probably best off using Oracle or DB2 and getting one of the
more expensive service agreements. The reason is that sooner or
later you will have problems that require substantial vendor
support. I have experience with all three companies and, IMHO,
Oracle and IBM both have better support than Microsoft.

HTH
Jerry
Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mark Wilson CPU | last post: by
133 posts views Thread by jonathan | last post: by
175 posts views Thread by Sai Hertz And Control Systems | last post: by
39 posts views Thread by Mairhtin O'Feannag | last post: by
12 posts views Thread by timothy.williams | last post: by
1 post views Thread by The|Godfather | last post: by
30 posts views Thread by Einstein30000 | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.