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 Managed Service, our on-demand, elastic cloud database-as-a-service, and SingleStore DB 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 Managed Service, 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. Managed Service 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.
SingleStore DB 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 Managed Service, 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 Managed Service
SingleStore Managed Service 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 Managed Service, 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.
Benefits of SingleStore Managed Service include:
SingleStore Managed Service 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, Managed Service 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 Managed Service immediately, please contact us to request an invitation.
Also, see our SingleStore Intro playlist on YouTube.
Introducing 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 SingleStore DB 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.
Also in SingleStore DB 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 SingleStore DB 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” Capability
SingleStore DB 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.
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 Today
Managed Service is now available in limited public preview. You can try it now for free, or contact us to purchase Managed Service – availability is limited – or speak to a product specialist for details.
SingleStore Managed Service 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 SingleStore DB 7.0 Beta 2 to try out our new system of record features and Universal Storage. If you are interested in evaluating SingleStore DB 7.0, please contact us to request access. SingleStore DB 7.0 will be generally available in the cloud and for download later this year. Sign up for our upcoming Managed Service webinar to learn more.
Also, see our SingleStore Intro playlist on YouTube.