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
- Addressing the scalability limitations of single-node PostgreSQL.
- An overview of the Citus extension, including its purpose, architecture, and core components.
- Exploring key concepts such as coordinator nodes, worker nodes, metadata, and distribution keys.
2. Cluster Architecture and Setup
- Distinguishing between node types: coordinators versus workers.
- Understanding different table types: distributed, replicated, and local.
- Processes for installing and configuring Citus within existing PostgreSQL environments.
- Techniques for cluster discovery and effective node management.
3. Data Distribution and Sharding Strategies
- Comparing sharding methods: hash distribution versus append distribution.
- Selecting the optimal distribution column to maximize performance.
- Strategies for managing distributed and replicated tables.
- Methods for re-balancing shards and scaling out the cluster.
4. Distributed Query Execution and Optimisation
- Understanding how Citus routes and parallelizes query execution.
- Analyzing distributed query plans for efficiency.
- Implementing query pushdown and execution optimizations.
5. Consistency, Transactions and Fault Tolerance
- Implementing Two-Phase Commit (2PC) and ensuring atomic operations.
- Strategies for handling failures within distributed transactions.
6. Operational Management and Use Cases
- Leveraging monitoring tools and specific views for Citus management.
- Best practices for maintenance and upgrades in distributed environments.
Requirements
- Completion of the Advanced Administration course (covering High Availability and Replication) or possession of equivalent professional experience.
- A strong command of PostgreSQL configuration and performance tuning practices.
- Basic familiarity with Linux systems and fundamental network concepts.
Target Audience
This course is ideal for experienced Database Administrators, DevOps Engineers, and System Architects who currently manage production PostgreSQL environments and require strategies for horizontal scaling.
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.
