This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

How-to guides

1: Vertica Backup and Recovery

Users can create the Vertica(DBaaS) service by entering required information and selecting detailed options through Samsung Cloud Platform Console.

Create Vertica(DBaaS)

You can create and use the Vertica(DBaaS) service in Samsung Cloud Platform Console.

Follow the procedure below to create Vertica(DBaaS).

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Create Vertica(DBaaS) button on the Service Home page. You will be moved to the Create page.

Enter the information required to create the service and select detailed options on the Create Vertica(DBaaS) page.

Select the required information in the Image and Version Selection area.
Division
Required
Description
Image Version Required List of Vertica(DBaaS) versions
Table. Vertica(DBaaS) Image and Version Input Items

Division	Required	Description
Image Version	Required	List of Vertica(DBaaS) versions

Enter or select the required information in the Service Information Input area.

Division	Required	Description
Server Name Prefix	Required	Server name where Vertica is installed Start with lowercase English letters, and enter 3 to 13 characters using lowercase letters, numbers, and special characters (`-`) Actual server name is created with postfix such as 001, 002 based on server name
Cluster Name	Required	Cluster name where servers are configured Enter 3 to 20 characters using English letters Cluster is a unit that bundles multiple servers
Node Count	Required	Number of data nodes Enter node count in the range of 1-10 If you enter 2 or more nodes to configure a cluster, you secure High Availability
Service Type > Server Type	Required	Data node server type Standard: Standard specifications commonly used High Capacity: Large capacity servers with 24vCore or more For more information about server types provided by Vertica(DBaaS), refer to Vertica(DBaaS) Server Type
Service Type > Planned Compute	Optional	Resource status where Planned Compute is set In Use: Number of resources in use among resources where Planned Compute is set Set: Number of resources where Planned Compute is set Coverage Preview: Amount applied with Planned Compute for each resource Apply for Planned Compute Service: Move to Planned Compute service application page For more information, refer to Apply for Planned Compute
Service Type > Block Storage	Required	Block Storage type to be used for data nodes Basic OS: Area where engine is installed DATA: Data file storage area Select storage type and enter capacity (for detailed information about each Block Storage type, refer to Create Block Storage) SSD: General Block Storage SSD_KMS: Additional encrypted volume using KMS(Key Management System) encryption key Set Storage type is also applied identically to additional storage Enter capacity in multiples of 8 in the range of 16 ~ 5,120 Additional: DATA, Backup data storage area Select Use and enter storage Purpose, Capacity Click + button to add storage, and click x button to delete, you can add up to 9 Enter capacity in multiples of 8 in the range of 16 ~ 5,120, and you can create up to 9
Management Console	Optional	If Use is selected, server type and Block Storage settings for Node for cluster management and monitoring
Management Console > Server Type	Required	Select data node server type for cluster management and monitoring
Management Console > Block Storage	Required	Select Block Storage type to be used for data node for cluster management and monitoring
Network > Common Settings	Required	Network settings where servers created in the service are installed Select to apply the same settings to all servers being installed Select previously created VPC and Subnet IP: Enter IP for each server Public NAT settings are only possible with per-server settings
Network > Per-Server Settings	Required	Network settings where servers created in the service are installed Select to apply different settings for each server being installed Select previously created VPC and Subnet IP: Enter IP for each server Public NAT function can be used only when VPC is connected to Internet Gateway. If Use is checked, you can select from reserved IPs in Public IP of VPC product. For more information, refer to Create Public IP
IP Access Control	Optional	Service access policy settings Access policy is set for IPs entered on the page, so separate Security Group policy settings are not required 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 Add button To delete entered IP, click x button next to the entered IP
Maintenance Window	Optional	DB maintenance window If Use is selected, set day of week, start time, and duration It is recommended to set a maintenance window for stable DB management. Patch work proceeds at the set time and service interruption occurs If set to Not Used, problems caused by not applying patches are not the responsibility of Samsung SDS

Table. Vertica(DBaaS) Service Configuration Items

Enter or select the required information in the Database Configuration Required Information Input area.

