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 scaling bottlenecks in single-node PostgreSQL
- Overview of the Citus extension: its objectives, architectural design, and core components
- Essential concepts: coordinator node, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Differentiating node types: coordinator versus workers
- Understanding table categories: distributed, replicated, and local
- Installing and configuring Citus within existing PostgreSQL ecosystems
- Implementing cluster discovery and node management
3. Data Distribution and Sharding Strategies
- Comparing sharding methodologies: hash-based versus append-based
- Identifying the optimal distribution column for performance gains
- Managing distributed and replicated table structures
- Rebalancing shards and executing horizontal scaling
4. Distributed Query Execution and Optimization
- Examining how Citus routes and parallelizes query execution
- Interpreting distributed query execution plans
- Leveraging query pushdown and execution optimization techniques
5. Consistency, Transactions, and Fault Tolerance
- Implementing Two-Phase Commit (2PC) and ensuring atomic operations
- Managing failure scenarios within distributed transactions
6. Operational Management and Use Cases
- Utilizing monitoring tools and specific views for Citus
- Performing maintenance and upgrades in distributed environments
Requirements
- Successfully completed Advanced Administration (High Availability & Replication) or possess comparable practical experience
- Demonstrate a strong command of PostgreSQL configuration and performance tuning
- Have a working familiarity with Linux systems and fundamental networking concepts
Target Audience
Senior Database Administrators, DevOps Engineers, and System Architects who are responsible for 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.
