/plushcap/analysis/cockroach-labs/how-to-update-your-database-schema-with-no-downtime

How to Update Your Database Schema With No Downtime

What's this blog post about?

This article discusses how to update a database schema with no downtime. It highlights the challenges faced when updating traditional relational databases (RDBMS) and NoSQL document-store alternatives, such as MySQL and MongoDB respectively. The author introduces CockroachDB, a next-gen distributed SQL database that offers live schema updates without any downtime or impact on users. It also provides an example of altering the database schema for a Node.js app using CockroachDB's SQL syntax.

Company
Cockroach Labs

Date published
Aug. 12, 2021

Author(s)
Charlie Custer

Word count
1897

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.