Division	Required	Description
Database Name	Required	Server name applied when DB is installed Start with English letters, and enter 3 to 20 characters using English letters and numbers
Database Username	Required	DB username Account with that name is also created in OS Enter 2 to 20 characters using lowercase English letters Database usernames with restricted use can be checked in Console
Database Password	Required	Password to use when accessing DB Enter 8 to 30 characters including English letters, numbers, and special characters (excluding `"` `’`)
Database Password Confirmation	Required	Re-enter the password to use when accessing DB identically
Database Port Number	Required	Port number required for DB connection Enter DB port in the range of 1200 ~ 65535
Backup > Use	Optional	Whether to use node backup Select Use and select node backup retention period and backup start time
Backup > Retention Period	Optional	Backup retention period Select backup retention period. File retention period can be set from 7 days to 35 days Separate fees are charged for backup files depending on capacity
Backup > Backup Start Time	Optional	Backup start time Select backup start time Backup execution minutes are set randomly, and backup end time cannot be set
License Key	Required	Enter Vertica License Key held by customer If the entered license key is invalid, service creation is not possible
DB Locale	Required	Settings related to string processing, number/currency/date/time display format, etc. to use in Vertica(DBaaS) DB is created with default settings to the selected Locale
Time Zone	Required	Standard time zone to use in Vertica(DBaaS)

Table. Vertica(DBaaS) Required Configuration Items

Enter or select the required information in the Additional Information Input area.
Division
Required
Description
Tags Optional Add tags
Can add up to 50 per resource
After clicking Add Tag button, enter or select Key, Value values
Table. Vertica(DBaaS) Additional Information Input Items

Check the detailed information and estimated billing amount in the Summary panel, and click Complete button.
- When creation is completed, check the created resource on the Resource List page.

Division	Required	Description
Tags	Optional	Add tags Can add up to 50 per resource After clicking Add Tag button, enter or select Key, Value values

Check Vertica(DBaaS) Detailed Information

Vertica(DBaaS) service can check and modify the entire resource list and detailed information. The Vertica(DBaaS) Details page consists of Details, Tags, Operation History tabs.

Follow the procedure below to check the detailed information of Vertica(DBaaS) service.

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Vertica(DBaaS) menu on the Service Home page. You will be moved to the Vertica(DBaaS) List page.

Click the resource for which you want to check detailed information on the Vertica(DBaaS) List page. You will be moved to the Vertica(DBaaS) Details page.

Status information and additional feature information are displayed at the top of the Vertica(DBaaS) Details page.

Division	Description
Cluster Status	Cluster status Creating: Cluster is being created Editing: Cluster is changing to state where Operation is being performed Error: Cluster failed while performing operation If it occurs continuously, contact administrator Failed: Cluster failed during creation process Restarting: Cluster is being restarted Running: Cluster is operating normally Starting: Cluster is being started Stopped: Cluster is stopped Stopping: Cluster is in stopping state Synchronizing: Cluster is being synchronized Terminating: Cluster is being deleted Unknown: Cluster status is unknown If it occurs continuously, contact administrator Upgrading: Cluster is changing to state where upgrade is being performed
Cluster Control	Buttons to change cluster status Start: Start the stopped cluster Stop: Stop the running cluster Restart: Restart the running cluster
Additional Features More	Cluster-related management buttons Synchronize Service Status: Check real-time DB service status Backup History: If backup is set, check whether backup is executed normally and history Database Recovery: Recover DB based on specific time point
Service Termination	Button to terminate service

Table. Vertica(DBaaS) Status Information and Additional Features

Details

You can check the detailed information of the resource selected on the Vertica(DBaaS) List page and modify information if necessary.

Division	Description
Server Information	Server information configured in the cluster Category: Server type (Vertica cluster configuration nodes are displayed as Data, Management Console is displayed as Console) Server Name: Server name IP:Port: Server IP and port Status: Server status
Service	Service name
Resource Type	Resource type
SRN	Unique resource ID in Samsung Cloud Platform Means cluster SRN
Resource Name	Resource name Means cluster name
Resource ID	Unique resource ID in the service
Creator	User who created the service
Created At	Date and time when the service was created
Modifier	User who modified the service information
Modified At	Date and time when the service information was modified
Image/Version	Installed DB image and version information
Cluster Name	Cluster name where servers are configured
Database Name	Server name applied when DB is installed
Database Username	DB username
Planned Compute	Resource status where Planned Compute is set For more information, refer to Apply for Planned Compute
Maintenance Window	DB maintenance window status If maintenance window setting is needed, click Modify icon to set
Backup	Backup setting status If backup setting is needed, click Modify icon to set For more information, refer to Backup Vertica(DBaaS)
Managed Console	Managed Console resource status set when DB is installed
Network	Installed network information (VPC, Subnet)
IP Access Control	Service access policy settings If IP addition or deletion is needed, click Modify icon to set
Time Zone	Standard time zone where Vertica(DBaaS) DB is used
License	Vertica(DBaaS) license information
Server Information	Data/Console server type, basic OS, additional Disk information If server type modification is needed, click Modify icon next to server type to set. For server type modification procedure, refer to Change Server Type If server type is modified, server restart is required If storage expansion is needed, click Modify icon next to storage capacity to expand. For storage expansion procedure, refer to Expand Storage If storage addition is needed, click Add Disk button next to additional Disk to add. For storage addition procedure, refer to Add Storage

