Database

• 1: EPAS(DBaaS)
• 1.1: Overview
• 1.1.1: Server Type
• 1.1.2: Monitoring Metrics
• 1.2: How-to guides
• 1.2.1: EPAS(DBaaS) server connection
• 1.2.2: Managing DB Service
• 1.2.3: DB Backup and Recovery
• 1.2.4: Configuring Read Replica
• 1.2.5: Extension use
• 1.3: API Reference
• 1.4: CLI Reference
• 1.5: Release Note
• 2: PostgreSQL(DBaaS)
• 2.1: Overview
• 2.1.1: Server Type
• 2.1.2: Monitoring Metrics
• 2.2: How-to guides
• 2.2.1: Managing DB Services
• 2.2.2: DB Backup and Recovery
• 2.2.3: Read Replica Setup
• 2.2.4: Connect to DB Server
• 2.2.5: Using Extensions
• 2.3: API Reference
• 2.4: CLI Reference
• 2.5: Release Note
• 3: MariaDB(DBaaS)
• 3.1: Overview
• 3.1.1: Server Type
• 3.1.2: Monitoring Metrics
• 3.2: How-to guides
• 3.2.1: MariaDB(DBaaS) server connection
• 3.2.2: Managing DB Services
• 3.2.3: DB Backup and Recovery
• 3.2.4: Configuring Read Replica
• 3.3: API Reference
• 3.4: CLI Reference
• 3.5: Release Note
• 4: MySQL(DBaaS)
• 4.1: Overview
• 4.1.1: Server Type
• 4.1.2: Monitoring Metrics
• 4.2: How-to guides
• 4.2.1: MySQL(DBaaS) server connection
• 4.2.2: Managing DB Services
• 4.2.3: DB Backup and Recovery
• 4.2.4: Setting up Read Replica
• 4.3: API Reference
• 4.4: CLI Reference
• 4.5: Release Note
• 5: Microsoft SQL Server(DBaaS)
• 5.1: Overview
• 5.1.1: Server Type
• 5.1.2: Monitoring Metrics
• 5.2: How-to guides
• 5.2.1: Managing DB Services
• 5.2.2: DB Backup and Recovery
• 5.2.3: Add Secondary
• 5.2.4: Microsoft SQL Server(DBaaS) server connection
• 5.3: API Reference
• 5.4: CLI Reference
• 5.5: Release Note
• 6: CacheStore(DBaaS)
• 6.1: Overview
• 6.1.1: Server Type
• 6.1.2: Monitoring Metrics
• 6.2: How-to guides
• 6.2.1: Managing CacheStore Service
• 6.2.2: CacheStore Backup and Recovery
• 6.2.3: CacheStore(DBaaS) server connection
• 6.3: API Reference
• 6.4: CLI Reference
• 6.5: Release Note

1 - EPAS(DBaaS)

1.1 - Overview

Service Overview

EPAS (DBaaS) is a relational database management system (RDBMS) with high compatibility with Oracle databases. Samsung Cloud Platform provides an environment that can automate EPAS installation and perform management functions for operation through a web-based console.

EPAS(DBaaS) is designed as a high-availability architecture that performs storage-based data replication and minimizes failover time. To prevent data loss, when the content of the Active server changes, it is synchronously replicated to the Standby server, and up to five read-only servers called Replicas are provided for read load balancing and disaster recovery (DR). Additionally, to prepare for issues with the DB server or data, it offers an automatic backup function at user-specified times, supporting data recovery at the desired point in time.

Provided Features

EPAS(DBaaS) provides the following functions.

• Auto Provisioning (Auto Provisioning): Installation and configuration of Database (DB) is possible via UI, and provides an Active-standby redundancy configuration built on storage replication. In case of an Active server failure, automatic failover to Standby occurs.
• Operation Control Management: Provides a function to control the status of running servers. In addition to start and stop, restart is possible if there is an issue with the DB or to apply configuration values. In case of high availability (HA) configuration, the user can directly perform node switching of Active-Standby via Switch-over.
• Backup and Recovery: Provides data backup functionality based on its own backup command. Backup time slots and storage agencies can be set by the user, and additional fees are incurred depending on backup volume. It also provides a recovery function for backed‑up data, and when the user performs a recovery, a separate DB is created and recovery proceeds to the point in time selected by the user (backup save point, user‑specified point). If recovery is set to a user‑specified point, the recovery point can be set to 5 minutes/10 minutes/30 minutes/1 hour before based on the stored backup file and archive file.
• Version Management: Provides version upgrade (Minor) functionality according to some feature improvements and security patches. Whether to perform a backup for the version upgrade can be selected by the user, and if a backup is performed, data is backed up before applying the patch, then the DB engine is updated.
• Replica configuration: You can add up to 5 read-only Read Replicas, enabling read performance scaling and load balancing.
• Audit setting: Provides an Audit setting feature that can monitor the user’s DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) execution.
• Parameter management: Performance improvement and security-related DB configuration parameter modifications are possible.
• Service status query: Retrieve the final status of the current DB service.
• Monitoring: CPU, memory, DB performance monitoring information can be checked through the Cloud Monitoring service.
• DB User Management: Query and manage DB account (user) information registered in the DB.
• DB Access Control Management: Based on DB accounts registered in the DB, you can register and revoke allowed IPs for access.
• Archive Management: You can set the archive file retention period (1 day~35 days) within the DB server and configure the archive mode (On/Off).
• DB Log Export: Through Audit settings, saved logs can be exported to the user’s Object Storage.
• Migration: Synchronize data in real-time with the operating database, and support migration using the Replication method without service interruption.

Components

EPAS (DBaaS) provides pre-validated engine versions and various server types. Users can select and use them according to the scale of the service they want to configure.

Engine Version

The engine versions supported by EPAS (DBaaS) are as follows.

Technical support can be used until the supplier’s EoTS (End of Technical Service) date, and the EOS date when new creation is stopped is set to six months before the EoTS date.

According to the supplier’s policy, the EOS and EoTS dates may change, so please refer to the supplier’s license management policy page for details.

• EPAS: https://www.enterprisedb.com/resources/platform-compatibility

Server Type

The server types supported by EPAS (DBaaS) are as follows.

For detailed information about the server types provided by EPAS(DBaaS), please refer to EPAS(DBaaS) server type.

Standard db1v2m4

Preceding Service

This is a list of services that must be pre-configured before creating the service. For details, please refer to the guide provided for each service and prepare in advance.

1.1.1 - Server Type

EPAS(DBaaS) Server Type

EPAS(DBaaS) provides server types with various combinations of CPU, Memory, Network Bandwidth, and more. When creating an EPAS(DBaaS), the Database Engine is installed according to the selected server type based on the intended use.

The server types supported by EPAS(DBaaS) are as follows:

Standard db1v2m4

db1 Server Type

The db1 server type of EPAS(DBaaS) is provided with standard specifications (vCPU, Memory) and is suitable for various database workloads.

• Up to 3.3Ghz Intel 3rd generation (Ice Lake) Xeon Gold 6342 Processor
• Supports up to 16 vCPUs and 256 GB of memory
• Up to 12.5 Gbps networking speed

dbh2 Server Type

The dbh2 server type of EPAS(DBaaS) is provided with high-capacity server specifications and is suitable for large-scale data processing database workloads.

• Up to 3.2GHz Intel 4th generation (Sapphire Rapids) Xeon Gold 6448H Processor
• Supports up to 128 vCPUs and 1,536 GB of memory
• Up to 25Gbps networking speed

1.1.2 - Monitoring Metrics

EPAS(DBaaS) Monitoring Metrics

The table below shows the performance monitoring metrics of EPAS (DBaaS) that can be checked through Cloud Monitoring. For detailed usage of Cloud Monitoring, refer to the Cloud Monitoring guide.

EPAS(DBaaS) server monitoring metrics refer to the Virtual Server Monitoring Metrics guide.

1.2 - How-to guides

The user can enter the required information for EPAS (DBaaS) and select detailed options through the Samsung Cloud Platform Console to create the service.

Creating EPAS(DBaaS)

You can create and use the EPAS (DBaaS) service from the Samsung Cloud Platform Console.

To create EPAS (DBaaS), follow the steps below.

1. All Services > Database > EPAS(DBaaS) Click the menu. Navigate to the Service Home page of EPAS(DBaaS).
2. Service Home on the page click the EPAS(DBaaS) Creation button. Navigate to the EPAS(DBaaS) Creation page.
3. Create EPAS (DBaaS) page, enter the information required to create the service, and select detailed options.
   • Image and Version Selection Select the required information in the area.

     Category	Required	Detailed description
     Image version	Required	Provide version list of EPAS (DBaaS)

     Table. EPAS(DBaaS) Image and Version Selection Items
   • Service Information Input area, please enter or select the required information.

     Category	Required	Detailed description
     Server Name Prefix	Required	Server name where DB will be installed Start with an English lowercase letter, and use lowercase letters, numbers, and the special character (-) to input 3 to 13 characters Based on the server name, a postfix such as 001, 002 is attached to create the actual server name
     Cluster Name	Required	Cluster name of DB servers Enter using English letters, 3 ~ 20 characters A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type where DB will be installed Standard: Standard specifications commonly used High Capacity: Large-capacity server with 24 vCore or more For detailed information about the server types provided by EPAS (DBaaS), refer to EPAS(DBaaS) Server Type
     Service Type > Planned Compute	Select	Status of resources with Planned Compute set In Use: Number of resources with Planned Compute set that are currently in use Configured: Number of resources with Planned Compute set Coverage Preview: Amount applied by Planned Compute per resource Create Planned Compute Service: Go to the Planned Compute service application page For more details, refer to Apply for Planned Compute
     Service Type > Block Storage	Required	Block Storage settings used by DB according to purpose Base OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Select the storage type and then enter the capacity. (For details on each Block Storage type, refer to Create Block Storage) SSD: High‑performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volumes using Samsung Cloud Platform KMS (Key Management System) encryption keys The configured storage type is applied identically to additional storage Capacity must be entered as a multiple of 8 within the range 16–5,120 Since large sorts during SQL execution or monthly batch processes can cause service interruption, a separate TEMP storage must be allocated and used Add: DATA, Archive, TEMP, Backup data storage areas Select Use, then enter the storage purpose and capacity The storage type is applied the same as set for DATA, and capacity can be entered as a multiple of 8 within the range 16–5,120 Click the + button to add storage, and the x button to delete. Up to 9 can be added Backup data is temporarily stored in BACKUP storage before transmission If the data to be backed up exceeds 100 GB and changes frequently, it is recommended to add a separate BACKUP storage for reliable backup; set the backup capacity to about 60 % of the DATA capacity If no BACKUP storage is added, using the /tmp area is recommended For each service, only one Block Storage is allocated for Archive, TEMP, and BACKUP
     Redundancy Configuration	Select	Redundancy Configuration Status If redundancy configuration is used, the DB instance is configured as Active DB and Standby DB
     Network > Common Settings	Required	Network settings where servers generated by the service are installed Select if you want to apply the same settings to all servers being installed Select a pre‑created VPC, Subnet, IP, and Public NAT IP can only be auto‑generated The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If you check Use, you can select a reserved IP from the VPC product’s Public IP pool. For more information, see Create Public IP.
     Network > Server-specific Settings	Required	Network settings where servers generated by the service are installed Select if you want to apply different settings per installed server Select a pre-created VPC, Subnet, IP, Public NAT Enter each server’s IP The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If you check Use, you can select a reserved IP from the VPC product’s Public IP. For more details, see Create Public IP
     IP Access Control	Select	Service Access Policy Settings Since the access policy is set for the IP entered on the page, a separate Security Group policy setting is not required. 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 Use is selected, set the day of the 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 patches not being applied

     Table. EPAS (DBaaS) Service Information Input Items

