Oracle advantages over MySql?

Question

what are the advantages of Oracle over Mysql database? Can I make a search engine with billions of data with Mysql?(If not why and what should I do?)

Answer 1

Oracle is much versatile than MySQL. Oracle can run and handle more transactions than MysQL. Oracle would be better if you are going to have lots of db usage.

I've used MySQL. Only for a forum. Still, MySQL takes up resources with PHP that affected the server load. Oracle on the other hand is better with memory leaks and handles multiple threads. You can do SQL Transactions, stored procedures, DTS in Oracle that you can not do in MySQL earlier versions.

Oracle is expensive, although they came out with Oracle Free Edition to attract MySQL users.

MySQL users enjoy this database because it is available on virtually all hosting companies. Oracle are only limited to large corporations due to licencing costs and not all hosting companies have Oracle (they might have SQL Server, but not Oracle).

You can make billions of data with MySQL, but it will be slow on the server. In addition, backing up the MySQL database takes forever, versus Oracle's tools which makes database backup a cinch.

If you are going to use MySQL, then add lots of memory. In addition, I recommend that you seperate the Website from the database. In other words, have emails and website on a seperate server and only have a dedicated MySQL server specific to mysql/db only.

MySQL is Free, It's everwhere, that's the whole concept!!!

Good luck!

-Jack
[e-mail]

Answer 2

Oracle is much versatile than MySQL.
Oracle can run and handle more transactions than MysQL.
Oracle would be better if you are going to have lots of db usage. I've used MySQL.
Oracle is expensive, although they came out with Oracle Free Edition to attract MySQL users.

Answer 3

I think that this all depends on what you are trying to do.

Oracle gives you a LOT more tools to do a lot more things then MySql. I don't know the upper limit of MySql, but if you are going to hold a LOT of critical data, I would go with Oracle. I would use Oracle for large applications. Oracle costs a lot of money, which is why I'd only use it for the big stuff.

SQL Server might be an option, and I think for mid to large-sized applications that it works really well.

MySql works great for mid to small applications. I don't know the size restrictions, but things like Full-Text indexing, and replication aren't available to my knowledge using MySql.

Answer 4

MySQL=loose till you take advantage of it in a advertisement surroundings. MySQL is tremendous for light-weight applications. In some places there are lacking valuable residences. after I regarded at it many years in the past i idea that such issues as ROLLBACK were lacking yet they seem to were further now. Oracle=very intense priced yet might want to be in a position to run the most stressful application.

Answer 5

Yes, I think it is possible. A real example is google.com, as far as I know they use MySql if I am wrong let me know.
By the way, oracle comes with many additional utilities plus development tools and part from that since it is propriety software they have good customer care and help.