Oracle XE 或 MySQL ，我应该选择哪一个？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/829959/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle XE or MySQL , which one I should choice?
提问by ariso
I am going to develop a SNS website. Now I need to make a decision between Oracle XE and MySQL.
我要开发一个SNS网站。现在我需要在 Oracle XE 和 MySQL 之间做出决定。
I know you are a group of experts. Can you share some comments on this?
我知道你们是一群专家。你能就此发表一些评论吗？
Best wishes
最好的祝愿
Ariso
阿里索
回答by Jon Hopkins
The things I'd consider:
我会考虑的事情：
1) Are you ever likely to want to scale it up massively? If so Oracle will allow a very straight forward route to a massively scalable platform (you can pretty much just back up the database and restore it to a full Oracle instance).
1) 你有没有可能想要大规模地扩大规模？如果是这样，Oracle 将允许一条非常直接的途径到达大规模可扩展平台（您几乎可以只备份数据库并将其恢复到完整的 Oracle 实例）。
2) Are you going to want to scale moderately? If so then Oracle XE is limited to 4Gb total DB size where MySQL can perform reasonably with significantly more.
2）您是否要适度扩展？如果是这样，那么 Oracle XE 仅限于 4Gb 的总数据库大小，其中 MySQL 可以合理地执行更多。
3) Would the other constraints on Oracle XE likely impact you? It will only support 1Gb of RAM and 1 CPU for instance. If you think you're likely to need more than this for decent performance it's a non-starter. See the FAQ (http://www.oracle.com/technology/products/database/xe/pdf/dbxe_faq.pdf) for more details.
3) Oracle XE 的其他限制可能会影响您吗？例如，它仅支持 1Gb 的 RAM 和 1 个 CPU。如果您认为您可能需要比这更多才能获得体面的性能，那么它就不是初学者。有关更多详细信息，请参阅常见问题解答 ( http://www.oracle.com/technology/products/database/xe/pdf/dbxe_faq.pdf)。
4) Do you have skills in either in your organisation? Not only as a developer but also for support, back up strategy and so on. If there are skills in place then likely go with whichever you have the skills for. Make sure you speak to the support guys too and get their input.
4) 你在你的组织中是否有技能？不仅作为开发人员，还作为支持、备份策略等。如果有到位的技能，那么可能会选择你有技能的人。确保您也与支持人员交谈并听取他们的意见。
My gut feel says MySQL but use the above to weigh it up.
我的直觉是 MySQL，但使用上面的来衡量它。
回答by northpole
I would choose MySQL. Oracle XE is just supposed to be used for a proof of concept kind of thing. It is like the crack dealer giving you a taste then charging you a butt load once your hooked :D
我会选择 MySQL。Oracle XE 只是应该用于概念验证之类的事情。这就像破解经销商给你一个味道然后在你上瘾后向你收取大量费用：D
I think MySQL is a solid choice for small to midsized applications. But your anticipated size will negate your decision.
我认为 MySQL 是中小型应用程序的可靠选择。但是您预期的尺寸会否定您的决定。
回答by runxc1 Bret Ferrier
I would like to point out that Oracle has recently purchased MySql and that the MySql future is now a little bit up in the air. If you are very familiar with Oracle XE you may want to use it but I would like to point out the following reasons for not using Oracle.
我想指出，Oracle 最近购买了 MySql，MySql 的未来现在有点悬而未决。如果您对 Oracle XE 非常熟悉，您可能想使用它，但我想指出以下不使用 Oracle 的原因。
Oracle licenses are the most expensive in the business (Sql Express might be better as Sql Server is cheaper)
Oracle 许可证是业内最昂贵的（Sql Express 可能更好，因为 Sql Server 更便宜）
Oracle is virtually un heard of in the hosting domain. Hosting providers will provide SqlServer, MySql and PostGre Sql but I can't even think of one that has Oracle Hosting.
Oracle 在托管域中几乎无人听说过。托管服务提供商将提供 SqlServer、MySql 和 PostGre Sql，但我什至想不出有 Oracle 托管服务的提供商。
回答by David
This is a lot like the question : What language should I use? Long before you get to any scaling issues you are likely to run into experience issues. I think you should ask yourself more basic questions like:
这很像这样的问题：我应该使用什么语言？在遇到任何扩展问题之前，您很可能会遇到体验问题。我认为您应该问自己更基本的问题，例如：
- What type of support is available should you run into problems? For example: IRC, forums, bloggers, friends ;)
- How good is the documentation?
- Are there free tools?
- How well does your language support the database you choose?
- With your language what database is most often used with sample db code?
- What do you have the most personal experience with?
- 如果遇到问题，可以使用哪种类型的支持？例如：IRC、论坛、博主、朋友 ;)
- 文档有多好？
- 有免费的工具吗？
- 您的语言对您选择的数据库的支持程度如何？
- 使用您的语言，哪个数据库最常与示例数据库代码一起使用？
- 你有什么最个人的经历？
So for instance if you're using Ruby you'll probably want to go with MySQL. If you're using PHP, maybe the choice is a bit more blurred.
因此，例如，如果您使用 Ruby，您可能想要使用 MySQL。如果您使用的是 PHP，那么选择可能会更加模糊。
