The page has been translated by Gen AI.

Backing up and restoring the DB

Users can configure backups of MySQL (DBaaS) through the Samsung Cloud Platform Console and restore from the backed‑up files.

Backing up MySQL (DBaaS)

PostgreSQL(DBaaS) provides a data backup feature 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 instructions on configuring backup settings for MySQL(DBaaS), see MySQL(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 experiences frequent changes, please provision additional storage equal to approximately 60 % of the data size. * Please refer to the guides for adding and expanding storage, MySQL(DBaaS) 스토리지 추가하기, MySQL(DBaaS) 스토리지 증설하기.
  • If a backup is configured, it runs at the specified time after the set time, and additional fees are incurred based on the backup size.
  • If you change the backup setting to Unset, backup execution will stop immediately, and the stored backup data will be deleted and can no longer be used.

To set up a backup, follow these steps.

  1. Click the All Services > Database > MySQL(DBaaS) menu. 1. Navigate to the Service Home page of MySQL (DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Navigate to the page.
  3. MySQL(DBaaS) List On the page, click the resource to configure a backup. 3. MySQL(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 the retention period, backup start time, and Archive backup interval, then click the Confirm button.
    • If you stop the backup setting, uncheck Use in the Backup Settings popup window and authenticate via the logged-in user’s mobile phone.
      Once user authentication is completed, the backup setting is disabled and backup execution stops.

Perform immediate backup

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. All Services > Database > MySQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Navigate to the page.
  3. MySQL(DBaaS) List page, click the resource to perform an immediate backup. 3. MySQL(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 setting popup, click the Confirm button.

Check backup history

안내
To set notifications for backup success and failure, you can configure them through the Notification Manager product. For a detailed usage guide on configuring notification policies, see 알림 정책 생성하기.

To view the backup history, follow these steps.

  1. All Services > Database > MySQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of MySQL (DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Navigate to the page.
  3. On the MySQL(DBaaS) List page, click the resource to view the backup history. 3. MySQL(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, start time, completion time, and size.

Delete backup file

Caution
Backup files cannot be restored after deletion. Please be sure to confirm that the data is unnecessary before deleting it.

To delete the backup history, follow these steps.

  1. All Services > Database > MySQL(DBaaS) Click the menu. 1. Go to the Service Home page of MySQL (DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Navigate to the page.
  3. MySQL(DBaaS) List page, click the resource to view the backup history. 3. MySQL(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, check the files you want to delete, then authenticate using the logged-in user’s mobile phone.
    • When user authentication is completed, the backup file will be deleted.

MySQL(DBaaS) Recover

If a failure or data loss necessitates restoration from a backup file, the recovery function can restore based on a specific point in time. When performing a MySQL(DBaaS) recovery, a new server is created with the OS image from the initial provisioning point, the database is installed with the version from the backup point, and the recovery proceeds using the database’s configuration information and data.

Caution
To perform recovery, at least double the Disk data type’s capacity is required. If disk space is insufficient, recovery may fail.

To recover MySQL (DBaaS), follow these steps.

  1. All Services > Database > MySQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of MySQL (DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Navigate to the page.
  3. MySQL(DBaaS) Resource Click the resource you want to restore on the list page. 3. MySQL(DBaaS) Details Go to the page.
  4. Click the Database Recovery button. 4. Go to the Database Recovery page.
  5. After entering the relevant 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 restore
    • Backup point (recommended): Restore based on the backup file. Select from the list of backup points displayed in the list.
    • Custom point: Restore to a user‑desired point within the range of recoverable backup times. The recoverable period depends on the Archive backup interval setting, allowing restoration from the initial backup start time up to 1 hour/30 minutes/10 minutes/5 minutes before the current time. Select the date and time to back up
    Server name prefixRequiredRecovery 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 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 TypeRequiredServer type for the recovery DB installation
    • Standard: standard specification commonly used
    • High Capacity: large-capacity server with 24vCore or more (to be provided later)
    Service Type > Planned ComputeSelectionPlanned Compute가 설정된 자원 현황
    • 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
    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 original 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 original cluster
      • In the recovery DB, only DATA, TEMP, and Archive purposes can be added
      • After selecting Use, enter the storage purpose and capacity
      • Click the Add button to add storage, or click the x button to delete
      • 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 set in the source DB
    Database Port numberRequiredDatabase Port number set in the source DB
    IP access controlSelectionIP 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), and click the Add button
    • To delete an entered IP, click the x button next to the entered IP
    Maintenance periodSelectionDB maintenance window
    • If you select Use, set the day of the week, start time, and duration
    • The maintenance window is a feature that lets the user define the time slot for performing patch operations, and any patch work within that period must be carried out by the user.
    • 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 from failure to perform tasks within the window.
    tagSelectionAdd tag
    • After clicking the Add tag button, enter or select Key, Value values
    Table. MySQL(DBaaS) recovery configuration items
Managing DB Services
Configure Read Replica