Product Features

Ingest

create pipeline

Create PipelineFEATURED

Ingest data from Apache Kafka and Amazon S3 with a single command

exactly-once semantics

Exactly-Once SemanticsFEATURED

Achieve guaranteed message delivery for precise reporting and analysis

import data

Data Import

Import from existing systems using native data load functions

Analysis

sophisticated insignts

Sophisticated Insights

Perform fast SQL operations for instant response to BI dashboards, reports, and machine learning applications

geospatial

Geospatial SupportFEATURED

Store, query, and index geographic data types including polygons and points to support location analytics

JSON

JSON OptimizedFEATURED

Store and query JSON data as a column-type and analyze multi-attribute objects

multi-statement transactions

Multi-Statement Transactions

Multi-statement transactions allow a set of DML statements to be combined into a single transaction

compiled queries

Compiled Queries

Compile repeat queries into low level machine code to deliver real-time response for analytic queries

distributed joins

Fully Distributed Joins

Scale out distributed JOINs across any table or column for simple query access

Storage

distributed storage

Distributed Storage

Store and process data across clusters and maximize resilience and performance

big data capacity

Big Data Capacity

Store petabytes of data on low cost disk and cloud storage for archive requirements while maintaining instant retrieval for analysis

massivelly parallel

Massivelly Parallel

Scale out shared nothing architecture with a parallel execution engine for read and write queries delivering real-time performance

full durability

Full Durability to Disk

Write transactions directly to disk or write to memory with full data persistence and archiving

in-memory performance

In-Memory or On-Disk Tables

Use memory for transactional workloads and cleanup while using disk for historical data and analysis

compressed tables

Compressed On-Disk Tables

Optimize column store disk compression resources for storing up to petabytes of data

Ready to get started? Transform your business to Real-Time today
Book a Demo Try MemSQL

Management

performance monitoring

Monitor Performance and Capacity

Respond to issues and ensure your cluster is always online and operating within server capacity

deploy

Provision and Deploy

Provision and deploy MemSQL according to your desired cluster configuration

high availability

High Availability

Redundancy protect against data loss and ensures data consistency with replication

cluster management

Cluster Management

Automate and simplify common tasks including adding, dropping, restoring, rebalancing partitions

scaling

Administration and Scaling

Manage data replication and restore without pausing or going offline

data center replication

Cross Data Center Replication

Synchronize one cluster with another over a broad network connection

Security

RBAC

Role-Based Access Control (RBAC)

Manage simple or robust security configurations by user role and group while maintaining maximum performance

encryption

Encryption

Data encryption is supported at time of ingest and when delivered across nodes using SSL. Use third party storage encryption while data is stored in MemSQL

authentication

Authentication

Manage existing account access with PAM (Pluggable Authentication Module) and SAML authentication support

Ready to Get Started?

Take your business real-time