Scylla Database Administration & Operations Training Course

Foundational Principles and System Architecture

• Overview of Scylla: Historical context, operational use cases, and comparative performance analysis against Cassandra.
• Architectural Analysis: Examination of sharding mechanisms, partitioning logic, and the distributed infrastructure of the database.
• Data Modeling: Comprehension of clustering keys, partition structures, and supported data types.
• CQL Fundamentals: Introduction to the Cassandra Query Language (CQL) and operational utilization of the CQL shell.

Cluster Deployment and Administrative Operations

• Installation Procedures: Deployment of Scylla across various operating system environments.
• Cluster Configuration: Implementation of seeding, replication strategies, and node discovery protocols.
• Advanced CQL Implementation: Execution of complex queries, schema optimization, and indexing strategies.
• Operational Tooling: Overview of integrated utilities such as nodetool and sstableloader.
• Administrative Governance: User access management, permission hierarchies, and data lifecycle management.

Monitoring, Diagnostics, and Operational Best Practices

• Performance Monitoring: Configuration of metrics collection and visualization of cluster health status.
• Diagnostic Procedures: Identification and resolution of bottlenecks, latency anomalies, and node failures.
• Performance Optimization: Application of recommended configuration standards.
• Conclusion: Comprehensive summary and final assessment.