Scylla Database Administration & Operations Training Course

Foundations and Architecture

• Introduction to Scylla: History, use cases, and a comparison of performance metrics with Cassandra.
• Architecture Deep Dive: Exploring sharding, partitioning, and the distributed nature of the database.
• Data Model: Understanding Clustering Keys, Partitions, and Data Types.
• CQL Basics: An introduction to Cassandra Query Language and executing the CQL shell.

Cluster Setup and Administration

• Installation: Deploying Scylla across various OS platforms.
• Cluster Configuration: Managing seeding, replication strategies, and node discovery.
• Working with CQL: Advanced queries, schema design, and indexing techniques.
• Scylla Tools: Introduction to built-in utilities such as nodetool and sstableloader.
• Database Administration: Handling user management, permissions, and the data lifecycle.

Monitoring, Troubleshooting & Best Practices

• Monitoring: Configuring metrics and visualizing cluster health.
• Troubleshooting: Identifying bottlenecks, latency issues, and node failures.
• Performance Tuning: Applying configuration best practices.
• Final Review: Summary and conclusion.