Scylla Database Administration & Operations Training Course

Foundations and Architecture

• Introduction to Scylla: An overview of its history, common use cases, and performance metrics relative to Cassandra.
• Architecture Deep Dive: Examining sharding, partitioning, and the distributed nature of the database.
• Data Model: A clear understanding of Clustering Keys, Partitions, and Data Types.
• CQL Basics: Introduction to Cassandra Query Language and utilizing the CQL shell.

Cluster Setup and Administration

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

Monitoring, Troubleshooting & Best Practices

• Monitoring: Configuring metrics and visualizing cluster health.
• Troubleshooting: Diagnosing bottlenecks, latency issues, and node failures.
• Performance Tuning: Applying best practices for configuration optimization.
• Conclusion: A final summary and wrap-up of key takeaways.