Ask MemSQL: Anything you want to know about MemSQL?

A very shy team of ex-Facebookers have created MemSQL, what they claim is the world's fastest database, and I'll be interviewing them on Tuesday. Are there any questions you would like to ask the MemSQL team? If so, please contact me or make a comment on this thread.

Comments

[Syed Alam]

A very shy team of ex-Facebookers lolz

[Syed Alam]

A very shy team of ex-Facebookers lolz

[Chris]

How do they translate SQL to C++ to make their database fast?

[Renato Moya]

What's the difference among other noSQL databases?
Why makes it so 'fast' to claim it as the world's fastest database?
How does it work?

I guess all of my question point to the same answer.

[Fred]

I am very sorry, It's no opensource project. so It's not mysql, posregSQL, mongodb...

and not oracle also.

why shoud I use MEMSQL?

memsql will dead if it is not a opensource/free soft.

[Altieres]

I've heard about memsql and searched for more info last week. On http://dom.as/2012/06/26/memsql-rage/ they sad memsql is slower then mysql when set to be really durable. Is it true?

[Ben G]

Where does their product stand on the CAP when using many servers ?
Was their product's core technology / ideas tested while at facebook or is it something they invented after leaving the company ?

[Chris EA]

How does MemSQL scale?

Is it a single box store? Master-Slave? Master-Master? Distributed?

Usual questions on Data Availability, Consistency, etc.

[John Apps]

What APIs are or will be supported?
What ACID properties?
Are distributed transactions supported across multiple databases?
What platforms will be supported?
What is the maximum physical memory size supported?

John

[Niek Sanders]

How much does it cost?

[Xavier / Needing not just big data, but fast data]

With all the Microsoft SQL Server coders on the team, will there be a version for Windows (Looking to replace MSSQL on multiple 1TB and 2TB HP Blades [BL680c/BL620c] running 2008R2 Data Center, *nix is none starter for this client)?

Assuming 2TB databases are supported? What is max support ram configuration?

For private/physical servers, do you have any recommendations of fastest motherboard/cpu/chipset/ram configs?

While MEMSQL is wire compatible with MYSQL (already swapped it in for two 'non production' apps with no coding changes, sweet...), but since it does not support things like stored procedures, that has blocked benchmarking on some real world apps that we are running. Code generation seems a no brainer for stored procs, is this on the roadmap for MEMSQL?

For one client running NoSQL as an external reference to MYSQL data, in a 'very quick' benchmark, non-durable mode seems the way to improve their lookup/insert times but the 'non-durable' term scares them (me too). Are there any forth coming tools/utilities to hot snapshot the DB in memory to disk/network (i.e. like boost::archive::binary_iarchive) vs using MYSQL dump routines? Or diid I just miss something?

[Mike Jarema]

More a request than question - please optimize your site for mobile! (android in my case)

I'm interested in finding out more about Memsql but can't even scroll the home page or nav menu.

[Fusheng Han]

Will MEMSQL support more isolation levels?
Give us some infomaton about the inner data structures, especially the lock free ones. And what kinds of the importance of the lock free data structures?
Has the dev team consider the power comsumption of the memory, if we have 500GB or more memory in commodity hardware?

[Fusheng Han]

And one more question:
Why not MEMSQL implement a storage engine for Mysql, instead of building a new one from the groud?

[Xavier / Needing not just big data, but fast data]

When running in non-durable mode (--durability=NO) and memsqld crashes, is there a memory dump, log or sequence of the C++/SQL code that was running that caused the crash that can be reviewed?

i.e. Through trail and error I determined that a 'delete from xxxx' is causing the following error (see below) when multiple other connections are issuing selects that join two tables and thus changed it to a drop table/create table as a work-around to solve the problem and more forward with some testing....

40308966941 2012-08-07 01:06:05 FAIL: Fatal buffer manager memory allocation failure. The maximum_memory parameter (23032) has been reached.
+-----------------------------------------------------------------------------+
| MemSQL has encountered a fatal error and exited.
| It could be a bug, misconfiguration, or hardware issue.
+-----------------------------------------------------------------------------+

[Frazer Clement]

What are the downsides of MemSQL when compared to VoltDB, Clustrix, MySQL Cluster?

[panos]

How much will it cost?

[Giuseppe Di Mauro]

Any plan to make it replication compatible with mysql?