How to Update Your Database Schema With No Downtime
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.