Citus Cluster: our zero-downtime migration story | Citus Con: An Event for Postgres 2022 скачать в хорошем качестве

Citus Cluster: our zero-downtime migration story | Citus Con: An Event for Postgres 2022

Video of a talk about migrating from Citus Cloud to Citus on Azure by Algolia engineers Matthieu Dumont and Antoine Hemery, presented at Citus Con: An Event for Postgres. Abstract: At Algolia, we were long time customers of Citus Cloud for our multi-region analytics pipeline (~5TB of data). We chose to migrate to Hyperscale (Citus) on Azure at the end of 2021. As the analytics stack is a key part of our search as a service offering, our goal was to have the least downtime possible on our infrastructure. Hence, we designed a database migration plan to provide a seamless migration to our Algolia users. What's included in this talk: • our database migration plan • our architecture choices that helped achieving the migration • the migration itself (featuring unplanned surprises!) What's not included in this talk from the EMEA livestream at Citus Con: • DROP DATABASE analytics; • On-call incidents Antoine Hemery are Matthieu Dumont are both Senior Software Engineers at Algolia. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 02:09 About Algolia, the analytics dashboard, & the dashboard architecture ⏩ 03:56 Why did Algolia need to migrate? ⏩ 04:57 Migration goals ⏩ 07:00 Preparing for the migration ⏩ 18:57 Executing the migration ⏩ 20:48 Migration timeline ⏩ 21:28 Key takeaways ⏩ 24:30 Q&A with Matthieu, Antoine, & Claire ✅ 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 📌 Let’s connect: Twitter – @CitusCon,   / cituscon   🔔 Subscribe to the Citus monthly technical newsletter: https://aka.ms/citus-newsletter #CitusCon #PostgreSQL #AzureDBPostgres