The page has been translated by Gen AI.

Vertica Backup and Recovery

Users can set up backups of Vertica (DBaaS) through the Samsung Cloud Platform Console and restore from the backed-up files.

Vertica(DBaaS) Backup

You can set up a backup function so that the user’s data can be stored safely. Also, through the backup history function, you can verify whether the backup was performed correctly and you can also delete backed-up files.

Set up backup

For backup configuration of Vertica(DBaaS), see Create Vertica(DBaaS).

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

Caution
  • If a backup is set, the backup will be performed at the designated time after the set time, and additional charges will be incurred depending on the backup size.
  • 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. All Services > Data Analytics > Vertica(DBaaS) Click the menu. Navigate to the Service Home page of Vertica(DBaaS).
  2. Click the Vertica(DBaaS) menu on the Service Home page. Navigate to the Vertica(DBaaS) List page.
  3. Click the resource to set backup on the Vertica(DBaaS) List page. You will be taken to the Vertica(DBaaS) Details page.
  4. Click the Edit button of the backup item. Backup Settings popup window opens.
  5. When setting up 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, uncheck Use in the Backup Setting popup window and click the Confirm button.

Check backup history

Guide
To set notifications for backup success and failure, you can configure them via the Notification Manager product. For a detailed usage guide on setting notification policies, refer to Create Notification Policy.

To view the backup history, follow these steps.

  1. All Services > Data Analytics > Vertica(DBaaS) Click the menu. Go to the Service Home page of Vertica(DBaaS).
  2. Click the Vertica(DBaaS) menu on the Service Home page. Navigate to the Vertica(DBaaS) list page.
  3. Click the resource to view the backup history on the Vertica(DBaaS) 목록 page. Go to the Vertica(DBaaS) 상세 page.
  4. Click the Backup History button. Backup History popup opens.
  5. Backup History In the popup window, you can check the backup status, version, backup start date and time, backup completion date and time, and size.

Delete backup file

To delete the backup history, follow the steps below.

Caution
Backup files cannot be restored after deletion. Please be sure to confirm whether the data is unnecessary before deleting.
  1. All Services > Data Analytics > Vertica(DBaaS) Click the menu. Navigate to the Service Home page of Vertica(DBaaS).
  2. Service Home page, click the Vertica(DBaaS) menu. Go to the Vertica(DBaaS) list page.
  3. Vertica(DBaaS) List On the page, click the resource to view the backup history. Vertica(DBaaS) Details You will be taken to the page.
  4. Click the Backup History button. The Backup History popup window opens.
  5. Backup History In the popup window, check the file you want to delete, then click the Delete button.

Vertica(DBaaS) Recover

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

Caution
To perform recovery, a capacity at least equal to the data type Disk capacity is required. If Disk capacity is insufficient, recovery may fail.

Vertica (DBaaS)를 복구하려면 다음 절차를 따르세요.

  1. All Services > Data Analytics > Vertica(DBaaS) Click the menu. Navigate to the Service Home page of Vertica(DBaaS).
  2. Click the Vertica(DBaaS) menu on the Service Home page. Go to the Vertica(DBaaS) List page.
  3. Vertica(DBaaS) Resource On the list page, click the resource you want to recover. You will be taken to the Vertica(DBaaS) Detail page.
  4. Click the Database Recovery button. Go to the Database(DBaaS) Recovery page.
  5. Database Recovery area, after entering the relevant information, click the Complete button.
    Category
    Required or not
    		Detailed description
    Recovery TypeRequiredSet the point in time the user wants to recover
    • Backup point (recommended): Recover based on 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 PrefixRequiredRecovery DB Server Name
    • Enter 3~16 characters starting with a lowercase English letter, using lowercase letters, numbers, and the special character (-)
    • A postfix such as 001, 002 is appended based on the server name to create the actual server name
    Cluster NameRequiredRecovery DB Cluster Name
    • Enter using English, 3 to 20 characters
    • A cluster is a unit that groups multiple servers
    Number of nodesSelectNumber of data nodes
    • Set to be the same as the number of nodes configured in the original cluster.
    Service Type > Server TypeRequiredRecovery DB Server Type
    • Standard: Standard specifications commonly used
    • High Capacity: Large-capacity server of 24 vCore or more
    Service Type > Planned ComputeSelectStatus of resources with Planned Compute set
    • In Use: Number of resources with Planned Compute that are currently in use
    • Configured: Number of resources with Planned Compute set
    • 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
    • Base OS: Area where the DB engine is installed
    • DATA: Storage area for table data, archive files, etc.
      • Apply the same Storage type as set in the source cluster
      • After selecting Use, enter the storage purpose and capacity
      • Click the + button to add storage, and the x button to delete
      • 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 TypeRequiredManagement Console Server Type
    • After selecting Use, choose the storage purpose and capacity
    • Standard: Standard specifications commonly used
    • High Capacity: Large-capacity server with 24 vCore or more
    Management Console > Block StorageRequiredBlock Storage settings used by Management Console
    • Select Use and then select Base OS
    Database usernameRequiredDatabase username
    • Apply the same username set in the original cluster
    Database PasswordRequiredDatabase 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 Settings
    • Since the access policy is set for the IP entered on the page, you do not need to separately configure Security Group policies.
    • 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 periodSelectDB maintenance period
    • If Use is selected, set day of week, start time, and duration
    • It is recommended to set a maintenance period for stable DB management. Patch work will be performed at the set time, causing service interruption
    • If set to not use, Samsung SDS is not responsible for issues arising from unapplied patches.
    License KeyRequiredEnter the Vertica License Key to recover
    • If the entered license key is not valid, service creation is not possible
    TagSelectAdd Tag
    • Add Tag button click after entering or selecting Key, Value values
    Table. Vertica(DBaaS) Recovery Configuration Items
How-to guides
Release Note