Big Data // Big Data Analytics
News
2/6/2014
11:45 AM
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail

MemSQL Heats Up In-Memory Competition

Adding historical analysis to its bag of tricks, MemSQL takes on real-time contenders from SAP Hana to VoltDB.

Comment  | 
Print  | 
Comments
Newest First  |  Oldest First  |  Threaded View
rjonesx
50%
50%
rjonesx,
User Rank: Apprentice
12/27/2014 | 7:17:10 PM
Re: The poster child versus the real competition
I think memSQL has some huge advantages that will be realized over time...

1. mySQL wire compatibility: every developer and their mother knows how to deal with mySQL, and every platform out there has pre-written libraries to interact with mySQL. It cuts out a huge amount of friction of adoption (you don't need to hire new people and you don't need to rewrite your code)

2. In-Memory is Insufficient: What is truly remarkable about running a query on memSQL is running it the 2nd time. While the in-memory component offers a truly remarkable speed improvement, there is something amazing about watching the query run a second time with the optimized query code in place. Nearly every query drops down to milliseconds. 

3. Column store for historical data: Finally, they don't throw away the historical big data as of 3.0

Frankly, I haven't seen a better all-around option available, especially at their pricepoint. 
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
2/6/2014 | 4:03:55 PM
The poster child versus the real competition
Another competing vendor here might be Aerospike (formerly Citrus Leaf), but that's a NoSQL database that's used mostly in the online advertising world. Eevery vendor with in-memory technology inevitabaly mentions SAP Hana, but I don't see these vendors going after the same sorts of customers.
6 Tools to Protect Big Data
6 Tools to Protect Big Data
Most IT teams have their conventional databases covered in terms of security and business continuity. But as we enter the era of big data, Hadoop, and NoSQL, protection schemes need to evolve. In fact, big data could drive the next big security strategy shift.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest, Dec. 9, 2014
Apps will make or break the tablet as a work device, but don't shortchange critical factors related to hardware, security, peripherals, and integration.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of January 18, 2015.
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.