设为首页收藏本站

LUPA开源社区

 找回密码
 注册
文章 帖子 博客
LUPA开源社区 首页 业界资讯 软件追踪 查看内容

MemSQL v3.1发布,分布式关系型数据库

2014-8-13 16:18| 发布者: joejoe0332| 查看: 1816| 评论: 0|原作者: oschina|来自: oschina

摘要:   MemSQL 3.1 发布了,值得关注的改进有:Unmaterialized views which enable row- and column-level security with online ALTER VIEW.Automatic cross-datacenter replication via a single REPLICATE DATABASE ...

  MemSQL 3.1 发布了,值得关注的改进有:


  • Unmaterialized views which enable row- and column-level security with online ALTER VIEW.

  • Automatic cross-datacenter replication via a single REPLICATE DATABASE command. The slave site can be used as a hot backup and for offloading read processing from the main site.

  • INSERT and LOAD DATA are now transactional in the distributed system. Both commands now also support the IGNORE syntax.

  • INSERT...SELECT in the distributed system. INSERT...SELECT will automatically push down to the leaves across a foreign shard key or stream through the aggregator otherwise.

  • The aggregator can now stream GROUP BY queries rather than materializing a hash table. This has major performance and space implications for high cardinality GROUP BY queries.


  由前Facebook工程师创办的MemSQL,号称世界上最快的分布式关系型数据库,兼容MySQL但快30倍,能实现每秒150万次事务。原理是仅用内存并将SQL预编译为C++。


  MemSQL 提供免费的开发者版本(数据限制32G)和全功能试用版本(试用期30天)


酷毙

雷人

鲜花

鸡蛋

漂亮
  • 快毕业了,没工作经验,
    找份工作好难啊?
    赶紧去人才芯片公司磨练吧!!

最新评论

关于LUPA|人才芯片工程|人才招聘|LUPA认证|LUPA教育|LUPA开源社区 ( 浙B2-20090187 浙公网安备 33010602006705号   

返回顶部