Product

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


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