Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Distributed SQL Sovereignty
- Challenges of global SQL confined within closed platforms: Spanner, Aurora Global.
- CockroachDB architecture fundamentals: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Configuring single-region and multi-region topologies using Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Optimization
- Overview of supported SQL features and PostgreSQL limitations.
- Understanding the cost-based optimizer and execution plans.
- Leveraging indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Defining region and locality settings to control data placement.
- Distinguishing between 'follow-the-workload' strategies and regional tables with specific survival goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Executing full cluster backups to cloud storage or on-premise S3 repositories.
- Implementing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for Kafka integration and webhook streaming.
Security and Compliance
- Enforcing TLS across all connections: node-to-node and client-to-node.
- Managing RBAC and row-level security policies.
- Configuring audit logging and compliance reporting mechanisms.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Strategies for migrating from PostgreSQL using appropriate tooling.
- Integrating Kubernetes sidecars and service mesh architectures.
Requirements
- Proficiency in SQL and relational database administration.
- Conceptual understanding of distributed consensus mechanisms, specifically Raft.
- Familiarity with Go tooling and Docker is advantageous.
Audience
- Senior database architects designing independent data layers.
- Teams tasked with migrating away from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare entities requiring strict data consistency standards.
21 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