• Database configuration required information input area, please input or select the required information.

  Category	Required	Detailed description
  Database name	Required	Server name applied when installing DB Start with an English letter, and use English letters and numbers, input 3 to 20 characters
  Database username	Required	DB user name An account with the same name is also created on the OS Enter using lowercase English letters, 2 ~ 20 characters Restricted Database usernames can be checked in the Console
  Database password	Required	Password to use when accessing the DB Enter 8-30 characters including letters, numbers, and special characters (“ ‘ excluded)
  Database Password verification	Required	Re-enter the same password to be used when accessing the DB
  Database Port number	Required	Port number required for DB connection Enter DB port within the range 1,024 ~ 65,535
  Backup > Use	Select	Whether to use backup Select Use to set backup file retention period, backup start time, and Archive backup cycle.
  Backup > Retention Period	Select	Backup Retention Period Select the backup retention period. File retention period can be set from 7 days to 35 days. Backup files incur additional charges based on size.
  Backup > Backup Start Period	Select	Backup Start Time Select backup start time The minutes (minutes) when the backup is performed are set randomly, and the backup end time cannot be set
  Backup > Archive backup frequency	Select	Archive backup frequency Select the Archive backup frequency Archive backup frequency is recommended at 1 hour. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance.
  Audit Log Settings	Select	Whether to store Audit Log Select Use to configure the Audit Log feature DDL, DML, SELECT, and user connection information records are stored Users can specify the types of SQL statements to audit via the edb_audit_statement parameter, and can modify it through the Parameter screen Refer to the EDB documentation for details on this parameter Enabling Audit may degrade DB performance
  Parameter	Required	DB configuration parameters View button click to view detailed information of the parameter Parameters can be modified after the service creation is completed, and after modification, the DB must be restarted
  Database Encoding	Required	Character encoding method to be used for the DB Character set used when storing text data The DB is created with the selected encoding as the default setting
  DB Locale	Required	Locale to use for the DB Settings related to string processing, number/currency/date/time display formats, etc. The DB is created with the selected Locale as the default setting
  Time zone	Required	Standard time zone to be used by the Database
  License	Required	Check EPAS License As a verification item for license usage, you cannot proceed to the next step unless you click confirm.

  Table. EPAS(DBaaS) Database configuration items
  • Enter additional information area, please input or select the required information.

    Category	Required or not	Detailed description
    Tag	Select	Add Tag Up to 50 can be added per resource After clicking the Add Tag button, enter or select Key, Value values

    Table. EPAS (DBaaS) Additional Information Input Items

4. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.
   • Once creation is complete, check the created resource on the Resource List page.

EPAS(DBaaS) Check detailed information

EPAS(DBaaS) service can view and edit the full resource list and detailed information. EPAS(DBaaS) Detail page consists of Detail Information, Tag, Operation History tabs, and for a DB with a Replica configured, a Replica Information tab is additionally provided.

To view detailed information about the EPAS (DBaaS) service, follow the steps below.

