SingleStore is a scalable SQL database designed for transactional and analytical workloads that demand performance, consistency, and durability. The Single Database for All Data-Intensive Applications can perform as a transactional system and data warehouse in a single integrated architecture for accelerating legacy data architectures or enabling new data intensive applications.
Is everything in Memory?
No. SingleStore utilizes both memory, flash, and spinning disk. SingleStore uniquely accelerates ingest and query performance with memory optimized tables to deliver persistence with full ACID compliance, high availability, and disaster recovery so your data is always accessible.
What is the relationship between SingleStore and MySQL?
SingleStore is a next generation, distributed database built from the ground up for maximum performance for transactions and analytics. The SingleStore server includes its own storage engine and SQL-based execution engine built around scalable distributed execution and lock-free data structures. SingleStore and MySQL servers do not share any code, but SingleStore is compatible with MySQL client software. SingleStore uses the same wire protocol as MySQL and supports similar SQL syntax as MySQL for easier compatibility.
Why is SingleStore based on SQL?
SingleStore was designed to support modern data-intensive applications and real-time analytics while being able to be easily used with existing tools, applications, and skills. SQL is a proven, pervasively used language for writing and retrieving data. It provides rich descriptive capabilities that are interoperable with a large ecosystem of tools, is a straightforward skill to find and learn, and provides the easiest and fastest method to perform analytics.
When is SingleStore a good choice?
SingleStore is a modern NewSQL database that efficiently manages multiple workloads including transactions and analytics in a single integrated relational SQL architecture. SingleStore gives applications maximum performance for real-time decisions and dynamic experiences. Common applications of SingleStore include IoT analytics, fraud detection, streaming media, portfolio analysis, personalization and recommendations, and other data intensive applications. Enterprises choose SingleStore for predictable performance across queries, data ingest, and demanding user concurrency requirements.
SingleStore can be installed in minutes on any Linux compliant system. We recommend using pre-defined Cloud Formation templates to quickly deploy on AWS EC2 environments. Customers can also deploy SingleStore in single and multi-node clusters. To see all the available installation options, please read our installation documentation.
Let us go through your use case and give you a customized quote.
SingleStore licenses software based on the total number of nodes provisioned. Note that Aggregator nodes are not included in the license cost. Customer installations range from a handful to hundreds of nodes. To give you the most accurate information on price, contact us to discuss your schemas, queries, and tables together.
What is included in the free version of SingleStore?
SingleStore offers a free tier for clusters up to 4 nodes (not including Aggregator nodes) and up to 128 GB Memory Capacity. Unlike other database providers, the freely downloadable version of SingleStore is full-featured and includes all the performance, security, and capabilities available in any version of our database. There are no time or deployment restrictions.
An Enterprise subscription comes with 24x7, ticket-based support and unrestricted memory usage (up to the contracted subscription amount) and is unrestricted on the number of nodes used. Updating SingleStore to an Enterprise subscription only requires updating the license key. No migrations or upgrades are required and can be done seamlessly without taking the database offline or impacting your application.
Streaming with exactly-once semantics from Apache Kafka, Amazon S3, Azure Blob, HDFS, and Linux filesystems
A high-throughput, bi-directional, parallelized SingleStore Spark Connector
Where can SingleStore be deployed?
SingleStore runs on any commodity hardware system running Linux. It can be deployed on-premises, in any cloud, or as-a-service. This provides complete flexibility for customers to control how they deploy their data analytics infrastructure.
How does SingleStore scale?
SingleStore scales horizontally on cloud instances or industry-standard hardware, providing high throughput across a wide range of platforms. The distributed system automatically shards data among nodes in a cluster. You can add nodes and redistribute shards (also known as partitions) as needed to scale your workload. For high speed ingestion, SingleStore leverages parallel loading to maximize throughput.
Have questions that weren’t answered?
Contact us to understand how SingleStore can help your solution.