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 with global SQL confined to closed platforms: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without shared storage dependencies.
Cluster Deployment
- Configuring single-region and multi-region topologies using Docker Compose.
- Deploying via Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and limitations compared to PostgreSQL.
- Utilizing the cost-based optimizer and interpreting execution plans.
- Implementing indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Defining region and locality settings to manage data placement.
- Strategies for follow-the-workload, regional tables, and survival goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3 repositories.
- Executing incremental backups and achieving point-in-time recovery.
- Establishing Changefeeds for Kafka and webhook streaming.
Security and Compliance
- Implementing TLS everywhere: covering node-to-node and client-to-node communication.
- Managing Role-Based Access Control (RBAC) and row-level security.
- Maintaining audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Facilitating migration from PostgreSQL using appropriate tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Proficiency in SQL and relational database administration.
- A solid understanding of distributed consensus mechanisms, specifically Raft.
- Familiarity with Go tooling and Docker is advantageous.
Audience
- Senior database architects developing sovereign data layers.
- Teams looking to replace Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare institutions requiring strong data consistency.
21 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
