Difference between MySQL and Oracle? What's better?

  • Cathydoesloans

    SSC Enthusiast

    Points: 103

    Hello all!

    I wanna studying Oracle after a long time working with MySQl..

    Is really really difficult to work with Oracle?

    Does oracle have a lot of difference with Mysql?

    thank for watching!

  • Eric M Russell

    SSC Guru

    Points: 125026

    I'm only somewhat acquainted with Oracle, enough to form an opinion without forming an attachment. In my opinion, Oracle has a lot of "junk in it's trunk" dating back to the 1980s; a lot of cryptic sysadmin commands, old-style SQL syntax, and backward compatibility. In contrast, MySQL is new enough not to suffer from that affliction, and Microsoft periodically deprecates obsolete features from SQL Server (which in my opinion is a good thing). From the perspective of someone coming in new, Oracle's commitment to legacy support is a negative; it makes learning the product more difficult.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • andrew gothard

    SSChampion

    Points: 12296

    To me, they're not really the same thing. MySQL is more of a replacement for xBase than a proper enterprise product, it's certainly nowhere like Oracle or SQL Server in terms of support for critical systems where your data "matters". Obviously though, the price points are also worlds apart.

    MySQL is simpler and regarded as faster due to less overhead for smaller projects. For a Mom n' Pop's corner shop online presence where if the site dies you can rebuild it without breaking into a sweat and no great demands on it, MySQL fits the bill. You wouldn't want them to be storing your medical records in it though (at least I would be horrified at the idea). Certainly a paid license version of Oracle would be colossal overkill and as mentioned above would add both cost and complexity to a small project.

    If your data is "important", frequently updated with minimal dataloss requirements and transactional and referential consistency, that's where Oracle would come in.

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • Luis Cazares

    SSC Guru

    Points: 183573

    andrew gothard (10/3/2016)


    To me, they're not really the same thing. MySQL is more of a replacement for xBase than a proper enterprise product, it's certainly nowhere like Oracle or SQL Server in terms of support for critical systems where your data "matters". Obviously though, the price points are also worlds apart.

    MySQL is simpler and regarded as faster due to less overhead for smaller projects. For a Mom n' Pop's corner shop online presence where if the site dies you can rebuild it without breaking into a sweat and no great demands on it, MySQL fits the bill. You wouldn't want them to be storing your medical records in it though (at least I would be horrified at the idea). Certainly a paid license version of Oracle would be colossal overkill and as mentioned above would add both cost and complexity to a small project.

    If your data is "important", frequently updated with minimal dataloss requirements and transactional and referential consistency, that's where Oracle would come in.

    Or you could start with SQL Server Express (free) and do an easy upgrade to Standard or Enterprise.

    Here's a link (a bit obsolete) that compares different implementations of SQL database systems. http://troels.arvin.dk/db/rdbms/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • ZZartin

    SSC-Dedicated

    Points: 30379

    Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what the database engine is actually doing and the capabilities you have as a dba you'll very quickly realize you're dealing with an actual enterprise application vs. a freeware application. Just look at the differences in how backups/restores are handled between them to get an idea.

  • FridayNightGiant

    SSCertifiable

    Points: 7091

    ZZartin (10/3/2016)


    Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what the database engine is actually doing and the capabilities you have as a dba you'll very quickly realize you're dealing with an actual enterprise application vs. a freeware application. Just look at the differences in how backups/restores are handled between them to get an idea.

    Actually if you use Cloud Control - the latest version of the oracle enterprise manager - then the interface is excellent. You can do pretty much anything without going to the command line.

  • kevaburg

    SSCoach

    Points: 17910

    FridayNightGiant (10/3/2016)


    ZZartin (10/3/2016)


    Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what the database engine is actually doing and the capabilities you have as a dba you'll very quickly realize you're dealing with an actual enterprise application vs. a freeware application. Just look at the differences in how backups/restores are handled between them to get an idea.

    Actually if you use Cloud Control - the latest version of the oracle enterprise manager - then the interface is excellent. You can do pretty much anything without going to the command line.

    Not only that but the newest Version of SQL Developer is quite nifty. I use it alot and even prefer it to some products such as Toad and DBArtisan....and it is free.

    On the other side however, I would recommend learning SQL Server over Oracle. The reasoning here is that more and more companies are making exactly that Switch mainly due to TCO and complexity within the Oracle environment.

    After working with both RDBMSs over the last 15 years I have found the learning curve with SQL Server on Windows to be much easier to master than Oracle on *nix. There are companies and organisations that run Oracle on Windows but that is like playing Tennis with a Badminton racket.....a terrible mix.....

  • Jeff Moden

    SSC Guru

    Points: 994867

    Title of this post:


    Difference between MySQL and Oracle? What's better?

    Answer: SQL Server. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • kevaburg

    SSCoach

    Points: 17910

    Jeff Moden (11/14/2016)


    Title of this post:


    Difference between MySQL and Oracle? What's better?

    Answer: SQL Server. 😉

    and thus start the flame wars.... 😀

  • Jeff Moden

    SSC Guru

    Points: 994867

    kevaburg (11/14/2016)


    Jeff Moden (11/14/2016)


    Title of this post:


    Difference between MySQL and Oracle? What's better?

    Answer: SQL Server. 😉

    and thus start the flame wars.... 😀

    No... no flame wars. Considering that the OP has apparently done zero research on the differences of two very different database engines, I thought I'd throw in a third. We can also throw in NoSQL and a ton of other "engines" because no one engine has everything that might ever occur when it comes to "which is better". The OP even appears oblivious that MySQL has two different engines and, unless you need support, is basically free compared to the rather expensive Oracle.

    I really am concerned for those companies and people where people post such questions. It means they've done zero homework and there's no way that a single thread like this one could actually answer such a question. You're talking about something the company or an individual career is going to need to live with for a long time so trivial answers on a thread such as this should not be a driving factor in what a company or individual chooses but frequently is, and it's frightening.

    Either that or Yabingooglehoo is broke again. 😀

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • kevaburg

    SSCoach

    Points: 17910

    Jeff Moden (11/14/2016)


    kevaburg (11/14/2016)


    Jeff Moden (11/14/2016)


    Title of this post:


    Difference between MySQL and Oracle? What's better?

    Answer: SQL Server. 😉

    and thus start the flame wars.... 😀

    No... no flame wars. Considering that the OP has apparently done zero research on the differences of two very different database engines, I thought I'd throw in a third. We can also throw in NoSQL and a ton of other "engines" because no one engine has everything that might ever occur when it comes to "which is better". The OP even appears oblivious that MySQL has two different engines and, unless you need support, is basically free compared to the rather expensive Oracle.

    I really am concerned for those companies and people where people post such questions. It means they've done zero homework and there's no way that a single thread like this one could actually answer such a question. You're talking about something the company or an individual career is going to need to live with for a long time so trivial answers on a thread such as this should not be a driving factor in what a company or individual chooses but frequently is, and it's frightening.

    Either that or Yabingooglehoo is broke again. 😀

    I know what you mean with you second paragraph. I actually like Oracle alot. It is hideously complex for the same Action in SQL Server most of the time, basic functions like partitioning, spatial and Real Application Testing cost an enormous amount and are only available as add-ons (even though Oracle ships the functions with the Software...) but I learned the most about databases thanks to the need to know and understand the architecture inside out.

    With SQL Server I have found that anyone that can use a mouse and can log on to the database immediately thinks they are an admin (read that for almost every Microsoft product) and they produce the most awful results. There are very few that REALLY put the effort in to learning the concept of a database. This is what I think is most dangerous but then said individuals and companies need to realise that themselves.

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply