Backing up and restoring Vertica

Users can set up backups for Vertica (DBaaS) and restore from the backed‑up files via the Samsung Cloud Platform Console.

Vertica(DBaaS) Backup

You can configure the backup feature to ensure that user data is stored securely. Additionally, you can verify whether the backup was successful using the backup history feature, and you can also delete backed‑up files.

Configure Backup

For backup configuration of Vertica (DBaaS), refer to Vertica(DBaaS) Create.

Follow the steps below to modify the backup settings of Vertica(DBaaS).

1. All Services > Data Analytics > Vertica(DBaaS) Click the menu. 1. Navigate to the Service Home page of Vertica (DBaaS).
2. On the Service Home page, click the Vertica(DBaaS) menu. 2. Go to the Vertica(DBaaS) List page.
3. Vertica(DBaaS) List page, click the resource for which you want to configure a backup. 3. Vertica(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 and backup start time, and click the Confirm button.
   • If you want to stop the backup setting, deselect Backup Setting in the Use 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.

Check backup history

To view the backup history, follow these steps.

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

Delete backup file

To delete the backup history, follow these steps.

1. All Services > Data Analytics > Vertica(DBaaS) Click the menu. 1. Go to the Service Home page of Vertica (DBaaS).
2. On the Service Home page, click the Vertica(DBaaS) menu. 2. Navigate to the Vertica(DBaaS) List page.
3. Vertica(DBaaS) List page, click the resource to view the backup history. 3. Vertica(DBaaS) Details Navigate 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 is deleted.

Vertica(DBaaS) Recover

If a failure or data loss requires restoration from backup files, you can use the cluster recovery feature to recover based on a specific point in time.

To recover Vertica (DBaaS), follow the steps below.

1. All Services > Data Analytics > Vertica(DBaaS) Click the menu. 1. Go to the Service Home page of Vertica(DBaaS).
2. On the Service Home page, click the Vertica(DBaaS) menu. 2. Vertica(DBaaS) List Navigate to the page.
3. Vertica(DBaaS) resource On the list page, click the resource you want to recover. 3. Vertica(DBaaS) Details Go to the page.
4. Click the Database Recovery button. 4. Database(DBaaS) Recovery Go to the page.
5. Database Recovery area, after entering the relevant information, click the Complete button.

   Category	Required status	Detailed description
   Copy the restored file the restored file the restored file the restored file the restored file the restored file the restored file the restored file the restored file.	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 Recovery point: Choose the date and time to recover. Can be selected from the start time of the backup history
   Server name Prefix	Required	Recovery 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 name	Required	Recovery DB cluster name Enter using English letters, 3 ~ 20 characters A cluster is a unit that groups multiple servers
   Number of nodes	Selection	Number of data nodes Set to be the same as the number of nodes configured in the original cluster
   Service Type > Server Type	Required	Recovery DB server type Standard: standard specifications commonly used High Capacity: large-capacity server of 24 vCore or more
   Service Type > Planned Compute	Selection	Resource status with Planned Compute configured 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 per resource by Planned Compute Planned Compute Service Request: Go to the Planned Compute service request page For more details, see Planned Compute Apply.
   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 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 in multiples of 8 within the range 16 to 5,120, and up to 9 can be created
   Management Console > Server Type	Required	Management Console server type After selecting Use, choose the storage purpose and capacity Standard: standard specification commonly used High Capacity: large-capacity server with 24 vCore or more
   Management Console > Block Storage	Required	Block Storage settings used by the Management Console Select Use and then select Default OS
   Database username	Required	Database username Apply the same username set in the original cluster
   Database password	Required	Database password Apply the same password 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 If you select Use, you can set the day of the week, start time, and duration The maintenance window is a feature that allows the user to set the time slot for performing patch operations, and any patch tasks within that period must be carried out directly 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.
   License Key	Required	Enter the Vertica License Key to recover If the entered license key is invalid, the service cannot be created
   tag	Selection	Add Tag Add Tag after clicking the button, enter or select Key, Value values

   Table. Vertica (DBaaS) recovery configuration items