Scylla Database Administration & Operations Training Course

Foundations and Architecture

• Introduction to Scylla: Explore its history, common use cases, and performance metrics relative to Cassandra.
• Architecture Deep Dive: Examine sharding, partitioning, and the distributed nature of the database.
• Data Model: Gain a clear understanding of Clustering Keys, Partitions, and Data Types.
• CQL Basics: Get introduced to the Cassandra Query Language and learn to operate the CQL shell.

Cluster Setup and Administration

• Installation: Learn how to install Scylla across various operating system platforms.
• Cluster Configuration: Master seeding, replication strategies, and node discovery processes.
• Working with CQL: Delve into advanced queries, schema design, and indexing techniques.
• Scylla Tools: Become familiar with built-in utilities such as nodetool and sstableloader.
• Database Administration: Manage user access, permissions, and the data lifecycle effectively.

Monitoring, Troubleshooting & Best Practices

• Monitoring: Set up comprehensive metrics and visualize cluster health status.
• Troubleshooting: Identify and resolve bottlenecks, latency issues, and node failures.
• Performance Tuning: Apply configuration best practices for optimal performance.
• Final Review: Receive a summary of key concepts and conclusions.