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. Foundations of Distributed PostgreSQL
- Addressing scalability limitations inherent in single-node PostgreSQL setups
- An introduction to the Citus extension, including its objectives, architectural design, and core components
- Essential concepts such as coordinator nodes, worker nodes, metadata management, and distribution keys
2. Cluster Architecture and Configuration
- Differentiating node roles: the function of coordinators versus workers
- Classification of table types: distributed, replicated, and local tables
- Procedures for installing and configuring Citus within existing PostgreSQL environments
- Techniques for cluster discovery and node lifecycle management
3. Data Distribution and Sharding Methodologies
- Comparison of sharding techniques: hash-based versus append-based methods
- Strategic selection of distribution columns to maximise performance
- Best practices for managing distributed and replicated tables
- Strategies for shard re-balancing and horizontal scaling
4. Distributed Query Processing and Optimisation
- Mechanisms by which Citus routes and parallelises query execution
- Analysis and interpretation of distributed query plans
- Implementing query pushdown and execution optimisation techniques
5. Consistency, Transactional Integrity, and Fault Tolerance
- Implementation of Two-Phase Commit (2PC) for ensuring atomic operations
- Strategies for managing and recovering from failures in distributed transactions
6. Operational Oversight and Practical Applications
- Utilising monitoring tools and system views specific to Citus
- Protocols for maintenance tasks and software upgrades in distributed environments
Requirements
- Successful completion of the 'Advanced Administration (High Availability & Replication)' module or possession of equivalent practical experience
- Proficient understanding of PostgreSQL configuration parameters and performance tuning methodologies
- Adequate familiarity with Linux operating systems and fundamental networking principles
Target Audience
This course is tailored for seasoned Database Administrators, DevOps Engineers, and System Architects who currently oversee production PostgreSQL environments and require the skills to scale their infrastructure 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.
