Systems and methods of restoring a dataset of a database for a point in time
Systems and methods are provided for performing a point-in-time restore of data of a first tenant of a multitenanted database system. Metadata can be located to identify an archival version of first data of the first tenant stored in immutable storage of the database system. The archival version includes a most recently committed version of each datum prior to a first point in time. By using the metadata, a restore reference set is mapped into a target database instance of the database system. The mapping can be performed when all existing data for a tenant is to be the archival version, and where versions of data and records committed after the point in time are not available to the target database instance.
1. A method comprising:
performing a point-in-time restore of data of a first tenant of a multitenanted database system having immutable storage by:
locating metadata to identify an archival version of first data of a first tenant stored in the immutable storage, wherein the archival version includes a most recently committed version of each datum prior to a first point in time; and
mapping, by using the metadata, a restore reference set into a target database instance of the database system, wherein the restore reference set includes a minimum key and a maximum key to set a boundary range for the tenant data that is to be restored to the first point in time, and wherein versions of data and records committed after the point in time are not available to the target database instance.
2. The method of claim 1 , wherein the mapping the restore reference set into the target database instance comprises restoring tenant data to be transactionally consistent as of the first point in time.
3. The method of claim 2 , wherein the restoring the tenant data does not affect other tenants that are hosted in the target database instance of the database system.
4. The method of claim 1 , further comprising:
locating extent references that were generated after the archival version of the first data that contain tenant data before the first point in time; and
adding each of the located extent references to the restore reference set, which has the same minimum key and the same maximum key mapping.
5. The method of claim 1 , further comprising:
accessing the restored tenant data; and
when at least some extent references of the restored tenant data include references to data in the immutable storage that is newer than the first point in time, filtering the data to be presented.
6. The method of claim 1 , further comprising:
restoring the tenant prior to a first point in time; and
updating the restored tenant data with data committed at or before the first point in time.
7. A method comprising:
performing a point-in-time restore in a first tenant of a multitenanted database system having immutable storage by:
locating archival data of a first tenant prior to a desired point in time based on archival metadata information, wherein the archival data is previously written and not the current data of the first tenant;
switching pointers in the database system from the current data of the first tenant to the located archival version of the data of the first tenant in the immutable storage; and
limiting access of the database to the data of the first tenant that was committed before the point in time while the database is able to process data of other tenants.