Product

Community Edition

Launching Our Community Edition

We started MemSQL with a vision to enable every company to be a real-time enterprise, and to do that by delivering the leading real-time database for transactions and analytics. Since then, the forces shaping our digital economy have only added wind to our sails. The world is more mobile, interconnected, interactive, and on the cusp of several industry transformations such as the Internet of Things. Real-time processing is the secret to keeping up, and in-memory solutions are the foundation....


HANA and Hadoop

Filling the Gap Between HANA and Hadoop

Takeaways from the Gartner Business Intelligence and Analytics Summit Last week, MemSQL had the opportunity to participate in the Gartner Business Intelligence and Analytics Summit in Las Vegas. It was a fun chance to talk to hundreds of analytics users about their current challenges and future plans. As an in-memory database company, we fielded questions on both sides of the analytics spectrum. Some attendees were curious about how we compared with SAP HANA, an in-memory offering at the...


Data Stores for the Internet of Things

Like the world wide web, the Internet of Things is personal. It represents a near complete connectedness, including the industrial world, and never ending possibilities of new applications and services. The Internet of Things also represents a need to examine conventional assumptions on databases and data stores to support real-time data pipelines. In an article on Silicon Angle, Designing data stores for the Internet of Things, MemSQL CEO and co-founder Erik Frenkiel shares his insight on the...


Operationalize Spark

Operationalizing Spark with MemSQL

In Short: Combining the data processing prowess of Spark with a real-time database for transactions and analytics, where both are memory-optimized and distributed, leads to powerful new business use cases. MemSQL Spark Connector links at end of this post. Data Appetite and Evolution Our generation of, and appetite for, data continues unabated. This drives a critical need for tools to quickly process and transform data. Apache Spark, the new memory-optimized data processing framework, fills this...


MemSQL Spark Connector

Run Real-Time Applications with Spark and the MemSQL Spark Connector

Apache Spark is one of the most powerful distributed computing frameworks available today. Its combination of fast, in-memory computing with an architecture that’s easy to understand has made it popular for users working with huge amounts of data. While Spark shines at operating on large datasets, it still requires a solution for data persistence. HDFS is a common choice, but while it integrates well with Spark, its disk-based nature can impact performance in real-time applications (e.g....


DBMS Disadvantages

Four Ways Your DBMS is Holding You Back - And One Simple Fix

Our data is changing faster than our data centers, making it harder and harder to keep up with the influx of incoming information, let alone make use of it. IT teams still tolerate overnight batch processing. The cost of scaling legacy solutions remains cost prohibitive. And many promised solutions force a complete departure from the past. If this sounds familiar, you are not alone. Far too many innovative companies struggle to build applications for the future on infrastructure of the past....


IoT Database

A Sensor In It, A Database Behind It

On opening day, Molly Wood at The New York Times recounted the official CES theme emerging as “Put a sensor in it.” The unofficial theme seemed to be: Put a sensor in it. Later that day Samsung declared its entire product portfolio will be connected within 5 years. “In five years,” every single one of Samsung’s products will be a connected “Internet of Things” device, Samsung chief executive Boo-Keun Yoon said today during the opening keynote at the 2015 Consumer Electronics Show...


Cache is the new RAM

One of the (few) advantages of being in technology for a long time is that you get to see multiple tech cycles beginning to end. You get to see how breakthroughs actually propagate. If all you have seen is a part of the curve, it’s hard to extrapolate correctly. You either overshoot the short-term progress or undershoot the long. What’s surprising is not how quickly the facts on the ground change, but how slowly engineering practice changes in response. This is a Strowger switch, an...


MemSQL and Cisco Work Together to Make Real-Time Performance on Hadoop a Reality

While Hadoop is great for storing large volumes of data, it’s too slow for building real-time applications. However, our recent collaboration with Cisco provides a solution for Hadoop users who want a better way of processing real-time data. Using Cisco’s Application Centric Infrastructure including APIC and Nexus switch technology, we’ve been able to demonstrate exceptional throughput on concurrent MemSQL and Hadoop 2.0 workloads. Here’s How It Works Cisco’s new networking technology...


MemSQL Does Oracle’s Own Demo Ten Times As Fast, Sixty Times Cheaper

In preparation for Open World, I asked some of our engineers to recreate a demo that Oracle has been using over the last year to show off their “in-memory option.” It’s impressive to look at: the demo shows the database searching through billions of records from Wikipedia search trend data for popular terms in less than a second. The thing about Oracle’s demo is it runs on a gigantically expensive server. In fact it is the biggest one they have at 32TB of RAM and hundreds of CPU cores....