是否有支持复制/集群的内存SQL数据库？
免费和稳定才是赢家。
我的计划非常简单——只需将所有数据放入内存并使用集群，而不更改应用程序代码。然后，为了持久性，我可以将节点中的数据转储到常规磁盘访问数据库中。
唯一的问题是，由于我需要内存存储，因此不可能进行完整的数据复制。我只想复制数据库模式，并且内存数据库为我一致地管理所有连接。
先感谢您！
更新： 我找到了一个可能满足我要求的开源产品，它是 VoltDB
Free and stable is the winner.
My plan is quite trivial - just put all the data in memory and use the cluster without changing the application code. Then, for persistence, I could just dump the data from nodes in a regular disk-access database.
The only thing is, that since I demand in-memory storage, there is no possibility of full data replication. I would like to copy the DB schema only and that in-memory DB manages all the joins consistently for me.
thank you in advance!
UPDATE:
I've found an open-source product likely to meet my requirements, it's VoltDB
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
H2 数据库还支持某种集群。
H2 Database also supports some kind of clustering.
出于兴趣，您“需要”内存存储而不能仅使用普通数据库服务器的任何特殊原因是什么？
Out of interest, any particular reason why you 'demand' in-memory storage and can't just use a normal db server?
甲骨文的十倍怎么样
http://www.oracle.com/technetwork/database/timesten/overview /index.html
或者也许是伯克利数据库
How about oracle's times ten
http://www.oracle.com/technetwork/database/timesten/overview/index.html
Or maybe berkeley DB
你的问题我不清楚。
您可以查看 Timesten（现归 ORACLE 所有） ，它基于SHMDB并提供SQL接口。
MySQL集群也是一种内存数据库，当你提交时，这意味着数据在两个节点的内存中，而不是写在磁盘上。当然，MySQL 集群会将所有数据异步写入磁盘，以便能够在崩溃后备份和恢复数据。
Your question is unclear to me.
You can have a look to Timesten (now owned by ORACLE), it is based on SHMDB and provides a SQL interface.
MySQL cluster is also a kind of in-memory DB as when you commit, it means data are in memory of two nodes and not written on disk. But of course MySQL cluster will write all data on disk asynchronously to be able to backup and recover data after a crash.
该产品还可以作为内存集群来完成这项工作：
http://terracotta.org
如果您想处理一些作业，它还带有一个 java Quartz Scheduler 的适配器。
This product would also do the job as an in-memory cluster:
http://terracotta.org
It also comes whit an adapter to java Quartz Scheduler, if you wanna handle some jobs to.
MEMSSQL，它与 MySQL 兼容（或直接替代）。
H2 也是本次比赛的不错候选者。请参阅此处
与其他数据库的比较
MEMSQL, its wire compatible (or drop in replacement) with MySQL.
H2 is also good candidate for this competition. See here with
comparisons with other databases