blocks|key|4508993|text|如果您的用户群足够大，需要一个高性能的DB，那么您的带宽和存储费用将不便宜；为什么要在数据库上省钱？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4508994|MS+SQL有性能受限的免费和/或廉价版本。我总是从他们开始，如果网站起飞了，我就会升级。也许甲骨文也提供类似的服务。|4508995|编辑:我应该在一开始就说，你不太可能在短期内超越MySQL，整个问题可能是过早优化的情况。|4508996|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

If your userbase is large enough to require a high-performance DB, your bandwidth and storage charges will not be cheap; why skimp on the database?

MS SQL has free and/or cheap editions which are performance-inhibited. I always start with them, and if the site takes off, I upgrade. Probably Oracle offers something similar.

Edit: I should have said at the start that you're unlikely to outgrow MySQL anytime soon, and that this whole question might be a case of premature optimization.

blocks|key|1188887|text|我建议为这些文件建立一个云帐户，并可能为数据库(MySQL和MyISAM)建立一个专用服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1188888|您可以限制在云存储文件上的成本，但通过增加处理能力和内存为DB配备专用服务器来提高性能。|1188889|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I would recommend getting a cloud account for the files and potentially a dedicated server for the DB (MySQL and MyISAM).

You can limit your cost on the cloud storing the files, but enhance performance by having a dedicated server for the DB by increasing processing power and memory.

blocks|key|1241229|text|如果你是一家初创公司，你可能终究能买得起微软的东西。查看他们的BizSPark程序，该程序在几年内免费为您提供软件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1241230|不过，我不确定我是否同意MySQL不是您的最佳选择。FaceBook不使用MySQL吗？你希望变得更大吗？|1241231|如果你认为InnoDB对你来说太慢了，在MySQL上有其他的存储引擎选项。例如，您是否研究过TokuDB|1241232|你有没有考虑过像Linode.com这样的托管服务而不是你自己的硬件？这可能更适合您的现金流配置文件。如果你真的觉得数据库负载很重，你可以有专用的或多个服务器。从一个专用的DB盒开始，并从那里向上扩展。你也可以使用像Amazon+EC2这样的云服务。|1241233|编辑:我刚刚意识到Tokutek有一个社交网络案例：+http://tokutek.com/customers/a-social-networking-case-study/|style|BOLD|1241234|在我看来，你的成长不太可能在短期内超越MySQL。如果你忙到需要像TokuDB这样的东西，你可以用一些分享来感谢我。:-)|1241235|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/bizspark/|1|http://tokutek.com/|2|http://linode.com/|3|http://aws.amazon.com/ec2/|4|http://tokutek.com/customers/a-social-networking-case-study/^0|V|8|0|0|0|1A|6|1|0|8|A|2|30|A|3|0|0|Q|R|1O|4|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|H|3|I|5|6|7|1E|8|@]|9|@$A|1F|B|1G|1|1H]|$A|1I|B|1J|1|1K]]|C|$]]|$1|J|3|K|5|6|7|1L|8|@$A|1M|B|1N|L|M]]|9|@$A|1O|B|1P|1|1Q]]|C|$]]|$1|N|3|O|5|6|7|1R|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1S|8|@]|9|@]|C|$]]]|Q|$R|$5|S|T|U|C|$V|W]]|X|$5|S|T|U|C|$V|Y]]|Z|$5|S|T|U|C|$V|10]]|11|$5|S|T|U|C|$V|12]]|13|$5|S|T|U|C|$V|14]]]]

If you are a start-up, you may be able to afford Microsoft's stuff after all. Check out their <a href="http://www.microsoft.com/bizspark/" rel="nofollow noreferrer">BizSPark</a> program which gives you software for free for a few years.

I am not sure that I agree that MySQL is not your best option though. Doesn't FaceBook use MySQL? Are you expecting to be bigger?

If you think that InnoDB will be too slow for you, there are other storage engine options on MySQL. For example, have you investigated <a href="http://tokutek.com/" rel="nofollow noreferrer">TokuDB</a>?

Have you considered a hosting service like <a href="http://linode.com" rel="nofollow noreferrer">Linode.com</a> instead of your own hardware? This might be a better fit for your cashflow profile. If you really feel the DB load is onerous, you could have dedicated or multiple servers. Start with a dedicated DB box and scale up from there. You could also go with a cloud service like <a href="http://aws.amazon.com/ec2/" rel="nofollow noreferrer">Amazon EC2</a>.

EDIT: I just realized that Tokutek have a social networking case study:
<a href="http://tokutek.com/customers/a-social-networking-case-study/" rel="nofollow noreferrer">http://tokutek.com/customers/a-social-networking-case-study/</a>

It sounds to me like you are unlikely to outgrow MySQL any time soon. If you grow busy enough to need anything like TokuDB you can thank me with a few shares. :-)

For a heavy user content website with user profiles, live feeds, photo /video/content sharing, etc what DB to use, and what DB engine? Ofcourse Oracle/Microsoft sql are out because they are not free (or cheap). I am using MySQL with MyISAM but that will run into performance issues on a social site. Even using InnoDB may not help performance. So firstly which DB is better to use and which engine - starting from Free to paid? 

Main concern is with live feeds performance, plus there is lots of data tracking and mining with analytic.

Since this is a startup - hardware costs are limited so no hardware farm here to support performance, hence seeking a decent alternative for the first 2 years atleast.

Database and DB engine for social website

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

对于一个有大量用户内容的网站，有用户配置文件，实时订阅，照片/视频/内容分享等，使用什么数据库，什么数据库引擎？当然，Oracle/Microsoft sql被淘汰是因为它们不是免费的(或便宜的)。我正在使用MySQL和MyISAM，但这会在社交网站上遇到性能问题。即使使用InnoDB也可能不会提高性能。那么，首先，哪...

问用于社交网站的数据库和DB引擎
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用于社交网站的数据库和DB引擎EN