Scylla Database Administration & Operations Training Course

Core Concepts and Architecture

• Overview of Scylla: Historical context, applicable use cases, and performance comparisons against Cassandra.
• In-Depth Architecture: Examination of sharding, partitioning, and the distributed architecture of the database.
• Data Modeling: Comprehending Clustering Keys, Partitions, and various Data Types.
• Introduction to CQL: Familiarization with Cassandra Query Language and operating the CQL shell.

Deploying and Administering Clusters

• Deployment Procedures: Installing Scylla across different operating system platforms.
• Cluster Configuration: Managing seeding, replication strategies, and node discovery processes.
• Advanced CQL Usage: Complex queries, schema optimization, and index creation.
• Scylla Utilities: An introduction to integrated tools such as nodetool and sstableloader.
• Administrative Tasks: Managing users, setting permissions, and overseeing the data lifecycle.

Monitoring, Diagnostics & Optimal Practices

• System Monitoring: Configuring metrics collection and visualizing overall cluster health.
• Diagnostic Techniques: Detecting performance bottlenecks, latency concerns, and node failures.
• Performance Optimization: Applying best practices for configuration tuning.
• Concluding Summary: Recap of key learnings and final thoughts.