Amazon Technologies, Inc.

Benjamin S Ellis

Raman Mittal

Anurag Windlass Gupta

Alexandre Olegovich Verbitski

Murali Brahmadesam

Saleem Mohideen

Xiaofeng Bao

Changan Han

Li-Che Hsiao

Seungmin Wei

Xiang Peng

Konstantin Dubinets

Tiffany Jianto

Venkatesh Nandakumar

Peng Gu

Alisdair William Owens

Shanpei Zhou

Backup and restore of client-managed tables and system-managed tables in a same database may be performed. A request to restore a database with both a client-managed table and system-managed table may be received. The request may specify a point in time to restore the database. A metadata volume for the database that describes both the client-managed table and the system-managed table may be restored and used to identify the volumes for both the client-managed table and shards of the system-managed table. Redo logs for each of the volumes may be used according to timestamps that are synchronized according to a time synchronization service to generate restored versions of the volumes for the client-managed table and the shards of the system-managed table from backup copies, which can then be made available for accessing the database.

Backup and restore of client-managed and system-managed database tables

Online restore operations for a database engine can be performed. A request to restore a database to a previous state can be received. Previously stored content of the database, such as snapshot stored prior to the previous state, can be identified along with log records describing changes to be made to the content prior to the previous state. State information in a query engine can be updated based on the previously stored content and log records so that queries can be processed based on the state information at the database restore to the previous state.

Online restore to a selectable prior state for database engines

Growing community of inventors

Seattle, WA, United States of America

Benjamin S Ellis