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
1. Introduction to Distributed PostgreSQL
- Addressing scaling challenges with single-node PostgreSQL
- Overview of the Citus extension: its purpose, architecture, and key components
- Fundamental concepts: coordinator node, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Node types: differentiating between coordinator and worker nodes
- Table types: distributed, replicated, and local tables
- Installing and configuring Citus in existing PostgreSQL environments for government use
- Cluster discovery and node management practices
3. Data Distribution and Sharding Strategies
- Sharding methods: hash versus append
- Selecting an appropriate distribution column for optimal performance
- Managing distributed and replicated tables in a government context
- Re-balancing shards and scaling out the cluster
4. Distributed Query Execution and Optimization
- How Citus routes and parallelizes queries for efficient execution
- Understanding distributed query plans to enhance performance
- Techniques for query pushdown and execution optimization in government databases
5. Consistency, Transactions, and Fault Tolerance
- Two-Phase Commit (2PC) and atomic operations to ensure data integrity
- Strategies for handling failures in distributed transactions within government systems
6. Operational Management and Use Cases
- Monitoring tools and views available for Citus to support operational oversight
- Best practices for maintenance and upgrades in distributed environments, particularly for government operations
Requirements
- Completion of Advanced Administration (High Availability & Replication) or equivalent experience for government systems.
- Solid understanding of PostgreSQL configuration and performance optimization.
- Proficiency with Linux operating systems and fundamental network concepts.
Audience
This training is designed for experienced Database Administrators, DevOps Engineers, and System Architects who are currently managing production PostgreSQL environments within government agencies and require the skills to scale these systems horizontally.
7 Hours
Testimonials (2)
The provided examples and labs
Christophe OSTER - EU Lisa
Course - PostgreSQL Advanced DBA
1. A very well-structured training program 2. The warm atmosphere the trainer created, along with his outstanding personal professionalism 3. That the trainer explained everything as if he were talking to a complete beginner, without slipping into any technical jargon.
