Product

Arrays a Hidden Gem in MemSQL

Arrays - A Hidden Gem in MemSQL

Released this March, MemSQL 6 Beta 1 introduced MemSQL Procedural SQL (MPSQL). MPSQL supports the creation of: User-Defined Functions (UDFs) Stored Procedures (SPs) Table-Valued Functions (TVFs) User-Defined Aggregate Functions (UDAFs) A Hidden Gem: Array Types There’s a hidden gem in MemSQL 6 Beta 1 that we didn’t document at first — array types!  These make programming much more convenient. Since we compile your extensions to machine code, the performance is fantastic. And you...


MemSQL Design Principles

Design Principles at MemSQL

At MemSQL, we believe that every company should have the opportunity to become a real-time enterprise. We believe that data drives business, and that data management performance leads to successful business results. Specifically related to our products, we believe in: The Need for Performance To compete in a 24×7 business world, companies must be able to ingest data quickly, execute low latency queries, and support a large number of analytics users and data volume, all at the same time. The...


MemSQL Pipelines

MemSQL Pipelines: Real-Time Data Ingestion with Exactly-Once Semantics

Today we launched MemSQL 5.5 featuring MemSQL Pipelines, a new way to achieve maximum performance for real-time data ingestion at scale. This implementation enables exactly-once semantics when streaming from message brokers such as Apache Kafka. An end-to-end real-time analytics data platform requires real-time analytical queries and real-time ingestion. However, it is rare to find a data platform that satisfies both of these requirements. With the launch of MemSQL Pipelines as a native feature...


BPU Linux Performance

What is BPF and why is it taking over Linux Performance Analysis?

Performance analysis often gets bottlenecked by lack of visibility. At MemSQL, we architected our database to easily observe its inner workings. Observability allows our engineers to easily identify components that need to be faster. Faster components mean our database’s performance skyrockets. These tools also enable support engineers to react quickly and precisely to customer needs. In the spirit of using the best available tools to which we have access, the performance team is currently...


Tableau Integration

Connect Directly to MemSQL with Tableau 10

This post originally appeared in Tableau News by Arthur Gyldenege. Many of us have data in many places, waiting to be understood. That’s why we’re thrilled to announce we’ve added even more data-source options in Tableau 10. We want to help you gain value from your data, no matter where it lives. Here’s what’s new. MemSQL Named Connector We love fast databases. It makes the experience of interacting with your database that much more enjoyable. MemSQL is a database...


Connect Tableau to MemSQL

Real-Time Analytics in Tableau

This is a Guest Post from our Friends at Tableau MemSQL is the database platform for real-time analytics. One of the great features of the latest release, MemSQL 5, is users can connect directly from Tableau. Using the new MemSQL 5 named connector, currently in beta, users can analyze current and historical data together while MemSQL ingests millions of transactions per second. MemSQL is also wire-protocol compliant with MySQL, so if you already have a MySQL driver installed or you are running...


Community Globe

MemSQL Community Edition: A Year in Review

Today marks the 1-year anniversary of the MemSQL Community Edition launch. Over the course of a year, Community Edition has surpassed tens of thousands of downloads and is deployed across hundreds of active clusters. We have a thriving community user group on Slack, ranging from SQL beginners to award-winning data engineers. On our anniversary, we want to share what has contributed to our community success, and what users can expect moving forward. A Database So Scalable, Everyone Can Use It...


Top MemSQL Posts

18 Favorite Posts and Articles from MemSQL

The data industry has so many topics to dive into. At MemSQL, we do our best to provide coverage across a range of subjects. To make it a bit easier to find a few of our recent and historical hits, we have curated a short list of articles by topic. Enjoy! SQL SQL is the lingua franca of data processing. Understand why MemSQL has stayed true to this dominant approach. Hidden Cost of NoSQL | Network World Article | Jan 2016 Why MemSQL Placed a Bet on SQL | MemSQL Blog | Oct 2015 In-Memory The...


MemSQL 5

MemSQL 5 Ships with LLVM-based Code Generation for SQL Queries

We are proud to announce general availability for MemSQL 5 today. A key milestone in this release is a full fledged SQL compiler resulting in faster query processing across the board. Making this happen was a result of several months of hard work, which featured a large uplift of our existing database execution engine. This new SQL compiler is using LLVM for code generation. This modern compilation strategy is capable of supporting dynamic compilation of programming languages. In addition to...


MemSQL 5 Beta

Introducing MemSQL 5 Beta

A post from our co-founders Eric Frenkiel, CEO and Nikita Shamgunov, CTO Today MemSQL 5 Beta is publicly available! MemSQL customers have been able to achieve remarkable results with our database, and we look forward to feedback on this upcoming release from our user community. Click here to jump to MemSQL 5 Beta download ⇒ This release aligns with our 5th anniversary as a company and it is our most ambitious release to date. Over the past five years, we have learned how to deliver real-time...