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
- Scaling challenges associated with single-node PostgreSQL
- Overview of the Citus extension: purpose, architecture, and components
- Key concepts: coordinator node, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Node types: distinction between coordinator and workers
- Table types: distributed, replicated, and local tables
- Installing and configuring Citus within existing PostgreSQL environments
- Cluster discovery and node management
3. Data Distribution and Sharding Strategies
- Sharding methods: hash versus append strategies
- Selecting a distribution column for optimal performance
- Managing distributed and replicated tables
- Re-balancing shards and scaling out the cluster
4. Distributed Query Execution and Optimisation
- Mechanisms by which Citus routes and parallelises queries
- Understanding distributed query plans
- Query pushdown techniques and execution optimisation
5. Consistency, Transactions and Fault Tolerance
- 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 Advanced Administration (High Availability & Replication) or equivalent experience
- Strong understanding of PostgreSQL configuration and performance tuning
- Familiarity with Linux operating systems and fundamental network concepts
Audience
Experienced Database Administrators, DevOps Engineers, and System Architects who currently manage production PostgreSQL environments and require methods to scale them horizontally.
7 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 1600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
Logging behaviour when the instance is under stress, and the hierarchy/nomenclature of instances, databases, files, etc.
