 | This article has multiple issues. Please helpimprove it or discuss these issues on thetalk page.(Learn how and when to remove these messages) (Learn how and when to remove this message)
|
 | |
| Genre | RDBMS |
|---|---|
| Founded | January 2011 (2011-01) |
| Founders |
|
| Headquarters |
|
Area served | Worldwide |
Number of employees | 380[1] |
| Website | www |
SingleStore (formerlyMemSQL) is adistributed,relational,SQLdatabase management system[2] (RDBMS) that features ANSISQL support, it is known for speed indata ingest,transaction processing, and query processing.[3][4]
SingleStore stores relational data,JSON data, geospatial data, key-value vector data, andtime series data. It can be run in variousLinux environments, includingon-premises installations,public andprivate cloud providers, in containers via aKubernetes operator, or as a hosted service in the cloud known as SingleStore Helios.[5][6]
Recent updates have included bi-directional integration with Apache Iceberg, faster vector search, enhanced full-text search, autoscaling and a ‘bring your own cloud’ deployment.[7] In its latest release, v.8.9, SingleStore added support for continuous ingest from Iceberg tables, as well as Polaris and Hive catalogs, support for foreign languages as well as n-grams in full-text search; simplified pipelines; a no-code interface that simplifies data ingestion from S3, CSV and MongoDB sources; and disk spilling that now works on right and full join, as well as writable views and vector indexes on nullable columns.[8]
On April 23, 2013, SingleStore launched its first generally available version of the database to the public as MemSQL.[9] Early versions supportedrow-oriented tables, and were optimized for cases where all data fit withinmain memory. This design was based on the idea that the cost ofRAM would continue to decrease exponentially over time, in a trend similar toMoore's law. This would eventually allow most use cases for database systems to store their data exclusively in memory.
Shortly after launch, MemSQL added general support for an on-disk column-based storage format to work alongside the in-memory rowstore.[10]
On October 27, 2020, MemSQL rebranded to SingleStore to reflect a shift in focus away from exclusively in-memory workloads.[11]
In April 2023, SingleStore introduced new features to enhance real-time AI capabilities, focusing on faster data processing and more efficient AI-driven applications.[12] In May, the company introduced additional tools aimed at enhancing generative AI (GenAI) and analytics capabilities. The update included features designed to improve data processing, scalability, and performance, enabling more efficient analytics and AI-driven insights for complex data workloads.[13]
In July 2023, SingleStore announced a partnership with AWS to advance real-time data analytics and AI applications.[14]
In August 2023, IBM announced a collaboration with SingleStore to integrate its watsonx.ai platform for developing generative AI applications.[15]
In January 2024, SingleStore announced a new capability under the name SingleStore Kai that added MongoDB API compatibility to SingleStore allowing users to bring in data from MongoDB and run the same queries within SingleStore.[16][17]
In September 2024, SingleStore announced its integration with Snowflake by making SingleStore available as a Snowflake Native App in the Snowpark Container Services (SPCS) marketplace.[18][19]
In October 2024, the company announced the acquisition of BryteFlow, a leading data integration platform. The move expanded SingleStore’s capacity to ingest data from a wide range of sources like SAP, Oracle, Salesforce, and many more, enabling customers to operationalize data from their CRM and ERP systems at scale and in real time.[20][21][22] This capability has been added into the product under the name "SingleStore Flow" or simply "Flow".[23]
Headquartered inSan Francisco, California, in June 2021 SingleStore opened an office inRaleigh, North Carolina. Its other offices includeSunnyvale, California;Seattle, Washington; London, England; Hyderabad, India; andLisbon, Portugal.[24]
In January 2013, SingleStore announced it raised $5 million. Since then, the company has raised $318.1M from investors includingKhosla Ventures, Accel, Google Ventures, Dell Capital andHPE, among others.[25] In October 2022, SingleStore closed Series F-2 and welcomed new investor Prosperity7.[26]
| Series | Date | Amount (million $) | Lead Investors |
|---|---|---|---|
| A | 2013 | 5 | DVCA, IA Ventures |
| B | 2014 | 35[5] | Accel |
| C | 2016 | 36[5] | Caffeinated Capital, REV |
| D | 2018 | 30[2] | Google Ventures, Glynn Capital |
| E | Dec. 2020 | 80[27] | Insight Partners |
| F | Sept. 2021 | 80[3] | Insight Partners |
| G | July 2022 | 116[28] | Goldman Sachs Asset Management |
| F-2 | October 2022 | 30[26] | Prosperity7 |
SingleStore can store data in eitherrow-oriented tables ("rowstores") orcolumn-oriented tables ("columnstores"). The format used is determined by the user when creating the table.[29]
Rowstore tables, as the name implies, store information in row format, which is the traditional data format used byRDBMS systems. Rowstores are optimized for singleton or small insert, update, or delete queries and are most closely associated withOLTP (transactional) use cases. Data for rowstore tables is stored completely in-memory, making random reads fast, with snapshots and transaction logs persisted to disk. Columnstores are optimized for complex SELECT queries, typically associated withOLAP (analytics) and data warehousing use cases.[30]
Rather than the traditional B-tree index, SingleStore rowstores useskiplists optimized for fast, lock-free processing in memory. Columnstores store data in sorted segments, in order to maximize on-disk compression and achieve fast ordered scans. SingleStore also supports using hash indexes as secondary indexes to speed up certain queries.[31][32]
A SingleStore database is distributed across many nodes, which may be cloud-based servers or commodity machines. Data is stored in partitions on leaf nodes, and users connect to aggregator nodes.[33][34] A single piece of software is installed for SingleStore aggregator and leaf nodes; administrators designate each machine’s role in the cluster during setup. An aggregator node is responsible for receiving SQL queries, breaking them up across leaf nodes, and aggregating results back to the client. A leaf node stores SingleStore data and processes queries from the aggregator(s). All communication between aggregators and leaf nodes is done over the network using SQL. SingleStore uses hash partitioning to distribute data uniformly across the number of leaf nodes.[35]
Durability for the in-memory rowstore is implemented with a write-ahead log and snapshots, similar to checkpoints. With default settings, as soon as a transaction is acknowledged in memory, the database will asynchronously write the transaction to disk as fast as the disk allows.[36]
A SingleStore cluster can be configured in "High Availability" (HA) mode, where every data partition is automatically created with primary and replica partitions on two separate leaf nodes. In HA mode, aggregators send transactions to the primary partitions, which then send logs to the secondary partitions. In the event of an unexpected primary failure, the replica partitions take over as primary partitions, in a fully online operation with no downtime.[37]
In 2024, SingleStore updated its architecture to include support for Apache Iceberg, enabling more efficient data lake management and querying.[38] The release also added enhanced full-text search for more efficient data retrieval, autoscaling for better resource management, and a "bring your own cloud" deployment option, offering users greater flexibility in cloud infrastructure choices.[39][40][41]
SingleStore can be downloaded for free and run on Linux for systems up to 4 leaf nodes of 32 gigs RAM each; an Enterprise license is required for larger deployments and for official SingleStore support.SingleStore is also available as a managed service named SingleStore Helios, available in various regions inGoogle Cloud and Amazon Web Services. The underlying engine and potential system performance are identical in all distribution formats.[1]
SingleStore includes a set of tools, called SingleStore Tools, for installing, managing, and monitoring its distributed database across multiple machines. It also offers a browser-based interface, SingleStore Studio, for running queries, monitoring the database, and viewing cluster health and status.[2]
{{cite web}}:|last= has generic name (help)