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
- Global SQL data often confined to closed platforms such as Spanner and Aurora Global.
- CockroachDB's architecture features Raft ranges, leaseholders, and Multi-Version Concurrency Control (MVCC).
- Horizontal scaling is achieved without the need for shared storage.
Cluster Deployment
- Single-region and multi-region Docker Compose topologies are supported.
- Kubernetes StatefulSet deployment with persistent volumes ensures data durability.
- Best practices for security certificates and node initialization enhance system robustness and security.
SQL Compatibility and Query Tuning
- The database supports a wide range of SQL features while noting certain limitations compared to PostgreSQL.
- A cost-based optimizer is used to generate efficient execution plans.
- Indexes, composite keys, and inverted indexes for JSON/arrays optimize query performance.
Multi-Region Configuration
- Region and locality settings facilitate strategic data placement for optimal performance and compliance.
- Follow-the-workload strategies are contrasted with regional tables, each designed to meet specific survival goals.
- Leaseholder placement and topology-aware routing ensure efficient data access across regions.
Backup, Restore, and Disaster Recovery
- Full cluster backups can be stored in cloud storage or on-premise S3 for robust data protection.
- Incremental backups and point-in-time recovery options are available to minimize downtime and data loss.
- Changefeeds enable real-time data streaming to Kafka and webhooks, enhancing operational flexibility.
Security and Compliance
- TLS encryption is implemented for all node-to-node and client-to-node communications to ensure data security.
- Role-Based Access Control (RBAC) and row-level security features provide granular access management.
- Comprehensive audit logging and compliance reporting support regulatory requirements and internal audits.
Integration Patterns
- ORM frameworks such as SQLAlchemy, Prisma, and GORM can be seamlessly integrated for efficient data management.
- Tools are available to facilitate migration from PostgreSQL, ensuring a smooth transition for government applications.
- Kubernetes sidecars and service mesh integration enhance the scalability and resilience of distributed systems for government use.
Requirements
- Proficient in SQL and relational database administration.
- Advanced knowledge of distributed consensus mechanisms (e.g., Raft).
- Familiarity with Go tooling and Docker is beneficial.
Audience
- Senior database architects developing sovereign data layers for government and private sector entities.
- Teams transitioning from Spanner, Aurora Global, and Cosmos DB to more tailored solutions.
- Financial and healthcare organizations requiring robust consistency in their data management systems.
21 Hours
Testimonials (2)
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
