The page has been translated by Gen AI.

Backing up and restoring the database

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

Refer to MariaDB(DBaaS) Creating for how to configure backups for MariaDB (DBaaS).

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

Caution

  • For reliable backups, we recommend adding separate BACKUP storage or sufficiently expanding storage capacity.

  • Especially when the backup data exceeds 100 GB and undergoes frequent changes, please secure additional storage amounting to about 60 % of the data size.

  • For instructions on adding and expanding storage, refer to the MariaDB(DBaaS) Add Storage and MariaDB(DBaaS) Expand Storage guides.

  • If a backup is configured, it will be performed at the designated time after the set time, and additional fees will be incurred based on the backup size.

  • If you change the backup setting to unset, backup execution stops immediately, and the stored backup data is deleted and can no longer be used.

  1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Go to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. Navigate to the MariaDB(DBaaS) List page.
  3. MariaDB(DBaaS) List page: click the resource you want to configure a backup for. 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 setting up 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 want to stop the backup configuration, deselect Use in the Backup Settings popup and authenticate via the logged-in user’s mobile phone.
      Once user authentication is completed, the backup configuration is disabled and backup execution stops.

Check backup history

information
To set notifications for backup success and failure, you can configure them via the Notification Manager product. For a detailed usage guide on setting up notification policies, refer to 알림 정책 생성하기.

To check the backup history, follow these steps.

  1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Go to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. Navigate to the MariaDB(DBaaS) List 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, you can view the backup status, version, backup start time, backup completion time, and size.

Delete backup files

To delete the backup file, follow these steps.

Caution
Backup files cannot be restored after deletion. Please be sure to verify whether the data is unnecessary before deleting it.
  1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Go to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. Navigate to the MariaDB(DBaaS) List page.
  3. MariaDB (DBaaS) List page: click the resource to view the backup history. 3. MariaDB(DBaaS) Details Navigate to the page.
  4. Click the Backup History button. 4. Backup History popup opens.
  5. Backup History In the popup window, check the files you want to delete, then authenticate via the logged-in user’s mobile phone.
    • When user authentication is completed, the backup file is deleted.

Recover MariaDB(DBaaS)

If a backup file must be restored due to a failure or data loss, you can recover to a specific point in time using the recovery feature. When performing a MariaDB(DBaaS) recovery, a new server is created with the OS image from the initial provisioning point, the DB is installed with the version from the backup point, and the recovery proceeds with the DB’s configuration information and data.

Caution
Performing recovery requires at least twice the capacity of the Disk data type. If there is insufficient disk space, recovery may fail.

To recover MariaDB (DBaaS), follow these steps.

  1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Go 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. Go to the Database Recovery page.
  5. After entering information in the Database recovery configuration area, click the Complete button.
    Category
    required status
    		Detailed description
    Recovery TypeRequiredSet 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 range where backup is possible. The recoverable period depends on the Archive backup cycle 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 prefixRequiredServer name of the recovery DB
    • Start with a lowercase English letter and use lowercase letters, numbers, and special characters (-) to input 3 to 16 characters
    • Based on the server name, a postfix such as 001, 002 is appended to generate the actual server name
    Cluster nameRequiredCluster name of the recovery DB
    • Enter using English letters, 3 ~ 20 characters
    • A cluster is a unit that groups multiple servers
    Service Type > Server TypeEssentialServer type for the recovery DB installation
    • Standard: commonly used standard specification
    • High Capacity: large-capacity server with 24vCore or more (to be provided later)
    Service Type > Planned ComputeSelectionStatus of resources with Planned Compute configured
    • In Use: Number of resources with Planned Compute configured that are currently in use
    • Configured: Number of resources with Planned Compute configured
    • Coverage Preview: Amount applied per resource by Planned Compute
    Service Type > Block StorageRequiredBlock 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.
      • Applied identically with the storage type set in the source cluster
      • Enter capacity as a multiple of 8 within the range 16 to 5,120
    • Additional: Storage area for DATA, Archive, TEMP, Backup data
      • Applied identically with the storage type set in the source 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 usernameRequiredDatabase username configured in the source DB
    Database Port numberRequiredDatabase port number set in the source DB
    IP access controlSelectionIP address for accessing the recovery DB
    • IP format (e.g., 192.168.10.1) or CIDR format (e.g., 192.168.10.1/32, 192.168.10.1/32) and click the Add button
    • To delete an entered IP, click the x button next to the entered IP
    maintenance periodSelectDatabase maintenance window
    • If you select Use, set the day of week, start time, and duration
    • It is recommended to set a maintenance window for stable DB management. Patch operations will be performed at the scheduled time, causing service interruption
    • If set to unused, Samsung SDS is not responsible for issues arising from unapplied patches.
    tagSelectAdd Tag
    • After clicking the Add Tag button, enter or select Key, Value values
    Table. MariaDB (DBaaS) recovery configuration items
DB Service Manage
Configure Read Replica