SingleStore is proud to announce the general availability of SingleStore DB 7.3 for immediate download. SingleStore DB 7.3 is also available today on SingleStore Managed Service, the company’s elastic cloud database, available on public cloud providers around the world.
At SingleStore, we are building the next great database platform. SingleStore DB is a distributed operational database that delivers speed and scale. As the leading NewSQL platform for real-time analytics and augmented transaction processing [Ron19], SingleStore DB can handle all your workloads in the cloud or in your data center. This release provides improved ingestion and multi-way join efficiency to further strengthen SingleStore for mission-critical applications providing transaction processing, operational analytics, and more.
This blog post describes the major features of SingleStore DB 7.3 self-managed software and SingleStore Managed Service in some detail.
For a quick 5-minute rundown, checkout the release overview video here:
For even more detail, see the 7.3 release notes.
Why the Cloud World Needs to Simplify to Accelerate
The proliferation of special-purpose datastores is complicating cloud infrastructure, inflating cloud bills, and adding unnecessary latency in copying and moving data from multiple operational stores to analytical stores. To tame the growing cloud complexity and data infrastructure sprawl, organizations should look to solutions like SingleStore that unify workloads across operational and analytical use cases without sacrificing the speed, scale, and flexibility which makes special-purpose datastores attractive. With fewer types of datastores and less data movement among them, data infrastructure is simplified and there are fewer skill sets to maintain allowing you to focus on accelerating your business.
Major Features in SingleStore DB 7.3
Along with improvements across the product, SingleStore DB 7.3 provides notable features in the areas below:
SingleStore supports the MPSQL language for programming internal extensions, including stored procedures and user-defined functions. The 7.3 release enhances this capability by providing additional flexibility for developers in these aspects:
Flexibility for Developers
SingleStore DB now has DDL forwarding, which allows you to send both DDL and DML statements to any aggregator. This simplifies things for your developers so they don’t have to remember which endpoint to use based on the type of operation.
Cloud-Native Ingestion Enhancements
This release has enhancements for data ingestion that are helpful for cloud deployments:
Multi-way Join Efficiency Improvements
For queries that join more than 18 tables, the query optimizer generates plans more quickly and produces query plans that run faster. This enhancement is especially helpful for our large enterprise customers.
SingleStore Universal Storage technology is a suite of features that we are delivering over several releases. The aim of this technology is to support real-time analytics and online transaction processing (OLTP) on SingleStore, with great performance and low total cost of ownership (TCO).
Universal Storage is an extension of our columnstore technology that excels at analytics and which also improves OLTP, including support for indexes, unique keys, seeks, and fast, highly selective, nested-loop-style joins. Because the data is highly compressed and doesn’t all have to fit in RAM, Universal Storage gives excellent TCO.
In this release, SingleStore DB extends Universal Storage with these features:
For a detailed explanation of what’s new in Universal Storage, read Eric Hanson’s blog post here.
Greater Operations Visibility & Resilience
Release 7.3 of SingleStoreDB has improvements that make the product easier and more robust to operate and monitor:
These are just a few of the new features you’ll get when you upgrade to SingleStore DB 7.3. For the full list of features, see the release notes at docs.singlestore.com.
The SingleStore DB 7.3 release delivers a big advance in our ability to support system-of-record applications on SingleStore, including improvements to Universal Storage (upserts, default table type); replication status monitoring; easier Avro schema migrations; faster large joins; and more.
Are you interested in building a data platform with unlimited scale and power? Come join our growing team at http://www.singlestore.com/careers.
[Ron19] Adam Ronthal, There is Only One DBMS Market!, https://blogs.gartner.com/adam-ronthal/2019/07/17/one-dbms-market/, Gartner, 2019.