Backing up and restoring the DB
Users can configure backups for EPAS (DBaaS) through the Samsung Cloud Platform Console and restore using the backed‑up files.
EPAS(DBaaS) Backing up
To ensure that user data is stored securely, EPAS (DBaaS) provides a data backup feature based on its own backup commands. Additionally, you can verify whether the backup was successful using the backup history feature, and you can also delete backed-up files.
Configure Backup
Refer to EPAS(DBaaS) 생성하기 for how to configure backup settings for EPAS (DBaaS).
To modify the backup settings of a created resource, follow the steps below.
- 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 secure additional storage equal to about 60 % of the data size. * For storage addition and expansion methods, please refer to the guides EPAS(DBaaS) 스토리지 추가하기, EPAS(DBaaS) 스토리지 증설하기.
- If a backup is configured, it runs at the specified time after the set time, and additional fees apply 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.
- All Services > Database > EPAS(DBaaS) Click the menu. 1. Navigate to the Service Home page of EPAS (DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. 2. Navigate to the EPAS(DBaaS) List page.
- On the EPAS (DBaaS) List page, click the resource you want to configure backup for. 3. Go to the EPAS(DBaaS) Details page.
- Click the Edit button of the backup item. 4. Backup Settings The popup window opens.
- When configuring 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 setting, deselect 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.
- If you want to stop the backup setting, deselect Use in the Backup Settings popup window and authenticate via the logged-in user’s mobile phone.
Perform immediate backup
If additional data protection is required, you can quickly create a backup using the instant backup feature.
To perform an immediate backup, follow these steps.
- Click the All Services > Database > EPAS(DBaaS) menu. 1. Navigate to the Service Home page of EPAS (DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. 2. Navigate to the EPAS (DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource to perform an immediate backup. 3. Go to the EPAS(DBaaS) Details page.
- Click the Immediate Backup button of the backup item. 4. Immediate Backup Settings popup window opens.
- In the Immediate backup setup popup, click the Confirm button.
Check backup history
To view the backup history, follow these steps.
- Click the All Services > Database > EPAS(DBaaS) menu. 1. Navigate to the Service Home page of EPAS (DBaaS).
- Click the EPAS(DBaaS) menu on the Service Home page. 2. Go to the EPAS (DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource to view the backup history. 3. Navigate to the EPAS(DBaaS) Details page.
- Click the Backup History button. 4. Backup History The popup window opens.
- Backup History In the popup window, you can view the backup status, version, backup start time, backup completion time, and size.
Delete backup file
To delete the backup history, follow these steps.
- All Services > Database > EPAS(DBaaS) Click the menu. 1. Navigate to the Service Home page of EPAS (DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. 2. Navigate to the EPAS(DBaaS) List page.
- EPAS(DBaaS) List page, click the resource to view the backup history. 3. Navigate to the EPAS(DBaaS) Details page.
- Click the Backup History button. 4. Backup History The popup window opens.
- 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.
Recover EPAS(DBaaS)
If a failure or data loss occurs and restoration from a backup file is required, recovery can be performed based on a specific point in time using the recovery feature. When you perform EPAS (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 recovery proceeds with the database’s configuration information and data.
To restore EPAS(DBaaS), follow the steps below.
- All Services > Database > EPAS(DBaaS) Click the menu. 1. Navigate to the Service Home page of EPAS (DBaaS).
- Click the EPAS(DBaaS) menu on the Service Home page. 2. EPAS (DBaaS) List Navigate to the page.
- EPAS(DBaaS) resource On the list page, click the resource you want to recover. 3. EPAS(DBaaS) Details page is accessed.
- Click the Database Recovery button. 4. Go to the Database Recovery page.
- Database Recovery Configuration After entering the relevant information in the area, click the Complete button.Required status
Detailed description Recovery type Required Set the point in time the user wants to recover - Backup point (recommended): Recover based on the backup file. Select from the list of backup file timestamps displayed in the list
- Custom point: Recover to a user‑desired point within the range where backups are possible. The recoverable period depends on the Archive backup cycle setting, allowing recovery 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 prefix Required Recovery DB server name - Start with a lowercase English letter, then 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 name Required Recovery DB cluster name - Enter using English letters, 3 ~ 20 characters
- A cluster is a unit that groups multiple servers
Service Type > Server Type Required Recovery DB server type - Standard: standard specifications commonly used
- High Capacity: large-capacity server with 24vCore or more
Service Type > Planned Compute Selection Planned Compute가 설정된 자원 현황 - 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 by Planned Compute per resource
- Create Planned Compute Service: Go to the Planned Compute service application page
- For more details, see Planned Compute 신청하기
Service Type > Block Storage Required Block 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
- 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 username Required Database username - Apply the same username set in the original cluster
Database Port number Required Database Port number - Apply the same Port number as set in the original cluster
IP access control Selection Service Access Policy Configuration - Since the access policy is set for the IP entered on the page, you do not need to configure a separate Security Group policy
- Enter in IP format (example:
192.168.10.1) or CIDR format (example: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 period Selection DB maintenance window - Use if selected, you can 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 patch operations, and any patch work during that period must be performed directly by the user.
- We ask you to set a maintenance window for the stable operation of the system; we are not responsible for any problems arising from not setting it or from failure to perform tasks within the designated period.
tag Selection Add Tag - After clicking the Add Tag button, enter or select Key, Value values
Table. EPAS (DBaaS) recovery configuration items