Company
Date Published
Author
Carlota Soto
Word count
1610
Language
English
Hacker News points
None

Summary

Neon offers an innovative solution for database recovery through its Instant Point-in-Time Recovery (PITR) feature, which allows users to restore a multi-terabyte production database to a precise moment before an inadvertent table drop. This is achieved by creating a new branch, ensuring that the main branch remains operational and continues to ingest new data without disruption. The restoration process is nearly instantaneous, taking about one second regardless of database size, due to Neon's copy-on-write storage model that references existing storage pages until changes occur. Unlike traditional methods used by AWS RDS, which require time-consuming snapshot restoration and WAL replay, Neon's approach allows for immediate access to the restored branch, making it highly efficient for large-scale databases. Users can choose to either keep production as is and copy the missing table from the PITR branch or switch production to the recovered branch, depending on their need for post-drop data. Neon's ability to handle these operations seamlessly and quickly has made it a favored choice for thousands of teams, as it significantly reduces downtime and ensures data availability.