Backing up and restoring the DB

Users can set up backups for MariaDB (DBaaS) through the Samsung Cloud Platform Console and restore from the backed‑up files.

Backing up MariaDB(DBaaS)

PostgreSQL (DBaaS) provides data backup functionality based on its own backup commands. Additionally, it provides an optimized backup environment for data protection and management through backup history verification and backup file deletion features.

Configure Backup

For backup configuration of MariaDB (DBaaS), please refer to MariaDB(DBaaS) 생성하기.

To modify the backup settings of the created resource, follow the steps below.

1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Go to the page.
3. MariaDB(DBaaS) List Click the resource for which you want to set up a backup. 3. MariaDB(DBaaS) Details Go to the page.
4. Click the Edit button of the backup item. 4. Backup Settings The popup window opens.
5. When configuring a backup, click Use in the Backup Settings popup, select retention period, backup start time, and Archive backup interval, then click the Confirm button.
   • If you wish to stop the backup configuration, deselect Use in the Backup Settings popup and authenticate using the logged-in user’s mobile phone.
     Once user authentication is complete, the backup configuration is disabled and backup execution stops.

Perform backup immediately

If additional data protection is needed, you can quickly create a backup using the instant backup feature.

To perform an immediate backup, follow these steps.

1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
3. On the MariaDB(DBaaS) List page, click the resource to perform an immediate backup. 3. MariaDB(DBaaS) Details Go to the page.
4. Click the Immediate Backup button of the backup item. 4. Immediate backup settings The popup window opens.
5. In the Immediate backup setup popup, click the Confirm button.

Check backup history

To check the backup history, follow these steps.

1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Go to the page.
3. MariaDB(DBaaS) List On the page, click the resource to view the backup history. 3. MariaDB(DBaaS) Details Go to the page.
4. Click the Backup History button. 4. Backup History The popup window opens.
5. Backup History In the popup window, you can view the backup status, version, backup start date and time, backup completion date and time, and size.

Delete backup file

To delete the backup file, follow these steps.

1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
3. MariaDB(DBaaS) List page, click the resource to view the backup history. 3. MariaDB(DBaaS) Details Go to the page.
4. Click the Backup History button. 4. Backup History The popup window opens.
5. Backup History In the popup window, select the files you wish to delete, then authenticate via the logged-in user’s mobile phone.
   • When user authentication is completed, the backup file will be deleted.

Recover MariaDB(DBaaS)

If a failure or data loss requires restoration from a backup file, recovery can be performed based on a specific point in time using the recovery feature. When you perform a MariaDB(DBaaS) recovery, a new server is created using the OS image from the initial provisioning point, the database is installed with the version from the backup point, and the recovery proceeds with the database’s configuration information and data.

To recover MariaDB (DBaaS), follow the steps below.

1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Go to the page.
3. On the MariaDB(DBaaS) List page, click the resource you want to recover. 3. MariaDB(DBaaS) Details Go to the page.
4. Click the Database Recovery button. 4. Database Recovery Navigate to the page.
5. After entering information in the Database recovery configuration area, click the Complete button.

   Category	Required	Detailed description
   Recovery type	Required	Set the point in time the user wants to recover Backup point (recommended): Recover based on the backup file. Select from the list of backup points displayed in the list Custom point: Recover to a user‑desired point within the recoverable backup time range. The recoverable period depends on the Archive backup interval setting, allowing recovery from the start of the first backup up to 1 hour/30 minutes/10 minutes/5 minutes before the current time. Select the date and time to back up
   Server name prefix	Required	Recovery DB server name Start with a lowercase English letter and use lowercase letters, numbers, and special characters (-) to enter 3 to 16 characters Based on the server name, a postfix such as 001, 002 is appended to generate the actual server name
   Cluster name	Required	Cluster name of the recovery DB Enter using English letters, 3 ~ 20 characters A cluster is a unit that groups multiple servers
   Service Type > Server Type	Required	Server type for the recovery DB installation Standard: Standard specifications commonly used High Capacity: Large-capacity server of 24vCore or more (to be provided later)
   Service Type > Planned Compute	Selection	Status of resources with Planned Compute set In Use: Number of resources with Planned Compute that are currently in use Configured: Number of resources with Planned Compute set Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Go to the Planned Compute service application page For more details, refer to Planned Compute 신청하기
   Service Type > Block Storage	Required	Block Storage settings used by the recovery DB Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Apply the same storage type as set in the original cluster Enter capacity as a multiple of 8 within the range 16 to 5,120 Add: Storage area for DATA, Archive, TEMP, Backup data Apply the same storage type as set in the original cluster In the recovery DB, only DATA, TEMP, and Archive purposes can be added After selecting Use, enter the storage purpose and capacity To add storage, click the Add button; to delete, click the x button Capacity can be entered as a multiple of 8 within the range 16 to 5,120, and up to 9 can be created
   Database username	Required	Database username set in the source DB
   Database Port number	Required	Database Port number set in the source DB
   IP access control	Selection	IP address for accessing the recovery DB Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.1/32, 192.168.10.1/32), then click the Add button To delete an entered IP, click the x button next to the entered IP
   maintenance period	Selection	DB maintenance window If you select Use, you can set the day, start time, and duration The maintenance window is a feature that allows the user to set the time slot for performing patch operations, and patch tasks within that time are the user’s responsibility. We ask you to set a maintenance window for the stable operation of the system, and we are not responsible for any issues arising from not setting it or failing to perform tasks within the window.
   tag	Selection	Add Tag Add Tag after clicking the button, enter or select Key, Value values

   Table. MariaDB (DBaaS) Recovery Configuration Items