Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa...
by nikita on Monday June 18, 2012 @10:22AM
(#4126520)
Memsql is a database that does some things incredibly well: deliver on high throughput for on small transactions and some things not as well (surface area).
Of course a new product will have certain limitation which will be removed as the product matures.
You can turn off durability, but then you risk losing everything.
For features... forget about geo-spatial extensions - they can only do read-committed isolation level... but as they only allow for one SQL statement per transaction I suppose this might not be such a big concern.
If you were using this for something like a session management database, or something where durability is not so important then it's probably fine. Not sure I'd use it for anything that relies heavily on transaction management features.
I see other limitations, like it cannot support CHANGE COLUMN, and it can't do joins on more than 2 tables. Actually, it doesn't look like it can do FULL OUTER or RIGHT OUTER joins, either. :(