funding

Helping Enterprises Derive Value from Data with Our Series D

We are thrilled to share that we raised $30 million in our Series D. This round of fundraising was led by GV (formerly Google Ventures) and Glynn Capital, and brings our total fundraising to $110 million. Why are firms continuing to invest in MemSQL? Database technology sets the foundation for business leaders looking to derive value from data. Across the industries and companies we support, MemSQL is driving digital transformation for some of the world’s business giants including companies...


How Careful Engineering Led to Processing Over a Trillion Rows Per Second

On March 13, we published a blog demonstrating the performance of MemSQL in the context of ad hoc analytical queries. Specifically, we showed that the query SELECT stock_symbol, count(*) as c FROM trade GROUP BY stock_symbol ORDER BY c desc LIMIT 10; 12345 SELECT stock_symbol, count(*) as cFROM tradeGROUP BY stock_symbolORDER BY c descLIMIT 10; can process 1,280,625,752,550 rows per seconds on a MemSQL cluster...


Matching Modern Databases with ML and AI

Introduction Machine Learning (ML) and Artificial Intelligence (AI) have stirred the technology sector into a flurry of activity over the past couple of years. However, it is important to remember that it all comes back to data. As Hilary Mason, a prominent data scientist, noted in Harvard Business Review*, …you can’t do AI without machine learning. You also can’t do machine learning without analytics, and you can’t do analytics without data infrastructure. Over the last year we...


blog opener

Architecting Data in the AWS Ecosystem

Amazon Web Services (AWS) is a juggernaut of a platform, and many of today’s database solutions can run on AWS, including MemSQL. Recently, we held a meetup at our office in San Francisco during AWS Summit 2018 to discuss how customers can benefit from using MemSQL within the AWS ecosystem. In the talk, “Architecting Data in the AWS Ecosystem,” Seth Luersen from MemSQL took a look at the overall data landscape related to the purpose-built databases from Amazon Web Services. He illustrated...


Visual Takeaways from Gartner Data and Analytics 2018

We attended the Gartner Data and Analytics Summit in Grapevine, Texas in early March. This series is part of its global events schedule and similar conferences happen around the world. One fun hallway display was a series of animated summaries with key themes, tracks, and sessions of the conference. They were created by Katherine Torrini at Creative Catalyst. The first display covered the primary show themes of scaling the value of data and analytics: – Establishing Trust in the data...


Create a MemSQL Pipeline for Apache Kafka in 5 minutes

Creating an IoT Kafka Pipeline in Under Five Minutes

In a recent MemSQL webcast, we discussed how modern enterprises can easily adopt new data management tools to manage data size, growth, and complexity. Then we demonstrated how to use Apache Kafka and MemSQL to build interactive, real-time data pipelines. Data pipelines capture, process, and serve massive amounts of data to millions of users. During the webcast we also shared how to: Build new data pipelines with modern tools Enable data workflows to support machine learning and predictive...


Operationalizing MemSQL

In a recent webcast, we shared some tips and tricks on how you can operationalize MemSQL for configuring MemSQL Ops and MemSQL root user passwords; memory settings and health metrics; and how you can take backups and add nodes securely to your cluster. Here are the topics we covered: Permissioning a new cluster by adding a super-user to MemSQL Ops and via GRANT statements on the cluster itself   Best practices for configuring memory limits Best practices for basic cluster monitoring, and how...


blog header

Just Like IoT, Enterprises Have Been Using AI All Along

Just like IoT, around in various forms for years, AI has been prevalent in nearly every enterprise for decades. The catch? It was hidden inside the databases and data warehouses in use under the banner of Query Optimization. Query optimization is the process where a database or data warehouse takes the input from a user’s question, and reworks that question to deliver a quick response with as few compute resources as possible. The number of query plan choices reach far beyond what a human can...


Shattering the Trillion-Rows-Per-Second Barrier With MemSQL

Last week at the Strata Data Conference in San Jose, I had the privilege of demonstrating MemSQL processing over a trillion rows per second on the latest Intel Skylake servers. It’s well known that having an interactive response time of under a quarter of a second gives people incredible satisfaction. When you deliver response time that drops down to about a quarter of a second, results seem to be instantaneous to users. But with large data sets and concurrency needs, giving all customers...


blog header

Full-Text Search in MemSQL

Today, we are sharing that MemSQL now has Full-Text Search, a highly requested feature, built into the product. Thanks to customer feedback, we are delighted to make it available for all companies building real-time applications. What is Full-Text Search? You might be thinking, “MemSQL is pretty fast at searching things and they already support large strings, so why do they need to add anything?” So let’s start with a description of Full-Text Search (FTS). Full-Text Search is different...