Table. Vertica(DBaaS) Details Information Items

Division	Description
Tag List	Tag list Can check tag Key, Value information Can add up to 50 tags per resource When entering tags, search and select from previously created Key and Value lists

Operation History

You can check the operation history of the resource selected on the Vertica(DBaaS) List page.

Division	Description
Operation History List	Resource change history Check operation date and time, resource ID, resource name, operation details, event topic, operation result, operator information

Table. Vertica(DBaaS) Operation History Tab Detailed Information Items

Manage Vertica(DBaaS) Resources

If you need to change existing configuration options of created Vertica(DBaaS) resources or add storage configuration, you can perform tasks on the Vertica(DBaaS) Details page.

Control Operation

If there are changes to running Vertica(DBaaS) resources, you can start, stop, or restart.

Follow the procedure below to control the operation of Vertica(DBaaS).

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Vertica(DBaaS) menu on the Service Home page. You will be moved to the Vertica(DBaaS) List page.
Click the resource for which you want to control operation on the Vertica(DBaaS) List page. You will be moved to the Vertica(DBaaS) Details page.
Check Vertica(DBaaS) status and complete changes through the following control buttons.
- Start: Server where Vertica(DBaaS) service is installed and Vertica(DBaaS) service become running.
- Stop: Server where Vertica(DBaaS) service is installed and Vertica(DBaaS) service become stopped.
- Restart: Only Vertica(DBaaS) service is restarted.

Synchronize Service Status

You can synchronize the real-time service status of Vertica(DBaaS).

Follow the procedure below to check the service status of Vertica(DBaaS).

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Vertica(DBaaS) menu on the Service Home page. You will be moved to the Vertica(DBaaS) List page.
Click the resource for which you want to check service status on the Vertica(DBaaS) List page. You will be moved to the Vertica(DBaaS) Details page.
Click Synchronize Service Status button. Cluster changes to Synchronizing status during checking.
When checking is completed, status is updated in the server information item, and cluster changes to Running status.

Change Server Type

You can change the configured server type.

Caution

If server type is configured as Standard, it cannot be changed to High Capacity. If you want to change to High Capacity, create a new service.
If server type is modified, server restart is required. Please check separately for SW license modification matters or SW settings and reflection according to server specification change.

Follow the procedure below to change the server type.

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Vertica(DBaaS) menu on the Service Home page. You will be moved to the Vertica(DBaaS) List page.
Click the resource for which you want to change server type on the Vertica(DBaaS) List page. You will be moved to the Vertica(DBaaS) Details page.
Click Modify icon of the server type you want to change at the bottom of detailed information. Modify Server Type popup window opens.
Select server type in the Modify Server Type popup window, and click Confirm button.

Add Storage

If you need more than 5 TB of data storage space, you can add storage. If it is High Availability configuration (HA cluster), when storage capacity is expanded or added, it is applied to all DBs simultaneously.

Follow the procedure below to add storage.

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Vertica(DBaaS) menu on the Service Home page. You will be moved to the Vertica(DBaaS) List page.
Click the resource for which you want to add storage on the Vertica(DBaaS) List page. You will be moved to the Vertica(DBaaS) Details page.
Click Add Disk button at the bottom of detailed information. Request Additional Storage popup window opens.
Enter purpose and capacity in the Request Additional Storage popup window, and click Confirm button.

Expand Storage

You can expand storage added as data area up to 5TB based on initially allocated capacity. You can expand storage without stopping Vertica(DBaaS), and if configured as a cluster, all nodes are expanded simultaneously.