1. All Services > Database > EPAS(DBaaS) Click the menu. Navigate to the Service Home page of EPAS(DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. You will be taken to the EPAS(DBaaS) List page.
3. Click the resource to view detailed information on the EPAS(DBaaS) List page. Move to the EPAS(DBaaS) Details page.
   • EPAS(DBaaS) Details At the top of the page, status information and information about additional features are displayed.

     Category	Detailed description
     Cluster Status	Cluster status with DB installed Creating: Creating cluster Editing: Cluster is changing to operation execution state Error: Cluster error occurred during operation execution If it occurs continuously, contact the administrator Failed: Cluster failed during creation process Restarting: Restarting cluster Running: Cluster is operating normally Starting: Starting cluster Stopped: Cluster is stopped Stopping: Cluster is in stopping state Synchronizing: Synchronizing cluster Terminating: Terminating cluster Unknown: Unknown cluster status If it occurs continuously, contact the administrator Upgrading: Cluster is changing to upgrade execution state
     Cluster Control	Buttons to change the cluster state Start: Start a stopped cluster Stop: Stop a running cluster Restart: Restart a running cluster Switch-Over: Switch a standby cluster to active
     More features	Cluster related management buttons Service status synchronization: Real-time DB service status lookup Backup history: If backup is set, check whether backup runs normally and view history Database recovery: Recover DB based on a specific point in time Parameter management: View and modify DB configuration parameters Replica configuration: Set up a read-only cluster as a Replica DB user management: View and manage DB account (user) information registered in the DB DB access control management: Register and revoke allowed IPs based on DB accounts registered in the DB Archive management: Set archive file retention period and archive mode Export DB Log: Through Audit settings, export stored logs to user’s Object Storage Migration configuration: Provide Migration function using Replication method
     Service termination	Button to cancel the service

     Table. EPAS (DBaaS) status information and additional features

Detailed Information

EPAS(DBaaS) List page allows you to view detailed information of the selected resource and, if necessary, edit the information.

Replica Information

Replica information tab is enabled only when a Replica is configured in the cluster. Through the Replica information tab, you can check the master cluster name, replica count, and Replica status.

Tag

EPAS(DBaaS) List page allows you to view the tag information of the selected resource, and you can add, modify, or delete it.

Work History

On the EPAS(DBaaS) List page, you can view the operation history of the selected resource.

EPAS(DBaaS) Manage Resources

If you need to change or restore the existing configuration options of a created EPAS (DBaaS) resource, or require a Replica configuration, you can perform the work on the EPAS (DBaaS) Details page.

Operating Control

If changes occur to the running EPAS (DBaaS) resources, you can start, stop, or restart them. Also, if HA is configured, you can switch the Active-Standby servers via Switch-over.

To control the operation of EPAS (DBaaS), follow the steps below.

1. All Services > Database > EPAS(DBaaS) Click the menu. Navigate to the Service Home page of EPAS(DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. Navigate to the EPAS(DBaaS) List page.
3. Click the resource to control operation on the EPAS(DBaaS) List page. It moves to the EPAS(DBaaS) Detail page.
4. Check the EPAS (DBaaS) status and complete the change using the control button below.
   • Start: The server where the DB service is installed and the DB service is running.
   • Stop: The server where the DB service is installed and the DB service are stopped.
   • Restart: Only the DB service will be restarted.
   • Switch Over: You can switch the DB’s Active server and Standby server.

Synchronize Service Status

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

To check the service status of EPAS (DBaaS), follow the steps below.

1. All Services > Database > EPAS(DBaaS) Click the menu. Navigate to the Service Home page of EPAS(DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. You will be taken to the EPAS(DBaaS) List page.
3. Click the resource to view the service status on the EPAS(DBaaS) List page. It will navigate to the EPAS(DBaaS) Details page.
4. Service Status Synchronization Click the button. While it is being queried, the cluster will change to Synchronizing state.
5. When the query is completed, the status in the server information item is updated, and the cluster changes to Running state.

Change Server Type

You can change the configured server type.

To change the server type, follow the steps below.

1. All Services > Database > EPAS(DBaaS) Click the menu. Navigate to the Service Home page of EPAS(DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. Go to the EPAS(DBaaS) List page.
3. Click the resource to change the server type on the EPAS (DBaaS) List page. It will navigate to the EPAS (DBaaS) Details page.
4. Click the Edit icon of the server type you want to change at the bottom of the detailed information. The Edit Server Type popup window will open.
5. Server Type Edit In the popup window, after selecting the server type, click the Confirm button.

Add storage

If more than 5 TB of data storage space is required, additional storage can be added. In the case of a redundant DB configuration, both redundant servers are added simultaneously.

To add storage, follow these steps.

1. All Services > Database > EPAS(DBaaS) Click the menu. Navigate to the Service Home page of EPAS(DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. You will be taken to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) List Click the resource to add storage on the page. EPAS(DBaaS) Details Navigate to the page.
4. Click the Add Disk button at the bottom of the detailed information. The Request Additional Storage popup window opens.
5. Additional Storage Request In the popup window, after entering the purpose and capacity, click the Confirm button.

Expanding Storage

You can expand the storage added to the data area up to a maximum of 5 TB based on the initially allocated capacity. In the case of a redundant DB configuration, all redundant servers are expanded simultaneously.

To increase storage capacity, follow the steps below.

1. All Services > Database > EPAS(DBaaS) Click the menu. Navigate to the Service Home page of EPAS(DBaaS).
2. Service Home page, click the EPAS(DBaaS) menu. Navigate to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) 목록 Click the resource to change the server type on the page. EPAS(DBaaS) 상세 Navigate to the page.
4. Click the Edit icon of the additional Disk you want to add at the bottom of the detailed information. The Edit Additional Storage popup window opens.
5. Add Storage Modification After entering the expansion capacity in the popup window, click the Confirm button.

EPAS(DBaaS) Cancel

You can cancel unused EPAS (DBaaS) to reduce operating costs. However, if you cancel the service, the service currently in operation may be stopped immediately, so you should proceed with the cancellation after fully considering the impact that may occur when the service is discontinued.

To cancel EPAS (DBaaS), follow the steps below.

1. Click the All Services > Database > EPAS(DBaaS) menu. Go to the Service Home page of EPAS(DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. You will be taken to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) list on the page, select the resource to cancel, and click the Cancel Service button.
4. Once the termination is complete, check whether the resource has been terminated on the EPAS(DBaaS) list page.

1.2.1 - EPAS(DBaaS) server connection

Scenario Overview

The EPAS(DBaaS) server connection scenario is a scenario where a Bastion host (Virtual Server) and Database service are created to access the DB service through the Bastion host. To securely access EPAS(DBaaS) in the Samsung Cloud Platform environment, it is necessary to create a Bastion host and use it for network connection. To maintain a stable and high level of security, it is recommended to configure the Database service in a Private Subnet environment and configure the Bastion host in a limited Public Subnet environment.

This scenario largely describes the process of creating a Bastion host and Database service, configuring the network environment for Bastion host and Database connection, and accessing it through a DB connection client.

Scenario Components

You can configure the scenario using the following services.

Scenario composition method

To configure the scenario, create the necessary services through the following procedure.

1. Configuring the Network

This describes the process of configuring the network environment for Bastion Host and Database service connection.

1-1. Creating a VPC

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. On the Service Home page, click the Create VPC button. It moves to the Create VPC page.
3. VPC Creation page, please enter the information required for service creation.
   • IP range should be entered as 192.168.x.0/16.
4. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • After creation is complete, check the created resource on the VPC list page.

1-2. Creating a Subnet

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Subnet menu. It moves to the Subnet list page.
3. Click the Subnet Creation button. It moves to the Subnet Creation page.
4. Subnet creation page where you enter the information needed to create a service.
   • Subnet type should be selected as General.
   • Please select a pre-created VPC.
   • IP range should be entered as 192.168.x.0/24.
5. In the Summary panel, review the detailed information and estimated charge, then click the Complete button.
   • After creation is complete, check the created resource in the Subnet list page.

1-3. Creating an Internet Gateway

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Internet Gateway menu. Move to the Internet Gateway list page.
3. Click the Create Internet Gateway button. It moves to the Create Internet Gateway page.
4. Internet Gateway creation page, please enter the required information necessary for service creation.
   • Please select a pre-created VPC.
   • Select use in the Firewall usage item.
5. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • After creation is complete, check the created resource on the Internet Gateway list page.

1-4. Creating a Public IP

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Public IP menu. It moves to the Public IP list page.
3. Public IP Reservation button, click. Move to the Public IP Reservation page.
4. Public IP Reservation page, enter the required information necessary for service reservation.
5. Summary panel, check the detailed information generated and the expected billing amount, and click the Complete button.
   • Once creation is complete, check the created resource on the Public IP List page.

1-5. Creating a Security Group

1. Click on the menu for all services > Networking > Security Group. It moves to the Service Home page of Security Group.
2. Click the Security Group Creation button on the Service Home page. It moves to the Security Group Creation page.
3. Security Group creation page where you enter the required information necessary for service creation.
4. Check the input information and click the Complete button.
   • Once creation is complete, check the created resource on the Security Group list page

2. Creating a Bastion Host

This explains the process of configuring the Bastion Host where the database connection client should be installed.

2-1. Creating a Server Keypair

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Click the Keypair menu on the Service Home page. It moves to the Keypair list page.
3. Create Keypair button should be clicked. It moves to the Create Keypair page.
4. Keypair creation page, please enter the required information necessary for service creation.
5. Check the creation information and click the Complete button.
   • The key can only be downloaded for the first time, and re-issuance is not provided.
   • Please keep the downloaded key in a safe place.

2-2. Creating a Bastion Host

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Click the Virtual Server Creation button on the Service Home page. It moves to the Virtual Server Creation page.
3. Virtual Server Creation page, please enter the required information necessary for service creation.
   • The image is Windows, please select.
   • Please select the pre-created VPC and Subnet.
   • Click NAT Use and select the Public IP reserved in 1-4. Creating Public IP.
   • 2-1. Creating a server Keypair Connect the Keypair created from
4. Summary panel, check the detailed information generated and the expected billing amount, and click the Complete button.
   • After creation is complete, check the created resource on the Virtual Server list page.

2-3. Check Bastion host connection ID and PW

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Service Home page, click the Virtual Server menu. Move to the Virtual Server list page.
3. Virtual Serve list page, click on the resource created in 2-2. Bastion host creation. It moves to the detailed information page of the corresponding resource.
4. Click the RDP password inquiry button in the Keypair item on the detailed information page. The RDP password inquiry popup window will open.
5. RDP password inquiry popup window, attach the keypair file downloaded from 2-1. Creating a server keypair.
6. After attaching, click the Password Check button. The ID and password required to access the resource will be displayed.
   • The ID and Password will be used as information to connect to the Bastion host later, as described in 5-1. Connect to Bastion host.

3. Creating a Database

Describes the process of creating a Database service.

3-1. Creating EPAS(DBaaS) Service

1. Click on the menu for all services > Database > EPAS(DBaaS). It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) creation button. It moves to the EPAS(DBaaS) creation page.
3. EPAS(DBaaS) creation page, please enter the required information necessary for service creation.
   • Select and connect the pre-created VPC and Subnet.
   • Enter Database related creation information on the required information input screen.
   • Add the Bastion host IP to the IP access control items.
   • Database Port is 2866 by default, but you can specify it as you want.
4. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • Once the creation is complete, check the created resource on the EPAS(DBaaS) list page.

4. Setting Rules

This describes the process of setting rules for users to access the Bastion host and rules for the Bastion host to access the Database.

4-1. Adding Security Group Security Rules

1. Click All services > Networking > Security Group menu. It moves to the Service Home page of Security Group.
2. Service Home page, click the Security Group menu. It moves to the Security Group list page.
3. 1-5. Creating a Security Group Select the Security Group resource created from. It will move to the detailed information page of the corresponding resource.
4. Click the Rules tab on the detailed information page. It moves to the Rules tab.
5. Click the Rule tab and click the Add Rule button. It moves to the Add Rule popup window.
6. Add Rule popup window, enter the rules below, and click the OK button

4-2. Adding IGW Firewall Rules

1. Click All services > Networking > Firewall menu. It moves to the Service Home page of Firewall.
2. Service Home page, click the Firewall menu. It moves to the Firewall list page.
3. Firewall list page, select the Internet Gateway resource name created in 1-3. Creating Internet Gateway, and move to the detailed information page of the corresponding resource.
4. Click the Rules tab on the detailed information page. It moves to the Rules tab.
5. Click the Rule tab and click the Add Rule button. It moves to the Add Rule popup window.
6. Add Rule popup window, enter the rules below, and click the OK button.

5. Connect to Database

This explains the process of a user accessing the Database through a DB connection client program.

This guide provides instructions on how to connect using pgAdmin. There are various database client programs and CLI utilities, so you can install and use the tools that suit you.

5-1. Connecting to the Bastion host

1. Run Remote Desktop Connection in the Windows environment of the PC you want to connect to the Bastion host, enter the NAT IP of the Bastion Host, and click the Connect button.
2. After a successful remote desktop connection, the user credential input window opens. Enter the ID and Password confirmed in 2-3. Checking Bastion host access ID and PW and click the Confirm button.

5-2. Installing DB connection client program (pgAdmin) on the Bastion host

1. Go to the official pgAdmin page and download the pgAdmin program.
   • pgAdmin program download path: https://www.pgadmin.org/download/
2. Connect the hard drive of the user PC to upload the file to the Bastion host.
3. Click the Details button for local devices and resources entries in the Local Resources tab of Remote Desktop Connection.
4. Select the local disk where the file was downloaded to the drive and click the Confirm button.
5. Copy the downloaded file and upload it to the Bastion Host, then click the pgAdmin installation file to install it.

5-3. Using DB connection client program (pgAdmin) to connect to the database

1. Run pgAdmin and click the Add New Server button.
2. In the Register - Server popup window, enter the Database server information created in 3-1. Creating EPAS(DBaaS) service in the General tab and Connection tab, and click the Save button.

   Screen (Tab)	Required Input Element Items	Input Value
   General	Name	Custom (ex. Service Name)
   Connection	Host name/address	Database server IP
   Connection	Port	Database Port
   Connection	Maintenance database	Database name
   Connection	Password	Database password

   DB Connection Client Program Input Items
3. Click the database name created on pgAdmin to connect.
   • You can try simple queries after connecting.

1.2.2 - Managing DB Service

The user can manage EPAS(DBaaS) through the Samsung Cloud Platform Console.

Managing Parameters

It provides a function to easily query and modify database configuration parameters.

Parameter Inquiry

To view the configuration parameters, follow these steps.

1. Click All Services > Database > EPAS(DBaaS) menu. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. EPAS(DBaaS) List page, click the resource you want to query and modify parameters. It moves to the EPAS(DBaaS) Details page.
4. Click the More button and click the Parameter Management button. The Parameter Management popup window opens.
5. In the Parameter Management popup window, click the Inquiry button. The Inquiry Notification popup window opens.
6. When the query notification pop-up window opens, click the OK button. It may take a little time to query.

Modifying Parameters

To modify the configuration parameters, follow these steps.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource you want to query and modify parameters. It moves to the EPAS(DBaaS) detail page.
4. Click the More button and click the Parameter Management button. The Parameter Management popup window opens.
5. In the Parameter Management popup window, click the Search button. The Search Notification popup window opens.
6. When the query notification popup window opens, click the OK button. It may take some time to query.
7. If modification is needed, click the Modify button and enter the modification details in the customized value area of the parameter to be modified.
8. When the input is complete, click the Save button.

Manage DB users

It provides management functions that can query DB user information and change status information.

Querying DB Users

To query DB users, follow the following procedure.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. Click on the resource you want to query the DB user on the EPAS(DBaaS) list page. It moves to the EPAS(DBaaS) details page.
4. Click the More button and click the DB User Management button. It moves to the DB User Management page.
5. On the DB User Management page, click the Search button. It may take some time to retrieve the results.

Change DB User Status

To change the status of the retrieved DB user, follow the next procedure.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource you want to modify the DB user. It moves to the EPAS(DBaaS) detail page.
4. Click the More button and click the DB User Management button. It moves to the DB User Management page.
5. On the DB User Management page, click the Search button. It may take some time to retrieve the results.
6. If modification is needed, click the Modify button and enter the status area value change or note contents.
7. When the input is complete, click the Save button.

DB Access Control Management

It provides IP-based DB user access control management function. Users can directly specify the IP that can access the database, so that only allowed IPs can access.

Checking DB Access Control

To view DB users with IP access control set, follow the next procedure.

1. All services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource for which you want to manage access control. It moves to the EPAS(DBaaS) details page.
4. Click the More button and click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. DB Access Control Management page, click the Search button. It takes a little time to search.

Add DB Access Control

To add IP access control, follow the next procedure.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource for which you want to add IP access control. It moves to the EPAS(DBaaS) details page.
4. Click the More button and click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. DB Access Control Management page, click the Search button. It takes a little time to search.
6. When the inquiry is complete, click the Add button. The Add DB Access Control popup window will open.
7. Add DB Access Control popup window, select DB username and enter IP Address.
8. When the input is complete, click the Save button.

Delete DB Access Control

To delete IP access control, follow these steps.

1. All services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource for which you want to delete IP access control. It moves to the EPAS(DBaaS) details page.
4. Click the More button and click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. DB Access Control Management page, click the Inquiry button. It takes a little time to inquire.
6. When the inquiry is complete, click the Delete button. The Delete popup window will open.
7. Delete popup window, click the OK button.

Managing Archives

It provides archive mode setting and archive log storage period setting functions, allowing users to flexibly set archive log management policies according to their operating environment. Additionally, it provides a function to manually delete Archive logs, allowing you to clean up unnecessary log data and effectively manage system resources.

Setting Archive Mode

To set the archive mode, follow the next procedure.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource for which you want to set the Archive mode. It moves to the EPAS(DBaaS) detail page.
4. Click the More button and click the Archive Settings Management button. It moves to the Archive Settings Management page.
5. Archive settings management page, click the Inquiry button. It takes a little time to inquire.
6. Click the Modify button and select whether to use it and the storage period.
7. When the modification is complete, click the Save button.

Delete Archive Files

To delete an Archive file, follow these steps.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource for which you want to set the Archive mode. It moves to the EPAS(DBaaS) details page.
4. Click the More button and click the Archive Settings Management button. It moves to the Archive Settings Management page.
5. Archive settings management page, if you want to delete all Archive files, click the Delete all Archives, if you want to delete only the backed up Archive files, click the Delete backed up Archives button.

DB Log export

It supports exporting log data that requires long-term storage in the 감사(Audit) log to Object Storage. Users can directly set the type of log to be stored, the destination bucket to be exported, and the cycle of exporting logs. It copies and stores logs to the specified Object Storage according to the set criteria. Additionally, to efficiently manage disk space, it provides an option to automatically delete the original log files while exporting logs to Object Storage at the same time. By utilizing this option, you can effectively secure the storage capacity while safely storing the necessary log data for a long time.

Set DB Log Export Mode

To set the DB log export mode, follow the following procedure.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. EPAS(DBaaS) list page, click on the resource you want to export DB Log. It moves to the EPAS(DBaaS) details page.
4. Click the More button and click the Export DB Log button. It moves to the Export DB Log page.
5. On the DB Log Export page, click the Register button. It moves to the DB Log Export Registration page.
6. On the DB Log Export Registration page, enter the corresponding information and click the Save button.

Managing DB Log Export

To modify, cancel, or immediately export the DB log export settings, follow these steps.

1. Click All Services > Database > EPAS(DBaaS) menu. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource you want to manage DB log export. It moves to the EPAS(DBaaS) detail page.
4. Click the More button and click the Export DB Log button. It moves to the Export DB Log page.
5. On the DB Log Export page, click the More button according to the type of log you want to manage, and then click the Export Now, Modify, or Cancel button.
   • Immediate Export: The selected log is exported to the existing Object Storage’s Bucket.
   • Modify: Modifies the DB log export mode setting.

• Cancel: Cancels the DB log export mode setting.

Minor Version Upgrade

It provides a version upgrade feature due to some functional improvements and security patches. Only minor version upgrade is supported within the same major version.

To perform a Minor Version upgrade, follow the procedure below.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. Click on the resource to be upgraded on the EPAS(DBaaS) list page. It moves to the EPAS(DBaaS) details page.
4. Click the Edit button in the Image/Version item. The Version Upgrade popup window opens.
5. In the 버전 업그레이드 popup window, select the modified version and whether to back up the settings, then click the 확인 button.
6. In the Version Upgrade Notification popup window, click the OK button.

Configuring Migration

It provides a migration function that synchronizes with the operating database in real-time and replicates in a replication manner without interrupting the service.

To configure the migration, follow the next procedure.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. Click on the resource to be migrated on the EPAS(DBaaS) list page. It moves to the EPAS(DBaaS) details page.
4. Click the More button and click the Migration Settings button. The Migration Settings popup window opens.
5. Check the instructions in the Migration Configuration popup window and click the OK button. It moves to the Migration Configuration page.
6. On the Migration Configuration page, enter the information and click the Check Connection button.
7. Once the connection is complete, click the Complete button.

Migrating Cluster to Master Cluster

You can promote a fully configured Migration Cluster to a Master Cluster.

To promote the Migration Cluster to Master, follow these steps.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. On the EPAS(DBaaS) list page, click the resource to be promoted to Master. It moves to the EPAS(DBaaS) detail page.
4. Click the More button and click the Master Promotion button. The Master Promotion Notification popup window opens.
5. In the Master Promotion Alert popup window, click the Confirm button.

1.2.3 - DB Backup and Recovery

The user can set up the backup of EPAS(DBaaS) through the Samsung Cloud Platform Console and restore it with the backed-up file.

EPAS(DBaaS) Backup

To ensure that the user’s data is safely stored, EPAS(DBaaS) provides a data backup function based on its own backup command, and also provides a backup history function to check if the backup was done normally, and can also delete the backed-up files.

Setting up backup

The method of setting up a backup for EPAS(DBaaS) is described in EPAS(DBaaS) creation guide.

To modify the backup settings of the generated resource, follow these steps.

To set up a backup, follow these steps.

1. All Services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. EPAS(DBaaS) list page, click the resource to set the backup. Move to the EPAS(DBaaS) details page.
4. Click the Edit button of the backup item. The Backup Settings popup window opens.
5. If you set up a backup, click Use in the Backup Settings popup window, select the retention period, backup start time, and Archive backup cycle, and then click the OK button.
   • If you want to stop the backup settings, uncheck Backup Settings in the popup window and click the OK button.

Check Backup History

To view the backup history, follow these steps.

1. All services > Database > EPAS(DBaaS) menu is clicked. It moves to the Service Home page of EPAS(DBaaS).
2. Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. EPAS(DBaaS) list page, click the resource to check the backup history. It moves to the EPAS(DBaaS) detail page.
4. Click the Backup History button. The Backup History popup window opens.
5. Backup History popup window where you can check the backup status, version, backup start time, backup completion time, and capacity.

Deleting Backup Files

To delete the backup history, follow these steps.

1. Click All Services > Database > EPAS(DBaaS) menu. It moves to the Service Home page of EPAS(DBaaS).
2. Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. EPAS(DBaaS) list page, click the resource to check the backup history. It moves to the EPAS(DBaaS) details page.
4. Click the Backup History button. The Backup History popup window opens.
5. Backup History popup window, check the file you want to delete, and then click the Delete button.

EPAS(DBaaS) Recovery

In the event of a failure or data loss that requires restoration from a backup file, recovery is possible based on a specific point in time through the recovery function. When performing EPAS (DBaaS) recovery, a new server is created with the OS image at the initial provisioning time, and the DB is installed with the version at the backup point, and the recovery proceeds with the DB configuration information and data.

To recover EPAS(DBaaS), follow these procedures.

1. Click All Services > Database > EPAS(DBaaS) menu. It moves to the Service Home page of EPAS(DBaaS).
2. Service Home page, click the EPAS(DBaaS) menu. It moves to the EPAS(DBaaS) list page.
3. EPAS(DBaaS) Resource list page, click the resource you want to restore. It moves to the EPAS(DBaaS) detail page.
4. Database Recovery 버튼을 클릭하세요. Database Recovery 페이지로 이동합니다.
5. Database Recovery Configuration area, enter the corresponding information, and then click the Complete button.

1.2.4 - Configuring Read Replica

Users can create a Read Replica by entering the required information through the Samsung Cloud Platform Console and configuring detailed options.

Configuring Replica

Replica configuration allows you to create a read-only replica server. You can create up to 5 replicas per database.

To configure a replica, follow these steps:

1. All Services > Database > EPAS(DBaaS) menu, click. Move to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. Move to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to configure the replica for. Move to the EPAS(DBaaS) Details page.
4. Click the Configure Replica button. Move to the Configure Replica page.
5. Enter the information in the Configure Replica section and click the Complete button.

Reconfiguring Replica

If a network failure or replication delay occurs between the master cluster, you can reconfigure the replica to re-replicate the master cluster’s data.

To reconfigure a replica, follow these steps:

1. All Services > Database > EPAS(DBaaS) menu, click. Move to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. Move to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to reconfigure the replica for. Move to the EPAS(DBaaS) Details page.
4. Click the Reconfigure Replica button. The Reconfigure Replica Notification popup window opens.
5. In the Reconfigure Replica Notification popup window, click the Confirm button.

Promoting Replica Cluster to Master

You can promote a configured replica cluster to a master cluster.

To promote a replica cluster to a master, follow these steps:

1. All Services > Database > EPAS(DBaaS) menu, click. Move to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. Move to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to promote to a master. Move to the EPAS(DBaaS) Details page.
4. Click the More button and then click the Promote to Master button. The Promote to Master Notification popup window opens.
5. In the Promote to Master Notification popup window, click the Confirm button.

1.2.5 - Extension use

EPAS(DBaaS) Extension usage

The list of Extensions that can be installed in the current database can be checked with the following SQL sentence.

SQL> select * from pg_available_extensions;

In EPAS(DBaaS), the items that are installed additionally, excluding the default Extensions included in each version, are as follows.

In addition to the above items, if additional Extension installation is required, please refer to Support Center > Inquiry for inquiries.

• Once your inquiry is received, we will review and proceed with the installation. Please note that some Extensions may not work properly during Replica configuration and recovery.

1.3 - API Reference

1.4 - CLI Reference

1.5 - Release Note

EPAS(DBaaS)

2 - PostgreSQL(DBaaS)

2.1 - Overview

Service Overview

PostgreSQL (DBaaS) is an open source relational database management system (RDBMS). Samsung Cloud Platform provides an environment that can automate PostgreSQL installation through a web-based console and perform management functions for operation.

PostgreSQL (DBaaS) is designed as a high-availability architecture that performs storage-based data replication and minimizes failover time. To prevent data loss, when the content of the Active server changes, it is synchronously replicated to the Standby server, and up to five read‑only servers called Replicas are provided for read‑load balancing and disaster recovery (DR). Additionally, to prepare for issues with the DB server or data, it offers an automatic backup function at user‑specified times, enabling data recovery to a desired point in time.

Provided Features

PostgreSQL (DBaaS) provides the following features.

• Auto Provisioning (Auto Provisioning): It is possible to install and configure the Database (DB) via UI, and it provides an Active-standby redundancy configuration built on storage replication. In case of an Active server failure, it automatically fails over to Standby.
• Operation Control Management: Provides a function to control the status of running servers. In addition to start and stop, restart is possible if there is an issue with the DB or to apply configuration values. When configured for high availability (HA), the user can directly perform node switching between Active-Standby via Switch-over.
• Backup and Recovery: Provides a data backup function based on its own backup commands. The backup time window and storage organization can be set by the user, and additional fees are incurred based on backup size. It also provides a recovery function for backed-up data, so when the user performs a recovery, a separate DB is created and the recovery proceeds to the point in time selected by the user (backup save point, user-specified point). If the user restores to a specified point, the recovery point can be set to 5 minutes, 10 minutes, 30 minutes, or 1 hour before the stored backup file and archive file.
• Version Management: Provides version upgrade (Minor) functionality due to some feature improvements and security patches. Whether to perform a backup for the version upgrade can be selected by the user, and if a backup is performed, data is backed up before applying the patch, then the DB engine is updated.
• Replica configuration: For read load balancing and disaster recovery (DR), up to 5 Read Replicas can be configured in the same/different region.
• Audit Settings: Supports audit (Audit) functionality for major activities within the database.
• Parameter Management: Performance improvement and security-related DB configuration parameters can be modified.
• Service Status Query: Retrieve the final status of the current DB service.
• Monitoring: CPU, memory, DB performance monitoring information can be checked through the Cloud Monitoring service.
• DB User Management: Retrieve and manage DB account (user) information registered in the DB.
• DB Access Control Management: Based on DB accounts registered in the DB, you can register and revoke allowed IPs.
• Archive Management: You can set the retention period of Archive files (1 day~35 days) on the DB server and configure the Archive mode (On/Off).
• DB Log Export: You can export stored logs to the user’s Object Storage through Audit settings.
• Migration: Synchronize data in real time with the operating database, and support migration using the Replication method without service interruption.

Components

PostgreSQL (DBaaS) provides pre-validated engine versions and various server types according to the open source support policy. Users can select and use them according to the scale of the service they want to configure.

Engine Version

The engine versions supported by PostgreSQL (DBaaS) are as follows.

Technical support can be used until the supplier’s EoTS (End of Technical Service) date, and the EOS date when new creation is stopped is set to six months before the EoTS date.

Since the EOS and EoTS dates may change according to the supplier’s policy, please refer to the supplier’s license management policy page for details.

• PostgreSQL: https://www.postgresql.org/support/versioning/

Server Type

The server types supported by PostgreSQL (DBaaS) are as follows.

For detailed information about the server types provided by PostgreSQL(DBaaS), see PostgreSQL(DBaaS) server type.

Standard db1v2m4

  



Category
Example
Detailed description




Server Type
Standard
Provided Server Types
Standard: Standard specifications (vCPU, Memory) configuration commonly used
High Capacity: Large-capacity server specifications of 24 vCores or more


Server specifications
db1
Provided server specifications
db1: Standard specifications (vCPU, Memory) configuration commonly used
dbh2: Large-scale server specifications
Provides servers with 24 vCores or more


Server specifications
v2
Number of vCores
v2: 2 virtual cores


Server Specifications
m4
Memory Capacity
m4: 4GB Memory




  Table. PostgreSQL (DBaaS) server type components





# Preliminary Service

This is a list of services that must be pre-configured before creating the service. For details, please refer to the guide provided for each service and prepare in advance.<br>







  



Service Category
Service
Detailed Description




Networking
VPC
A service that provides an isolated virtual network in a cloud environment




  Table. PostgreSQL(DBaaS) Pre-service

2.1.1 - Server Type

PostgreSQL(DBaaS) server type

PostgreSQL(DBaaS) provides a server type composed of various combinations such as CPU, Memory, Network Bandwidth. When creating PostgreSQL(DBaaS), the Database Engine is installed according to the server type selected for the purpose of use.

The server types supported by PostgreSQL(DBaaS) are as follows.

Standard db1v2m4

db1 server type

The db1 server type of PostgreSQL(DBaaS) is provided with standard specifications(vCPU, Memory) and is suitable for various database workloads.

Up to 3.3Ghz Intel 3rd generation (Ice Lake) Xeon Gold 6342 Processor Supports up to 16 vCPUs and 256 GB of memory Up to 12.5 Gbps of networking speed

dbh2 server type

The dbh2 server type of PostgreSQL(DBaaS) is provided with large-capacity server specifications and is suitable for database workloads for large-scale data processing.

Up to 3.2GHz Intel 4th generation (Sapphire Rapids) Xeon Gold 6448H Processor Supports up to 128 vCPUs and 1,536 GB of memory Up to 25Gbps of networking speed

2.1.2 - Monitoring Metrics

PostgreSQL(DBaaS) Monitoring Metrics

The following table shows the performance monitoring metrics of PostgreSQL(DBaaS) that can be checked through Cloud Monitoring. For detailed instructions on using Cloud Monitoring, refer to the Cloud Monitoring guide.

For server monitoring metrics of PostgreSQL(DBaaS), refer to the Virtual Server Monitoring Metrics guide.

2.2 - How-to guides

Users can enter the required information for PostgreSQL (DBaaS) through the Samsung Cloud Platform Console, select detailed options, and create the service.

Creating PostgreSQL(DBaaS)

You can create and use PostgreSQL (DBaaS) services from the Samsung Cloud Platform Console.

To create PostgreSQL (DBaaS), follow the steps below.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Go to the Service Home page of PostgreSQL(DBaaS).

2. Click the PostgreSQL(DBaaS) Create button on the Service Home page. Navigate to the PostgreSQL(DBaaS) Create page.

3. PostgreSQL(DBaaS) Creation on the page, enter the information required to create the service, and select detailed options.

   • Image and version selection Select the required information in the area.

     Category	Required or not	Detailed description
     Image version	Required	Provide version list of PostgreSQL (DBaaS)

     Table. PostgreSQL (DBaaS) image and version selection items
   • Service Information Input Enter or select the required information in the area.

     Category	Required or not	Detailed description
     Server Name Prefix	Required	Server name where DB will be installed Start with an English lowercase letter, and use lowercase letters, numbers, and the special character (-) to input 3 to 13 characters Based on the server name, a postfix such as 001, 002 is attached to create the actual server name
     Cluster Name	Required	Cluster name of DB servers Enter using English letters, 3 ~ 20 characters A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type where DB will be installed Standard: Standard specifications commonly used High Capacity: Large-capacity server of 24 vCore or more For detailed information about server types provided by PostgreSQL (DBaaS), refer to PostgreSQL(DBaaS) Server Type
     Service Type > Planned Compute	Select	Status of resources with Planned Compute set In Use: Number of resources with Planned Compute set that are currently in use Configured: Number of resources with Planned Compute set Coverage Preview: Amount applied by Planned Compute per resource Create Planned Compute Service: Go to the Planned Compute service application page For more details, refer to Apply for Planned Compute
     Service Type > Block Storage	Required	Set Block Storage used by DB according to purpose Base OS: Area where DB engine is installed DATA: Storage area for table data, archive files, etc. After selecting storage type, enter capacity (refer to Create Block Storage for details of each Block Storage type) SSD: High-performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volumes using Samsung Cloud Platform KMS (Key Management System) encryption keys The configured storage type is applied identically to additional storage Capacity must be entered as a multiple of 8 within the range 16 ~ 5,120 Because large sorts from SQL execution or monthly batch may cause service interruption, a separate TEMP storage must be allocated and used Add: DATA, Archive, TEMP, Backup data storage areas After selecting Use, enter the storage’s purpose and capacity The storage type is the same as set for DATA, and capacity can be entered as a multiple of 8 within 16 ~ 5,120 Click the + button to add storage, x button to delete. Up to 9 can be added Backup data is temporarily stored in BACKUP storage before transmission If backup data exceeds 100 GB and changes frequently, it is recommended to add a separate BACKUP storage for reliable backup; set backup capacity to about 60% of DATA capacity If BACKUP storage is not added, using the /tmp area is recommended For each service, Archive, TEMP, BACKUP storages are allocated only one Block Storage
     Redundancy Configuration	Select	Redundancy Configuration Status If redundancy configuration is used, the DB instance is configured as Active DB and Standby DB
     Network > Common Settings	Required	Network settings where servers generated by the service are installed Select if you want to apply the same settings to all servers being installed Select a pre-created VPC, Subnet, IP, Public NAT IP can only be auto-generated The Public NAT feature is available only when the VPC is connected to an Internet Gateway; if you check Use, you can select from reserved IPs in the VPC product’s Public IP. For details, see Create Public IP
     Network > Server-specific Settings	Required	Network settings where servers generated by the service are installed Select if you want to apply different settings for each installed server Select a pre-created VPC, Subnet, IP, and Public NAT Enter the IP for each server The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If you check Use, you can select from reserved IPs in the VPC product’s Public IP. For more details, see Create Public IP.
     IP Access Control	Select	Service Access Policy Settings Since the access policy is set for the IP entered on the page, a separate Security Group policy setting is not required. 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 the day of the 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 patches not being applied.

     Table. PostgreSQL(DBaaS) Service Information Input Items
   • Database Configuration Required Information Input In the area, please enter or select the required information.

     Category	Required or not	Detailed description
     Database name	Required	Server name applied when installing DB Start with English letters, use English letters and numbers, input 3 ~ 20 characters
     Database username	Required	DB user name An account with that name is also created on the OS Enter using lowercase English letters, 2 to 20 characters Restricted Database usernames can be checked in the Console
     Database Password	Required	Password to use when accessing the DB Enter 8~30 characters including letters, numbers, and special characters (excluding “ and ‘)
     Database password verification	Required	Re-enter the same password to be used for DB access
     Database Port number	Required	Port number required for DB connection Enter DB port within the range 1,024 ~ 65,535
     Backup > Use	Select	Whether to use backup Use to set backup file retention period, backup start time, Archive backup cycle
     Backup > Retention Period	Select	Backup Retention Period Select the backup retention period, set the file retention period from 7 days to 35 days Backup files are charged separately based on size
     Backup > Backup Start Period	Select	Backup Start Time Select backup start time The minutes at which the backup runs are set randomly, and the backup end time cannot be set
     Backup > Archive Backup Frequency	Select	Archive Backup Frequency Select the Archive Backup Frequency Archive Backup Frequency is recommended at 1 hour. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance.
     Audit Log Settings	Select	Whether to store Audit Log Enable to configure the Audit Log feature DDL, DML, and user connection information records are stored Users can specify the type of SQL statements to audit via the log_statement parameter, and can modify it through the Parameter screen Refer to the PostgreSQL documentation for details on this parameter Enabling Audit may degrade DB performance
     Parameter	Required	Parameters to use in the DB Click the Search button to view detailed information of the parameters Parameters can be modified after DB creation is complete, and the DB must be restarted after modification
     Database Encoding	Required	Character encoding method to be used for the DB Character set used when storing text data The DB is created with the selected encoding as the default setting
     DB Locale	Required	Locale to use for DB Settings related to string processing, number/currency/date/time display formats, etc. The DB is created with default settings using the selected Locale
     Time zone	Required	Standard time zone to be used by the Database

     Table. PostgreSQL(DBaaS) Database configuration items
   • Additional Information Input Enter or select the required information in the area.

     Category	Required or not	Detailed description
     Tag	Select	Add Tag Up to 50 can be added per resource After clicking the Add Tag button, enter or select Key, Value values

     Table. PostgreSQL(DBaaS) Additional Information Input Items

4. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.

   • When creation is complete, check the created resource on the Resource List page.

PostgreSQL(DBaaS) Check detailed information

PostgreSQL(DBaaS) service can view and edit the full resource list and detailed information. PostgreSQL(DBaaS) Details page consists of Details, Tags, Activity History tabs, and for databases with a Replica configured, a Replica Information tab is additionally provided.

To view detailed information of the PostgreSQL (DBaaS) service, follow the steps below.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Move to the PostgreSQL(DBaaS) List page.
3. Click the resource to view detailed information on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.

• PostgreSQL(DBaaS) Details At the top of the page, status information and additional feature information are displayed.

  Category	Detailed description
  Cluster Status	Cluster status with DB installed Creating: Cluster is being created Editing: Cluster is changing to operation execution state Error: Cluster encountered an error while performing tasks If it occurs continuously, contact the administrator Failed: Cluster failed during creation Restarting: Cluster is being restarted Running: Cluster is operating normally Starting: Cluster is being started Stopped: Cluster is stopped Stopping: Cluster is being stopped Synchronizing: Cluster is being synchronized Terminating: Cluster is being deleted Unknown: Cluster status is unknown If it occurs continuously, contact the administrator Upgrading: Cluster is changing to upgrade execution state
  Cluster Control	Buttons to change cluster state Start: Start a stopped cluster Stop: Stop a running cluster Restart: Restart a running cluster Switch-Over: Switch a standby cluster to active
  More functions	Cluster related management buttons Service status synchronization: View real-time DB service status Backup history: If backup is set, check whether backup runs normally and view history Database recovery: Recover DB based on a specific point in time Parameter management: View and modify DB configuration parameters Replica configuration: Configure a read-only cluster Replica; if there is no region to configure for the account, the button is disabled Replica configuration (Other Region): Configure a disaster recovery Replica in another region DB user management: View and manage DB account (user) information registered in the DB DB access control management: Register and revoke allowed IPs based on DB accounts registered in the DB Archive management: Set archive file retention period and archive mode Export DB Log: Export logs stored via audit settings to the user’s Object Storage Migration configuration: Provide migration function using replication method
  Service cancellation	Button to cancel the service

  Table. PostgreSQL(DBaaS) status information and additional features

Detailed Information

PostgreSQL(DBaaS) List On the page, you can view detailed information of the selected resource and, if necessary, edit the information.

Replica Information

Replica Information tab is enabled only when a Replica is configured in the cluster. Through the Replica Information tab, you can check the master cluster name, the number of replicas, and the replication status of the Replica.

Tag

PostgreSQL(DBaaS) List page allows you to view the tag information of the selected resource, and you can add, modify, or delete it.

Work History

You can view the operation history of the selected resource on the PostgreSQL(DBaaS) List page.

PostgreSQL(DBaaS) Managing Resources

If you need to change or restore the existing configuration options of a created PostgreSQL (DBaaS) resource, or require a Replica configuration, you can perform the work on the PostgreSQL (DBaaS) Details page.

Operating Control

If changes occur to the running PostgreSQL (DBaaS) resources, you can start, stop, or restart them. Also, if HA is configured, you can switch the Active-Standby servers via a switch‑over.

To control the operation of PostgreSQL(DBaaS), follow the steps below.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Navigate to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) List Click the resource to control operation on the page. PostgreSQL(DBaaS) Details Navigate to the page.
4. Check the PostgreSQL(DBaaS) status and complete the change using the control button below.
   • Start: The server where the DB service is installed and the DB service is running.
   • Stop: The server where the DB service is installed and the DB service will be stopped (Stopped).
   • Restart: Only the DB service will be restarted.
   • Switch Over: You can switch the DB’s Active server and Standby server.

Synchronize Service Status

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

To check the service status of PostgreSQL (DBaaS), follow the steps below.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Go to the Service Home page of PostgreSQL(DBaaS).
2. Service Home page, click the PostgreSQL(DBaaS) menu. Navigate to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) List Click the resource to view the service status on the page. PostgreSQL(DBaaS) Details Navigate to the page.
4. Service status synchronization Click the button. While it is being queried, the cluster changes to Synchronizing state.
5. When the query is completed, the status is updated in the server information item, and the cluster changes to Running state.

