Dear Chicago PUG members,
Our May meetup is scheduled for May 15 from 5-30 PM to 8 PM.
We will meet at our usual location: DRW Training Center, 540 W. Madison, 25th floor.
A reminder about our venue:
- This is a high-security building, which means the names of all participants should be communicated no later than 7:30 AM on the day of the event, and all participants must present a government-issued ID to be admitted. If your meetup profile does not list your full name, please send a DM with the required information to Hettie. Registration for all in-person events will be closed by 7-30 AM the day of the event.
- The food order will be placed two days before the event, so I strongly encourage everybody planning to attend to RSVP by April 22.
- If you plan to attend virtually, please RSVP for the Zoom version (a separate invite will be sent)
Please RSVP to this event only if you are attending in person.
Event Details:
Speaker:
Umair Shahid, Founder of Sormatics
Talk title:
Clustering in PostgreSQL: Because one database server is never enough (and neither is two)
Talk 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.
About the speaker
Umair is a 20-year PostgreSQL veteran with extensive experience in solving real-world database problems. My commercial experience spans over two decades of professional services and product development in the PostgreSQL ecosystem. Being a recognized expert in PostgreSQL, I am a blogger and a regular speaker at conferences globally. I am the founder of Stormatics - a professional services company with a mission to help businesses use PostgreSQL reliably for their critical data workloads. My previous experience with commercial PostgreSQL consists of roles in major pure-play PostgreSQL organizations like EDB, 2ndQuadrant, OpenSCG, & Percona.
Agenda:
- Hettie Dombrovskaya, DRW: Second PG Day Chicago review, and what's next
- Umair Shahid. Clustering in PostgreSQL: Because one database server is never enough (and neither is two)
- Q&A and networking
The doors will open at 5-30, with food arriving at the same time, and the talks will start promptly at 6 PM.
Please be on time! You might not be able to get in on the 25th floor after 6!
As usual, I hope to see as many of you as possible in person!
Hettie Dombrovskaya,
Chicago PUG Local Organizer