April 23, 2013

MemSQL scales out

The third of my three MySQL-oriented clients I alluded to yesterday is MemSQL. When I wrote about MemSQL last June, the product was an in-memory single-server MySQL workalike. Now scale-out has been added, with general availability today.

MemSQL’s flagship reference is Zynga, across 100s of servers. Beyond that, the company claims (to quote a late draft of the press release):

Enterprises are already using distributed MemSQL in production for operational analytics, network security, real-time recommendations, and risk management.

All four of those use cases fit MemSQL’s positioning in “real-time analytics”. Besides Zynga, MemSQL cites penetration into traditional low-latency markets — financial services (various subsectors) and ad-tech.

Highlights of MemSQL’s new distributed architecture start:

Also:

And which not-easily-parallelized aggregate did MemSQL implement first? The same one Platfora did — COUNT DISTINCT.

Comments

6 Responses to “MemSQL scales out”

  1. Analytic application themes | DBMS 2 : DataBase Management System Services on April 25th, 2013 4:42 am

    [...] data” included as well. I hear variants of that positioning from NewSQL vendors (e.g. MemSQL), NoSQL vendors (e.g. AeroSpike), BI stack vendors (e.g. Platfora), application-stack vendors (e.g. [...]

  2. GregW on June 7th, 2013 1:22 pm

    I looked into memsql in part based on your post.

    I do appreciate hearing about new options or improvements such as you mentioned; MPP was of interest. I have a strong interest in MPP SQL databases of the open source or closed-but-MySQL-compatible variety for scaling out data warehouse ETLs.

    But I was a bit disillusioned that they didn’t support more than a 2-way join. (See http://developers.memsql.com/docs/1b/sql/join.html .) For a new project that can be worked around, but for migrating existing work, that’s a pretty big non-starter or important caveat I thought worth mentioning to you or your readers.

  3. Ryan on June 7th, 2013 7:08 pm

    Hi Greg,
    Sorry you found an outdated version of our documentation. If you go here – http://developers.memsql.com/docs/2.0/sql/join.html – you should find what you need. If you’re interested in banging away on MemSQL, you can download a free trial at http://www.memsql.com/download.
    Thanks,
    Ryan

  4. GregW on June 10th, 2013 3:27 pm

    Thanks Ryan.

  5. Webinar Tuesday, June 26, 1 pm EST — Real-Time Analytics | DBMS 2 : DataBase Management System Services on June 16th, 2013 2:47 am

    [...] sponsor is MemSQL, one of my numerous clients to have recently adopted some version of a “real-time [...]

  6. MemSQL 3.0 | DBMS 2 : DataBase Management System Services on February 10th, 2014 5:32 pm

    [...] MemSQL has historically been an in-memory row store, which as of last year scales out. [...]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.