Scylla Database Administration & Operations Training Course

Core Principles and Architecture

• Introduction to Scylla: Examining its history, key use cases, and performance benchmarks relative to Cassandra.
• Architectural Analysis: Exploring sharding, partitioning mechanisms, and the intrinsic distributed nature of the system.
• Data Modeling: Comprehending Clustering Keys, Partition structures, and supported Data Types.
• CQL Fundamentals: Getting started with the Cassandra Query Language and utilizing the CQL shell.

Cluster Deployment and Management

• Installation: Deploying Scylla across various operating system platforms.
• Cluster Configuration: Managing seeding processes, replication strategies, and automatic node discovery.
• Advanced CQL Usage: Executing complex queries, optimizing schema design, and implementing indexing.
• Scylla Utility Suite: Overview of essential built-in tools (including nodetool, sstableloader, and others).
• Administrative Operations: Handling user management, permission controls, and data lifecycle management.

Observability, Diagnostics & Optimization

• Monitoring: Implementing metrics collection and visualizing overall cluster health.
• Diagnostic Practices: Detecting performance bottlenecks, latency anomalies, and node-level failures.
• Performance Enhancement: Applying best practices for configuration and tuning.
• Course Conclusion: Key takeaways and final summary.