Change Server Type

You can change the configured server type.

To change the server type, follow the steps below.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Navigate to the PostgreSQL(DBaaS) List page.
3. PostgreSQL(DBaaS) 목록 Click the resource to change the server type on the page. PostgreSQL(DBaaS) 상세 Navigate to the page.
4. Click the Edit icon of the server type you want to change at the bottom of the detailed information. The Edit Server Type popup window will open.
5. Server Type Edit After selecting the server type in the popup window, click the Confirm button.

Add storage

If you need more than 5 TB of data storage space, you can add storage. In the case of a redundant DB configuration, all redundant servers are added simultaneously.

To add storage, follow the steps below.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Go to the PostgreSQL(DBaaS) List page.
3. PostgreSQL(DBaaS) List on the page, click the resource to add storage. PostgreSQL(DBaaS) Details navigate to the page.
4. At the bottom of the detailed information, click the Add Disk button. The Add Storage Request popup window opens.
5. Additional Storage Request After entering purpose and capacity in the popup window, click the Confirm button.

Expanding storage

You can expand the storage added to the data area up to a maximum of 5 TB based on the initially allocated capacity. In the case of a redundant DB configuration, all redundant servers are expanded simultaneously.

To increase storage capacity, follow the steps below.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Go to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) List page, click the resource to change the server type. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the Edit icon of the additional Disk you want to expand at the bottom of the detailed information. Edit Additional Storage popup window opens.
5. Add Storage Modification In the popup window, after entering the expansion capacity, click the Confirm button.

