SingleStore database

How it Worksoverview

SingleStore is a distributed, highly-scalable SQL database that can run anywhere. We deliver maximum performance for transactional and analytical workloads with familiar relational models
Ecosystem Architecture Diagram
SingleStore is a scalable SQL database that ingests data continuously to perform operational analytics for the front lines of your business. Ingest millions of events per second with ACID transactions while simultaneously analyzing billions of rows of data in relational SQL, JSON, geospatial, and full-text search formats.

Optimized for Modern Workloads

Globe Americas Icon
Geospatial
Brackets Curly Icon
JSON
Kafka Icon
Kafka
Border All Icon
Relational
Universal Storage Icon
Universal Storage

Ready to get started?

Experience the performance of The Single Database for All Data-Intensive Applications for your data today

Accelerate and Simplify Data Ingestioningest

SingleStore Studio Physical Monitoring dashboard
SingleStore delivers ultimate data ingestion performance at scale and supports built in batch loading and real time data pipelines
createpipeline
Programmatic Pipelines
Build sophisticated for enrichment operations, eliminating the cost and complexity of ETL tooling
Learn More
exactlyonce
Exactly-Once Semantics
Achieve guaranteed message delivery of streaming data for accurate reporting and analysis
loaddata
Pipelines for Data Lakes
Continuously ingest data from HDFS and accelerate analytic performance using familiar ANSI SQL
Learn More
inputs-streaming
Streaming Inputs
Apache Kafka, Apache Spark
inputs-databases
Database Inputs
MySQL, SQL Server, Oracle, Postgres, Teradata, Redshift
inputs-storage
Storage Inputs
Amazon S3, HDFS

Experience Latency-Free Analyticsanalyze

low latency
SingleStore lets you achieve ultra fast query response across both live and historical data using familiar ANSI SQL
bitools
Sophisticated Insights
Perform ad hoc analysis with business intelligence tools, run machine learning algorithms for real-time scoring, perform geoanalytic queries in real time
geospatial
Geospatial Support
Store, query, and index geographic data types including polygons and points to support area, distance, location analytics in real-time
json
JSON Optimized
Store and query JSON data as a column-type to efficiently store and analyze multi-attribute objects
cmdline
Workload Management
Automatically deliver reliable database performance while under high concurrency – to easily support more users and queries
Learn More
fulltextsearch
Full-Text Search
Deliver fast, scalable full text-search applications with keyword-based and regular query conditions in a single SQL statement
Learn More
multi-statement
Multi-Statement Transactions
Multi-statement transactions allow a set of DML statements to be combined into a single transaction
compiled-queries
Compiled Queries
Repeat queries are compiled into low level machine code to deliver record breaking response for analytic queries
joins
Fully Distributed Joins
Scale out fully distributed JOINs across any table and column for simple efficient query access

Enhanced Reliability and Flexibilitystore

Our highly-scalable, distributed system balances data and queries across a cluster of cloud instances or commodity hardware for maximum performance, concurrency, and availability
cloud_on-premises
Separation of Storage and Compute
Effortlessly scale compute to meet the needs of any workload - both transactions and analytics - independent of storage
single-store
Universal Storage
A new patented single table type that supports both fast transactional and analytical workloads
parallel
Massively Parallel
Scale out shared nothing architecture provides a robust parallel execution engine for read and write queries delivering ultra-fast performance
simplified-architecture-arrow
Limitless Point in Time Recovery (PITR)
Allows users to pick an exact point in time to restore to, down to the microsecond no time horizons or limits
compressed
Compressed On-Disk Tables
Column store disk compression up to 80% optimizes resources for storing up to petabytes of data

Easily Deploy Clusters Anywheredeploy

SingleStore Studio Dashboard
SingleStore is a fully cloud-native database that supports on-premise and multi-cloud/hybrid cloud architectures. Deploy instantly and on-demand with SingleStore Managed Service, or on any of your own infrastructure — including Kubernetes-managed containers, VMs, or commodity hardware.
helios-cloud
Deploy Instantly with SingleStore Managed Service
Get the full capabilities of SingleStore with one-click deployment and easy cloud scalability
kubernetes-container
Deploy Anywhere with Kubernetes
Get maximum flexibility, freedom, and control with container-managed data infrastructure
on-prem
Deploy On-Premises with Ease
SingleStore runs on bare metal and VMs, performing well on both commodity & specialty hardware

Ready to get started?

Experience the performance of The Single Database for All Data-Intensive Applications for your data today

Simple to Setup and Configure with Built-in Monitoringmanage

laptop
SingleStore Studio Dashboard
Powerful management tooling accelerates deployment, backups, and administration tasks. SingleStore Studio provides an intuitive monitoring interface to quickly diagnose and assist query performance tuning.
simplified-architecture-arrow
Limitless Point in Time Recovery (PITR)
Allows users to pick an exact point in time to restore to, down to the microsecond no time horizons or limits
monitor_performance
Monitor Performance and Capacity
Quickly see and diagnose query performance bottlenecks and compute resources to ensure optimal performance and availability
it-operations-management
API Driven Deployment
Accelerate and simplify cluster deployment and configurations with API driven commands
enable-high-availability
Enable High Availability
SingleStore holds a redundant copy of data to protect against data loss. Online replication ensures data consistency
visual-explain
Scalable Multi-Tenancy
Deliver thousands of multi-tenant database instances for cloud applications, delivering premium data isolation and performance with minimal resources
Learn More
cluster-management
Cluster Management
Automate and simplify common tasks including starting, stopping, restoring, backing up clusters
crossdata
Cross Data Center Replication
Synchronize one cluster with another over a broad network connection
connectivity
Tool Interoperability
Seamlessly plug-in with existing devops tooling and cloud formation templates

Comprehensive Security for Your Most Sensitive Datasecure

SingleStore meets or exceeds data security requirements, including managing the most classified data, without compromising database performance. Easily manage how users and roles access data to support workloads in complex organizations and regulated environments.

Security Certifications

SingleStore is committed to protecting our customers and their data and put security at the heart of all we do. We have secured industry-leading security certifications including ISO/IEC 27001, SOC 2 Type 2 and Privacy Shield. SingleStore is also fully compliant to the requirements of HIPAA, CCPA and GDPR. Learn More

GDPR ReadyHIPAA CompliantISO 27001 CertifiedAICPA SOC
users
Role-Based Access Control (RBAC)
Efficiently manage simple or robust security configurations by user role and group while maintaining maximum performance
auditing
Auditing
Database logging writes all activities to a secure external location to support information security tasks such as tracking user access.
credential
Authentication
Manage existing account access with PAM (Pluggable Authentication Module) and SAML authentication support

Compatibility with Your Existing Systemsintegrate

Leverage the MySQL wire protocol or JDBC/ODBC interface to integrate SingleStore with the most popular data services and software tools. Deploy anywhere including on-premises or any cloud for ultimate infrastructure flexibility.
This is a sample of SingleStore integrations. To see how we fit with your systems, please Contact Us


What SingleStore Customers are Saying

Gartner gathered this feedback from SingleStore customers as part of a third-party study.
Learn more about Customer Success Stories.

What SingleStore Customers are Saying

Gartner gathered this feedback from SingleStore users as part of a third-party study. See what they have to say about our product.