Scylla Database Administration & Operations Training Course

Foundations and Architecture

• Introduction to Scylla: Overview of its history, applicable use cases, and performance metrics relative to Cassandra.
• Architecture Deep Dive: Examination of sharding, partitioning, and the distributed nature of the database.
• Data Model: Comprehension of Clustering Keys, Partitions, and Data Types.
• CQL Basics: Introduction to the Cassandra Query Language and execution of the CQL shell.

Cluster Setup and Administration

• Installation: Deployment of Scylla across various operating system platforms.
• Cluster Configuration: Managing seeding, replication strategies, and node discovery.
• Working with CQL: Execution of advanced queries, schema design, and indexing.
• Scylla Tools: Overview of built-in utilities such as nodetool and sstableloader.
• Database Administration: Management of users, permissions, and the data lifecycle.

Monitoring, Troubleshooting & Best Practices

• Monitoring: Configuration of metrics and visualization of cluster health.
• Troubleshooting: Diagnosis of bottlenecks, latency issues, and node failures.
• Performance Tuning: Implementation of configuration best practices.
• Final Review: Summary and concluding remarks.