具有最佳插入/秒性能的数据库? [英] DB with best inserts/sec performance?

问题描述

我们部署了一个(基于AJAX的)即时通讯程序，该通讯程序由Comet服务器提供服务.为了满足法律保留要求，我们需要将已发送的消息存储在数据库中以进行长期存档.

We deploy an (AJAX - based) Instant messenger which is serviced by a Comet server. We have a requirement to store the sent messages in a DB for long-term archival purposes in order to meet legal retention requirements.

在这种一次写入，永不读取(极少数例外)的需求中，哪个数据库引擎提供了最佳性能?

Which DB engine provides the best performance in this write-once, read never (with rare exceptions) requirement?

我们至少需要5000次插入/秒.我假设既不是MySQL也不是PostgreSQL 可以满足这些要求.

We need at least 5000 Insert/Sec. I am assuming neither MySQL nor PostgreSQL can meet these requirements.

是否有更高性能解决方案的建议? HamsterDB，SQLite，MongoDB ...?

Any proposals for a higher performance solution? HamsterDB, SQLite, MongoDB ...?

推荐答案

如果您永远不会查询数据，那么我根本不会将其存储到数据库中，那么您将永远不会失去仅编写数据的性能到一个平面文件.

If you are never going to query the data, then i wouldn't store it to a database at all, you will never beat the performance of just writing them to a flat file.

您可能要考虑的是伸缩性问题，如果将数据缓慢写入平面文件，您将投资更快的磁盘还是其他东西，会发生什么情况.

What you might want to consider is the scaling issues, what happens when it's to slow to write the data to a flat file, will you invest in faster disk's, or something else.

要考虑的另一件事是如何扩展服务，以便您可以添加更多服务器，而不必协调每个服务器的日志并手动合并它们.

Another thing to consider is how to scale the service so that you can add more servers without having to coordinate the logs of each server and consolidate them manually.

edit:您写道，您希望将其保存在数据库中，然后我还要考虑在线保存数据的安全性问题，当您的服务遭到破坏时会发生什么，您是否希望攻击者能够进行更改怎么说的历史?

edit: You wrote that you want to have it in a database, and then i would also consider security issues with havening the data on line, what happens when your service gets compromised, do you want your attackers to be able to alter the history of what have been said?

将其临时存储到文件中，然后将其转储到Internet站点遭到黑客入侵时无法访问的异​​地位置，可能会更聪明.

It might be smarter to store it temporary to a file, and then dump it to an off-site place that's not accessible if your Internet fronts gets hacked.

这篇关于具有最佳插入/秒性能的数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！