Scylla Database Administration & Operations Training Course

Foundations and Architecture

• Introduction to Scylla: Examining its history, typical use cases, and a performance comparison with Cassandra.
• Architecture Deep Dive: Analyzing sharding, partitioning, and the inherently distributed nature of the database.
• Data Model: Gaining a clear understanding of Clustering Keys, Partitions, and Data Types.
• CQL Basics: Getting introduced to the Cassandra Query Language and learning to execute commands via the CQL shell.

Cluster Setup and Administration

• Installation: Procedures for installing Scylla across various operating system platforms.
• Cluster Configuration: Managing seeding processes, replication strategies, and node discovery.
• Working with CQL: Executing advanced queries, designing schemas, and implementing indexing.
• Scylla Tools: An overview of built-in utilities such as nodetool and sstableloader.
• Database Administration: Handling user management, defining permissions, and managing the data lifecycle.

Monitoring, Troubleshooting & Best Practices

• Monitoring: Configuring metrics collection and visualizing overall cluster health.
• Troubleshooting: Techniques for identifying bottlenecks, resolving latency issues, and handling node failures.
• Performance Tuning: Applying best practices for optimal configuration.
• Final Review: A summary of key takeaways and course conclusion.