advertise
« Paper: High-Performance Concurrency Control Mechanisms for Main-Memory Databases | Main | Stuff The Internet Says On Scalability For August 3, 2012 »
Sunday
Aug052012

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.

 

Reader Comments (18)

A very shy team of ex-Facebookers lolz

August 5, 2012 | Registered CommenterSyed Alam

A very shy team of ex-Facebookers lolz

August 5, 2012 | Registered CommenterSyed Alam

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

August 5, 2012 | Unregistered CommenterChris

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.

August 5, 2012 | Unregistered CommenterRenato Moya

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.

August 5, 2012 | Unregistered CommenterFred

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?

August 5, 2012 | Unregistered CommenterAltieres

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 ?

August 6, 2012 | Unregistered CommenterBen G

How does MemSQL scale?

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

Usual questions on Data Availability, Consistency, etc.

August 6, 2012 | Unregistered CommenterChris EA

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

August 6, 2012 | Unregistered CommenterJohn Apps

How much does it cost?

August 6, 2012 | Unregistered CommenterNiek Sanders

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?

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.

August 6, 2012 | Unregistered CommenterMike Jarema

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?

August 6, 2012 | Unregistered CommenterFusheng Han

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

August 6, 2012 | Unregistered CommenterFusheng Han

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.
+-----------------------------------------------------------------------------+

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

August 7, 2012 | Unregistered CommenterFrazer Clement

How much will it cost?

August 8, 2012 | Unregistered Commenterpanos

Any plan to make it replication compatible with mysql?

August 8, 2012 | Unregistered CommenterGiuseppe Di Mauro

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>