With the SingleStoreDB On-Premises 7.1 release, we’re continuing our journey to a simpler data platform, offering speed, scalability, and SQL – accessible to everyone, and easy to use. The release is available today as downloadable software and at the core of SingleStoreDB Cloud, our elastic managed service in the cloud.
There is a trend, especially in the cloud, to add a new, specialized data management technology for each separate type of workload. Part of our solution to this is SingleStore Universal Storage, which unifies transactions and analytics in a single data table.
With the 7.1 release, we add broader support for indexes and unique keys in columnstore tables. This allows fast, rowstore-type updates to be performed on highly compressed, disk-based columnstore data, with much lower total cost of ownership (TCO).
A modern database must recover quickly from hardware, software, and networking failures. In SingleStoreDB On-Premises 7.1, we add fast DR failback – that is, the ability to return to your original data configuration much more quickly, after an error. We accomplish this by tracking and restoring recent updates incrementally. The result is greater flexibility and less downtime.
In SingleStoreDB On-Premises 7.1, we have extended our programming language, SingleStore Procedural SQL (MPSQL), to directly support functions that exist in other systems, making it easier to bring existing programs into SingleStore. And we have added new functions that greatly simplify coding when fetching data.
In SingleStoreDB On-Premises 7.1, we add the ability to back up data incrementally to more environments: Amazon S3, Azure Blob Store, and Google Cloud Platform. This makes data management easier in the cloud. You can now also upgrade SingleStore online, without downtime. And you will see improvements in SingleStore Tools and new, first-ever self-paced training modules.
Our new release includes a range of other features in the areas of fast and flexible data ingest, query optimization for faster query response, backup flexibility for databases that grow in size, the ability to work with data tables, security, and more.
For more information, please see below: