Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Citus & Patroni: The Key to Scalable and Fault-Tolerant PostgreSQL | Citus Con 2023

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
3.9K views 1 year ago #PostgreSQL #Database #CitusCon
Video recording of Alexander Kukushkin’s conference talk at Citus Con 2023 about Citus & Patroni, the key to scalable and fault-tolerant PostgreSQL. The Citus database is an open source extension to PostgreSQL that enables you to scale out horizontally by sharding your data across many nodes. And Patroni is an open source tool for managing and automating PostgreSQL High Availability. Combined together, three open source projects become a superhero: a scalable PostgreSQL cluster with self-healing capabilities. This talk covers implementation details of Patroni & Citus integration, and includes a demo of cluster deployment and maintenance on Citus worker nodes without interrupting client connections. Alexander Kukushkin is well known in the PostgreSQL community as a Patroni expert. Besides Patroni, Alexander occasionally contributes to PostgreSQL and other open source projects and tools, usually Postgres related. ► Video bookmarks: ⏩ 00:00  …...more
...more
Citus & Patroni: The Key to Scalable and Fault-Tolerant PostgreSQL | Citus Con 2023
93Likes
3,909Views
2023May 8
Video recording of Alexander Kukushkin’s conference talk at Citus Con 2023 about Citus & Patroni, the key to scalable and fault-tolerant PostgreSQL. The Citus database is an open source extension to PostgreSQL that enables you to scale out horizontally by sharding your data across many nodes. And Patroni is an open source tool for managing and automating PostgreSQL High Availability. Combined together, three open source projects become a superhero: a scalable PostgreSQL cluster with self-healing capabilities. This talk covers implementation details of Patroni & Citus integration, and includes a demo of cluster deployment and maintenance on Citus worker nodes without interrupting client connections. Alexander Kukushkin is well known in the PostgreSQL community as a Patroni expert. Besides Patroni, Alexander occasionally contributes to PostgreSQL and other open source projects and tools, usually Postgres related. ► Video bookmarks: ⏩ 00:00 Introducing Alexander ⏩ 00:47 Talk begins: using Patroni & Citus together ⏩ 02:13 As an application developer, I want ⏩ 04:44 High Availability with Patroni ⏩ 07:23 Horizontal scalability ⏩ 11:12 Sharding with Citus ⏩ 14:26 Citus HA with Patroni 3.0 ⏩ 17:24 Adding new workers to the Citus cluster ⏩ 18:41 Demo of Patroni 3.0 with Citus ⏩ 28:37 Q&A ✅ Learn more: Watch more Citus Con talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon ⭐ Stay connected with the Citus open source project on GitHub: https://github.com/citusdata/citus 📌 Let’s connect:   Twitter – @CitusCon,   / cituscon   🔔 Subscribe to the Citus monthly technical newsletter: https://aka.ms/citus-newsletter More resources: 📣 Slides for this talk: https://speakerdeck.com/cyberdemn/cit... #CitusCon #PostgreSQL #Database

Follow along using the transcript.

Microsoft Developer

589K subscribers