Our latest enterprise release, ScyllaDB Enterprise 2019.1.10 includes a rich set of features for more efficient querying, reduced storage requirements, lower repair times, and better overall database performance. Already the industry’s most performant NoSQL database, ScyllaDB Enterprise now includes production-ready features beyond the capabilities of Apache Cassandra.
Creates a persistent table that is a subset of a base table, using different keys and thus accelerating the search. The view and the base consistencies are managed by ScyllaDB automatically. Materialized Views are now fully production ready in ScyllaDB Enterprise 2019.1, while still experimental in Apache Cassandra.
Allows you to query data through non-primary key columns, minimizing the amount of data retrieved from the database and resulting in faster interactions. GSI is compatible with Apache Cassandra; however, with ScyllaDB the index is cluster-global and search does not depend on the size of the cluster.
ScyllaDB Enterprise will enable its users to safely balance real-time workloads within a single database cluster. For example, Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP), which have very different data access patterns and characteristics, can be run concurrently on the same cluster.
Users of Size Tiered Compaction Strategy (STCS) have been accustomed to reserving half their total disk to allow for compactions of data. However, with ScyllaDB’s innovative new Incremental Compaction Strategy you can raise disk utilization to 80%, allowing you to store far more data on your existing cluster, or to shrink your deployment and save more than a third of your storage costs.
Get more query flexibility by appending queries with ALLOW FILTERING to bypass some Cassandra query restrictions. Designed for low-selectivity queries, the ALLOW FILTERING command can be executed on regular and primary key columns, reducing the network traffic back to the client and resulting in better application performance.
Now compatible with the latest Apache Cassandra file format (SSTable “mc”), which results in less disk space used and improved performance. The storage volume is reduced by as much as 3X.
Automatically recover intermediate failures by storing up to 3 hours of untransmitted data between nodes. This improves consistency and reduces the repair time and amount of work, resulting in higher overall performance for large clusters.
Increases system responsiveness and efficiency by improving locality and caching of range scans. This feature increases the throughput of range scans by 30%, reduces the amount of data read from the disk by 40% and lowers disk operations by as much as 75%.
Increase the security of the ScyllaDB Enterprise database by implementing RBAC. RBAC is a method of restricting database access based on the roles of individual users within an organization.
Boost the speed of auto-scaling the cluster as well as replacing faulty nodes. These improvements result in higher performance for the overall system when there is a change in the cluster topology.
ScyllaDB Enterprise 2019.1 incorporates the features first introduced in ScyllaDB Open Source 3.0. We invite you to learn more below.
Take a deep dive into Materialized Views, Secondary Indexes and Allow Filtering in this engineering talk from our ScyllaDB Summit.