Product

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 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 capabilities to MemSQL, closing the gap between data science and operational applications. Product...


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


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