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.
Duration 7 hours
Course Outline
1. Introduction to Distributed PostgreSQL
- Challenges associated with scaling single-node PostgreSQL
- Overview of the Citus extension: its objectives, architecture, and core components
- Fundamental concepts: coordinator nodes, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Node roles: distinguishing between coordinators and workers
- Table categories: 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 and append strategies
- Selecting optimal distribution columns to enhance performance
- Managing distributed and replicated table structures
- Rebalancing shards and techniques for horizontal scaling
4. Distributed Query Execution and Optimisation
- Mechanisms by which Citus routes and parallelizes queries
- Interpreting distributed query execution plans
- Implementing query pushdown and execution optimizations
5. Consistency, Transactions and Fault Tolerance
- Two-Phase Commit (2PC) and ensuring atomic operations
- Strategies for handling failures within distributed transactions
6. Operational Management and Use Cases
- Utilizing monitoring tools and system views specific to Citus
- Maintenance procedures and upgrade processes in distributed environments
Requirements
- Successful completion of Advanced Administration (High Availability & Replication) or possessing equivalent practical experience
- Robust understanding of PostgreSQL configuration and performance tuning practices
- Proficiency in Linux environments and fundamental networking concepts
Target Audience
Seasoned Database Administrators, DevOps Engineers, and System Architects who are already responsible for production PostgreSQL environments and require skills to scale them horizontally.
Testimonials (2)
Tuning strategies.
Jeffrey Zieg - Matrix Consulting
Course - PostgreSQL Performance Tuning
Logging behaviour when the instance is under stress, and the hierarchy/nomenclature of instances, databases, files, etc.
