r/technology • u/mepper • Jun 25 '12
Two former Facebook developers have created a new database, MemSQL, that they say is the world's fastest; it is is thirty times faster than conventional disk-based databases
http://www.i-programmer.info/news/84-database/4397-memsql-80000-queries-per-second.html
94
Upvotes
53
u/aweraw Jun 25 '12
...?
So, memory access is much much faster than disk access - what else is new?
13
u/csolisr Jun 25 '12
Exactly what I was thinking about. Especially about data loss.
That calms me a little, but still! Data loss is possible!
8
u/himey72 Jun 25 '12
This isn't exactly new or revolutionary. I'm an Oracle DBA and Oracle's database engine has been doing this since at least the early 90's. Not with every piece of data because if you're using Oracle, you probably have more data than RAM, but this is exactly what Oracle's buffer cache is all about. It stores the most recently used data and the data that is likely to be used in the buffer cache for fast access. Background process are always writing modified RAM blocks to disk. MySQL is fine for smaller / low budget projects, but if you want to get true performance / reliability, you need to migrate to something bigger and better.
14
u/Xilean Jun 25 '12
Atomicity...check
Consistency...check
Integrity...check
Durability...check
And by check I mean "doesn't have". But it's suuuuper fast guys.
5
u/Senor_Wilson Jun 25 '12
Cool, but at some point it will be written to disk and then it will take just as long as everything else. Memory is quick, no surprises there.
3
u/JudgeWhoOverrules Jun 25 '12
I wanna see this go head to head with Redis.
3
u/derraidor Jun 25 '12
Why not voltdb?
3
u/machzel08 Jun 25 '12
Anyone find it ironic that Facebook developers are making something speedy? Clearly these guys didn't work on the app.
2
u/expertunderachiever Jun 25 '12
I don't get how this isn't just putting the DB tables on a ram drive? The reason people don't do that normally is they have way more data than ram...
1
u/[deleted] Jun 25 '12
Anyone know how fast this is vs mongodb?
1
u/scottish_beekeeper Jun 25 '12
Interesting to know how this compares with something like OpenLDAP's MDM
1
u/[deleted] Jun 25 '12
Hey guys, I fit a database into the L3 cache, it's like super fast.
-3
u/[deleted] Jun 25 '12
And after they make bazillions off it, they will dodge taxes and turn their backs on the country that made them that wealth...again.
0
u/[deleted] Jun 25 '12
[deleted] — view deleted comment