Announcing SingleStore Helios: The World’s First Universal Storage, System of Record Cloud Database


Peter Guagenti


Announcing SingleStore Helios: The World’s First Universal Storage, System of Record Cloud Database

SingleStore extends our operational data platform with an on-demand, elastic cloud service, and new features to support Tier 1 workloads.

SingleStore is proud to announce two exciting new product releases today: Singlestore Helios, our on-demand, elastic cloud database-as-a-service, and SingleStoreDB Self-Managed 7.0 Beta 2, the next major release of our database engine, featuring SingleStore Universal Storage™ – a breakthrough new way of managing data – and new features to fully support Tier 1, system of record workloads.

With Singlestore Helios, you get instant, effortless access to the world’s fastest, most scalable data platform for operational analytics, machine learning, and AI, with platform operations handled by SingleStore. Singlestore Helios is a fully managed cloud service that provides you with instant access to our best-in-class operational database — on demand and at elastic scale — in public cloud environments around the world.

SingleStoreDB Self-Managed 7.0, which will be generally available in the coming months, brings two exciting new advance advances: SingleStore Universal Storage and key features to make SingleStore “system of record” capable for Tier 1 workloads.

Data platform spending is seeing explosive growth as new applications are built to support real-time decisions, predictive analytics, and automation leveraging machine learning and AI. With this growth, and the desire for greater flexibility and cost control, more and more data workloads are moving to the cloud; see Gartner’s perspective in this recent analyst research.

The vast majority of SingleStore’s customers are already deploying our database in the cloud, typically using deployment automation or container infrastructure. Many have chosen SingleStore as the cloud migration path from older, on-premises operational database implementations.

The availability of Singlestore Helios, along with the imminent release of Universal Storage and the new system of record capabilities, make SingleStore the ideal choice for both new applications and to move legacy operational databases to the cloud.

announcing-singlestore-heliosAnnouncing Singlestore Helios

Singlestore Helios has the best-in-class speed, scale, and robust features you have come to expect from SingleStore, but now available on demand. Customers can focus on using their data to build breakthrough applications and analytical systems instead of mundane infrastructure management and tuning.

With Singlestore Helios, there’s no software to deploy or manage. The most important steps in getting started are choosing an initial deployment size from a pull-down menu, then clicking a button to initiate deployment. Compute and storage resources are automatically assigned, the necessary software is installed and configured, and clusters are created, ready to store data — all in a few minutes. High availability is built in, with SingleStore handling data backup and, if needed, restore operations.

SingleStoreDB Cloud provides a managed service for a fast, scalable SQL database.
SingleStoreDB Cloud handles infrastructure monitoring, cluster configuration, management, maintenance, and support.

Benefits of Singlestore Helios include:

  • Effortless deployment and management. As we have all come to expect from cloud services, deployment and upgrades are built in. With Singlestore Helios you get the full benefits and capabilities of the SingleStore data platform without having to worry about deployment, management, or maintenance. There’s no need to rack servers, script deployments, or manage VMs.
  • Avoid cloud lock-in through multi-cloud flexibility. Singlestore Helios is available today on Amazon Web Services and Google Cloud Platform. SingleStore operates exactly the same whether deployed on-premises on bare metal, across on-premises or cloud infrastructure, using the SingleStore Kubernetes Operator, or within the Singlestore Helios service. You can use SingleStore to support a broad set of operational and analytical use cases, allowing for a simple, single platform across applications, analytical systems, and cloud deployments.
  • Superior TCO. Compared to both legacy databases and proprietary databases from the cloud service providers, Singlestore Helios offers superior total cost of ownership (TCO). SingleStore offers high performance, scalability, ANSI SQL support, and the ability to replace traditional databases like Oracle Exadata and SAP Hana, at a fraction of the cost. When compared to the proprietary databases offered on Amazon Web Services and Google Cloud Platform, SingleStore’s unique architecture and high-performance query engine mean that many operational analytics workloads run with far less resource consumption, offering significant cost savings.

Singlestore Helios is available in limited public preview today. The service is secure, stable, and ready for your production workloads. There is a time-limited trial open to all users; however, Singlestore Helios is initially available only to a limited number of customers to purchase. Try it for yourself now, or request a technical deep dive with a product specialist. If you are interested in purchasing Singlestore Helios immediately, please contact us to request an invitation.

Also, see our SingleStore Intro playlist on YouTube.

