Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can an open source databases like MySQL support my web site's load? [closed]

I'm about to start developing a product (in .NET), and I'm evaluating open source database engines in order to avoid adding licensing costs to the overall cost of my product.

Which ones do you know that are potent? Is MySQL a good alternative? What kind of website load can it support?

Do you have any experience using an open source database in real life projects?

Or do I just need to use Oracle or SQL Server to develop a robust product?

like image 554
juan Avatar asked Dec 29 '08 21:12

juan


People also ask

What is the best open source database for a website?

Much like open source solutions such as WordPress, an open source database will offer you flexibility, scalability, and security at a core level. Even better, tools such as MySQL, MariaDB, PostgreSQL, and Redis are all open source, popular, and supported by many web hosts.

Is MySQL open source?

Is MySQL OpenSource? MySQL Software is an Open-source RDBMS software. The source code of MySQL OpenSources is available under the terms of GNU General Public License, as well as under a variety of proprietary agreements. For Proprietary use, several paid versions are available that offer additional functionalities.

Is MySQL free to use?

You can always download the free version of MySQL that many companies and individuals use for their databases. It is called the MySQL Community edition, the most widely used open-source database in the World. Most web hosting plans don’t even require you to download it, because it is usually included in their package as a bonus.

Is MySQL a good choice for a database?

If performance is one of the main aspects you need in a database, then MySQL is the perfect choice for you. It is designed in a way to provide high-speed usage, especially for those that run their websites on a shared web hosting plan. After all, you don’t want to wait for those load times when the stakes are high.


2 Answers

MySQL is good enough for Flickr, Facebook, Wikipedia, Google, and YouTube to use it (says Wiki) - I'd say they each serve more load than you're likely to reach. I believe WordPress.com - four million+ blogs (stats), including CNN, Time, etc. blogs - also uses MySQL.

Oracle/MSSQL are definitely not required to develop a robust product.

like image 116
ceejayoz Avatar answered Sep 20 '22 18:09

ceejayoz


This wikipedia link should help, it compares most of the big relational databases. http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems Mysql should work fine assuming you write your code properly, it's what wikipedia runs on so should support almost all applications if configured properly and run on good enough hardware/clustering setups.

like image 35
Jared Avatar answered Sep 20 '22 18:09

Jared