Scylla Database Administration & Operations Training Course

Foundations and Architecture

• Introduction to Scylla: History, use cases, and performance benchmarks compared to Cassandra.
• Architecture Deep Dive: Sharding, partitioning, and the distributed nature of the database.
• Data Model: Understanding Clustering Keys, Partitions, and Data Types.
• CQL Basics: Introduction to Cassandra Query Language and using the CQL shell.

Cluster Setup and Administration

• Installation: Installing Scylla across various operating systems.
• Cluster Configuration: Seeding, replication strategies, and node discovery.
• Working with CQL: Advanced queries, schema design, and indexing.
• Scylla Tools: Overview of built-in utilities such as nodetool and sstableloader.
• Database Administration: User management, permissions, and data lifecycle management.

Monitoring, Troubleshooting & Best Practices

• Monitoring: Setting up metrics and visualizing cluster health.
• Troubleshooting: Identifying bottlenecks, latency issues, and node failures.
• Performance Tuning: Best practices for configuration.
• Final Review: Summary and conclusion.