Frequently Asked Questions
What is SingleStore?
SingleStore offers a fast, distributed, cloud SQL database designed to power modern data-intensive applications. It is designed to deliver maximum performance for both transactional (OLTP) and analytical (OLAP) workloads in a single unified engine to drive maximum performance for your applications. With SingleStore you can ingest and update millions of events per second, while simultaneously delivering blazing fast SQL queries on billions of rows of data.
Is everything in Memory?
No. SingleStore utilizes both memory and disk storage as well as Cloud object storage. SingleStore uniquely accelerates ingest and query performance with our patented Universal Storage to deliver persistence with full transaction support, high availability, and disaster recovery so your data is always accessible.
Moreover, SingleStore offers Separation of Storage and Compute, for both transactions and analytics, allowing users to effortlessly scale compute to meet the needs of any workload, while managing storage needs completely independently. This allows SingleStore to store nearly limitless volumes of data without increasing query latency or giving up on our industry-leading performance.
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. SingleStore offers a ground-breaking Universal Storage engine and SQL-based execution built around a scalable distributed architecture and lock-free data structures. SingleStore and MySQL 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 and migrations. A number of leading customers have migrated from MySQL to SingleStore to drive performance and limitlessly scale their data-intensive applications.
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. Moreover, SQL provides physical data independence, meaning that you can change table and index structures without changing application code - a major advantage over NoSQL platforms.
When is SingleStore a good choice?
SingleStore is a modern relational database that offers blazing fast performance and limitless scalability for both transactional and analytical workloads in a single unified architecture. SingleStore is ideal when your applications need fast ingest and high-performance queries while being able to scale to high concurrency. A number of customers also move to SingleStore to simplify their data architectures by being able to consolidate multiple SQL and NoSQL databases into SingleStore to drive up to 100x the performance at ⅓ the costs.
SingleStore gives applications maximum performance for real-time decisions and dynamic experiences. Many customers utilize SingleStore to power modern data-intensive applications including dynamic customer experiences, real-time marketing, streaming media telemetry, portfolio analysis, fraud detection, user personalization and recommendations, IoT analytics, and other dynamic use cases.
How does SingleStore compare to Oracle?
SingleStore can drive 10-100x better performance at just 1/3 or 1/4th of the Cost compared to Oracle. We have a number of leading enterprise customers who have moved from Oracle and Oracle Exadata to drive down costs while improving the performance of their applications.
Check out our Oracle vs SingleStore comparison page to learn more
How easy is it to deploy SingleStore?
SingleStore can be deployed in minutes on any of the leading public clouds of your choice including AWS, Azure, and Google Cloud. Customers can also deploy SingleStore on-premises in single and multi-node clusters. To try SingleStore today sign up for our free trial.
How much does SingleStore cost?
SingleStore is priced by the size of the deployment and offers a flexible usage model for our managed service using compute credits. You can get started with SingleStoreDB Cloud for as low as $0.65/hour. Our customers use SingleStore for everything from powering their startup application to some of the largest mission-critical Enterprise applications in the world. SingleStore pricing is available on our public pricing page, but to help size your specific workloads contact our customer enablement team directly using the link below. Request a quote
What is included in the free version of SingleStore?
SingleStore offers a free trial for customers to try out our database, load sample datasets, and evaluate existing workloads. The SingleStore trial is full-featured and includes the features, performance, and security capabilities available in the production version of the product.
What is included in the Enterprise Subscription?
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. Book a Demo
Integrations & Deployments
How do I connect with SingleStore?
SingleStore supports most MySQL-compatible clients and libraries such ODBC and JDBC drivers from MariaDB and MySQL, and provides dedicated ODBC and JDBC drivers.
What data sources does SingleStore work with?
SingleStore supports several ways to ingest data, listed below.
- Batch loading command (LOAD DATA) for one-time loads
- Streaming load (pipelines) with exactly-once semantics from Apache Kafka, Amazon S3, Azure Blob, HDFS, and Linux filesystems
- A high-throughput, bi-directional, parallelized SingleStore Spark Connector
- High-speed INSERT, UPDATE, and UPSERT based on compiled code.
Where can SingleStore be deployed?
SingleStore is deployed as a cloud database as a service, and can also be run on commodity hardware on premises, or self-hosted on the public cloud, on Linux. This provides complete flexibility for customers to control how they deploy their infrastructure for data-intensive applications and analytics.
How does SingleStore scale?
SingleStore scales out horizontally using a distributed cluster architecture, providing high throughput and fast response time for query execution. The storage engine automatically shards data across the cluster, allowing you to scale your workload as needed. SingleStore also leverages parallel loading together with the clustered architecture to maximize throughput on data ingestion. And SingleStore's single-core speed is 10x to 100x or more the speed of many legacy database platforms, which means we use hardware efficiently, saving you money or enabling new applications that were infeasible before.