DB Backup and Recovery
Users can configure backups for EPAS(DBaaS) through the Samsung Cloud Platform Console and recover using the backed up files.
EPAS(DBaaS) Backup
To ensure users’ data is safely stored, EPAS(DBaaS) provides data backup functionality based on its own backup commands. Additionally, you can verify whether backups were performed normally through the backup history feature and delete backed up files.
Setting Backup
For information on how to set up backups for EPAS(DBaaS), see EPAS(DBaaS) Creation Guide.
To modify the backup settings of a created resource, follow these steps:
- For stable backup, it is recommended to add separate BACKUP storage or sufficiently expand the storage capacity. In particular, if the backup target data exceeds 100 GB and there are many data changes, please secure additional storage equivalent to approximately 60% of the data capacity. For information on adding and expanding storage, see EPAS(DBaaS) Storage Addition and EPAS(DBaaS) Storage Expansion guides.
- If backup is set, backup will be performed at the specified time after the set time, and additional charges will be incurred depending on the backup capacity.
- If the backup setting is changed to Not Set, backup execution will immediately stop, and stored backup data will be deleted and can no longer be used.
To set up backup, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource for which you want to set up backup. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Modify button in the Backup section. The Backup Settings popup will appear.
- To set up backup, click Enable in the Backup Settings popup, select the retention period, backup start time, and archive backup cycle, then click the Confirm button.
- To stop backup settings, uncheck Enable in the Backup Settings popup and click the Confirm button.
Checking Backup History
To view backup history, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource for which you want to check backup history. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Backup History button. The Backup History popup will appear.
- In the Backup History popup, you can check the backup status, version, backup start date/time, backup completion date/time, and capacity.
Deleting Backup Files
To delete backup history, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource for which you want to check backup history. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Backup History button. The Backup History popup will appear.
- In the Backup History popup, check the file you want to delete and click the Delete button.
EPAS(DBaaS) Recovery
If recovery using backup files is required due to failure or data loss, you can recover based on a specific point in time through the recovery function. When EPAS(DBaaS) recovery is performed, a new server is created with the OS image at the time of initial provisioning, the DB is installed with the version at that backup point, and recovery proceeds with the DB configuration information and data.
To recover EPAS(DBaaS), follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) Resource list page, click the resource you want to recover. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Database Recovery button. You will be directed to the Database Recovery page.
- After entering the corresponding information in the Database Recovery Configuration section, click the Complete button.
Item RequiredDetailed Description Recovery Type Required Set the point in time the user wants to recover - Backup Point (Recommended): Recovery based on backup files. Select from the list of backup file points displayed in the list
- User-Specified Point: Recover to a point desired by the user within the range of points where backup is possible. The recoverable period can recover from the first backup start time to 1 hour/30 minutes/10 minutes/5 minutes before the current time depending on the Archive backup cycle setting value. Select the date and time you want to backup
Server Name Prefix Required Recovered DB server name - Enter 3~16 characters starting with lowercase English letters and using lowercase letters, numbers, and special characters (
-)
- Actual server name is created with a postfix like 001, 002 based on the server name
Cluster Name Required Recovered DB cluster name - Enter 3~20 characters using English letters
- Cluster is a unit that groups multiple servers
Service Type > Server Type Required Recovered DB server type - Standard: Standard specifications generally used
- High Capacity: Large capacity servers with 24vCore or more
Service Type > Planned Compute Optional Status of resources with Planned Compute set - In Use: Number of resources in use among resources with Planned Compute set
- Set: Number of resources with Planned Compute set
- Coverage Preview: Amount applied by Planned Compute for each resource
- Create Planned Compute Service: Move to Planned Compute service application page
- For details, see Applying for Planned Compute
Service Type > Block Storage Required Block Storage settings used by recovered DB - Basic OS: Area where DB engine is installed
- DATA: Storage area for table data and archive files
- Applied identically with the Storage type set in the original cluster
- Enter capacity in multiples of 8 in the range of 16~5,120
- Additional: DATA, Archive, TEMP, Backup data storage area
- Applied identically with the Storage type set in the original cluster
- In recovered DB, only DATA, TEMP, Archive purposes can be added
- Select Use and then enter the storage purpose and capacity
- Click + button to add storage, x button to delete
- Capacity can be entered in multiples of 8 in the range of 16~5,120, and up to 9 can be created
Database Username Required Database username - Applied identically with the username set in the original cluster
Database Port Number Required Database port number - Applied identically with the port number set in the original cluster
IP Access Control Optional Service access policy settings - Sets access policy for IPs entered on the page, so separate Security Group policy settings are 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 an entered IP, click the x button next to the entered IP
Maintenance Window Optional DB 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 proceed at the set time and service interruption occurs
- If set to Not Use, Samsung SDS is not responsible for problems caused by not applying patches
Tags Optional Add tags - Click the Add Tag button and then enter or select Key, Value values
Table. EPAS(DBaaS) Recovery Configuration Items