database

Should You Use a Rowstore or a Columnstore?

This is a repost of an article by Ankur Goyal, VP of Engineering, published on Medium ⇒ The terms rowstore and columnstore have become household names for database users. The general consensus is that rowstores are superior for online transaction processing (OLTP) workloads and columnstores are superior for online analytical processing (OLAP) workloads. This is close but not quite right — we’ll dig into why in this article and provide a more fundamental way to reason about when...


dbBench

dbbench: Bringing Active Benchmarking to Databases

In my last blog post, I investigated a Linux performance issue affecting a specific customer workload. In this post, I will introduce the tool I created to drive that investigation. Recently, a customer was running a test where data was loaded into MemSQL via LOAD DATA. The customer’s third-party benchmarking tool found that MemSQL took twice as long to load the same amount of data as a competing database; however, the numbers reported by this tool did not make sense. Local tests had shown...


Modern Database Characteristics

Characteristics of a Modern Database

Many legacy database systems are not equipped for modern applications. Near ubiquitous connectivity drives high-velocity, high-volume data workloads – think smartphones, connected devices, sensors – and a unique set of data management requirements. As the number of connected applications grows, businesses turn to in-memory solutions built to ingest and serve data simultaneously. Bonus Material: Free O’Reilly Ebook – learn how to build real-time data pipelines with modern...


Oracle and MemSQL Together

Using Oracle and MemSQL Together

Photo: Martin Taylor We often hear “How can I use MemSQL together with my Oracle database?” As a relational database, MemSQL is similar to an Oracle database, and can serve as an alternative to Oracle in certain scenarios. Here is what sets MemSQL apart: MemSQL is a distributed system, designed to run on multiple machines with a massively parallel processing architecture. An Oracle database, on the other hand, resides in a single, large machine, or a smaller fixed cluster size. MemSQL has...


SQL

Why MemSQL Placed a Bet on SQL

In the technology industry, when products or innovations last for a long period of time, they are often here to stay. SQL is a great example of this – it has been around for over 30 years and is not going away anytime soon. When Eric Frenkiel and Nikita Shamgunov founded MemSQL in 2011, they were confident in choosing the SQL relational model as the foundation for their database. But the database industry during that era was clamoring around NoSQL, lauding it as the next great innovation,...


Incumbents and Contenders in the $33B Database Market

The database market continues to surprise those of us who have been in it for a while. After the initial wave of consolidation in the late 1990s and early 2000s, the market has exploded with new entrants: column-stores, document databases, NoSQL, in-memory, graph databases, and more. But who will truly challenge the incumbents for a position in the Top 5 rankings? Oracle, IBM, Microsoft, SAP, and Teradata dominate the $33B database market. Will it be a NoSQL database? Will it be an open source...


Forrester Wave In-Memory Databases

MemSQL Cited As a Strong Performer by Independent Research Firm

As adoption of in-memory databases grows at a faster and faster pace, IT leaders turn to research firms to find valuable use cases and guidance for purchasing options. We are thrilled to share that MemSQL was among the select companies that Forrester Research invited to participate in its 2015 Forrester Wave™ evaluation. In this evaluation, MemSQL was cited as a strong performer for in-memory database platforms. The report, The Forrester Wave™: In-Memory Database Platforms, Q3 2015,...


What's Hot and What's Not in Working With Data

Data is often considered to be the foundation of many global businesses. Data fuels daily operations, from customer transactions to analytics, from operations to communications. So we decided to answer the question: what’s hot and what’s not in working with data today? HOT: Letting your database be a database Databases were constructed to store data. However, sometimes applications are used to store data itself, a result of legacy database limitations. Storing data in an application makes...


Unsexy Database Features That Matter: Part 2

In the previous post, we talked about how you should focus on how people derive value from your product. Today we will focus on database management — your goal should always be 24/7 100% uptime. How People Manage A Database Product Deployment (time to get the system up and running) How much time does it take to get your product up and running? People have talked about barriers to entry for a long long time. The worst one is, “I couldn’t install your product so I gave up.” This is simply...


Unsexy Database Features That Matter: Part 1

As enterprise customers start to use your product in many different ways, new feature requests will start to flow into the product team. These features aren’t sexy features by any means, but every enterprise customer cares about them deeply, and we try to include as many customer feature requests as possible into every release, sexy or not. To really understand these unsexy features, we must examine two areas: How users derive value out of your product. How users manage a database product....