Oracle DB Vs MySQL for Enterprise DataBase Deployments

Oracle DB is big, and expensive, but it brings a lot to the "table" when compared with MySQL.

MySQL has limited ability to audit.

MySQL's security is unsophisticated. There are no groups or roles, no ability to deny a privilege (you can only grant privileges). A user who logs in with the same username and password from different network addresses may be treated as a completely separate user. There is no built-in encryption comparable to Oracle.

MySQL's Authentication is built-in. There is no LDAP, Active Directory, or other external authentication capability.

MySQL has no MPP (massively parallel processing ) support.

Unlike Oracle MySQL has no fractional-second storage type for times, dates, or intervals.

There is no RAC (Real Application Cluster) support in My SQL, and no failover or server promotion either. These are strong features in Oracle

MySQL's number of joins per query is limited to 61. Oracle's limit is much larger.

MySQL Replication is asynchronous and has many limitations and edge cases. For example, it is single-threaded, so a powerful slave can find it hard to replicate fast enough to keep up with a less powerful master.

Category:

Science & Technology

Tags:

• Oracle
• DB
• ORACLEDB
• mysql
• sql
• data
• base
• database
• Technology
• System
• enterprise
• scale
• scaling
• scalability
• RAC
• ADS
• active
• directory
• services
• Security
• Management
• replication
• cluster
• clustering
• business
• deployment
• asynchronous
• massively
• parallel
• processing
• MPP
• LDAP
• dba
• administration
• administrator

[mrhypermagnetic]

Thanks for making this video. What are some hosting providers that use oracle and can wordpress or drupal be installed using this type of dbs? thanks in advanced.

[BlackwaterOpsDotCom]

@mrhypermagnetic MySQL is no long SQL compatible. There are branches of WP that run on Oracle, but I can't imagine you have a site large enough that the support headaches would off set the scalability benefits.

[4urge]

What database does YouTube use? if it's MySql their database has to atleast be 500k terabytes

[BlackwaterOpsDotCom]

@4urge ROFLMFAO  Google GQL/DataStore

[sinistar99]

@BlackwaterOpsDotCom THat's a big acronym. I bet you were just LMFAO... :)

[BlackwaterOpsDotCom]

@sinistar99 Well I was actually Face Palm Head Shake LMFAO but Didn't figure anyone would would know what FPHSLMFAO was.

[memo430]

thank you so much, it's very useful

[mrhypermagnetic]

@BlackwaterOpsDotCom Thanks for the speedy response. Im always learning and greatly appreciate all your videos. I just installed PostgreSql on my windows machine. Going to tamper around with RoR and Java...would be cool to see a video by you comparing the many languages and best use scenarios for each.

Thanks Again.

[MrOprea3]

-great presentation .

- and who cares about the shirt ,people can be really stupid .

thank you once again

[Zeus13345]

who else notices he wears the same shirt each video