[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Mysql vs Oracle

Posted on 2016-07-16
10
Medium Priority
?
209 Views
Last Modified: 2016-08-04
Hello Experts,
Our customer needs to distribute a small app to several distant locations....
Now this app will have a database...
1) Which is the best database to distribute many times (like little less than a hundred )
2) Is it ok to consider Oracle and MySQL as the top databases in the world for medium and small apps for distribution ?
3) which database would you suggest for easy remote instalation and implementation as well as maintenace?

regards,
0
Comment
Question by:RGuillermo
  • 3
  • 3
  • 2
  • +2
10 Comments
 
LVL 1

Expert Comment

by:Gene Klamerus
ID: 41714914
You can't just distribute oracle.  It's a licensed DB.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 41715033
0
 
LVL 1

Expert Comment

by:Gene Klamerus
ID: 41715776
Ah thanks.  Didn't realize that existed.

What OS is this for?  That's relevant to the discussion.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41715793
Any os oracle supports
0
 
LVL 1

Expert Comment

by:Gene Klamerus
ID: 41715847
Yes, the question what was cost effective and if the target is Windows then there's probably a value in considering SQL Server.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41715862
Indeed, as sql server express version also exists.
Like oracle and mysql, the "free" versions come with limitations that need to be clearly studied before choosing
0
 

Author Comment

by:RGuillermo
ID: 41715994
Hi thank you for your answers,
I am seeing the main limitations for Oracle XE are

11GB of data and 1 GB Ram.... no hard limit for user connections..
Is there any other important limitation?
Thank you
0
 
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 41716052
>>Is there any other important limitation?

CPU.

...
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.
...

http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html
0
 
LVL 14

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 41716366
Any os oracle supports
BUT not any architecture ;-) E.g. ARM based systems like Raspberry devices
0
 

Author Closing Comment

by:RGuillermo
ID: 41743676
Thanks to all Experts very much !!!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question