Follow the procedure below to expand storage capacity.

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Vertica(DBaaS) menu on the Service Home page. You will be moved to the Vertica(DBaaS) List page.
Click the resource for which you want to change server type on the Vertica(DBaaS) List page. You will be moved to the Vertica(DBaaS) Details page.
Click Modify button of the additional Disk you want to expand at the bottom of detailed information. Modify Additional Storage popup window opens.
Enter expansion capacity in the Modify Additional Storage popup window, and click Confirm button.

Change Recovery DB Instance Type

After DB recovery is completed, you can change the instance type in the Recovery detailed information screen.

Follow the procedure below to change the Recovery DB instance type.

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Vertica(DBaaS) menu on the Service Home page. You will be moved to the Vertica(DBaaS) List page.
Click the resource for which you want to change Recovery DB instance type on the Vertica(DBaaS) List page. You will be moved to the Vertica(DBaaS) Details page.
Click Change Instance Type button. Change Instance Type confirmation dialog is displayed.

DB instance type is changed from Recovery to Active to perform the same function as a single DB.

Terminate Vertica(DBaaS)

You can reduce operating costs by terminating unused Vertica(DBaaS). However, if you terminate the service, the running service may stop immediately, so you should fully consider the impact of service interruption before proceeding with termination work.

Follow the procedure below to terminate Vertica(DBaaS).

Click All Services > Data Analytics > Vertica(DBaaS) menu. You will be moved to the Service Home page of Vertica(DBaaS).
Click Vertica(DBaaS) menu on the Service Home page. You will be moved to the Vertica(DBaaS) List page.
Select the resource to terminate on the Vertica(DBaaS) List page, and click Terminate Service button.
When termination is completed, check if the resource is terminated on the Vertica(DBaaS) list page.

1 - 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.

All Services > Data Analytics > Vertica(DBaaS) Click the menu. Navigate to the Service Home page of Vertica(DBaaS).
Click the Vertica(DBaaS) menu on the Service Home page. Navigate to the Vertica(DBaaS) List page.
Click the resource to set backup on the Vertica(DBaaS) List page. You will be taken to the Vertica(DBaaS) Details page.
Click the Edit button of the backup item. Backup Settings popup window opens.
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.

All Services > Data Analytics > Vertica(DBaaS) Click the menu. Go to the Service Home page of Vertica(DBaaS).
Click the Vertica(DBaaS) menu on the Service Home page. Navigate to the Vertica(DBaaS) list page.
Click the resource to view the backup history on the Vertica(DBaaS) List page. Go to the Vertica(DBaaS) Details page.
Click the Backup History button. Backup History popup opens.
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.

All Services > Data Analytics > Vertica(DBaaS) Click the menu. Navigate to the Service Home page of Vertica(DBaaS).
Service Home page, click the Vertica(DBaaS) menu. Go to the Vertica(DBaaS) list page.
Vertica(DBaaS) List On the page, click the resource to view the backup history. Vertica(DBaaS) Details You will be taken to the page.
Click the Backup History button. The Backup History popup window opens.
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.

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

All Services > Data Analytics > Vertica(DBaaS) Click the menu. Navigate to the Service Home page of Vertica(DBaaS).
Click the Vertica(DBaaS) menu on the Service Home page. Go to the Vertica(DBaaS) List page.
Vertica(DBaaS) Resource On the list page, click the resource you want to recover. You will be taken to the Vertica(DBaaS) Detail page.
Click the Database Recovery button. Go to the Database(DBaaS) Recovery page.

Database Recovery area, after entering the relevant information, click the Complete button.

Category	Required or not	Detailed description
Recovery Type	Required	Set 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 Prefix	Required	Recovery 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 Name	Required	Recovery DB Cluster Name Enter using English, 3 to 20 characters A cluster is a unit that groups multiple servers
Number of nodes	Select	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	Select	Status 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 For details, refer to Planned Compute Apply
Service Type > Block Storage	Required	Block 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 Type	Required	Management 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 Storage	Required	Block Storage settings used by Management Console Select Use and then select Base 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	Select	Service 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 period	Select	DB 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 Key	Required	Enter the Vertica License Key to recover If the entered license key is not valid, service creation is not possible
Tag	Select	Add Tag Add Tag button click after entering or selecting Key, Value values

Table. Vertica(DBaaS) Recovery Configuration Items