introducing-universal-storage-breakthrough-data-management-from-single-storeIntroducing Universal Storage: Breakthrough Data Management from SingleStore

With legacy databases, customers had their data in silos: transaction data in rowstore tables, analytics and data warehousing systems using columnstore tables, and extract, transform, and load (ETL) operations to bridge the gap. SingleStore brings rowstore and columnstore tables together in a single database; ETL is eliminated, and SQL queries can combine data from both types of tables. With Universal Storage, in future versions of SingleStore, we will eliminate the need to choose one table type or another. The system will optimize storage and data access for you.

SingleStore is seeking to eliminate data duplication, reduce complexity, and cut total cost of ownership with the launch of SingleStore Universal Storage, a new breakthrough in data architecture. In the future, Universal Storage will offer the fastest possible performance, at the lowest possible cost, for every kind of workload – transactional, analytical, and hybrid – by storing all data in a single table type.

In SingleStoreDB Self-Managed 7.0, Universal Storage is delivered through improvements to both rowstore and columnstore tables, allowing each to handle workloads that previously only worked well on the other. Rowstore tables – used for transactions, for seeking a few rows of data, and for analytics on rapidly-changing data – get null elimination via the new sparse compression feature. In null elimination, fields that are subject to sparse compression are labeled as SPARSE when the table is created.

For each sparse field, a flag is created, half a byte wide. When the field’s value is null, the flag is set by the database software, and no value is stored for that column, saving that amount of storage – often 4, 8, or 16 bytes per null. Null elimination reduces the memory footprint of many rowstore tables by 50% or more, cutting memory usage and costs by half or more.

Rowstore compression reduces storage space and TCO due to memory usage.
Setting the SPARSE flag causes appropriate fields to have null values indicated by flags, rather than by a null value taking up the normal field width.

Also in SingleStoreDB Self-Managed 7.0, columnstore tables – highly useful for most analytics purposes, but much harder to update efficiently than rowstore tables – get multiple secondary indexes, allowing fast seeks on multiple access paths, and locking at row level, which enables higher concurrency of updates and deletes.

With the initial implementation of SingleStore Universal Storage delivered in SingleStoreDB Self-Managed 7.0, you can use columnstore for more workloads than you could before – workloads that previously required rowstore. Using columnstore for these additional workloads means lower total cost of ownership (TCO), while still meeting service level agreements (SLAs) and user expectations. In addition, for the workloads that still require the updating capabilities and even faster performance of rowstore, compression lowers TCO for those workloads as well.

new-features-enable-system-of-record-capabilityNew Features Enable “System of Record” Capability

SingleStoreDB Self-Managed 7.0 also introduces two key availability features which combine to enable Tier 1, system of record workloads: much faster sync replication, turned on by default, and incremental backup.

Fast sync replication introduces a high-availability replication option — the ability to always keep a replicated, live copy of your database as it’s receiving updates. Together with the availability of sync durability (copy to disk required for an update to be logged), long supported in SingleStore, sync replication enables the level of data safety required for Tier 1, system of record workloads.

SingleStoreDB Self-Managed 7.0 pairs synchronous replication (sync rep) and synchronous duplication (sync dup) to provide strong resilience options.
Fast sync replication in SingleStoreDB Self-Managed 7.0 makes it possible to run high availability with a small performance hit.

Incremental backup extends the software’s capabilities beyond the ability to do full backups, to include regular backups of changed data from select time frames, and the ability to restore reliably from the previous full backup plus incremental backups.

Together, the addition of the ability to regularly backup recently changed data, and the ability to synchronously replicate your data, mean that SingleStore can now be trusted for critical data workloads.

get-started-todayGet Started Today

Singlestore Helios is now available in limited public preview. You can try it now for free, or contact us to purchase Singlestore Helios – availability is limited – or speak to a product specialist for details.

SingleStoreDB Cloud live webinar and demo

Singlestore Helios is secure, stable, and ready for production immediately. The service is priced based on consumption, with options for both on-demand purchase and discounted prepaid subscriptions. Not all deployment regions are supported initially.

Existing SingleStore customers can download SingleStoreDB Self-Managed 7.0 Beta 2 to try out our new system of record features and Universal Storage. If you are interested in evaluating SingleStoreDB Self-Managed 7.0, please contact us to request access. SingleStoreDB Self-Managed 7.0 will be generally available in the cloud and for download later this year. Sign up for our upcoming Singlestore Helios webinar to learn more.

Also, see our SingleStore Intro playlist on YouTube.