Postgres-XC dynamic cluster managment

on YouTube ↗58m

" summary

Demonstration builds a running Postgres‑XC cluster (version 1.1) with four coordinators and four data nodes (16 instances), deploys binaries to new hosts, and Postgres-XC cluster configuration moves from manual edits to a single control file. A shell-scripted tool pgxt control initializes nodes, starts/stops services, adds/removes servers live, redistributes tables, and manages replication. The demo kills GTM and a data node and shows GTM slave failover and continued operation though a crash happens during the demo.

AI-written summary · about

" chapters (10)

1. 0:00Postgres-XC introduction
2. 2:57Deployment and operation
3. 8:32pgxc_control demo
4. 17:10Distributed tables setup
5. 21:45Node failures and failover
6. 29:22Adding/removing nodes
7. 38:55Cluster configuration
8. 44:47High availability features
9. 55:18Future plans
10. 56:28Q&A

" related talks

• 56mA Shared nothing Cluster System Postgres XCAmit Khandekar · Postgres Open 2012
• 54mScaling out by distributing and replicating data in Postgres XCAshutosh Bapat · Postgres Open 2012
• 47mWhat Is Postgres XC?Maksim Boguk · HighLoad++ 2012
• 50mSupersized Postgres: Postgres-XL for OLTP and Big Data AnalyticsMason Sharp · PostgresOpen 2014
• 59mUsing Postgres XLRichard Silva · PGConf Silicon Valley 2016
• 50mDemystifying Kubernetes for Postgres DBAs; A Guide to OperatorsAdam Wright · PostgreSQL Conference Europe 2024
• 36mHighly Available PostgreSQL Database Cluster Creation & Monitoring in Minutesconcerned boy · HashiTalks 2020
• 44mEfficiently Deploying PostgreSQL Instances: The EvolutionAgustin Gallego · Percona Live 2022