PostgreSQL(DBaaS) Cancel

You can cancel unused PostgreSQL (DBaaS) to reduce operating costs. However, if you cancel the service, the running service may be stopped immediately, so you should consider the impact of service interruption sufficiently before proceeding with the cancellation.

To cancel PostgreSQL (DBaaS), follow the steps below.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Service Home page, click the PostgreSQL(DBaaS) menu. Navigate to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) List page, select the resource to cancel, and click the Cancel Service button.
4. When the termination is complete, check whether the resource has been terminated on the PostgreSQL(DBaaS) list page.

2.2.1 - Managing DB Services

Users can manage PostgreSQL (DBaaS) through the Samsung Cloud Platform Console.

Managing Parameters

It provides a feature to easily view and modify database configuration parameters.

Viewing Parameters

To view configuration parameters, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to view and modify parameters on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup window opens.
5. Click the View button in the Parameter Management popup window. The View Notification popup window opens.
6. When the View Notification popup window opens, click the OK button. It takes some time to view.

Modifying Parameters

To modify configuration parameters, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to view and modify parameters on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup window opens.
5. Click the View button in the Parameter Management popup window. The View Notification popup window opens.
6. When the View Notification popup window opens, click the OK button. It takes some time to view.
7. If modification is required, click the Modify button and enter the modification details in the custom value area of the parameter to be modified.
8. When the input is complete, click the Save button.

