What is the point of no return in a replica-based upgrade?
Promoting a new-version node to primary. Replication usually works from older to newer versions but not back, so once the new primary takes writes, the old nodes cannot follow. Everything must be validated on replicas before that promotion, because rollback after it is a much harder operation.
Answered in
Upgrading a Database Major Version Without Downtime: The Side-by-Side Replica PlaybookAdd new-version replicas, soak them on real reads, promote, then clean up. The four stages, the point of no return, and the MySQL 5.7 to 8.0 gotchas.
Read the full analysisOther questions this article answers
More development best practices questions
- How many repositories can be scanned at once?
- Is GitHub AI Scan generally available?
- Can a developer continue any Copilot session on a phone?
- Does GitHub Mobile replace the desktop development environment?
- What should teams do when a Copilot model is retired?
- Does changing the model guarantee identical output?
- What's the actual security flaw people mean when they say JWT is risky?
- How does PASETO structurally prevent the 'alg:none' style of attack?
Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the Development Best Practices beat.