On this page
SingleStoreDB Cloud is a standalone distributed database that is compatible with MySQL client software.
SingleStoreDB Cloud is not a storage engine or other component of MySQL, nor is MySQL a component of SingleStoreDB Cloud, and the SingleStoreDB Cloud and MySQL servers do not share any code.
Users use MySQL client software to connect to the SingleStoreDB Cloud server.
SingleStoreDB Cloud implements the MySQL wire protocol in order to provide compatibility with MySQL client software.
SingleStoreDB Cloud provides both in-memory row-based and on-disk column-based stores.
The in-memory row store:
Works best for mixed transactional and analytical workloads
Provides low latency and highly concurrent reads and writes of individual rows as well as sophisticated analytical SQL queries
Supports PRIMARY and UNIQUE keys
Supports geospatial indexes
Has longer recovery times (as the entire table needs to be loaded into memory)
The on-disk column store:
Works best for analytical workloads
Allows tables larger than the amount of available RAM in the workspace
Uses compression (which lowers disk usage and accelerates replication)
Provides fast and efficient scans of large datasets
Provides sorted columnstore indexes
Is optimized for batch
Requires more expensive query compilation (as compared to the row store)
SingleStoreDB Cloud’s storage engine uses multi-version concurrency control with lock-free skip lists and lock-free hash tables which allow highly concurrent reads and writes at very high throughput.
What is the advantage of SingleStoreDB Cloud over traditional databases like Oracle, SQL Server or MySQL with data in a
ramdisk or large buffer pools?
Two common techniques for leveraging large amounts of memory in traditional databases are storing data files on a
ramdisk or running a disk-based storage engine with a large buffer pool.
While running an existing storage engine like InnoDB in memory can alleviate some of the bottlenecks involved with disk, SingleStoreDB Cloud has four distinguishing memory-optimized features that enable it to perform significantly better than disk-based storage engines running in memory:
SingleStoreDB Cloud is a distributed scale-out system.
SingleStoreDB Cloud scales to thousands of machines on commodity hardware.
No buffer pool.
Traditional databases manage a global buffer pool since they assume that the dataset can’t fit into memory. The buffer pool is a resource shared across all databases and all tables, which creates significant contention.
Lock-free data structures.
SingleStoreDB Cloud uses memory-optimized, lock-free skip lists and hash tables as its indexes. Unlike B+ Trees, these data structures are designed from the ground up to be fast in memory.
Lock-free data structures are so fast that dynamic SQL interpretation quickly becomes the limiting factor for query execution. With code generation, SingleStoreDB Cloud compiles SQL down to native code for maximum performance.
SingleStoreDB Cloud supports full SQL and transactional semantics.
SingleStoreDB Cloud combines row and column store engines tuned for memory and flash storage.
Scales on commodity hardware.
SingleStoreDB Cloud does not require exotic hardware and can run on-premises or in the Cloud.
SingleStoreDB Cloud supports a large number of enterprise security and manageability features.
SingleStoreDB Cloud excels at real-time and high throughput query use cases.
SingleStoreDB Cloud is not designed to be a blob store. It is designed for high value data that is structured or semi-structured and ready to query. SingleStoreDB Cloud has open-source connectors for integrating with a variety of object stores, including Amazon S3 and Hadoop File System (HDFS).
SingleStoreDB Cloud is not run as a library or in-process with an application. SingleStoreDB Cloud is a distributed database which runs in separate processes from the application, and applications connect to SingleStoreDB Cloud via a client driver.
SingleStoreDB Cloud offers the same capabilities, including the ingest and query performance, scalability, and resiliency available in our self-managed software, but without having to worry about installation or workspace administration.
SingleStore automatically provisions infrastructure, deploys and configures workspace software, maintains availability, provides scalability, performs backups, and handles software upgrades including SingleStore, operating system, and system software.
To give you the most accurate information on sizing, contact us to discuss your schemas, queries, and tables together.
We’re currently working on adding more regions, but if you need a specific region please contact us to make it available.
There is no data ingress cost for SingleStoreDB Cloud but you may incur a charge from your Cloud Service Provider (CSP).
I've explored SingleStoreDB Cloud in the free trial and now want to POC a larger workspace.
How do I do that?
Contact us to learn more about your use case.
Last modified: January 10, 2023