Restore a MariaDB Cluster

With IONOS CLOUD DBaaS, you can roll back a MariaDB cluster to a previous point in time using point-in-time recovery (PITR). This prevents data loss in unexpected situations such as accidental data deletion.

Note: You can restore only one backup at a time. You must wait for the current restoration to complete before initiating another.

Prerequisites:

• The backup must belong to the MariaDB cluster to be restored.
• The backup must be active. Inactive backups are not eligible for restoration.
• The cluster must be in the AVAILABLE state.

To restore a cluster from a backup, follow these steps:

1

Navigate to the cluster

1. In the DCD, go to Menu > Databases > MariaDB.

A list of all MariaDB clusters is displayed.

2. Select a cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.

Select a MariaDB cluster

2

Open the Backups tab

In the cluster details page, select Backups.

The Point-in-time recovery section displays the earliest backup available for restoration.

Point-in-time recovery

2. Select Restore backup to open the restore dialog.

3

Set the recovery target time

In the Restore backup dialog, the Earliest recovery target time is displayed. Each backup has a recovery window defined by an earliest and a latest recovery target time. You can restore the backup to any point within this range.

1. Click the date and time field and enter a recovery target time. Select a date and time from the calendar. Only dates within the available backup window are selectable.

Note: The backup is replayed up to the specified timestamp. If left empty, the latest available backup is applied completely.

Select recovery date and time

2. Select Restore to start the restoration.

Result: The cluster's STATE is set to UPDATING while the restoration is in progress. Once complete, the cluster returns to AVAILABLE.

Next steps

• View MariaDB Clusters: Verify the restored cluster's state and configuration.
• Update a MariaDB Cluster: Modify cluster properties such as instances, resources, and maintenance settings.