The page has been translated by Gen AI.

Backing up and restoring Vertica

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

Backing up Vertica (DBaaS)

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

Configure Backup

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

To modify the backup settings of Vertica (DBaaS), follow the steps below.

Caution
  • If a backup is configured, it will run at the designated time after the set time, and additional fees will be incurred based on the backup volume.
  • If you change the backup setting to unused, backup execution will stop immediately, and the stored backup data will be deleted and can no longer be used.
  1. Click the All Services > Data Analytics > Vertica(DBaaS) menu. 1. Go 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 to configure a backup. 3. Vertica(DBaaS) Details Navigate to the page.
  4. Click the Edit button of the backup item. 4. Backup Settings The popup window opens.
  5. When setting up a backup, click Backup Settings in the popup window, click Enable, select the retention period and backup start time, and click the Confirm button.
    • If you want to stop the backup configuration, deselect Use in the Backup Settings popup and authenticate via the logged‑in user’s mobile phone.
      Once user authentication is completed, the backup configuration will be disabled and backup execution will stop.

Check backup history

information
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, refer to 알림 정책 생성하기.

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. Navigate to the Vertica(DBaaS) List page.
  3. On the 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. The Backup History 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 files

To delete the backup history, follow these steps.

Caution
Backup files cannot be restored after deletion. Please be sure to verify whether the data is unnecessary before deleting it.
  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. Go 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.

Recover Vertica(DBaaS)

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.

Caution
To perform recovery, you need a capacity at least equal to the Disk data type’s capacity. If there is insufficient disk space, the recovery may fail.

To restore Vertica(DBaaS), follow these steps.

  1. Click the All Services > Data Analytics > Vertica(DBaaS) menu. 1. Go 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. On the Vertica(DBaaS) resource list page, click the resource you want to recover. 3. Vertica(DBaaS) Details Go to the page.
  4. Database Recovery button, click it. 4. Database(DBaaS) Recovery Navigate to the page.
  5. After entering the relevant information in the Database Recovery area, click the Complete button.
    Category
    required status
    		Detailed description
    Recovery TypeRequiredSet 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
    • Recovery point: Choose the date and time to recover. Can be selected from the start time of the backup history
    Server name PrefixEssentialRecovery 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 nameRequiredRecovery DB cluster name
    • Enter using English letters, 3 to 20 characters
    • A cluster is a unit that groups multiple servers
    Number of nodesSelectionData node count
    • Set to be the same as the number of nodes configured in the original cluster
    Service Type > Server TypeRequiredRecovery DB server type
    • Standard: standard specification commonly used
    • High Capacity: large-capacity server with 24 vCores or more
    Service Type > Planned ComputeSelectionStatus of resources with Planned Compute configured
    • In Use: Number of resources with Planned Compute 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 Application: Go to the Planned Compute service application page
    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
      • 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 TypeEssentialManagement Console server type
    • After selecting Use, select the storage purpose and capacity
    • Standard: standard specification commonly used
    • High Capacity: large-capacity server with 24vCore or more
    Management Console > Block StorageRequiredBlock Storage settings used by the Management Console
    • Select Use, then select Default OS
    Database usernameRequiredDatabase username
    • Apply the same username set in the original cluster
    Database passwordEssentialDatabase password
    • Apply the same password set in the original cluster
    Database Port numberRequiredDatabase Port number
    • Apply the same Port number as set in the original cluster
    IP access controlSelectService 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 (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 periodSelectDatabase 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 management of the database. Patch operations will be performed at the scheduled time, causing service interruption
    • If set to not use, Samsung SDS is not responsible for issues arising from patches not being applied.
    License KeyRequiredEnter the Vertica License Key to recover
    • If the entered license key is invalid, the service cannot be created
    tagSelectionAdd Tag
    • After clicking the Add Tag button, enter or select Key, Value values
    Table. Vertica (DBaaS) recovery configuration items
How-to guides
Release Note