News for hackers. Stuff that matters.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by moe on Monday June 18, 2012 @09:49AM (#4126373)
Is this a joke?

Data must fit in RAM, no joins over >2 tables, no transactions, no builtin support for clustering/sharding/horizontal scaling whatsoever.

What is the advantage over memory-tables, MySQL on a ramdisk or something purpose-built (redis)?

Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by chris_wot on Monday June 18, 2012 @10:38AM (#4126586)
That's a little harsh I think. It still has a transaction log, so it has certain advantages over memory tables. Some interesting enhancements to indexes also. And it is also binary compatible with MySQL, so you can actually add it as a MySQL node.

I'd say it's a database for a niche market, as one of the folks from MemSQL has been saying. It would fit in nicely under a few scenarios.

Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by AaronBBrown on Tuesday June 19, 2012 @09:20AM (#4131610)
MEMORY tables have table-level locks and from a concurrency perspective, is just as bad as MyISAM, so really offer no advantage unless there is only a small number of consumers. A well tuned InnoDB table will outperform the MEMORY engine )(after the warm-up period) as soon as you have more than a handful of users performing write operations.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by tigerBL00D on Monday June 18, 2012 @02:38PM (#4127832)
Advantages are clear. Blazing speed, transactional durability, ease of use and flexibility that come from using a well known protocol and SQL dialect. Did I miss something?
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by old-gregg on Monday June 18, 2012 @02:35PM (#4127821)
On the other hand, if your data fits in RAM and you don't need to join more than two tables and you don't need clustering/sharding whatsoever and you need the full power of SQL, what would you use?

> ..something purpose-built (redis)?

Errr maybe "features" like GROUP BY with HAVING? I think you're trolling, Mr Moe.

Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by moe on Monday June 18, 2012 @06:03PM (#4128850)
trolling

Says the guy who resorts to selective quoting to make a point? You may want to review my original comment where I mention two other options.

Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by MuGo on Monday June 18, 2012 @10:58PM (#4130017)
nope. you're definitely a troll