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
- Addressing the constraints of closed platforms for global SQL: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without shared storage dependencies.
Cluster Deployment
- Single-region and multi-region Docker Compose topologies.
- Kubernetes StatefulSet deployment with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and PostgreSQL limitations.
- Cost-based optimizer and execution plans.
- Indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Region and locality settings for strategic data placement.
- Follow-the-workload strategies versus regional tables and durability goals.
- Leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Full cluster backups to cloud storage or on-premise S3 repositories.
- Incremental backups and point-in-time recovery capabilities.
- Changefeeds for Kafka and webhook streaming integration.
Security and Compliance
- TLS everywhere: node-to-node and client-to-node encryption.
- Role-Based Access Control (RBAC) and row-level security.
- Audit logging and compliance reporting mechanisms.
Integration Patterns
- Connecting ORM frameworks: SQLAlchemy, Prisma, GORM.
- Migration from PostgreSQL using available tooling.
- Kubernetes sidecars and service mesh integration.
Requirements
- Strong SQL and relational database administration skills.
- A high-level understanding of distributed consensus (Raft).
- Familiarity with Go tooling and Docker is advantageous.
Audience
- Senior database architects developing sovereign data layers.
- Teams transitioning from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organizations requiring robust consistency guarantees.
21 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
