Talks
Speakers
Events
Topics
Search
Sign in
Search
Home
Talks
Speakers
Events
Topics
Leaderboard
Use
Analytics
Sign in
search talks for
⏎
Suggest modification to this talk
Title
Description
Giving your Heroku App highly-available PostgreSQL by Jake Varghese As you’re building out your app, you know how important it is to have your database up at all times. You need your PostgreSQL database to be HA. Jake from Compose is going to show you how to migrate your data to a HA PG service in less than 20 minutes. This is a sponsored talk by Compose, an IBM company
Date
Summarized using AI?
If this talk's summary was generated by AI, please check this box. A "Summarized using AI" badge will be displayed in the summary tab to indicate that the summary was generated using AI.
Show "Summarized using AI" badge on summary page
Summary
Markdown supported
In this video, Jake Varghese from Compose explains how to migrate a PostgreSQL database to a highly available (HA) service on IBM Cloud. The presentation highlights the importance of maintaining database availability for applications and outlines the process to achieve it. Key points discussed include: - **Introduction to High Availability**: Varghese introduces the concept of high availability for PostgreSQL databases and explains that Compose uses an application called Governor in conjunction with a distribution coordinator called CD to manage the leader-follower structure of database nodes. - **Usage of HA Proxy**: An HA Proxy load balancer is discussed, which connects to the database nodes and manages requests seamlessly during failover events, ensuring that applications experience zero downtime. - **Patroni Enhancement**: Varghese explains a newer fork of the Governor called Patroni, which incorporates Zookeeper and Console as distribution coordinators, enhancing stability and performance for PostgreSQL deployments. - **Demo Preparation**: The session proceeds to a live demonstration that involves migrating data from a Heroku PostgreSQL instance to Compose's HA PostgreSQL service, using an AI application that places uploaded images into Star Trek captain posters for a lighthearted touch. - **Data Migration Steps**: The migration process is elaborated, showing steps to export existing data from Heroku and import it into the IBM Cloud PostgreSQL setup. Important commands such as PG Restore are highlighted, alongside necessary configuration adjustments, such as removing the Heroku PostgreSQL add-on to avoid conflicts with database URLs. - **Data Integrity Checks**: Varghese emphasizes the importance of checking connections and ensuring that the migration process has completed successfully without errors. - **Final Steps and Conclusion**: After completing the staging migration, the specific steps to migrate to the production database are demonstrated, reiterating the ease of switching from staging to production without downtime. He concludes by mentioning the capability to create additional resources, such as Elasticsearch, to enhance application functionality connected to the PostgreSQL database. Overall, the key takeaway is the streamlined process of migrating and maintaining a highly available PostgreSQL database on IBM Cloud, ensuring that applications remain operational with no downtime during transitions.
Suggest modifications
Cancel
