Implement Restore cluster from a Backup functionality

[serdardalgic]

There is a restore_cluster endpoint in the BigAnimal API that allows the users to restore a cluster (by creating a new cluster) from a backup. Users should provide a selectedRestorePointInTime and a new cluster from that time will be created from the backups.

This functionality can be implemented by adding an argument (for example selected_restore_point_in_time) to the biganimal_cluster resource. Any other implementation suggestions are also welcome.

For further reading on the Restore functionality:

• Free Trial Experimenting docs on Back Up and Restore Cluster
• Backing Up and Restoring documentation From that documentation:

If a restore is necessary—for example, in case of an accidental DROP TABLE statement—you can restore clusters to any point within the backup retention period.

Cluster restores aren't performed "in-place" on an existing cluster. Instead, a new cluster is created and initialized with data from the backup archive. Restores must replay the transaction logs between the most recent full database backup and the target restore point. Thus restore times (that is, RTO) are dependent on the write activity in the source cluster.

BigAnimal retains backups for 30 days by default. You can restore backups into a new cluster in any region supported by BigAnimal.

This functionality also makes sense for the Faraway Replicas. Some of the fields that cannot be changed during the creation of Faraway Replicas can be updated during restore from a Faraway Replica.

One thing to consider:

• For running clusters, the restore endpoint is /projects/{projectId}/clusters/{clusterId}/restore
• For deleted clusters, the restore endpoint is /projects/{projectId}/deleted-clusters/{clusterId}/restore