July 2024 Summaries

DBSchema, a visual database design and management tool, has recently introduced support for ScyllaDB, providing an alternative to the traditional cqlsh command-line interface for users. This advancement allows users, especially those new to ScyllaDB, to visually design database schemas and run queries more easily across both NoSQL and SQL databases such as PostgreSQL, MongoDB, and Snowflake. DBSchema facilitates the visualization of keyspaces, tables, columns, and column types, offering an intuitive way to perform tasks that would typically require command-line instructions. It supports both self-hosted and cloud versions of ScyllaDB and is available in a free version for Windows, Mac, and Linux. Users can start using DBSchema by downloading it, connecting to a ScyllaDB database, and employing its graphical user interface to run CQL queries and manage databases effectively, with the same output as cqlsh but enhanced with visual aids.

BenchANT's comprehensive study evaluates the performance and scalability of MongoDB and ScyllaDB under a social media workload scenario, revealing that ScyllaDB substantially outperforms MongoDB in terms of throughput, latency, scalability, and cost-efficiency. Using a read-heavy workload modeled on YCSB Workload B, the tests demonstrate that ScyllaDB achieves significantly higher throughput and lower latencies than MongoDB across different workload distributions and scaling sizes, with ScyllaDB reaching up to 12 times higher throughput and significantly lower update latencies. ScyllaDB also shows near-linear scalability, with its throughput scalability closely aligning with theoretical expectations, while MongoDB experiences a larger gap between theoretical and actual scalability. In terms of cost-efficiency, ScyllaDB offers a superior throughput per cost ratio compared to MongoDB, especially under hotspot distribution conditions. Additionally, the study explores the impact of different data models and consistency levels on performance, showing that ScyllaDB benefits more from a key-value data model and weaker read consistency settings in terms of throughput increases.

ScyllaDB is a distributed database system that achieves scalability and fault tolerance by dispersing and replicating data across multiple nodes without following a leader-follower topology, allowing any node to serve as a coordinator for data requests. It employs a hash ring system to map data to nodes, supporting tunable consistency levels to balance between availability and consistency, thus classifying it as an AP system according to the CAP theorem. With options like quorum-based consistency, ScyllaDB can maintain availability even during network partitions, although this may lead to eventual consistency where data converges over time. By prioritizing availability, ScyllaDB differentiates itself from traditional relational databases and aligns with the PACELC theorem's notion of trading off consistency for latency in specific scenarios.

ScyllaDB Cloud enhances the security of customer data through database-level encryption at rest, employing Customer-Managed Keys (CMK) to give clients control over their encryption keys or the option to delegate management to ScyllaDB. This encryption method, available on AWS and GCP platforms, complements the default storage-level encryption by encrypting data before storage, protecting against unauthorized access. The process involves using data encryption keys (DEKs) that are wrapped with master keys (MKs) stored in key management services, preventing data decryption without the MK. ScyllaDB Cloud supports multi-region deployment, ensuring data security across regions, and offers cost-effective management of encryption keys while complying with industry regulations. Customers can opt for ScyllaDB-managed keys, simplifying the process and reducing administrative overhead, thereby allowing them to focus on their core operations while maintaining robust data protection.

Freshworks, a company providing AI-enhanced business software, tackled challenges related to high tail latencies and administrative burdens while managing extensive data across various databases, including Cassandra. To address these issues and prepare for future growth, Freshworks transitioned to ScyllaDB, which proved to be cost-effective and efficient in reducing latency, easing administrative stress, and enabling scalability. The migration involved dual writes on Cassandra databases, snapshotting, and phased data transfer to ScyllaDB, achieving a significant reduction in tail latency. Freshworks plans further integration of ScyllaDB, including moving text and BLOB data from MySQL to ScyllaDB, to enhance performance and scalability across its operations.