The page has been translated by Gen AI.

DB Backup and Restore

Users can set up MariaDB(DBaaS) backup and restore using backed up files through Samsung Cloud Platform Console.

Backing up MariaDB(DBaaS)

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

Setting up Backup

For MariaDB(DBaaS) backup configuration method, please refer to Creating MariaDB(DBaaS).

Follow these steps to modify the backup settings of the created resource.

Warning
  • For stable backup, it is recommended to add a separate BACKUP storage or sufficiently increase storage capacity. Especially if backup target data exceeds 100 GB and there is a lot of data change, please secure additional storage corresponding to approximately 60% of the data capacity. For storage addition and capacity increase methods, please refer to Adding MariaDB(DBaaS) Storage, Expanding MariaDB(DBaaS) Storage guides.
  • If backup is set, backup is performed at the specified time after the set time, and additional charges occur according to backup capacity.
  • If backup setting is changed to Not Set, backup execution is immediately stopped and stored backup data is deleted and can no longer be used.
  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to set up backup on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click Modify button in the backup item. Backup Setting popup window will open.
  5. To set up backup, click Use in the Backup Setting popup window, select retention period, backup start time, Archive backup cycle, and click Confirm button.
    • To stop backup setting, uncheck Use in the Backup Setting popup window and click Confirm button.

Viewing Backup History

Notice
To set notifications for backup success and failure, you can set through Notification Manager product. For detailed user guide on notification policy setting, please refer to Creating Notification Policy.

Follow these steps to view backup history.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to view backup history on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click Backup History button. Backup History popup window will open.
  5. In the Backup History popup window, you can view backup status, version, backup start date/time, backup completion date/time, and capacity.

Deleting Backup Files

Follow these steps to delete backup files.

Warning
Backup files cannot be restored after deletion. Please be sure to confirm that it is unnecessary data before deletion.
  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to view backup history on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click Backup History button. Backup History popup window will open.
  5. Check the file you want to delete in the Backup History popup window and click Delete button.

Restoring MariaDB(DBaaS)

In case of failure or data loss, you can restore based on a specific point in time using the restore functionality. When MariaDB(DBaaS) restore is performed, a new server is created with the OS image at the time of initial provisioning, DB is installed with the version of that backup point, and restore is performed with the DB’s configuration information and data.

Warning
At least twice the capacity of the data type Disk is required to perform restore. If Disk capacity is insufficient, restore may fail.

Follow these steps to restore MariaDB(DBaaS).

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to restore on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click Database Restore button. You will be taken to the Database Restore page.
  5. Enter information in the Database restore configuration area and click Complete button.
    Category
    Required
    		Description
    Restore TypeRequiredSet the point in time the user wants to restore
    • Backup Point (Recommended): Restore based on backup file. Select from the list of backup file points displayed
    • User-Specified Point: Restore to the point in time the user wants within the range where backup is possible. The restorable period depends on the Archive backup cycle setting value, and can restore from the initial backup start point to 1 hour/30 minutes/10 minutes/5 minutes before the current time. Select the date and time to backup
    Server Name PrefixRequiredServer name of restore DB
    • Enter 3-16 characters starting with English lowercase letters, using lowercase letters, numbers, and special characters (-)
    • Actual server name is created with postfix like 001, 002 based on server name
    Cluster NameRequiredCluster name of restore DB
    • Enter 3-20 characters using English
    • Cluster is a unit that groups multiple servers
    Service Type > Server TypeRequiredServer type where restore DB will be installed
    • Standard: Standard specifications commonly used
    • High Capacity: Large capacity server with 24vCore or more (to be provided later)
    Service Type > Planned ComputeOptionalResource status with Planned Compute set
    • In Use: Number of resources in use among those with Planned Compute set
    • Set: Number of resources with Planned Compute set
    • Coverage Preview: Amount applied with Planned Compute per resource
    Service Type > Block StorageRequiredBlock Storage settings used by restore DB
    • Basic OS: Area where DB engine is installed
    • DATA: Storage area for table data, archive files, etc.
      • Applied identically with the Storage type set in the original cluster
      • Capacity is entered in multiples of 8 within the 16-5,120 range
    • Additional: DATA, Archive, TEMP, Backup data storage area
      • Applied identically with the Storage type set in the original cluster
      • In restore DB, only DATA, TEMP, Archive purposes can be added
      • Select Use and enter storage purpose and capacity
      • To add storage, click + button, to delete, click x button
      • Capacity can be entered in multiples of 8 within the 16-5,120 range, and can create up to 9
    Database UsernameRequiredDatabase username set in the original DB
    Database Port NumberRequiredDatabase Port number set in the original DB
    IP Access ControlOptionalIP address to access restore DB
    • Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.1/32, 192.168.10.1/32) and click Add button
    • To delete entered IP, click x button next to the entered IP
    Maintenance WindowOptionalDB maintenance window
    • If Use is selected, set day of week, start time, duration
    • For stable DB management, set maintenance window is recommended. Patching is performed at the set time and service interruption occurs
    • If set to Not Used, problems caused by not applying patching are not the responsibility of Samsung SDS.
    TagOptionalAdd tag
    • Click Add Tag button and enter or select Key, Value values
    Table. MariaDB(DBaaS) Restore Configuration Items
Managing DB Service
Configuring Read Replica