如MySQL的开源数据库能够支持我的网站的负载？ [英] Can an open source databases like MySQL support my web site's load?
问题描述
我要开始开发产品（以.NET），而且我评价的开源数据库引擎，以避免增加许可费用我公司产品的整体成本。
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.
哪些是你知道是有效的？是MySQL的一个很好的选择？它可以支持什么样的网站加载的？
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?
还是我只需要使用Oracle或SQL Server开发一个强大的产品？
Or do I just need to use Oracle or SQL Server to develop a robust product?
推荐答案
MySQL是不是你想象的那么便宜。
MySQL is not as cheap as you think.
这是使用MySQL花在保持它的运行相当多的资源，往往有自己开发的扩展大组织之参与。已经有从MySQL内部人士对自己产品的质量差一些最近的文章。我一直的MySQL的用户数年释放的质量了所有权变更为SUNW后，precipitous下降。
The big orgs that use MySQL spend considerable resources on keeping it running and often have to develop their own extensions. There have been several recent articles from MySQL insiders about the poor quality of their product. I've been a user of MySQL for several years and the quality of releases took a precipitous drop after change in ownership to SUNW.
我知道的MySQL可以优化并使其运行良好，但我不是一个DBA和不能对我的所有项目的DBA。我有几个非常复杂的查询，有时会导致系统内存耗尽。我目前在全球迁移我的系统到SQL Server防爆preSS的过程。测试查询的SQL Server防爆preSS显著更快的运行速度比他们做的MySQL。如果你不是很强大的数据库，需要一个强大的和快速的系统，我不会使用MySQL。 SQL Server的防爆preSS是由多为开发人员提供的数据库马路中间的知识。他们已经自动化和性能调整了很多事情，你将不得不手工做的MySQL。
I realize that MySQL can be optimized and made to run well, but I'm not a dba and cannot afford to have a dba on all of my projects. I have several very complicated queries that sometimes cause the system to run out of memory. I am currently in the process of migrating my systems over to SQL Server Express. The test queries run significantly faster on SQL Server Express than they do on MySQL. If you are not very strong in databases and need a robust and fast system, I would not use MySQL. SQL Server Express is made more for developers with middle of the road knowledge of databases. They've automated and performance tuned a lot of things that you would have to do manually on MySQL.
在另一方面，如果你是非常舒服的数据库，你可能要考虑PostgreSQL的。它是开源的。它并不像用户友好的MySQL，但我粗略的了解，这是更强大，更稳定。
On the other hand, if you are very comfortable with databases, you may want to consider PostgresSQL. It is open source. It's not as user friendly as MySQL, but from my cursory understanding, it is more powerful and much more stable.
底线 - MySQL的使用是一个不错的选择，但考虑到SQL Server的防爆preSS和PostgreSQL的更好替代品的电流
bottom line - MySQL used to be a good option, but consider SQL Server Express and PostgresSQL as better current alternatives.
编辑：
这里有一些参考文献。还有另外2个非常严厉的人 - 但我把他们关reddit的的
here are a few of the references. there were 2 other very scathing ones - but i got them off of reddit.
这篇关于如MySQL的开源数据库能够支持我的网站的负载？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
