Clustering in PostgreSQL: Because one database server is never enough (and neither is two)
MCLD 3038 | Fri 07 Aug 4:30 p.m.–5:15 p.m.
Presented by
-
Umair Shahid is the Founder & CEO of Stormatics, a specialist database services firm built to Elevate PostgreSQL in production. He works with fintechs, SaaS companies, and enterprises to design and run production-grade systems: resilient architectures, performance under load, security hardening, and migrations from proprietary databases across cloud and on-prem environments.
With more than two decades in the ecosystem, Umair is a subject matter expert who is regularly invited to speak at industry conferences. He publishes practical blogs and benchmark-driven white papers reaching more than 15,000 readers each month.
Umair Shahid is the Founder & CEO of Stormatics, a specialist database services firm built to Elevate PostgreSQL in production. He works with fintechs, SaaS companies, and enterprises to design and run production-grade systems: resilient architectures, performance under load, security hardening, and migrations from proprietary databases across cloud and on-prem environments.
With more than two decades in the ecosystem, Umair is a subject matter expert who is regularly invited to speak at industry conferences. He publishes practical blogs and benchmark-driven white papers reaching more than 15,000 readers each month.
Abstract
In the world of database management, high availability and disaster recovery are key considerations for any organization that wants to ensure reliable access to its critical data. Clustering in PostgreSQL is one of the most effective ways to achieve both. In this talk, we will explore the ins and outs of PostgreSQL clustering, including the benefits and challenges of different clustering approaches, and how to set up a highly available and disaster-resilient PostgreSQL cluster.
We will dive into topics such as synchronous vs. asynchronous replication, load balancing, failover, and disaster recovery. We will also touch on some open source tools that are readily available to aid in PostgreSQL cluster management.
In the world of database management, high availability and disaster recovery are key considerations for any organization that wants to ensure reliable access to its critical data. Clustering in PostgreSQL is one of the most effective ways to achieve both. In this talk, we will explore the ins and outs of PostgreSQL clustering, including the benefits and challenges of different clustering approaches, and how to set up a highly available and disaster-resilient PostgreSQL cluster.
We will dive into topics such as synchronous vs. asynchronous replication, load balancing, failover, and disaster recovery. We will also touch on some open source tools that are readily available to aid in PostgreSQL cluster management.