Database migrations with zero downtime? | Architectural Simplification

Description

Ready to simplify your software stack and make zero-downtime migrations possible? In this video, Cockroach Labs Technical Evangelist Rob Reid will look at Postgres vs CockroachDB when it comes to database migrations (eg; on-prem to cloud migration, cloud to cloud migration, etc). Rob will demonstrate migrating a Postgres database from a source location to a target location. You'll learn why this approach can lead to higher architectural and operational complexity as well as the necessity for downtime for a consistent cutover. Then, Rob will run through a stretch migration with CockroachDB, explain how data replicates synchronously to new nodes, and share how no downtime database migrations are possible with CockroachDB. 00:00 Introduction 00:32 Architectural diagrams and Rob's testing methodology 01:58 Launching a primary Postgres instance and starting the application 02:21 What happens if you need to move your database to a new location? 04:01 The problems with this approach to database migrations 04:29 What does database migration look like with CockroachDB? 05:30 What do new nodes look like in the CockroachDB cluster? 07:08 Zero downtime database migrations in CockroachDB Subscribe to CockroachDB on YouTube for more technical videos: https://www.youtube.com/c/cockroachdb ******************************** Further reading: ✔️ What is CockroachDB? https://cockroa.ch/42uaZ9G ✔️ CockroachDB architecture overview: https://cockroa.ch/3RzIvrh ******************************** Follow Cockroach Labs ✔️ Website: https://cockroachlabs.com/ ✔️ Twitter (X): https://twitter.com/cockroachdb ✔️ Linkedin: https://www.linkedin.com/company/cockroach-labs/ ✔️ Facebook: https://www.facebook.com/cockroachlabs ✔️ Instagram: https://www.instagram.com/cockroachdb ✔️ Threads: https://www.threads.net/@cockroachdb ******************************** #database #softwarearchitecture #softwaredesign