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 inherent in single-node PostgreSQL deployments
- Overview of the Citus extension: its purpose, architecture, and core components
- Essential concepts: coordinator nodes, worker nodes, metadata management, and distribution keys
2. Cluster Architecture and Setup
- Node types: distinguishing between coordinator and worker roles
- Table types: utilizing distributed, replicated, and local tables
- Installing and configuring Citus within existing PostgreSQL environments
- Cluster discovery processes and node management techniques
3. Data Distribution and Sharding Strategies
- Sharding methodologies: comparing hash-based and append-based approaches
- Selecting the optimal distribution column for peak performance
- Managing distributed and replicated tables effectively
- Techniques for re-balancing shards and scaling out infrastructure
4. Distributed Query Execution and Optimisation
- Mechanisms by which Citus routes and parallelises queries
- Interpreting distributed query execution plans
- Implementing query pushdown and execution optimisation strategies
5. Consistency, Transactions and Fault Tolerance
- Understanding Two-Phase Commit (2PC) and atomic operations
- Handling failures within distributed transactions
6. Operational Management and Use Cases
- Monitoring tools and views available for Citus
- Maintenance procedures and upgrades in distributed environments
Requirements
- Completion of the Advanced Administration (High Availability & Replication) course or equivalent professional experience
- Proficient understanding of PostgreSQL configuration and performance tuning
- Familiarity with Linux operating systems and fundamental network concepts
Audience
This course is designed for experienced Database Administrators, DevOps Engineers, and System Architects who currently manage production PostgreSQL environments and require methods to scale them 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.
