The page has been translated by Gen AI.

DB Backup and Recovery

The user can set up the backup of EPAS(DBaaS) through the Samsung Cloud Platform Console and restore it with the backed-up file.

EPAS(DBaaS) Backup

To ensure that the user’s data is safely stored, EPAS(DBaaS) provides a data backup function based on its own backup command, and also provides a backup history function to check if the backup was done normally, and can also delete the backed-up files.

Setting up backup

The method of setting up a backup for EPAS(DBaaS) is described in EPAS(DBaaS) creation guide.

To modify the backup settings of the generated resource, follow these steps.

Caution

For stable backup, it is recommended to add a separate BACKUP storage or sufficiently increase the storage capacity. Especially when the backup target data exceeds 100 GB and there are many data changes, please secure additional storage equivalent to about 60% of the data capacity. For storage addition and expansion methods, refer to the EPAS(DBaaS) Add Storage, EPAS(DBaaS) Expand Storage guides. If backup is set, backup is performed at the specified time after the set time, and additional fees are incurred depending on the backup capacity.
If the backup setting is changed to unset, the backup operation will be stopped immediately, and the saved backup data will be deleted and can no longer be used.

To set up a backup, follow these steps.

All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
EPAS(DBaaS) list page, click the resource to set the backup. Move to the EPAS(DBaaS) details page.
Click the Edit button of the backup item. The Backup Settings popup window opens.
If you set up a backup, click Use in the Backup Settings popup window, select the retention period, backup start time, and Archive backup cycle, and then click the OK button.
- If you want to stop the backup settings, uncheck Backup Settings in the popup window and click the OK button.

Check Backup History

Notice

Additionally, to set up notifications for backup success and failure, you can set them up through the Notification Manager product. For a detailed usage guide on setting up notification policies, please refer to Creating a Notification Policy.

To view the backup history, follow these steps.

All services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
EPAS(DBaaS) list page, click the resource to check the backup history. It moves to the EPAS(DBaaS) detail page.
Click the Backup History button. The Backup History popup window opens.
Backup History popup window where you can check the backup status, version, backup start time, backup completion time, and capacity.

Deleting Backup Files

To delete the backup history, follow these steps.

Caution

Backup files cannot be restored after deletion. Please make sure to check if the data is unnecessary before deleting it.

Click All Services > Database > EPAS(DBaaS) menu. It moves to the Service Home page of EPAS(DBaaS).
Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
EPAS(DBaaS) list page, click the resource to check the backup history. It moves to the EPAS(DBaaS) details page.
Click the Backup History button. The Backup History popup window opens.
Backup History popup window, check the file you want to delete, and then click the Delete button.

EPAS(DBaaS) Recovery

In the event of a failure or data loss that requires restoration from a backup file, recovery is possible based on a specific point in time through the recovery function. When performing EPAS (DBaaS) recovery, a new server is created with the OS image at the initial provisioning time, and the DB is installed with the version at the backup point, and the recovery proceeds with the DB configuration information and data.

Caution

To perform recovery, a data type with the same capacity as Disk capacity is required. If the Disk capacity is insufficient, recovery may fail.

To recover EPAS(DBaaS), follow these procedures.

Click All Services > Database > EPAS(DBaaS) menu. It moves to the Service Home page of EPAS(DBaaS).
Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
EPAS(DBaaS) Resource list page, click the resource you want to restore. It moves to the EPAS(DBaaS) detail page.
Database Recovery 버튼을 클릭하세요. Database Recovery 페이지로 이동합니다.
Database Recovery Configuration area, enter the corresponding information, and then click the Complete button.

Classification	Necessity	Detailed Description
Recovery Type	Required	Set the point in time to recover Backup Point (Recommended): Recover based on the backup file. Select from the list of backup file timestamps displayed Custom Point: Recover to the desired point in time within the range where backup is possible. The recoverable period is from the initial backup start time to the current time, 1 hour/30 minutes/10 minutes/5 minutes ago, depending on the Archive backup cycle setting value. Select the date and time you want to backup
Server name prefix	Required	Recovery DB server name Start with lowercase English letters, using lowercase letters, numbers, and special characters (`-`) to input 3-16 characters A postfix such as 001, 002 is attached based on the server name, and the actual server name is created
Cluster Name	Required	Recovery DB Cluster Name Enter in English, 3-20 characters A cluster is a unit that bundles multiple servers
Service Type > Server Type	Required	Recovery DB Server Type Standard: Generally used standard specification High Capacity: High-capacity server with 24vCore or more
Service Type > Planned Compute	Select	Current status of resources with Planned Compute set In Use: Number of resources with Planned Compute set that are in use Setting: Number of resources with Planned Compute set Coverage Preview: Amount applied by resource-based Planned Compute Create Planned Compute Service: Move to the Planned Compute service application page For more information, see Apply for Planned Compute
Service Type > Block Storage	Required	Block Storage settings used by the recovery DB Default OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Applied identically to the Storage type set in the original cluster Capacity can be entered in multiples of 8 in the range of 16 to 5,120 Additional: Storage area for DATA, Archive, TEMP, Backup data Applied identically to the Storage type set in the original cluster Only DATA, TEMP, and Archive purposes can be added in the recovery DB Select Use and enter the purpose and capacity of the storage To add storage, click the + button, and to delete, click the x button Capacity can be entered in multiples of 8 in the range of 16 to 5,120, and up to 9 can be created
Database username	required	Database username Applied identically to the username set in the original cluster
Database Port Number	required	Database Port Number Apply the same port number set in the original cluster
IP Access Control	Select	Set Service Access Policy Set access policy for IP entered on the page, so separate Security Group policy setting is not required Enter in IP format (e.g., `192.168.10.1`) or CIDR format (e.g., `192.168.10.0/24`, `192.168.10.1/32`), and click the Add button To delete the entered IP, click the x button next to the entered IP
Maintenance period	Select	DB maintenance period Use Select the day, start time, and duration It is recommended to set the maintenance period for stable DB management. Patch work will be carried out at the set time and service interruption will occur If set to not in use, the company will not be responsible for any problems that occur due to non-application of patches.
Tag	Select	Add Tag Click the Add Tag button and enter or select Key, Value

Fig. EPAS(DBaaS) Recovery Configuration Items

Managing DB Service

Configuring Read Replica