Product

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...


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...


2018 Gartner Magic Quadrant for Data Management Solutions for Analytics

The data management solutions for analytics market is evolving. Disruption is accelerating in this market, with more demand for broad solutions that address multiple data types and offer different delivery models. We are hosting complimentary access to the full Gartner Magic Quadrant for Data Management Solutions for Analytics, so you can learn more about what’s happening in this space. Access Here → MemSQL Positioned as Challenger in Gartner Magic Quadrant MemSQL has been positioned in...


Machine Learning and MemSQL

What is Machine Learning? Machine learning (ML) is a method of analyzing data using an analytical model that is built automatically, or “learned”, from training data. The idea is that the model gets better as you feed it more data points, enabling your algorithm to automatically get better over time.   Machine learning has two distinct steps, training, and operationalization. Training takes a data set you know a lot about (known as a training set), then explores the data set to find...


JSON Streaming And The Future Of Data Ingest

As businesses continue to become technology focused, data is more prevalent than ever. In response, companies have adopted a handful of common formats to help manage this explosive growth in data. Data Formats Today For a long time, XML has been the giant in terms of data interchange formats. Recently, JSON has become popular, catching a wave of interest due to its lightweight streaming support, and general ease of use. JSON is a common format for web applications, logging, and geographical...


Running Stored Procedures on Distributed Systems with MemSQL 6

Today we’re announcing the general availability of MemSQL 6. This is a big milestone for the product, which comes with new features to help customers get even more value out of MemSQL. The latest release includes breakthrough query performance, enhanced online operations, and extensibility. In this blog, we’ll take a deeper look at the new Extensibility features. Why did you add Extensibility to MemSQL 6? The Extensibility feature was built based on market demand, and enables people to move...


design blog

Designing for a Database: What’s Beyond the Query?

Even the most technically-minded companies need to think about design. Working on a database product at a startup is no different. But this comes with challenges, such as figuring out how to implement the human-centered design methodology at a technical company, but also contribute to building a design process that everyone agrees with across the organization. This blog will detail how product design is done at MemSQL as well as highlight how to design enterprise products at a startup.   How do...


MemSQL 6 Product Pillars and Machine Learning Approach

MemSQL 6 Pillars and Machine Learning Approach Want to try MemSQL 6? Click here to get started. Prefer the Release Notes? They are here. Today marks another milestone for MemSQL as we share the details of our latest release, MemSQL 6. This release encapsulates over one year of extensive development to continue making MemSQL the best database platform for real-time analytics with a focus on real-time data warehouse use cases. Additionally, MemSQL 6 brings a range of new machine learning...


MemSQL Cloud

Introducing MemSQL Cloud

I am excited to announce the general availability of MemSQL Cloud. MemSQL Cloud has been running for many months with a set of customers as we built out the system, but today, we are opening up the service to everyone. The computing world is in the midst of a once-in-a-generation shift. That shift is moving to the cloud. Cloud platforms enable a level of agility that allows enterprises to move faster than ever before, and provides opportunity for new scenarios and a chance to modernize...