データベースクラスターの復元

The Restore and Point-in-Time Recovery (PITR) features allow users to recover a database cluster from existing backups or restore a database cluster to a specific point in time in the past. This section provides detailed instructions to help users perform data recovery accurately, safely, and efficiently, while ensuring data integrity.

When performing Restore or PITR , the system will create a new database cluster and will not overwrite the existing cluster.

1. Restore database cluster

The restore feature allows users to use a previously created backup to recover data in a new database cluster. This is useful in cases of data loss, system failures, or when a rollback to a previous state is required.

Before performing a restore, ensure the database cluster has at least one successfully created backup (restore point) - meaning at least one restore point is available.

Steps to perform restore:

Step 1: Access the Restore screen

From the menu, select Database Platform → choose All Database or Non-Relational Database → click the Cluster ID of the database cluster to restore → select the Backup tab → choose the Restore sub-tab. The system displays a list of Available Restore Points.

Step 2: Perform restore

In the Actions column, click the ellipsis icon (⋮) corresponding to the desired restore point > select Restore. The Restore Database dialog appears:

Enter the required information:

• Restore Cluster Name : Enter a name for the restored cluster.
• Flavor : Select an appropriate configuration for the restored cluster.

Click Restore to start the recovery process. Upon successful restore, a new database cluster will appear in the database cluster list containing data from the selected backup.

2. Recover to Point-in-Time

The Recover to Point-in-Time feature allows users to restore a database cluster to an exact point in the past, which is especially useful when recovering from incidents or operational errors.

Before performing PITR, ensure that:

• PITR is enabled for the database cluster.
• At least one full backup exists
• Required archived logs are available for recovery.

Steps to perform recover to Point-in-Time:

Step 1: Access the recovery screen

Follow the same steps as accessing the restore screen in the 1. Restore database cluster section.

Step 2: Perform recover

On the Restore tab, click the Restore to point in time button > The Restore Database to a Point in Time popup appears:

Enter the required information:

• Restore Cluster Name : Enter a name for the restored cluster.
• Flavor : Select an appropriate configuration for the restored cluster.
• Recover To : Select the exact time to which you want to restore the database cluster (in date-time format).

Click Recover to start the recovery process. The system will create a new cluster and restore data to the specified point in time. Upon successful recovery, a new cluster will appear in the database cluster list screen containing data at the recovery time.