Scylla Database Administration & Operations Training Course

Foundations and Architecture

• Introduction to Scylla: Overview of its history, use cases, and performance metrics relative to Cassandra.
• Architecture Insights: A closer look at sharding, partitioning, and the distributed nature of the database.
• Data Model: Grasping the concepts of Clustering Keys, Partitions, and Data Types.
• CQL Essentials: Introduction to the Cassandra Query Language and using the CQL shell.

Cluster Setup and Administration

• Installation: Deploying Scylla across various operating system platforms.
• Cluster Configuration: Managing seeding, replication strategies, and node discovery.
• Working with CQL: Executing advanced queries, designing schemas, and implementing indexing.
• Scylla Utilities: Introduction to built-in tools such as nodetool and sstableloader.
• Database Administration: Handling user management, permissions, and data lifecycle.

Monitoring, Troubleshooting & Best Practices

• Monitoring: Configuring metrics and visualising cluster health.
• Troubleshooting: Diagnosing bottlenecks, latency issues, and node failures.
• Performance Tuning: Applying best practices for configuration.
• Final Review: Summary and wrap-up.