Managing DB Users

It provides a management feature that allows you to view DB user information and change status information.

Viewing DB Users

To view DB users, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to view DB users on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB User Management button. It moves to the DB User Management page.
5. Click the View button on the DB User Management page. It takes some time to view.

Changing DB User Status

To change the status of the viewed DB user, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to modify DB users on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB User Management button. It moves to the DB User Management page.
5. Click the View button on the DB User Management page. It takes some time to view.
6. If modification is required, click the Modify button and change the status value or enter notes.
7. When the input is complete, click the Save button.

Managing DB Access Control

It provides an IP-based DB user access control management feature. Users can directly specify the IP that can access the database, allowing only allowed IPs to access.

Viewing DB Access Control

To view DB users with IP access control set, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to manage access control on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. Click the View button on the DB Access Control Management page. It takes some time to view.

Adding DB Access Control

To add IP access control, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to add IP access control on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. Click the View button on the DB Access Control Management page. It takes some time to view.
6. When the view is complete, click the Add button. The DB Access Control Add popup window opens.
7. In the DB Access Control Add popup window, select the DB user name and enter the IP address.
8. When the input is complete, click the Save button.

Deleting DB Access Control

To delete IP access control, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to delete IP access control. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Inquire button. It takes some time to inquire.
6. Once the inquiry is complete, click the Delete button. The Delete pop-up window opens.
7. In the Delete pop-up window, click the Confirm button.

Managing Archive

It provides functions to set Archive mode and Archive log retention period, allowing users to flexibly set Archive log management policies according to their operating environment. Additionally, it provides a function to manually delete Archive logs, allowing users to clean up unnecessary log data and effectively manage system resources.

Setting Archive Mode

To set Archive mode, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to set Archive mode. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the Archive Settings Management button. It moves to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Inquire button. It takes some time to inquire.
6. Click the Modify button and select the usage and retention period.
7. Once the modification is complete, click the Save button.

Deleting Archive Files

To delete Archive files, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to set Archive mode. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the Archive Settings Management button. It moves to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Delete All Archives button to delete all Archive files, or click the Delete Backed-up Archives button to delete only backed-up Archive files.

Exporting DB Logs

It supports exporting audit logs that require long-term storage to Object Storage. Users can directly set the type of log to be stored, the target Bucket, and the frequency of log export. According to the set criteria, it copies the logs to the specified Object Storage for storage. Additionally, to efficiently manage disk space, it provides an option to automatically delete the original log files when exporting logs to Object Storage. By utilizing this option, users can effectively secure storage capacity while safely storing necessary log data for long-term storage.

Setting DB Log Export Mode

To set DB Log export mode, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to export DB logs. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the DB Log Export button. It moves to the DB Log Export page.
5. On the DB Log Export page, click the Register button. It moves to the DB Log Export Registration page.
6. On the DB Log Export Registration page, enter the corresponding information and click the Save button.

Managing DB Log Export

To modify, cancel, or immediately export DB log settings, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to manage DB log export. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the DB Log Export button. It moves to the DB Log Export page.
5. On the DB Log Export page, click the More button for the log type you want to manage, and then click the Immediate Export, Modify, or Cancel button.
   • Immediate Export: Exports the selected log to the Object Storage Bucket set earlier.
   • Modify: Modifies the DB log export mode setting.
   • Cancel: Cancels the DB log export mode setting.

Upgrading DB Version

It provides a version upgrade function due to some feature improvements and security patches. Only minor version upgrades are supported within the same major version.

To upgrade the version, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource to upgrade the version. It moves to the PostgreSQL(DBaaS) details page.
4. Click the Modify button in the image/version item. The Version Upgrade popup window opens.
5. In the Version Upgrade popup window, select the version to modify and whether to set backup, and then click the Confirm button.
6. In the Version Upgrade Notification popup window, click the Confirm button.

Configuring Migration

It provides a migration function that synchronizes with the operating database in real-time and replicates in a replication manner without interrupting the service.

To configure migration, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource to migrate. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the Configure Migration button. The Configure Migration popup window opens.
5. In the Configure Migration popup window, check the instructions and click the Confirm button. It moves to the Configure Migration page.
6. On the Configure Migration page, enter the corresponding information and click the Connect Check button.
7. When the connection is complete, click the Complete button.

The configured migration cluster can be promoted to a master cluster.

To promote the migration cluster to master, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource to promote to master. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the Promote to Master button. The Promote to Master Notification popup window opens.
5. In the Promote to Master Notification popup window, click the Confirm button.

2.2.2 - DB Backup and Recovery

The user can set up a backup of PostgreSQL(DBaaS) through the Samsung Cloud Platform Console and restore it with the backed-up file.

PostgreSQL(DBaaS) backup

PostgreSQL(DBaaS) provides a data backup feature based on its own backup command, and also provides an optimized backup environment for data protection and management through backup history checking and backup file deletion functions.

Setting up backup

The method of setting up a backup of PostgreSQL(DBaaS) is described in PostgreSQL(DBaaS) creation guide.

To modify the backup settings of the generated resource, follow these steps.

To set up a backup, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) menu is clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) list page, click the resource to set the backup. It moves to the PostgreSQL(DBaaS) details page.
4. Click the Edit button of the backup item. The Backup Settings popup window will open.
5. If you set up a backup, click Use in the Backup Settings popup window, select the retention period, backup start time, and Archive backup cycle, and then click the Confirm button.
   • If you want to stop the backup setting, uncheck Use in the Backup Setting popup window and click the OK button.

Check Backup History

To view the backup history, follow these steps.

1. 모든 서비스 > Database > PostgreSQL(DBaaS) menu should be clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) list page, click the resource to check the backup history. It moves to the PostgreSQL(DBaaS) details page.
4. Click the Backup History button. The Backup History popup window will open.
5. Backup History popup window where you can check the backup status, version, backup start time, backup completion time, and capacity.

Deleting backup files

To delete the backup history, follow these steps.

1. All services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) list page, click the resource to check the backup history. It moves to the PostgreSQL(DBaaS) details page.
4. Click the Backup History button. The Backup History popup window opens.
5. Backup History popup window, check the file you want to delete, and then click the Delete button.

PostgreSQL(DBaaS) recovery

In the event of a failure or data loss that requires restoration from a backup file, the recovery function can be used to restore to a specific point in time. When performing a PostgreSQL (DBaaS) recovery, a new server is created with the OS image at the initial provisioning time, the DB is installed with the version at the backup point, and the recovery proceeds with the DB configuration information and data.

To restore PostgreSQL(DBaaS), follow these steps.

1. All services > Database > PostgreSQL(DBaaS) menu is clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) resource list page, click the resource you want to restore. It moves to the PostgreSQL(DBaaS) detail page.
4. Database Recovery 버튼을 클릭하세요. Database Recovery 페이지로 이동합니다.
5. Database Recovery Configuration area, enter the corresponding information, and then click the Complete button.

2.2.3 - Read Replica Setup

The user can enter the required information for a Read Replica through the Samsung Cloud Platform Console and create the service using detailed options.

Replica Configure

Through the Replica configuration, you can create replica servers for read-only or disaster recovery purposes. You can create up to 5 Replicas per Database.

To configure a replica, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Go to the PostgreSQL(DBaaS) List page.
3. PostgreSQL(DBaaS) List Click the resource to configure the replica on the page. PostgreSQL(DBaaS) Detail Navigate to the page.
4. Click the Replica configuration button. Navigate to the Replica configuration page.
5. Replica configuration After entering information in the area, click the Complete button.

   Category	Required	Detailed description
   Region	Required	Region to configure Replica Replica configuration (Other Region) displayed only when selected
   Number of Replicas	Required	Number of Replicas to configure Up to 5 can be configured per cluster If selecting more than 2 values, additionally input Replica name and service type information
   Replica name	Required	Replica server name Start with a lowercase English letter, and use lowercase letters, numbers, and the special character (-) to input 3 to 19 characters The entered Replica name is displayed as the cluster name in the list
   Service Type > Server Type	Required	Replica Server Type Standard: Standard specifications commonly used High Capacity: Large-capacity server with 24 vCore or more
   Service Type > Planned Compute	Optional	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 Create Planned Compute Service: Go to the Planned Compute service application page For details, refer to Apply for Planned Compute
   IP Access Control	Select	Service Access Policy Settings Since the access policy is set for the IP entered on the page, a separate Security Group policy setting is not required 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 the day of the 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, we are not responsible for issues arising from patches not being applied.
   Tag	Select	Add Tag Add Tag button click then input or select Key, Value values

   Table. PostgreSQL(DBaaS) Replica configuration items

Replica Reconstruct

If a network failure or replication delay with the Master Cluster occurs, you can re-replicate the Master Cluster’s data using the Replica reconstruction function.

To reconstruct the Replica, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Go to the Service Home page of PostgreSQL(DBaaS).
2. Service Home page, click the PostgreSQL(DBaaS) menu. Move to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) list page, click the resource to reconfigure the Replica. PostgreSQL(DBaaS) details page will be opened.
4. Replica reconstruction Click the button. Replica reconstruction notification A popup window opens.
5. Replica Reconstruction Notification in the popup window click the Confirm button.

Promote Replica Cluster to Master Cluster

You can promote a Replica Cluster that has completed configuration to a Master Cluster.

