News for hackers. Stuff that matters.

A comment on Ex-Facebookers launch MemSQL (YC W11) to make your database fly. Parent comment

Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by imfine on Monday June 18, 2012 @11:36AM (#4126916)
I am not sure this solves anything. From their implementation details I could just mount mysql on a memory filesystem and have 100% of MySQL's feature. If I need near 100% assurance that the data will be saved, there is always block replication, transaction logs and regular replication. their transition module adds nearly nothing but overhead, since stored procedures are better, and if you have the need for ultra performance, there is always the ability to access mysql at the command level and bypass sql entirely.
[ Parent | on HN ]
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by nikita on Monday June 18, 2012 @12:37PM (#4127235)
You could do that, but you won't be able to achieve as high throughput in highly concurrent environments. MemSQL achieves this via code generation and lockfree data structures.

We will also put the technology on steroids, by building a clustered system

[ Parent | on HN ]
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by genwin on Monday June 18, 2012 @03:20PM (#4128032)
> We will also put the technology on steroids, by building a clustered system

Isn't that the same as MySQL Cluster, minus the SQL-to-C++ part (and maybe lock-free structures)? Why not fork MySQL Cluster to add the SQL-to-C++ code generation? Then it seems you could claim (from MemSQL site) "MemSQL is ... still faster than other in-memory databases because of SQL-to-C++ code generation" and also support every feature of MySQL Cluster. Why reinvent the wheel only to create something with great limitations compared to the existing wheel?

[ Parent | on HN ]
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by tintor on Monday June 18, 2012 @03:38PM (#4128100)
"Why not fork MySQL Cluster to add the SQL-to-C++ code generation (and lock-free storage engine)?"

:) It is a little more complicated than that.

[ Parent | on HN ]
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by imfine on Monday June 18, 2012 @03:12PM (#4127985)
lets see some stats. Its a bit unfair to compare an in memory database with a severely truncated feature set to a more robust sick based system.
[ Parent | on HN ]
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by nikita on Monday June 18, 2012 @04:35PM (#4128372)
Correct! Different scenarios require different solution. One size doesn't fit all. And it's nice when solutions play nicely with each other.
[ Parent | on HN ]
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by iamleppert on Monday June 18, 2012 @01:49PM (#4127601)
lockfree data structures FTW!
[ Parent | on HN ]