Scylla Database Administration & Operations Training Course

Foundations and Architecture

• Overview of Scylla: Historical context, operational use cases, and performance benchmarks relative to Cassandra.
• Architectural Analysis: Examination of sharding mechanisms, partitioning strategies, and distributed database principles.
• Data Modeling: Review of clustering keys, partition definitions, and supported data types for government applications.
• CQL Fundamentals: Introduction to the Cassandra Query Language and utilization of the CQL shell.

Cluster Deployment and Administration

• Deployment: Installation procedures for Scylla across multiple operating systems.
• Cluster Configuration: Methods for seed node setup, replication strategies, and automated node discovery.
• CQL Operations: Advanced querying techniques, schema design principles, and indexing strategies.
• Administrative Utilities: Overview of built-in tools such as nodetool and sstableloader.
• System Administration: Procedures for user management, access control permissions, and data lifecycle governance for government systems.

Monitoring, Troubleshooting & Best Practices

• Observability: Implementation of metrics collection and visualization dashboards to assess cluster health.
• Diagnostic Procedures: Identification of performance bottlenecks, latency anomalies, and node failure events.
• Optimization: Configuration guidelines to enhance system performance.
• Closing Summary: Key takeaways and final recommendations.