To promote a Replica Cluster to Master, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Navigate to the PostgreSQL(DBaaS) List page.
3. Click the resource to promote to Master on the PostgreSQL(DBaaS) List page. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button and click the Master promotion button. The Master promotion notification popup window opens.
5. Master Promotion Notification in the popup window click the Confirm button.

2.2.4 - Connect to DB Server

Scenario Overview

The PostgreSQL(DBaaS) server connection scenario is a scenario where a Bastion host (Virtual Server) and Database service are created, and the DB service is accessed through the Bastion host. To securely access PostgreSQL(DBaaS) in the Samsung Cloud Platform environment, it is necessary to create a Bastion host and use it for network connection. To maintain a stable and high level of security, it is recommended to configure the Database service in a Private Subnet environment and configure the Bastion host in a limited Public Subnet environment.

This scenario largely describes the process of creating Bastion host and Database services, and configuring the network environment for Bastion host and Database connection, to connect through a DB access client.

Scenario Components

You can configure the scenario using the following services.

Scenario composition method

To configure the scenario, create the necessary services through the following procedure.

1. Configuring the Network

This describes the process of configuring the network environment for Bastion Host and Database service connection.

1-1. Creating a VPC

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. On the Service Home page, click the Create VPC button. It moves to the Create VPC page.
3. VPC Creation page, please enter the information required for service creation.
   • IP range should be entered as 192.168.x.0/16.
4. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • After creation is complete, check the created resource on the VPC list page.

1-2. Creating a Subnet

1. Click on the menu for all services > Networking > VPC. It moves to the Service Home page of VPC.
2. Service Home page, click the Subnet menu. It moves to the Subnet list page.
3. Click the Subnet Creation button. It moves to the Subnet Creation page.
4. Subnet Creation page where you enter the information needed to create a service.
   • Subnet type should be selected as General.
   • Please select a pre-created VPC.
   • IP range should be entered as 192.168.x.0/24.
5. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • Once creation is complete, check the created resource on the Subnet list page.

1-3. Creating an Internet Gateway

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Internet Gateway menu. It moves to the Internet Gateway list page.
3. Click the Create Internet Gateway button. It moves to the Create Internet Gateway page.
4. Internet Gateway creation page, please enter the required information necessary for service creation.
   • Please select a pre-created VPC.
   • Select Use in the Firewall usage item.
5. In the Summary panel, review the detailed information and the estimated charge, then click the Complete button.
   • Once the creation is complete, check the created resource on the Internet Gateway list page.

1-4. Creating a Public IP

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Public IP menu. It moves to the Public IP list page.
3. Public IP Reservation button, click. Move to the Public IP Reservation page.
4. Public IP Reservation page, enter the required information necessary for service reservation.
5. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • After creation is complete, check the created resource on the Public IP List page.

1-5. Creating a Security Group

1. Click on the menu for all services > Networking > Security Group. It moves to the Service Home page of Security Group.
2. Click the Security Group creation button on the Service Home page. It moves to the Security Group creation page.
3. Security Group creation page where you enter the required information necessary for service creation.
4. Check the input information and click the Complete button.
   • After creation is complete, check the created resource on the Security Group list page

2. Creating a Bastion Host

This describes the process of configuring the Bastion Host where the database connection client should be installed.

2-1. Creating a Server Keypair

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Click the Keypair menu on the Service Home page. It moves to the Keypair list page.
3. Keypair creation button should be clicked. It moves to the Keypair creation page.
4. Keypair creation page, please enter the required information necessary for service creation.
5. Check the creation information and click the Complete button.
   • The key can only be downloaded for the first time, and re-issuance is not provided.
   • Please keep the downloaded key in a safe place.

2-2. Creating a Bastion Host

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Click the Virtual Server Creation button on the Service Home page. It moves to the Virtual Server Creation page.
3. Virtual Server creation page where you enter the required information necessary for service creation.
   • Image is Windows please select.
   • Please select the pre-created VPC and Subnet.
   • Click NAT usage and select the Public IP reserved in 1-4. Public IP creation.
   • 2-1. Creating Server Keypair Connect the Keypair created from 2-1. Creating Server Keypair.
4. Summary panel, check the detailed information generated and the expected billing amount, and click the Complete button.
   • Once creation is complete, check the created resource on the Virtual Server list page.

2-3. Check Bastion host connection ID and PW

1. Click on the menu for all services > Compute > Virtual Server. It moves to the Service Home page of Virtual Server.
2. Service Home page, click the Virtual Server menu. Move to the Virtual Server list page.
3. Virtual Serve list page, click on the resource created in 2-2. Bastion host creation. It moves to the detailed information page of the corresponding resource.
4. Click the RDP password inquiry button in the Keypair item on the detailed information page. The RDP password inquiry popup window will open.
5. RDP password inquiry popup window, attach the keypair file downloaded from 2-1. Creating a server keypair.
6. After attaching, click the Password Check button. The ID and password required to access the resource will be displayed.
   • The ID and Password will be used as information to connect to the Bastion host later, as described in 5-1. Connect to Bastion host.

3. Creating a Database

Describes the process of creating a database service.

3-1. Creating PostgreSQL(DBaaS) Service

1. Click on the menu for all services > Database > PostgreSQL(DBaaS). It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the Create PostgreSQL(DBaaS) button. It moves to the Create PostgreSQL(DBaaS) page.
3. PostgreSQL(DBaaS) creation page, please enter the required information needed for service creation.
   • Select and connect the pre-created VPC and Subnet.
   • Enter database-related creation information on the essential information input screen.
   • Add the Bastion host IP to the IP access control items.
   • Database Port is 2866 by default, but you can specify it as you want.
4. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • After creation is complete, check the created resource on the PostgreSQL(DBaaS) list page.

4. Setting Rules

This describes the process of setting rules for users to access the Bastion host and rules for the Bastion host to access the Database.

4-1. Adding Security Group Security Rules

1. Click on the menu for all services > Networking > Security Group. It moves to the Service Home page of Security Group.
2. Service Home page, click the Security Group menu. Move to the Security Group list page.
3. 1-5. Creating a Security Group Select the Security Group resource created from. It will move to the detailed information page of the resource.
4. Click the Rules tab on the detail information page. It moves to the Rules tab.
5. Click the Rules tab and click the Add Rule button. It moves to the Add Rule popup window.
6. Add Rule popup window, enter the rules below, and click the OK button

4-2. Adding IGW Firewall Rules

1. Click All services > Networking > Firewall menu. It moves to the Service Home page of Firewall.
2. Service Home page, click the Firewall menu. It moves to the Firewall list page.
3. Firewall list page, select the Internet Gateway resource name created in 1-3. Creating Internet Gateway, and move to the detailed information page of the corresponding resource.
4. Click the Rules tab on the detailed information page. It moves to the Rules tab.
5. Click the Rule tab and click the Add Rule button. It moves to the Add Rule popup window.
6. Add Rule In the popup window, enter the rules below and click the OK button.

5. Connect to Database

This describes the process of a user accessing the Database through a DB connection client program.

This guide provides instructions on how to connect using pgAdmin. There are various database client programs and CLI utilities, so you can install and use the tools that are suitable for the user.

5-1. Connect to the Bastion host

1. Run Remote Desktop Connection in the Windows environment of the PC you want to connect to the Bastion host, enter the NAT IP of the Bastion Host, and click the Connect button.
2. After a successful remote desktop connection, the User Credential Input Window opens. Enter the ID and Password confirmed in 2-3. Checking Bastion Host Access ID and PW and click the Confirm button.

5-2. Installing DB connection client program (pgAdmin) on the Bastion host

1. Go to the official pgAdmin page and download the pgAdmin program.
   • pgAdmin program download path: https://www.pgadmin.org/download/
2. Connect the hard drive of the user PC to upload the file to the Bastion host.
3. Click the Details button for local devices and resources entries in the Local Resources tab of Remote Desktop Connection.
4. Select the local disk where the file was downloaded to the drive and click the Confirm button.
5. Copy the downloaded file and upload it to the Bastion Host, then click the pgAdmin installation file to install it.

5-3. Using DB connection client program (pgAdmin) to connect to the database

1. Run pgAdmin and click the Add New Server button.
2. In the Register - Server popup window, enter the Database server information created in 3-1. PostgreSQL(DBaaS) service creation in the General tab and Connection tab, and click the Save button.

   Screen (Tab)	Required Input Element Items	Input Value
   General	Name	Custom (ex. Service Name)
   Connection	Host name/address	Database server IP
   Connection	Port	Database Port
   Connection	Maintenance database	Database name
   Connection	Password	Database password

   DB connection client program input items
3. Click the database name created on pgAdmin to connect.
   • You can try simple queries after connecting.

2.2.5 - Using Extensions

PostgreSQL(DBaaS) Extension usage

The list of extensions that can be installed in the current database can be checked with the following SQL statement.

SQL> select * from pg_available_extensions;

PostgreSQL(DBaaS) has the following additional installation items outside of the default extension by version:

In addition to the above items, if additional Extension installation is required, please refer to Support Center > 문의하기 and inquire.

• Once the inquiry is received, we will proceed with the installation after review. Please note that some Extensions may not work normally during Replica configuration and recovery.

2.3 - API Reference

2.4 - CLI Reference

2.5 - Release Note

PostgreSQL(DBaaS)

3 - MariaDB(DBaaS)

3.1 - Overview

Service Overview

MariaDB (DBaaS) is an open source relational database (RDBMS) with high compatibility with MySQL. Samsung Cloud Platform provides an environment that can automate MariaDB installation and perform management functions for operation through a web-based console.

MariaDB (DBaaS) is designed as a high-availability architecture that performs storage-based data replication and minimizes failover time. To prevent data loss, when the content of the Active server changes, it is synchronously replicated to the Standby server, and up to five read-only servers called Replicas are provided for read load balancing and disaster recovery (DR). Additionally, to prepare for issues with the DB server or data, it offers a feature that automatically backs up at a user-specified time, supporting data recovery at the desired point in time.

Provided Features

MariaDB (DBaaS) provides the following features.

• Auto Provisioning (Auto Provisioning): Installation and configuration of Database (DB) via UI is possible, and it provides an Active-standby redundancy configuration built on storage replication. In case of an Active server failure, it automatically fails over to Standby.
• Operation Control Management: Provides a function to control the status of running servers. In addition to start and stop, restart is possible if there is an issue with the DB or to apply configuration values. When configured for high availability (HA), the user can directly perform node switching between Active-Standby via Switch-over.
• Backup and Recovery: Provides data backup functionality based on its own backup command. The backup time window and storage organization can be set by the user, and additional fees may be incurred depending on backup volume. It also provides a recovery function for backed-up data, so when the user performs recovery, a separate DB is created and recovery proceeds to the point in time selected by the user (backup save point, user-defined point). When recovering to a user-specified point, the recovery point can be set to 5 minutes/10 minutes/30 minutes/1 hour before the stored backup file and archive file.
• Version Management: Provides version upgrade (Minor) functionality due to some feature improvements and security patches. Whether to perform a backup for the version upgrade can be selected by the user, and if a backup is performed, data is backed up before applying the patch, then the DB engine is updated.
• Replica configuration: You can add up to 5 read-only Read Replicas, enabling read performance scaling and load balancing.
• Audit setting: Provides an Audit setting feature that can monitor the user’s DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) execution.
• Parameter Management: Performance improvement and security-related DB configuration parameter modifications are possible.
• Service status query: Retrieves the final status of the current DB service.
• Monitoring: CPU, memory, DB performance monitoring information can be checked through the Cloud Monitoring service.
• DB User Management: View and manage DB account (user) information registered in the DB.
• DB Access Control Management: Based on DB accounts registered in the DB, you can register and revoke allowed IPs for access.
• Archive Management: You can set the Archive file retention period (1 day~35 days) within the DB server and configure the Archive mode (On/Off).
• DB Log Export: Through Audit settings, you can export stored logs to the user’s Object Storage.
• Migration: Synchronize data in real time with the operating database, and support migration using replication method without service interruption.

