473,574 Members | 3,169 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2029
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1415
by: Mitch | last post by:
Here is the basic scenario: - Configuration data is gathered from Oracle servers then ftp'd to my apache / mysql server. - The apache / mysql server receives the datafile from the Oracle clients and loads the data into a MySQL database. - The webpages are coded using PHP, SQL, and some JavaScript.
4
9335
by: Mark Wilson CPU | last post by:
A colleague has written a prototype program in PHP, using a MySQL database. It's a relatively simple app, with a restricted set of mysql commands used (see below). The MySQL DB is being replaced with an Oracle DB (same schema). My plan 1) globally replace the few mysql commands with intermediate equivalents (such as myDB_connect for...
133
8942
by: jonathan | last post by:
hey all, I realize that this question might pop up from time to time, but I haven't seen it a while and things might of changed, so - Right now (July 2004) how does mysql stand up in comparison to oracle? We are seriously considering migrating our multi-processor oracle system to mysql to save on licensing costs, and would need several...
1
2540
by: Cern | last post by:
Is it somebody out there who has made a migration from an Oracle server to an MySQL server?? The scenario is as simply: I've got a Oracle 8 server with a database with content that I want to transfer to a MySQL database. No special data, constraints etc that MySQL not will handle. My solution is to reverse engineer the database from...
175
11278
by: Sai Hertz And Control Systems | last post by:
Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. What I think is PostgreSQL would have less USP's (Uniqe Selling Points
39
8385
by: Mairhtin O'Feannag | last post by:
Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort of stammering and sputtering, and managed to pull out something I heard a couple of years back - that there was no real transaction safety in MySql....
12
2989
by: timothy.williams | last post by:
Hi. I have a Python program that parses a file and inserts records into a database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my parser runs *really* slow. Writing out to CSV files is fine, but when I try to insert the same records in a MySQL5 database, it slows to a crawl. Using MySQL 4.1 seems fine. The data seems to be...
1
4800
by: The|Godfather | last post by:
Hello, I have a "slight" problem with the mySQL C API. I want to bind vectors for output/input prepared statements. However, the C API does NOT support such data binding. Is there ANY other way to do a bulk-INSERT/DELETE/UPDATE or bulk-SELECT in mySQL C API? I mean, one can do it with a loop, but obiously the goal is to have a higher...
30
2783
by: Einstein30000 | last post by:
Hi, in one of my php-scripts is the following query (with an already open db-connection): $q = "INSERT INTO main (name, img, descr, from, size, format, cat, host, link, date) VALUES ('$name', '$img', '$descr', '$user', '$size', '$format', '$cat', '$host', '$link', '$date')" or die(mysql_error()); And when the query gets executed i get...
0
8234
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7815
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8098
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6452
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5620
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5300
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3740
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2243
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.