Scylla Database Administration & Operations Training Course

Core Foundations and Architecture

• Introduction to Scylla: Overview of its history, applicable use cases, and performance benchmarks relative to Cassandra.
• Architectural Analysis: Examining sharding, partitioning, and the distributed characteristics of the database.
• Data Modeling: Comprehending Clustering Keys, Partitions, and various Data Types.
• Basics of CQL: Getting started with Cassandra Query Language and executing the CQL shell.

Establishing and Managing Clusters

• Installation Procedures: Deploying Scylla across different operating system platforms.
• Cluster Setup: Configuring seeding, replication strategies, and node discovery mechanisms.
• Advanced CQL Usage: Executing complex queries, designing schemas, and implementing indexing.
• Scylla Utilities: Getting acquainted with native tools such as nodetool and sstableloader.
• Administrative Tasks: Handling user management, permission settings, and data lifecycle management.

Monitoring, Resolution & Best Practices

• Performance Monitoring: Configuring metrics and visualizing overall cluster health.
• Issue Resolution: Detecting performance bottlenecks, latency problems, and node failures.
• Optimization: Applying configuration best practices for improved performance.
• Conclusion: Course summary and final remarks.