Components

MariaDB (DBaaS) provides pre-validated engine versions and various server types according to the open source support policy. Users can select and use them according to the scale of the service they want to configure.

Engine Version

The engine versions supported by MariaDB (DBaaS) are as follows.

Technical support can be used until the supplier’s EoTS (End of Technical Service) date, and the EOS date when new creation is stopped is set to 6 months before the EoTS date.

Since the EOS and EoTS dates may change according to the supplier’s policy, please refer to the supplier’s license management policy page for details.

• MariaDB (Community): https://mariadb.org/about/#maintenance-policy

Server Type

The server types supported by MariaDB (DBaaS) are as follows.

For detailed information about the server types provided by MariaDB(DBaaS), see MariaDB(DBaaS) Server Type.

Standard db1v2m4

Preliminary Service

This is a list of services that must be pre-configured before creating the service. For details, please refer to the guide provided for each service and prepare in advance.

3.1.1 - Server Type

MariaDB(DBaaS) Server Type

MariaDB(DBaaS) provides server types with various combinations of CPU, Memory, and Network Bandwidth. When creating a MariaDB(DBaaS), the database engine is installed according to the selected server type, which is chosen based on the intended use.

The server types supported by MariaDB(DBaaS) are as follows:

Standard db1v2m4

db1 Server Type

The db1 server type of MariaDB(DBaaS) is provided with standard specifications (vCPU, Memory) and is suitable for various database workloads.

• Up to 3.3Ghz Intel 3rd generation (Ice Lake) Xeon Gold 6342 Processor
• Supports up to 16 vCPUs and 256 GB of memory
• Up to 12.5 Gbps networking speed

dbh2 Server Type

The dbh2 server type of MariaDB(DBaaS) is provided with high-capacity server specifications and is suitable for large-scale data processing database workloads.

• Up to 3.2GHz Intel 4th generation (Sapphire Rapids) Xeon Gold 6448H Processor
• Supports up to 128 vCPUs and 1,536 GB of memory
• Up to 25Gbps networking speed

3.1.2 - Monitoring Metrics

MariaDB(DBaaS) Monitoring Metrics

The following table shows the performance monitoring metrics of MariaDB(DBaaS) that can be checked through Cloud Monitoring. For detailed usage of Cloud Monitoring, refer to the Cloud Monitoring guide.

For server monitoring metrics of MariaDB(DBaaS), refer to the Virtual Server monitoring metrics guide.

3.2 - How-to guides

The user can enter the required information for MariaDB (DBaaS) and select detailed options through the Samsung Cloud Platform Console to create the service.

Creating MariaDB(DBaaS)

You can create and use the MariaDB (DBaaS) service from the Samsung Cloud Platform Console.

To create MariaDB (DBaaS), follow the steps below.

1. Click the All Services > Database > MariaDB(DBaaS) menu. You will be taken to the Service Home page of MariaDB(DBaaS).
2. Service Home on the page click the MariaDB(DBaaS) creation button. Navigate to the MariaDB(DBaaS) creation page.
3. MariaDB(DBaaS) creation on the page, enter the information required to create the service, and select detailed options.
   • Please select the required information in the Image and version selection area.

     Category	Required	Detailed description
     Image version	Required	Provide version list of MariaDB (DBaaS)

     Table. MariaDB(DBaaS) Image and Version Selection Items
   • Service Information Input Enter or select the required information in the area.

     Category	Required or not	Detailed description
     Server name Prefix	Required	Name of the server where the DB will be installed Start with a lowercase English letter, and use lowercase letters, numbers, and the special character (-) to input 3 to 13 characters Based on the server name, a postfix such as 001, 002 is attached to create the actual server name
     Cluster Name	Required	Cluster name composed of DB servers Enter using English letters, 3 to 20 characters A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type where DB will be installed Standard: Standard specifications commonly used High Capacity: Large-capacity server of 24 vCore or more For detailed information about server types provided by MariaDB (DBaaS), refer to MariaDB(DBaaS) Server Type
     Service Type > Planned Compute	Select	Status of resources with Planned Compute set In Use: Number of resources with Planned Compute set that are currently in use Configured: Number of resources with Planned Compute set Coverage Preview: Amount applied by Planned Compute per resource Create Planned Compute Service: Go to the Planned Compute service application page For details, refer to Apply for Planned Compute
     Service Type > Block Storage	Required	Block Storage settings used by DB according to purpose Base OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Select the storage type and then enter the capacity. (For detailed information on each Block Storage type, refer to Create Block Storage) SSD: High-performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volumes using Samsung Cloud Platform KMS (Key Management System) encryption keys The configured storage type is applied identically to additional storage Capacity must be entered as a multiple of 8 within the range 16 ~ 5,120 Since large sorts during SQL execution or monthly batch processes can cause service interruptions, a separate TEMP storage must be allocated and used Additional: Data storage areas for DATA, Archive, TEMP, Backup After selecting Use, enter the storage’s purpose and capacity The storage type is applied the same as set for DATA, and capacity can be entered as a multiple of 8 within the range 16 ~ 5,120 Click the + button to add storage, and the x button to delete. Up to 9 can be added Temporarily store backup data in BACKUP storage before transmitting backup data If the data to be backed up exceeds 100 GB and changes frequently, it is recommended to add a separate BACKUP storage for reliable backup. It is advised to set the backup capacity to about 60% of the DATA capacity If a BACKUP storage is not added, using the /tmp area is recommended For each service, only one Block Storage is allocated for Archive, TEMP, BACKUP
     Redundancy Configuration	Selection	Redundancy Configuration Status If redundancy configuration is used, the DB instance is configured as Active DB and Standby DB
     Network > Common Settings	Required	Network settings where servers generated by the service are installed Select if you want to apply the same settings to all servers being installed Select a pre‑created VPC, Subnet, IP, and Public NAT IP can only be auto‑generated The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If you check Use, you can select a reserved IP from the VPC product’s Public IP. See Create Public IP for details.
     Network > Server-specific Settings	Required	Network settings where servers generated by the service are installed Select if you want to apply different settings per installed server Select a pre-created VPC, Subnet, IP, Public NAT Enter each server’s IP The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If you check Use, you can select from reserved IPs in the VPC product’s Public IP. For more details, see Create Public IP.
     IP Access Control	Select	Service Access Policy Settings Since the access policy is set for the IP entered on the page, a separate Security Group policy setting is not required. 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 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 is performed at the set time, causing service interruption If set to not use, Samsung SDS is not responsible for issues arising from unapplied patches.

     Table. MariaDB (DBaaS) Service Information Input Items
   • Database configuration required information input area, please enter or select the required information.

     Category	Required or not	Detailed description
     Database name	Required	Server name applied when installing DB Start with English letters, use English letters and numbers, input 3 ~ 20 characters
     Database username	Required	DB user name An account with the same name is also created on the OS Enter using lowercase English letters, 2 to 20 characters Restricted Database usernames can be checked in the Console
     Database password	Required	Password to use when accessing the DB Enter 8~30 characters including letters, numbers, and special characters (“ ‘ excluded)
     Database Password Confirmation	Required	Re-enter the same password to be used when accessing the DB
     Database Port Number	Required	Port number required for DB connection Enter DB port within the range 1,024 ~ 65,535
     Backup > Use	Select	Whether to use backup Select Use to set the backup file retention period, backup start time, and Archive backup cycle
     Backup > Retention Period	Select	Backup retention period Select backup retention period. File retention period can be set from 7 days to 35 days Backup files incur separate charges based on size
     Backup > Backup Start Period	Select	Backup Start Time Select backup start time The minutes (minutes) at which the backup runs are set randomly, and the backup end time cannot be set
     Backup > Archive backup frequency	Select	Archive backup frequency Select the Archive backup frequency Archive backup frequency is recommended at 1 hour. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance
     Audit Log Settings	Select	Whether to store Audit Log Enable를 선택하여 Audit Log 기능을 설정 User connection information records are stored Users can specify the types of events to audit via the server_audit_events parameter, and it can be modified through the Parameter screen Refer to the MariaDB documentation for details on this parameter Enabling Audit may degrade DB performance
     Parameter	Required	Parameters to use in the DB Lookup Click the button to view detailed information of the parameter Parameters can be modified after DB creation is complete, and after modification the DB must be restarted
     DB character set	Required	Character encoding method to use for the DB The character set used when storing text data, and the DB is created with this encoding set as the default.
     Time zone	Required	Standard time zone to be used by the Database

     Table. MariaDB(DBaaS) Database configuration items
   • Additional Information Input area: enter or select the required information.

     Category	Required or not	Detailed description
     Tag	Select	Add Tag Up to 50 can be added per resource After clicking the Add Tag button, enter or select Key, Value values

     Table. MariaDB(DBaaS) Additional Information Input Items
4. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.
   • Once creation is complete, check the created resource on the Resource List page.

MariaDB(DBaaS) Check detailed information

MariaDB(DBaaS) service can view and edit the full resource list and detailed information. The MariaDB(DBaaS) Details page consists of Details, Tags, Activity Log tabs, and for DBs with a Replica configured, an additional Replica Information tab is included.

To view detailed information about the MariaDB (DBaaS) service, follow the steps below.

1. All Services > Database > MariaDB(DBaaS) Click the menu. Navigate to the Service Home page of MariaDB(DBaaS).
2. Click the MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
3. Click the resource to view detailed information on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Details page.

• MariaDB(DBaaS) Details At the top of the page, status information and information about additional features are displayed.

  Category	Detailed description
  Cluster Status	Cluster status with DB installed Creating: Cluster is being created Editing: Cluster is being changed to operation execution state Error: Cluster encountered a failure while performing tasks If it occurs continuously, contact the administrator Failed: Cluster failed during creation Restarting: Cluster is being restarted Running: Cluster is operating normally Starting: Cluster is being started Stopped: Cluster is stopped Stopping: Cluster is being stopped Synchronizing: Cluster is being synchronized Terminating: Cluster is being deleted Unknown: Cluster status is unknown If it occurs continuously, contact the administrator Upgrading: Cluster is changing to upgrade execution state
  Cluster Control	Button to change cluster state Start: Start a stopped cluster Stop: Stop a running cluster Restart: Restart a running cluster Switch-Over: Switch a standby cluster to active
  More additional features	Cluster related management buttons Service status synchronization: Real-time DB service status lookup Backup history: If backup is set, check whether backup runs normally and view history Database recovery: Recover DB based on a specific point in time Parameter management: DB configuration parameters can be queried and modified Replica configuration: Set up a read-only cluster called Replica DB user management: View and manage DB account (user) information registered in the DB DB access control management: Based on DB accounts registered in the DB, you can register and revoke allowed IPs Archive management: Can set archive file retention period and archive mode DB Log export: Through audit settings, stored logs can be exported to the user’s Object Storage Migration configuration: Provides migration functionality using replication method
  Service termination	Button to cancel the service

  Table. MariaDB (DBaaS) status information and additional features

Detailed Information

MariaDB(DBaaS) List page allows you to view detailed information of the selected resource and, if necessary, edit the information.

Replica Information

Replica Information tab is enabled only when a Replica is configured in the cluster. Replica Information tab allows you to check the master cluster name, number of replicas, and replica status.

Tag

MariaDB(DBaaS) List page allows you to view the tag information of the selected resource, and you can add, modify, or delete it.