Database

• 1: EPAS(DBaaS)
• 1.1: Overview
• 1.1.1: Server Types
• 1.1.2: Monitoring metrics
• 1.2: How-to guides
• 1.2.1: DB Service Manage
• 1.2.2: Backing up and restoring the database
• 1.2.3: Configure Read Replica
• 1.2.4: EPAS(DBaaS) Server Connection
• 1.2.5: Extension Usage
• 1.3: API Reference
• 1.4: CLI Reference
• 1.5: Release Note
• 2: PostgreSQL(DBaaS)
• 2.1: Overview
• 2.1.1: Server Types
• 2.1.2: Monitoring metrics
• 2.2: How-to guides
• 2.2.1: DB Service Manage
• 2.2.2: Backing up and restoring the DB
• 2.2.3: Configure Read Replica
• 2.2.4: DB Server Connection
• 2.2.5: Extension Use
• 2.3: API Reference
• 2.4: CLI Reference
• 2.5: Release Note
• 3: MariaDB(DBaaS)
• 3.1: Overview
• 3.1.1: Server Types
• 3.1.2: Monitoring Metrics
• 3.1.3: ServiceWatch Metrics
• 3.2: How-to guides
• 3.2.1: DB Service Manage
• 3.2.2: Backing up and restoring the database
• 3.2.3: Configure Read Replica
• 3.2.4: MariaDB(DBaaS) Server Connection
• 3.3: API Reference
• 3.4: CLI Reference
• 3.5: Release Note
• 4: MySQL(DBaaS)
• 4.1: Overview
• 4.1.1: Server Types
• 4.1.2: Monitoring metrics
• 4.1.3: ServiceWatch Metrics
• 4.2: How-to guides
• 4.2.1: DB Service Manage
• 4.2.2: Backing up and restoring the database
• 4.2.3: Configure Read Replica
• 4.2.4: MySQL(DBaaS) Server Connection
• 4.3: API Reference
• 4.4: CLI Reference
• 4.5: Release Note
• 5: Microsoft SQL Server(DBaaS)
• 5.1: Overview
• 5.1.1: Server Types
• 5.1.2: Monitoring metrics
• 5.2: How-to guides
• 5.2.1: DB Service Manage
• 5.2.2: Backing up and restoring the DB
• 5.2.3: Secondary Add
• 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 Types
• 6.1.2: Monitoring metrics
• 6.2: How-to guides
• 6.2.1: CacheStore Service Manage
• 6.2.2: CacheStore Backup and Restore
• 6.2.3: CacheStore(DBaaS) Server Connection
• 6.3: API Reference
• 6.4: CLI Reference
• 6.5: Release Note
• 7: Scalable DB(DBaaS)
• 7.1: Overview
• 7.1.1: Server Types
• 7.1.2: ServiceWatch Metrics
• 7.2: How-to guides
• 7.2.1: Read Node Manage
• 7.2.2: Backup DB
• 7.3: 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 automates EPAS installation and performs 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 contents of the Active server change, they are synchronously replicated to the Standby server, and up to five read‑only Replica servers for read load balancing and disaster recovery (DR) are provided. Additionally, to prepare for potential issues with the DB server or data, we provide a feature that automatically backs up at a user-specified time, enabling data recovery at the desired point.

Provided Features

EPAS(DBaaS) provides the following features.

• Auto Provisioning: UI allows installation and configuration of Database (DB), and provides an Active‑standby redundancy configuration built on storage replication. * When the active server fails, 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, you can restart if there is a DB issue or to apply configuration changes. * When high availability (HA) is configured, the user can manually perform node switching between Active and Standby via a switch‑over.
• Backup and Recovery: Provides data backup functionality based on its own backup commands. * The backup schedule and retention policy can be set by the user, and additional fees apply based on the backup size. * It also provides a recovery function for backed‑up data, so when the user performs a recovery, a separate database is created and the recovery proceeds to the point in time selected by the user (the backup save point or a user‑specified point). * When restoring to a user-specified point in time, the restore point can be set up to 5 minutes, 10 minutes, 30 minutes, or 1 hour earlier, based on the stored backup and archive files.
• Version Management: Provides a version upgrade (Minor) feature based on certain feature enhancements and security patches. * Whether to perform a backup for a version upgrade can be selected by the user, and if a backup is performed, the data is backed up before applying the patch, after which the DB engine is updated.
• Replica configuration: Up to five Read Replicas can be configured in the same or different regions for read load balancing and disaster recovery (DR).
• Audit configuration: Provides an Audit configuration feature that can monitor users’ DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) operations.
• Parameter management: You can modify DB configuration parameters related to performance improvement and security.
• Service Status Query: Retrieves the final status of the current DB service.
• Monitoring: CPU, memory, DB performance monitoring information can be viewed through the Cloud Monitoring service.
• DB User Management: Query and manage the 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~35 days) on the DB server and configure the Archive mode (On/Off).
• Export DB Log: You can export stored logs to the user’s Object Storage through Audit settings.
• Migration: Synchronize data in real time with the operational database and support migration using replication without service interruption.
• OS Kernel Upgrade: You can upgrade the OS Kernel to apply some feature improvements and security patches.

Component

EPAS (DBaaS) provides pre‑validated engine versions and a variety of server types. Users can select and use it based on the scale of the service they wish 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.

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.

• 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), see EPAS(DBaaS) Server Types.

Standard db1v2m4

Preceding Service

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

1.1.1 - Server Types

EPAS(DBaaS) server type

EPAS (DBaaS) offers server types configured with various combinations of CPU, memory, and network bandwidth. When creating an EPAS (DBaaS), the Database Engine is installed based on the server type selected for the intended purpose.

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

Standard db1v2m4

db1 server type

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

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

db2 server type

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

• Intel 4th‑generation (Sapphire Rapids) Xeon Gold 6448H Processor, up to 3.2 GHz
• Supports up to 16 vCPUs and 256 GB of memory
• Maximum networking speed of 12.5 Gbps

dbh2 server type

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

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

1.1.2 - Monitoring metrics

EPAS(DBaaS) Monitoring Metrics

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

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

1.2 - How-to guides

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

Create EPAS (DBaaS)

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

To create EPAS (DBaaS), follow these steps.

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

2. On the Service Home page, click the Create EPAS (DBaaS) button. 2. Go to the EPAS(DBaaS) Create page.

3. On the Create EPAS (DBaaS) page, enter the information required to create the service and select detailed options.

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

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

     Table. EPAS (DBaaS) Image and version selection items
   • In the Service Information Input area, enter or select the required information.

     Category	required status	Detailed description
     Server name Prefix	Required	Server name where the DB will be installed must start with a lowercase English letter and be entered using lowercase letters, numbers, and the special character (-) with a length of 3 to 13 characters A postfix such as 001, 002 is appended to the base server name to generate the actual server name
     Cluster name	required	Cluster name composed 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 for DB installation Standard: Standard specification commonly used High Capacity: Large-capacity server with 24 vCores or more For detailed information about the server types provided by EPAS (DBaaS), refer to EPAS(DBaaS) 서버 타입
     Service Type > Planned Compute	Select	Status of resources with Planned Compute configured In Use: Number of resources with Planned Compute configured that are currently in use Configured: Number of resources with Planned Compute configured Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Navigate to the Planned Compute service application page For more details, refer to Planned Compute Application
     Service Type > Block Storage	Required	Block Storage settings used by the DB according to purpose Base OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Select a storage type and then enter the capacity.(For details on each Block Storage type, refer to Block Storage 생성하기) SSD: High‑performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volume that uses 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 to 5,120 Because executing SQL or monthly batch jobs can cause service interruption due to large sorts, a separate TEMP storage must be allocated and used Add: DATA, Archive, TEMP, Backup data storage areas Use after selecting, enter the storage’s purpose and capacity The storage type is applied the same as the type set for DATA, and capacity can be entered as a multiple of 8 within the range 16 to 5,120 To add storage, click the Add button; to delete, click the x button. Up to 9 can be added Before transmitting backup data, temporarily store the backup data in the BACKUP storage If the data to be backed up exceeds 100 GB and undergoes frequent changes, it is recommended to add a separate BACKUP storage for reliable backup; the backup capacity is advised to be set at about 60 % of the DATA capacity If a BACKUP storage is not added, the /tmp area is used, and backup fails if capacity is insufficient For each service, Archive, TEMP, and BACKUP storages are allocated only one Block Storage each
     Redundancy configuration	Selection	Redundancy configuration status When redundancy configuration is used, the DB instance is set up as an Active DB and a Standby DB
     Network > Common Settings	Essential	Network settings for servers created by the service Select when you want to apply the same settings to all installed servers Select a pre‑created VPC, Subnet, IP, and Public NAT IP can only be generated automatically The Public NAT feature is available only when the VPC is connected to an Internet Gateway. Use it by checking the box, allowing selection from reserved IPs in the VPC product’s Public IP. For more details, see Public IP 생성하기
     Network > Server-specific Settings	Required	Network settings where servers generated by the service are installed Select when 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. Checking Use makes it possible to select a reserved IP from the VPC product’s Public IP pool. For more details, see Public IP 생성하기.
     IP access control	Select	Service Access Policy Configuration Since the access policy is set for the IP entered on the page, a separate Security Group policy configuration is not required Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.0/24, 192.168.10.1/32) and click the Add button To delete an entered IP, click the x button next to the entered IP
     maintenance period	Select	Database maintenance window If you select Use, set the day of the week, start time, and duration It is recommended to set a maintenance window for stable management of the DB. Patch operations will be performed at the scheduled time, causing service interruption If set to unused, Samsung SDS is not responsible for issues arising from unapplied patches.

     Table. EPAS (DBaaS) Service Information Input Items
   • Enter required database configuration information Enter or select the required information in this area.

     Category	required status	Detailed description
     Database name	Required	Server name applied during DB installation must start with an English letter and be entered using English letters and numbers, 3 to 20 characters
     Database username	Required	Database 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 user names can be viewed in the Console
     Database password	Required	Password to use when accessing the DB Enter 8 to 30 characters, including letters, numbers, and special characters (excluding “ ‘)
     Database password verification	Essential	Re-enter the same password to use for DB access
     Database Port number	Required	Port number required for DB connection Enter DB port within the range 1200 ~ 65535
     Backup > Use	Select	Backup usage Select Use to set backup file retention period, backup start time, and Archive backup interval
     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 incur additional charges based on size
     Backup > Backup Start Period	Selection	Backup start time Select backup start time The minute(s) at which the backup runs is set randomly, and the backup end time cannot be set
     Backup > Archive backup cycle	Select	Archive backup interval Select the archive backup interval The archive backup interval is recommended to be 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 The user 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 detailed information about this parameter Enabling Audit may degrade database performance
     Parameter	Essential	DB configuration parameters Click the Query button to view detailed information of the parameters Parameters can be modified after the service 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 be used for the DB settings related to string handling, 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 for the database
     License	Required	EPAS License verification status Verification item for license usage; if you do not click Confirm, you cannot proceed to the next step

     Table. EPAS (DBaaS) Database configuration items
   • In the Additional Information Input area, enter or select the required information.

     Category	Required status	Detailed description
     Tag	Select	Add Tag Up to 50 per resource can be added Add Tag button, then input or select Key, Value values

     Table. EPAS (DBaaS) Additional Information Input Items

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

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

View detailed information of EPAS (DBaaS)

The EPAS (DBaaS) service allows you to view and edit the full list of resources and detailed information. EPAS(DBaaS) Details page consists of Details, Tags, Activity History tabs, and when the DB has a Replica configured, a Replica Information tab is added.

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

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Go to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource to view detailed information. 3. EPAS(DBaaS) Details Go to the page.
   • EPAS(DBaaS) Details The top of the page displays status information and additional feature details.

     Category	Detailed description
     Cluster status	Cluster status with DB installed Creating: Creating cluster Editing: Cluster is changing to a state of performing an operation Error: Cluster encountered an error while performing tasks If it occurs continuously, contact the administrator Failed: Cluster failed during creation Restarting: Restarting the cluster Running: Cluster is operating normally Starting: Starting the cluster Stopped: Cluster is stopped Stopping: Cluster is in the process of stopping Synchronizing: Synchronizing the cluster Terminating: Terminating the cluster Unknown: Cluster status is unknown If it occurs continuously, contact the administrator Upgrading: Cluster is changing to a state of performing an upgrade
     Cluster control	Button 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 Management Buttons Service Status Synchronization: Real-time DB service status lookup Backup History: When backup is configured, verify successful execution and view history Database Recovery: Recover the DB based on a specific point in time Parameter Management: View and modify DB configuration parameters Replica Configuration: Set up a read-only Replica cluster Replica Configuration (Other-Region): Set up a disaster recovery Replica in another region; the button is disabled if the account has no region to configure 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 Settings Management: Configure archive file retention period and enable archive mode Export DB Log: Export stored logs to the user’s Object Storage via Audit settings Migration Configuration: Provides migration functionality using replication OS (Kernel) Upgrade: Upgrade the OS kernel version
     Service termination	Cancel service button

     Table. EPAS (DBaaS) status information and additional features

Detailed information

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

Replica information

The 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, number of replicas, and Replica status.

tag

EPAS (DBaaS) List page lets you view, add, modify, or delete tag information for the selected resource.

Work History

EPAS (DBaaS) List page allows you to view the operation history of the selected resource.

Managing EPAS (DBaaS) 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 task on the EPAS(DBaaS) Details page.

Control operation

If changes occur to a running EPAS (DBaaS) resource, you can start, stop, or restart it. Additionally, when HA is configured, you can switch the Active‑Standby servers using a switch‑over.

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

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Navigate to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to control. 3. EPAS(DBaaS) Details Navigate to the page.
4. Check the EPAS (DBaaS) status and complete the change using the control button below.
   • Start: DB service is installed on the server and the DB service is running (Running).
   • Stop: The server where the DB service is installed and the DB service are 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 EPAS (DBaaS).

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

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Go to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource for which you want to view the service status. 3. EPAS(DBaaS) Details Go to the page.
4. Service Status Synchronization Click the button. 4. While it is being queried, the cluster changes to Synchronizing state.
5. When the query completes, the status in the server information field is updated, and the cluster changes to the Running state.

Change server type

You can change the configured server type.

To change the server type, follow these steps.

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Navigate to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) List page, click the resource whose server type you want to change. 3. Go 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. 4. Edit Server Type The popup window opens.
5. Edit Server Type 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, you can add additional storage. For a redundant DB configuration, all redundant servers are added simultaneously.

To add storage, follow these steps.

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

Expand storage

Storage added to the data area can be expanded 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 expand storage capacity, follow the steps below.

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Go to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) List page, click the resource for which you want to change the server type. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the Edit icon of the additional Disk you want to add at the bottom of the detailed information. 4. Edit Additional Storage The popup window opens.
5. Edit Additional Storage In the popup window, after entering the expanded capacity, click the Confirm button.

Cancel EPAS (DBaaS)

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

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

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

1.2.1 - DB Service Manage

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

Managing Parameters

Provides a feature that enables easy viewing and modification of database configuration parameters.

Viewing Parameters

To view configuration parameters, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) menu. Navigate to the EPAS(DBaaS) Service Home page.
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be taken to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource whose parameters you want to view or modify. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup opens.
5. In the Parameter Management popup, click the Search button. The Search Notification popup opens.
6. Lookup Notification when the popup window opens, click the Confirm button. Retrieving may take a short amount of time.

Parameter Modify

To modify the configuration parameters, follow the steps below.

1. Click the All Services > Database > EPAS(DBaaS) menu. Navigate to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be taken to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource whose parameters you want to view or modify. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup opens.
5. In the Parameter Management popup, click the Search button. The Search Notification popup opens.
6. Lookup Notification When the popup window opens, click the Confirm button. Retrieving may take a short amount of time.
7. If editing is required, click the Edit button and enter the changes in the custom value area of the Parameter to be edited.
8. When the input is complete, click the Complete button.

DB User Management

Provides management features that allow viewing DB user information and changing status information.

Query DB users

To retrieve DB users, follow these steps.

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. On the EPAS(DBaaS) List page, click the resource whose DB users you want to view. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button, then click the DB User Management button. You will be directed to the DB User Management page.
5. Click the Search button on the DB User Management page. Retrieving may take a short while.

Changing DB User Status

To change the status of the retrieved DB user, follow these steps.

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 page, click the resource whose DB user you want to modify. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button, then click the DB User Management button. You will be directed to the DB User Management page.
5. On the DB User Management page, click the Search button. Retrieving may take a short time.
6. If modification is needed, click the Edit button, and change the status field value or enter remarks.
7. When the input is complete, click the Complete button.

Managing DB Access Control

Provides IP-based DB user access control management functionality. Users can directly specify the IPs that can access the database, configuring it so that only authorized IPs are allowed access.

View DB Access Control

Follow these steps to query DB users with IP access control enabled.

1. Click the All Services > Database > EPAS(DBaaS) menu. Proceed 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 you want to manage access control for on the EPAS(DBaaS) List page. You will be taken to the EPAS(DBaaS) Detail page.
4. Click the More button, then click the DB Access Control Management button. You will be taken to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Search button. Retrieving the data may take a moment.

Add DB access control

To add IP access control, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) menu. Navigate to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be taken 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. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button, then click the DB Access Control Management button. You will be taken to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Search button. The query may take a moment.
6. After the query completes, click the Add button. The Add DB Access Control popup window opens.
7. Add DB Access Control In the popup window, select the DB username and enter the 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. 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. Navigate 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. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button and then click the DB Access Control Management button. You will be taken to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Search button. Retrieving the data may take a moment.
6. When the query is complete, click the Delete button. The Delete popup window opens.
7. In the Delete popup, click the Confirm button.

Managing Archive

Provides the ability to configure Archive mode and set the retention period for Archive logs, allowing users to flexibly configure Archive log management policies to suit their operational environment. Additionally, it provides a feature to manually delete archive logs, allowing you to clean up unnecessary log data and manage system resources effectively.

Configure Archive mode

To set the Archive mode, follow these steps.

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. Navigate to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource for which you want to set Archive mode. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button and then click the Archive Settings Management button. You will be taken to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Search button. The query may take a short time.
6. Click the Edit button and select the usage status and retention period.
7. When the edit is complete, click the Complete button.

Delete Archive file

To delete the Archive file, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) menu. Navigate to the Service Home page of EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be taken to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to set to Archive mode. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button, then click the Archive Settings Management button. You will be taken to the Archive Settings Management page.
5. Archive Settings Management page, if you want to delete all Archive files, click the Delete All Archives button; if you only want to delete the backed‑up Archive files, click the Delete Backed‑up Archives button.

Modify Audit Settings

You can modify the Audit log storage settings for EPAS (DBaaS).

To change the Audit log storage settings of EPAS (DBaaS), follow the steps below.

1. Click the All Services > Database > EPAS(DBaaS) menu. Navigate to the EPAS(DBaaS) Service Home page.
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 page, click the resource whose service status you want to view. You will be taken to the EPAS(DBaaS) Details page.
4. Click the Edit icon of Audit Settings at the bottom of the detailed information. The Edit Audit Settings popup window opens.
5. Modify Audit Settings After changing the usage in the popup window, click the Confirm button.
   • When Enable is selected, the Audit log feature is configured. Enabling the Audit log may degrade DB performance.
   • If you disable use, the Audit log storage file will be deleted. Before disabling use, back up the Audit log file separately.

DB Log Export

Supports exporting log data that requires long-term retention among audit logs to Object Storage. Users can directly configure the log types to be stored, the target bucket for export, and the export interval. Based on the configured criteria, logs are copied to the specified Object Storage for retention. Additionally, to efficiently manage disk space, we also provide an option that exports logs to Object Storage while automatically deleting the original log files. By using this option, you can effectively free up storage capacity while safely retaining the necessary log data for long-term storage.

Setting DB Log Export Mode

To set the DB Log export mode, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) 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. On the EPAS(DBaaS) List page, click the resource for which you want to export the DB Log. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button, then click the DB Log Export button. You will be taken to the DB Log Export page.
5. On the DB Log Export page, click the Register button. You will be taken to the DB Log Export Register page.
6. After entering the required information on the DB Log Export Registration page, click the Complete button.

   Category	Required	Detailed description
   Log type	Required	Log type to be saved
   Save bucket name	Required	Object Storage bucket name to be saved
   Authentication key > Access key	Required	Access key for accessing the Object Storage you want to store
   Authentication key > Secret key	Required	Secret key for accessing the Object Storage you want to store
   File creation cycle	Required	File creation frequency in Object Storage
   Whether to delete the original log	Selection	Whether to delete the original logs when exporting to Object Storage

   Table. EPAS (DBaaS) DB Log Export Configuration Items

Managing DB Log Export

To modify, cancel, or immediately export the DB Log export settings, 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. Navigate to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to manage DB Log export for. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button and then click the DB Log Export button. You will be taken to the DB Log Export page.
5. DB Log Export On the page, depending on the log type you want to manage, click the More button and then click the Export Now, Edit, Terminate buttons.
   • Export Immediately: The selected logs are exported to the bucket of the previously configured Object Storage.
   • Edit: Modify the DB Log export mode setting.
   • Cancel: Cancel the DB Log export mode setting.

Minor Version Upgrade

We provide version upgrade functionality for some feature improvements and security patches. Only Minor version upgrades within the same Major version are supported.

To upgrade the Minor Version, 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. On the EPAS(DBaaS) List page, click the resource you want to upgrade the version for. You will be taken to the EPAS(DBaaS) Detail page.
4. Click the Edit button in the Image version item. The Version Upgrade popup window opens.
5. Version Upgrade In the popup window, select the updated version and backup setting, then click the Confirm button.
6. Version Upgrade Notification Click the Confirm button in the popup window.

Configuring Migration

Provides a Migration feature that synchronizes in real time with the live database and replicates using a Replication method without service interruption.

To configure Migration, 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 page: click the resource you want to migrate. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button, then click the Migration configuration button. Migration configuration popup window opens.
5. Migration configuration In the popup window, review the instructions and click the Confirm button. You will be taken to the Migration configuration page.
6. On the Migration configuration page, enter the required information, then click the Check connection button.
7. When the connection is complete, click the Complete button.

   Category	Required	Detailed description
   Source DB Database name	Required	Database name of the source DB to be migrated
   Source DB IP	Required	IP of the Source DB that is the migration target
   Source DB Port	Required	Port of the Source DB to be migrated
   Source DB username	Required	Username of the source DB that is the migration target
   Source DB password	Required	Password of the source DB for migration

   Table. EPAS(DBaaS) migration configuration items

Promote Migration Cluster to Master Cluster

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

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

1. Click the All Services > Database > EPAS(DBaaS) 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. On the EPAS(DBaaS) List page, click the resource to promote to Master. You will be taken to the EPAS(DBaaS) Details page.
4. Click the More button, then click the Master Promotion button. The Master Promotion Notification popup window opens.
5. Master Promotion Notification in the popup window, click the Confirm button.

Upgrade OS Kernel

The OS Kernel can be upgraded to improve the functionality of the running database and apply security patches.

To upgrade the OS Kernel, follow the steps below.

1. Click the All Services > Database > EPAS(DBaaS) menu. Navigate to the EPAS(DBaaS) Service Home page.
2. Click the EPAS(DBaaS) menu on the Service Home page. You will be taken to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource to upgrade the OS Kernel. You will be taken to the EPAS(DBaaS) Detail page.
4. Click the More button, then click the OS(Kernel) Upgrade button. The OS(Kernel) Upgrade Notification popup opens.
5. OS(Kernel) Upgrade Notification In the popup window, review the instructions and click the Confirm button.

1.2.2 - Backing up and restoring the database

Users can configure backups of EPAS (DBaaS) through the Samsung Cloud Platform Console and restore from the backed‑up files.

EPAS(DBaaS) Backup

To ensure that users’ data can be stored safely, EPAS (DBaaS) provides a data backup feature based on its own backup commands. Additionally, you can verify whether the backup was successful using the backup history feature, and you can also delete backed‑up files.

Configure Backup

For instructions on configuring backups for EPAS (DBaaS), see Create EPAS (DBaaS).

To modify the backup settings of the created resource, follow the steps below.

To set up a backup, follow these steps.

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Go to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) List page: click the resource for which you want to configure a backup. 3. EPAS(DBaaS) Details page is accessed.
4. Click the Edit button of the backup item. 4. Backup Settings popup window opens.
5. When configuring a backup, click Enable in the Backup Settings popup, select the retention period, backup start time, and Archive backup interval, then click the Confirm button.
   • If you stop the backup configuration, deselect Use in the Backup Settings popup and authenticate using the logged-in user’s mobile phone.
     Once user authentication is completed, the backup configuration is disabled and backup execution stops.

Check backup history

To view the backup history, follow these steps.

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Go to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) List page, click the resource to view the backup history. 3. Go to the EPAS(DBaaS) Details page.
4. Click the Backup History button. 4. The Backup History popup opens.
5. Backup History In the popup window, you can view the backup status, version, backup start time, backup completion time, and size.

Delete backup file

To delete the backup history, follow these steps.

1. All Services > Database > EPAS(DBaaS) menu, click it. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Go to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource to view its backup history. 3. Go to the EPAS(DBaaS) Details page.
4. Click the Backup History button. 4. Backup History The popup window opens.
5. Backup History In the popup window, check the files you want to delete, then authenticate using the logged-in user’s mobile phone.
   • When user authentication is completed, the backup file is deleted.

EPAS(DBaaS) Recover

If recovery is needed from a backup file due to a failure or data loss, the restore function can recover based on a specific point in time. When you perform an EPAS (DBaaS) recovery, a new server is created with the OS image from the initial provisioning point, the database is installed with the version from the backup point, and the recovery proceeds with the database’s configuration information and data.

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

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Go to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) resources On the list page, click the resource you want to restore. 3. Navigate to the EPAS(DBaaS) Details page.
4. Click the Database Recovery button. 4. Database Recovery Navigate to the page.
5. After entering the relevant information in the Database Recovery Configuration area, click the Complete button.

   Category	required status	Detailed description
   Recovery Type	Required	Set the point in time the user wants to recover Backup point (recommended): Recover based on the backup file. Select from the list of backup points displayed in the list Custom point: Recover to a user‑desired point within the range of recoverable backup points. The recoverable period depends on the Archive backup interval setting, allowing recovery to any point from the start of the first backup up to 1 hour/30 minutes/10 minutes/5 minutes before the current time. Select the date and time to recover
   Server name prefix	Required	Recovery DB server name Start with a lowercase English letter and use lowercase letters, numbers, and special characters (-) to enter 3 to 16 characters Based on the server name, a postfix such as 001, 002 is appended to generate the actual server name
   Cluster name	Required	Recovery DB cluster name Enter using English letters, 3 to 20 characters A cluster is a unit that groups multiple servers
   Service Type > Server Type	Essential	Recovery DB server type Standard: Standard specification commonly used High Capacity: Large-capacity server with 24 vCores or more
   Service Type > Planned Compute	Selection	Status of resources with Planned Compute configured In Use: Number of resources with Planned Compute configured that are currently in use Configured: Number of resources with Planned Compute configured Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Navigate to the Planned Compute service application page For more details, refer to Planned Compute 신청하기
   Service Type > Block Storage	Required	Block Storage settings used by the recovery DB Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Applied identically with the storage type set in the original cluster Enter capacity as a multiple of 8 within the range 16 to 5,120 Additional: Storage area for DATA, Archive, TEMP, Backup data Applied identically with the storage type set in the original cluster In the recovery DB, only DATA, TEMP, and Archive purposes can be added After selecting Use, enter the storage purpose and capacity To add storage, click the Add button, and to delete, click the x button Capacity can be entered as a multiple of 8 within the range 16 to 5,120, and up to 9 can be created
   Database username	Required	Database username Apply the same username set in the original cluster
   Database Port number	Required	Database Port number Apply the same Port number configured in the original cluster
   IP access control	Select	Service Access Policy Configuration Since the access policy is set for the IP entered on the page, you do not need to configure a separate Security Group policy Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.0/24, 192.168.10.1/32) and click the Add button To delete an entered IP, click the x button next to the entered IP
   maintenance period	Select	Database maintenance window If you select Use, set the day of week, start time, and duration It is recommended to set a maintenance window for stable management of the DB. Patch operations will be performed at the scheduled time, causing service interruptions If set to not use, Samsung SDS is not responsible for issues arising from unapplied patches.
   tag	Select	Add Tag Add Tag after clicking the Add Tag button Enter or select Key, Value values

   Table. EPAS (DBaaS) recovery configuration items

1.2.3 - Configure Read Replica

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

Configure Replica

You can create replica servers for read‑only or disaster‑recovery purposes through replica configuration. You can create up to 5 replicas per database.

To configure a Replica, follow these steps.

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

   Category	required status	Detailed description
   Region	Required	Region to configure the Replica Replica configuration (Other Region)exposed only when selected
   Replica count	Required	Number of Replicas to configure Up to 5 can be configured per cluster If you select more than one value, additionally enter the Replica name and service type information
   Replica name	Required	Replica server name Start with a lowercase English letter, and use lowercase letters, numbers, and special characters (-) to enter 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 specification commonly used High Capacity: large-capacity server with 24 vCore or more
   Service Type > Planned Compute	Selection	Status of resources with Planned Compute configured In Use: Number of resources with Planned Compute that are currently in use Configured: Number of resources with Planned Compute configured Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Navigate to the Planned Compute service application page For more details, see Planned Compute Apply
   IP access control	Selection	Service Access Policy Configuration Since the access policy is set for the IP entered on the page, you do not need to configure a separate Security Group policy Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.0/24, 192.168.10.1/32) and click the Add button To delete an entered IP, click the x button next to the entered IP
   maintenance period	Selection	Database maintenance window If you select Use, set the day, start time, and duration It is recommended to set a maintenance window for stable management of the DB. Patch operations will be performed at the scheduled time, causing service interruption If set to unused, we are not responsible for any issues arising from patches not being applied.
   Tag	Select	Add Tag Add Tag after clicking the button Enter or select Key, Value values

   Table. EPAS (DBaaS) Replica configuration items

Reconfigure Replica

If a network outage or replication delay with the Master Cluster occurs, you can use the Replica reconstruction function to replicate the Master Cluster’s data again.

To reconfigure the Replica, follow these steps.

1. All Services > Database > EPAS(DBaaS) Click the menu. 1. Go to the Service Home page of EPAS (DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. 2. Go to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource to reconfigure the Replica. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the Reconstruct Replica button. 4. Replica Reconfiguration Notification A popup window opens.
5. Replica Reconfiguration Notification popup window, click the Confirm button.

Promoting a Replica Cluster to a Master Cluster

You can promote a configured Replica Cluster to a Master Cluster.

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

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

1.2.4 - EPAS(DBaaS) Server Connection

Scenario Overview

EPAS(DBaaS) Server Connection scenario involves creating a Bastion host (Virtual Server) and a Database service, and accessing the DB service through the Bastion host. To reliably connect to EPAS (DBaaS) in the Samsung Cloud Platform environment, you need to create a Bastion host and establish a network connection using it. To maintain stability and a high level of security, it is recommended to configure the Database service in a Private Subnet environment and set up the Bastion host in a restricted Public Subnet environment.

This scenario primarily describes creating a Bastion host and a Database service, configuring the network environment for Bastion host and Database access, and connecting through a DB client.

Scenario components

You can build the scenario using the following services.

Scenario setup method

Create the services needed to build the scenario by following the steps below.

Configure the network

Describes the process of configuring the network environment for accessing the Bastion Host and Database services.

1-1. Create VPC

1. Click the All Services > Networking > VPC menu. You will be taken to the VPC’s Service Home page.
2. Click the Create VPC button on the Service Home page. You will be taken to the Create VPC page.
3. On the VPC Creation page, enter the information required to create the service.
   • Enter the IP range as 192.168.x.0/16
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 resources on the VPC List page.

1-2. Create Subnet

1. Click the All Services > Networking > VPC menu. Navigate to the VPC Service Home page.
2. On the Service Home page, click the Subnet menu. You will be taken to the Subnet List page.
3. Click the Subnet Create button. You will be taken to the Subnet Create page.
4. On the Subnet Creation page, enter the information required to create the service.
   • Select the Subnet type as General.
   • Select a pre‑created VPC.
   • Enter the IP range as 192.168.x.0/24.
5. In the Summary panel, verify the detailed information and estimated billing amount, then click the Complete button.
   • When creation is complete, check the created resources on the Subnet list page.

1-3. Create Internet Gateway

1. Click the All Services > Networking > VPC menu. You will be taken to the VPC’s Service Home page.
2. On the Service Home page, click the Internet Gateway menu. You will be taken to the Internet Gateway List page.
3. Click the Create Internet Gateway button. You will be taken to the Create Internet Gateway page.
4. On the Internet Gateway Creation page, enter the required information needed to create the service.
   • Select a pre‑created VPC.
   • In the Firewall usage item, select Use.
5. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.
   • Once creation is complete, verify the created resource on the Internet Gateway list page.

1-4. Create Public IP

1. Click the All Services > Networking > VPC menu. Navigate to the VPC Service Home page.
2. On the Service Home page, click the Public IP menu. You will be taken to the Public IP List page.
3. Click the Public IP Reservation button. You will be taken to the Public IP Reservation page.
4. On the Public IP reservation page, enter the required information needed to reserve the service.
5. In the Summary panel, verify the detailed information and estimated billing amount, then click the Complete button.
   • Once creation is complete, check the created resources on the Public IP List page.

1-5. Create Security Group

1. Click the All Services > Networking > Security Group menu. Go to the Service Home page of Security Group.
2. Click the Create Security Group button on the Service Home page. Navigate to the Create Security Group page.
3. On the Security Group creation page, enter the required information needed to create the service.
4. Check the input information and click the Complete button.
   • Once creation is complete, check the created resources on the Security Group List page.

Create bastion host

Describes the process of configuring a Bastion Host that requires the Database access client to be installed.

2-1. Create Server Keypair

1. Click the All Services > Compute > Virtual Server menu. Navigate to the Service Home page of Virtual Server.
2. On the Service Home page, click the Keypair menu. You will be taken to the Keypair List page.
3. Click the Keypair creation button. You will be taken to the Keypair creation page.
4. Enter the required information needed to create a service on the Keypair creation page.
5. Check the creation information and click the Complete button.
   • The key can be downloaded only once, and reissuance is not available.
   • Please store the downloaded key in a secure location.

2-2. Create Bastion host

1. Click the All Services > Compute > Virtual Server menu. Navigate to the Service Home page of Virtual Server.
2. On the Service Home page, click the Virtual Server Create button. It navigates to the Virtual Server Create page.
3. Virtual Server Creation page, enter the required information to create the service.
   • Select Windows for the image.
   • Select the pre-created VPC and Subnet.
   • Click Use NAT, then in 1-4. Create Public IP select the reserved Public IP.
   • Connect the Keypair you created in 2-1. Create Server Keypair.
4. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.
   • After creation is complete, verify the created resources on the Virtual Server list page.

2-3. Bastion host Check login ID and PW

1. Click the All Services > Compute > Virtual Server menu. Navigate to the Service Home page of Virtual Server.
2. Click the Virtual Server menu on the Service Home page. You will be taken to the Virtual Server List page.
3. On the Virtual Serve List page, click the resource you created in 2-2. Create Bastion host. You will be taken to the detailed information page of that resource.
4. On the detail information page, click the RDP password View button in the Keypair name field. The RDP password View popup window will open.
5. In the RDP password lookup popup window, attach the keypair file downloaded from 2-1. 서버 Keypair 생성하기.
6. After attaching, click the Password Check button. The ID and Password for accessing the resource are displayed.
   • The ID and Password are used later as credentials to access the Bastion host in 5-1. Bastion host 접속하기.

Create Database

Describes the process of creating a Database service.

3-1. EPAS(DBaaS) Service Creation

1. Click the All Services > Database > EPAS(DBaaS) menu. Go to the Service Home page of EPAS(DBaaS).
2. Click the EPAS(DBaaS) Create button on the Service Home page. You will be taken to the EPAS(DBaaS) Create page.
3. Create EPAS (DBaaS) Enter the required information needed to create the service on this page.
   • Select the pre‑created VPC and Subnet and connect them.
   • Enter the database-related creation details on the required information input screen.
   • Add the Bastion host IP in the IP access control settings.
   • The Database Port defaults to 2866, but the user can also specify it.
4. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.
   • When creation is complete, verify the created resource on the EPAS(DBaaS) list page.

Configuring Rules

It explains the process of configuring rules for a user to connect to the Bastion host and rules for connecting to the Database from the Bastion host.

4-1. Add Security Group Rules

1. Click the All Services > Networking > Security Group menu. Navigate to the Service Home page of the Security Group.
2. From the Service Home page, click the Security Group menu. You will be taken to the Security Group List page.
3. Select the Security Group resource created in 1-5. Create Security Group. Navigate to the detailed information page of that resource.
4. On the detail information page, click the Rules tab. You will be taken to the Rules tab.
5. On the Rules tab, click the Add Rule button. You will be taken to the Add Rule popup.
6. Add Rule In the popup window, enter the rule below, and click the Confirm button.

   direction	Remote	target address	Protocol	port	Explanation
   Inbound	CIDR	User PC IP	TCP	3389 (RDP)	Bastion client PC → Bastion host
   Outbound	CIDR	DB IP	TCP	Database Port (manual entry)	Bastion host → Database

   Table. Security Group rules that need to be added

4-2. Add IGW Firewall Rule

1. All Services > Networking > Firewall Click the menu. Go to the Service Home page of the Firewall.
2. On the Service Home page, click the Firewall menu. You will be taken to the Firewall List page.
3. On the Firewall List page, select the Internet Gateway Resource Name created in 1-3. Internet Gateway 생성하기. You will be taken to the detailed information page for that resource.
4. Click the Rules tab on the detail information page. You will be taken to the Rules tab.
5. On the Rules tab, click the Add Rule button. You will be taken to the Add Rule popup.
6. Add Rule In the popup window, enter the rule below, and click the Confirm button.

   origin address	Destination address	Protocol	Port	Operation	direction	Explanation
   Bastion connection PC IP	Bastion host IP	TCP	3389(RDP)	Allow	Inbound	User PC → Bastion host

   Table. Internet Gateway Firewall rules that need to be added

Connect to Database

Describes the process of a user accessing the database via a DB client program.

This guide explains how to connect using pgAdmin. Since there are various database client programs and CLI utilities, you may install and use the tool that best fits your needs.

5-1. Connecting to Bastion host

1. In the Windows environment of the PC that will connect to the Bastion host, run Remote Desktop Connection, then enter the NAT IP of the Bastion Host and click the Connect button.
2. When the remote desktop connection succeeds, the user credential input window opens. Enter the ID and Password verified in 2-3. Bastion host Access ID and PW Check and click the Confirm button.

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

1. Go to the official pgAdmin page and download the pgAdmin program.
   • pgAdmin program download URL: https://www.pgadmin.org/download/
2. Connect the user’s PC hard drive to upload the file to the Bastion host.
3. In the Remote Desktop Connection Local Resources tab, click the Details button for the Local Devices and Resources entry.
4. Select the local disk of the location where the file was downloaded on the drive, and click the OK button.
5. Copy the downloaded file, upload it to the Bastion Host, and click the pgAdmin installer to install.

5-3. Connect to the database using the DB client program (pgAdmin)

1. Run pgAdmin and click the Add New Server button.
2. Register - Server popup window, enter the Database server information created in 3-1. EPAS(DBaaS) Create Service into the General and Connection tabs, and click the Save button.

   Screen (tab)	Required input field	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

   Table: DB connection client program input fields
3. Click the name of the database created in pgAdmin to connect.
   • After connecting, you can perform simple queries, among other tasks.

1.2.5 - Extension Usage

Using EPAS(DBaaS) Extension

You can view the list of extensions that can be installed in the current database with the SQL statement below.

SQL> select * from pg_available_extensions;

In EPAS(DBaaS), the items installed in addition to the default extensions included per version are as follows.

If you need to install additional extensions beyond the items above, refer to Support Center > Inquiry and contact us.

• After a request is received, we will review it and proceed with installation. Please note that some extensions may not function 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 automates PostgreSQL installation through a web-based console and performs 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 contents of the Active server change, they are synchronously replicated to the Standby server, and up to five read‑only Replica servers for read load balancing and disaster recovery (DR) are provided. Additionally, to prepare for potential issues with the DB server or data, we provide a feature that automatically backs up at a user-specified time, enabling recovery of data at the desired point.

Provided Features

PostgreSQL (DBaaS) provides the following features.

• Auto Provisioning: UI allows installation and configuration of Database (DB), and provides an Active‑standby redundancy configuration built on storage replication. * When the active server fails, 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, you can restart if there is a DB issue or to apply configuration changes. * When high availability (HA) is configured, the user can manually perform node switching between Active and Standby via a switch‑over.
• Backup and Recovery: Provides data backup functionality based on its own backup commands. * The backup schedule and retention policy can be set by the user, and additional fees apply based on the backup size. * It also provides a recovery function for backed‑up data, so when the user performs a recovery, a separate database is created and the recovery proceeds to the point in time selected by the user (the backup save point or a user‑specified point). * When restoring to a user-specified point in time, the restore point can be set up to 5 minutes, 10 minutes, 30 minutes, or 1 hour earlier, based on the stored backup files and archive files.
• Version Management: Provides version upgrade (Minor) functionality due to certain feature improvements and security patches. * Whether to perform a backup for a version upgrade can be selected by the user, and if a backup is performed, the data is backed up before applying the patch, after which the DB engine is updated.
• Replica configuration: For load balancing reads and disaster recovery (DR), up to five Read Replicas can be configured in the same or different regions.
• Audit Settings: Supports audit (Audit) functionality for key activities within the database.
• Parameter management: You can modify DB configuration parameters related to performance improvement and security.
• Service Status Query: Retrieves the final status of the current DB service.
• Monitoring: CPU, memory, and DB performance monitoring information can be accessed through the Cloud Monitoring service.
• DB User Management: Query and manage the 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 retention period (1 to 35 days) for Archive files on the DB server and configure the Archive mode (On/Off).
• Export DB Log: You can export stored logs to the user’s Object Storage through Audit settings.
• Migration: Synchronize data in real time with the operational database and support migration using replication without service interruption.
• OS kernel upgrade: The OS Kernel can be upgraded to apply certain feature improvements and security patches.

Component

PostgreSQL(DBaaS) provides pre‑validated engine versions and various server types in accordance with the open‑source support policy. Users can select and use it according to the scale of the service they wish 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 offered by PostgreSQL(DBaaS), see PostgreSQL(DBaaS) Server Types.

Standard db1v2m4

Preceding Service

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

2.1.1 - Server Types

PostgreSQL(DBaaS) server type

PostgreSQL (DBaaS) offers server types composed of various combinations of CPU, Memory, and Network Bandwidth. When creating PostgreSQL(DBaaS), the Database Engine is installed based on the server type chosen for the intended use.

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

Standard db1v2m4

db1 server type

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

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

db2 server type

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

• Intel 4th‑generation (Sapphire Rapids) Xeon Gold 6448H Processor up to 3.2 GHz
• Supports up to 16 vCPUs and 256 GB of memory
• Maximum networking speed of 12.5 Gbps

dbh2 server type

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

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

2.1.2 - Monitoring metrics

PostgreSQL(DBaaS) Monitoring Metrics

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

For PostgreSQL (DBaaS), refer to the Virtual Server Monitoring Metrics guide.

2.2 - How-to guides

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

Create PostgreSQL (DBaaS)

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

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

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

2. On the Service Home page, click the PostgreSQL(DBaaS) Create button. 2. Navigate to the Create PostgreSQL (DBaaS) page.

3. Create PostgreSQL (DBaaS) page, enter the information required to create the service and select advanced options.

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

     Category	required status	Detailed description
     Image version	required	Provide a list of PostgreSQL (DBaaS) versions

     Table. PostgreSQL (DBaaS) Image and version selection options
   • In the Service Information Input area, enter or select the required information.

     Category	required status	Detailed description
     Server name Prefix	Required	Server name where the DB will be installed must start with a lowercase English letter and be entered using lowercase letters, numbers, and the special character (-) with a length of 3 to 13 characters A postfix such as 001, 002 is appended to the base server name to generate the actual server name
     Cluster name	Required	Cluster name 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 for DB installation Standard: Standard specifications commonly used High Capacity: Large-capacity server with 24 vCores or more For detailed information about the server types provided by PostgreSQL (DBaaS), refer to PostgreSQL(DBaaS) Server Type
     Service Type > Planned Compute	Selection	Status of resources with Planned Compute configured In Use: Number of resources with Planned Compute configured that are currently in use Configured: Number of resources with Planned Compute configured Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Navigate to the Planned Compute service application page For more details, see Planned Compute Apply
     Service Type > Block Storage	Required	Block Storage configuration used by the DB according to its purpose Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Select a storage type and then enter the capacity (refer to Create Block Storage for details on each Block Storage type) SSD: High‑performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volumes that use Samsung Cloud Platform KMS (Key Management System) encryption keys The configured storage type is applied identically to additional storage Enter capacity as a multiple of 8 within the range 16–5,120 Because executing SQL or monthly batch jobs can cause large sorts that may interrupt service, 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 applied the same as the type set for DATA, and capacity can be entered as a multiple of 8 within the range 16–5,120 To add storage, click the Add button; to delete, click the x button. Up to 9 can be added Backup data is temporarily stored in the 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 a BACKUP storage is not added, the /tmp area is used, and backup will fail if capacity is insufficient For each service, Archive, TEMP, and BACKUP storages are allocated only one Block Storage each
     Redundant configuration	Select	Redundancy configuration status When redundancy configuration is used, the DB instance is set up as an Active DB and a Standby DB
     Network > Common Settings	Required	Network settings for servers created by the service Select when you want to apply the same settings to all installed servers Select a pre‑created VPC, Subnet, IP, and Public NAT IP can only be generated automatically The Public NAT feature is available only when the VPC is connected to an Internet Gateway; when Use is checked, you can select a reserved IP from the VPC product’s Public IP pool. For more information, see Public IP 생성하기
     Network > Server-specific Settings	Required	Network settings where servers generated by the service are installed Select when 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 a reserved IP from the VPC product’s Public IP. For more details, refer to Public IP 생성하기
     IP access control	Select	Service Access Policy Configuration Since the access policy is set for the IP entered on the page, a separate Security Group policy configuration is not required Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.0/24, 192.168.10.1/32) and click the Add button To delete an entered IP, click the x button next to the entered IP
     maintenance period	Select	Database maintenance window If you select Use, set the day, start time, and duration It is recommended to set a maintenance window for stable management of the database. Patch operations will be performed at the scheduled time, causing service interruption If set to not use, Samsung SDS is not responsible for issues arising from unapplied patches.

     Table. PostgreSQL (DBaaS) Service Information Input Items
   • Enter or select the required information in the Database Configuration Required Information Input area.

     Category	required status	Detailed description
     Database name	Required	Server name applied during DB installation must start with an English letter and be entered using English letters and numbers, 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 to 20 characters Restricted database user names can be viewed in the Console
     Database password	Required	Password to use when accessing the DB Enter 8 to 30 characters, including letters, numbers, and special characters (excluding “ ‘)
     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 the DB port within the range 1200 ~ 65535
     Backup > Use	Select	Backup usage Select Use to set the backup file retention period, backup start time, and Archive backup interval
     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 incur additional charges based on size
     Backup > Backup Start Period	Selection	Backup start time Select backup start time The minutes (minutes) during which the backup runs are set randomly, and the backup end time cannot be set
     Backup > Archive backup cycle	Select	Archive backup frequency Select the archive backup frequency The archive backup frequency is recommended to be 1 hour. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance.
     Audit Log Settings	Select	Whether to store Audit Log Select 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 For detailed information about this parameter, refer to the PostgreSQL documentation Enabling Audit may degrade database performance
     Parameter	Required	Parameters to be used in the DB Lookup button can be clicked to view detailed information of the parameter Parameters can be modified after the DB creation is complete, and the DB must be restarted after any modifications
     Database Encoding	Essential	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 be used for the DB settings related to string handling, number/currency/date/time formatting, etc. The DB is created with default settings using the selected Locale
     time zone	Required	Standard time zone for the database

     Table. PostgreSQL (DBaaS) Database configuration items
   • In the Additional Information Input area, enter or select the required information.

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

     Table. PostgreSQL (DBaaS) Additional Information Input Fields

4. Summary Review the detailed information and estimated charges generated in the panel, then click the Create button.

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

View PostgreSQL (DBaaS) details

The PostgreSQL (DBaaS) service allows you to view and edit the full list of resources and detailed information. PostgreSQL(DBaaS) Details page consists of Details, Tags, Activity History tabs, and when the DB has a Replica configured, a Replica Information tab is added.

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

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. PostgreSQL(DBaaS) List Click the resource on the page to view detailed information. 3. PostgreSQL(DBaaS) Details Go to the page.
   • PostgreSQL(DBaaS) Details The top of the page displays status information and additional feature details.

     Category	Detailed description
     Cluster status	Cluster status with DB installed Creating: Creating cluster Editing: Cluster is transitioning to an operational state Error: Cluster encountered an error during operation If it occurs continuously, contact the administrator Failed: Cluster failed during creation Restarting: Restarting cluster Running: Cluster is running normally Starting: Starting cluster Stopped: Cluster is stopped Stopping: Cluster is stopping Synchronizing: Synchronizing cluster Terminating: Terminating cluster Unknown: Unknown cluster status If it occurs continuously, contact the administrator Upgrading: Cluster is transitioning to an upgrading state
     Cluster control	Button 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
     View more features	Cluster-related management buttons Service status synchronization: Retrieve real-time DB service status Backup history: When backup is configured, verify successful execution and view the history Database recovery: Recover the DB based on a specific point in time Parameter management: View and modify DB configuration parameters Replica configuration: Set up a read‑only Replica cluster Replica configuration (Other Region): Set up a disaster‑recovery Replica in another region; if the account has no region to configure, the button is disabled 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 settings management: Set archive file retention period and enable archive mode Export DB logs: Export logs stored via audit settings to the user’s Object Storage Migration configuration: Provide migration functionality using replication method OS (Kernel) upgrade: Upgrade the OS kernel version
     Service termination	Button to cancel the service

     Table. PostgreSQL (DBaaS) status information and additional features

Detailed information

PostgreSQL (DBaaS) List page allows you to view detailed information of the selected resource and, if needed, 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 view the Master cluster name, the number of replicas, and the replication status of the Replica.

tag

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

Work History

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

Managing PostgreSQL (DBaaS) 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 operation on the PostgreSQL(DBaaS) Details page.

Control operation

If changes occur to a running PostgreSQL (DBaaS) resource, you can start, stop, or restart it. Also, when 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. 1. Navigate to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. PostgreSQL (DBaaS) List On the page, click the resource you want to control. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Check the PostgreSQL (DBaaS) status and complete the change using the control button below.
   • Start: DB service is installed on the server and the DB service is running (Running).
   • Stop: The server hosting the DB service and the DB service itself 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 PostgreSQL (DBaaS).

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

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

Change server type

You can change the configured server type.

To change the server type, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. On the PostgreSQL (DBaaS) List page, click the resource whose server type you want to change. 3. PostgreSQL(DBaaS) Details Go to the page.
4. Click the Edit icon of the server type you want to change at the bottom of the detailed information. 4. Edit Server Type The popup window opens.
5. Edit Server Type 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, you can add additional storage. For a DB configured with redundancy, all redundant servers are added simultaneously.

To add storage, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Go to the page.
3. On the PostgreSQL (DBaaS) List page, click the resource to add storage. 3. PostgreSQL(DBaaS) Details Go to the page.
4. Click the Add Disk button at the bottom of the details. 4. Additional Storage Request The popup window opens.
5. Additional Storage Request In the popup window, after entering the purpose and size, click the Confirm button.

Expand storage

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

To increase storage capacity, follow the steps below.

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

Cancel PostgreSQL (DBaaS)

You can cancel unused PostgreSQL (DBaaS) to reduce operating costs. However, if you terminate the service, the running service may be stopped immediately, so you should proceed with the termination only after fully considering the impact that may occur when the service is discontinued.

To cancel PostgreSQL (DBaaS), follow these steps.

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

2.2.1 - DB Service Manage

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

Managing Parameters

Provides a feature that allows you to easily view and modify database configuration parameters.

Query Parameters

To retrieve configuration parameters, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will be taken to the PostgreSQL(DBaaS) List page.
3. On the PostgreSQL(DBaaS) List page, click the resource whose parameters you want to view or modify. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup opens.
5. Parameter Management in the popup window, click the Search button. The Search Notification popup window opens.
6. Lookup Notification when the popup window opens, click the Confirm button. The lookup may take a short amount of time.

Modify Parameter

To modify the configuration parameters, follow the steps below.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. You will be taken to the PostgreSQL(DBaaS) List page.
3. On the PostgreSQL(DBaaS) List page, click the resource whose parameters you want to view or modify. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup opens.
5. Parameter Management popup window, click the Search button. Search Notification popup window opens.
6. Lookup Notification When the popup window opens, click the Confirm button. Retrieving may take a short amount of time.
7. If a modification is needed, click the Edit button and enter the changes in the custom value field of the Parameter to be edited.
8. When the input is complete, click the Complete button.

DB User Management

Provides management functions to retrieve DB user information and modify status information.

Query DB Users

To retrieve DB users, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the Service Home page’s PostgreSQL(DBaaS) menu. You will be taken to the PostgreSQL(DBaaS) List page.
3. PostgreSQL(DBaaS) List page, click the resource you want to view DB users for. PostgreSQL(DBaaS) Details page will be opened.
4. Click the More button and then click the DB User Management button. You will be taken to the DB User Management page.
5. DB User Management page, click the Search button. Retrieving the data may take a short time.

Changing DB User Status

Follow these steps to change the status of the retrieved DB user.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken 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 On the page, click the resource whose DB user you want to modify. PostgreSQL(DBaaS) Details You will be taken to the page.
4. Click the More button, then click the DB User Management button. You will be taken to the DB User Management page.
5. On the DB User Management page, click the Search button. The query may take a short time.
6. If modification is needed, click the Edit button, and change the status field value or enter remarks.
7. When the input is complete, click the Complete button.

Managing DB Access Control

Provides IP-based DB user access control management functionality. Users can directly specify the IPs that can access the database, configuring it so that only authorized IPs are allowed access.

Query DB Access Control

Follow these steps to query DB users with IP access control enabled.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will be taken to the PostgreSQL(DBaaS) List page.
3. On the PostgreSQL(DBaaS) List page, click the resource you want to manage access control for. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB Access Control Management button. You will be taken to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Search button. Retrieving the data may take a short time.

Add DB access control

To add IP access control, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. You will be taken to the PostgreSQL(DBaaS) List page.
3. PostgreSQL(DBaaS) List page, click the resource for which you want to add IP access control. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB Access Control Management button. You will be taken to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Search button. Retrieving the data may take a short time.
6. When the query is complete, click the Add button. The Add DB Access Control popup window opens.
7. Add DB Access Control In the popup window, select the DB username and enter the IP address.
8. When the input is complete, click the Complete button.

Delete DB access control

To delete IP access control, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken 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 for which you want to delete IP access control. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button, then click the DB Access Control Management button. You will be taken to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Search button. Retrieving the data may take a short time.
6. When the query is complete, click the Delete button. The Delete popup window will open.
7. Click the Confirm button on the Delete popup.

Manage Archive

Provides the ability to configure Archive mode and set the retention period for Archive logs, allowing users to flexibly configure Archive log management policies to suit their operational environment. Additionally, it provides a feature to manually delete Archive logs, allowing you to clean up unnecessary log data and manage system resources effectively.

Configure Archive mode

To set the Archive mode, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken 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 page: click the resource for which you want to set Archive mode. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the Archive Settings Management button. You will be taken to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Search button. Retrieval may take a short time.
6. Click the Edit button and select the usage status and retention period.
7. When the edit is complete, click the Done button.

Delete Archive file

To delete the Archive file, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) 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 page, click the resource for which you want to set Archive mode. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the Archive Settings Management button. You will be taken to the Archive Settings Management page.
5. Archive Settings Management page, if you want to delete all Archive files, click the Delete All Archives button; if you only want to delete backed-up Archive files, click the Delete Backed-up Archives button.

Modify Audit Settings

You can change the Audit log storage settings for PostgreSQL (DBaaS).

Follow these steps to change the Audit log storage settings for PostgreSQL (DBaaS).

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. You will be taken to the PostgreSQL(DBaaS) List page.
3. PostgreSQL(DBaaS) List page: click the resource to view the service status. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the Edit icon of Audit Settings at the bottom of the detailed information. The Edit Audit Settings popup window opens.
5. Edit Audit Settings After modifying the usage in the popup window, click the Confirm button.
   • When Enable is selected, the Audit log feature is configured. Enabling the Audit log may degrade DB performance.
   • If you turn off Use, the Audit log storage file will be deleted. Before turning it off, back up the Audit log file separately.

DB Log Export

Supports exporting log data that requires long-term retention among audit logs to Object Storage. Users can directly configure the log types to be stored, the target bucket for export, and the export interval. Based on the configured criteria, logs are copied to the specified Object Storage for retention. Additionally, to efficiently manage disk space, we provide an option that exports logs to Object Storage while automatically deleting the original log files. By using this option, you can effectively free up storage capacity while safely retaining the necessary log data for long-term archiving.

Setting DB Log Export Mode

To set the DB Log export mode, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) 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 page, click the resource you want to export the DB Log from. PostgreSQL(DBaaS) Details page will open.
4. Click the More button, then click the DB Log Export button. You will be taken to the DB Log Export page.
5. On the DB Log Export page, click the Register button. You will be taken to the DB Log Export Register page.
6. On the DB Log Export Registration page, after entering the required information, click the Complete button.

   Category	Required	Detailed description
   Log type	Required	Log type to be saved
   Save bucket name	Required	Object Storage bucket name to be saved
   Authentication key > Access key	Required	Access key for accessing the Object Storage you want to store
   Authentication key > Secret key	Required	Secret key for accessing the Object Storage you want to store
   File creation cycle	Required	File creation frequency in Object Storage
   Whether to delete original logs	Selection	Whether to delete the original logs when exporting to Object Storage

   Table. PostgreSQL (DBaaS) DB Log Export Configuration Items

Managing DB Log Export

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

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. Click the Service Home page’s PostgreSQL(DBaaS) menu. You will be taken to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to manage DB Log export for on the PostgreSQL(DBaaS) List page. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button, then click the DB Log Export button. You will be taken 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, then click Export Now, Edit, or Cancel.
   • Export Immediately: The selected logs are exported to the bucket of the previously configured Object Storage.
   • Edit: Modify the DB Log export mode setting.
   • Cancel: Cancel the DB Log export mode setting.

Minor Version Upgrade

We provide version upgrade functionality for some feature improvements and security patches. Only Minor version upgrades within the same Major version are supported.

To upgrade the Minor Version, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. You will be taken to the PostgreSQL(DBaaS) List page.
3. On the PostgreSQL(DBaaS) List page, click the resource to upgrade the version. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the Edit button in the Image version item. The Version Upgrade popup window opens.
5. Version Upgrade In the popup, select the updated version and backup setting, then click the Confirm button.
6. Version Upgrade Notification Click the Confirm button in the popup window.

Configure Migration

Provides a Migration feature that synchronizes in real time with the live database and replicates using a Replication method without service interruption.

To configure Migration, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. From the Service Home page, click the PostgreSQL(DBaaS) menu. You will be taken to the PostgreSQL(DBaaS) List page.
3. On the PostgreSQL(DBaaS) List page, click the resource to migrate. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button, then click the Migration configuration button. The Migration configuration popup opens.
5. In the popup window, review the instructions and click the Confirm button. You will be taken to the Migration configuration page.
6. Migration Configuration page, after entering the required information, click the Check Connection button.
7. When the connection is complete, click the Complete button.

   Category	Required	Detailed description
   Source DB Database name	Required	Database name of the source DB to be migrated
   Source DB IP	Required	IP of the Source DB that is the migration target
   Source DB Port	Required	Port of the Source DB to be migrated
   Source DB username	Required	Username of the source DB that is the migration target
   Source DB password	Required	Password of the source DB that is the migration target

   Table. PostgreSQL (DBaaS) migration configuration items

Promote Migration Cluster to Master Cluster

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

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

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

Upgrade OS Kernel

The OS kernel can be upgraded to improve the functionality of the running database and apply security patches.

To upgrade the OS kernel, follow the steps below.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will be taken to the Service Home page of PostgreSQL(DBaaS).
2. From the Service Home page, click the PostgreSQL(DBaaS) menu. You will be taken to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) List page, click the resource to upgrade the OS Kernel. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button, then click the OS(Kernel) Upgrade button. The OS(Kernel) Upgrade Notification popup window opens.
5. OS(Kernel) Upgrade Notification In the popup window, review the instructions and click the Confirm button.

2.2.2 - Backing up and restoring the DB

Users can configure backups of PostgreSQL (DBaaS) through the Samsung Cloud Platform Console and restore from the backed‑up files.

Backing up PostgreSQL(DBaaS)

PostgreSQL (DBaaS) provides a data backup feature based on its own backup commands. Additionally, it provides an optimized backup environment for data protection and management through backup history verification and backup file deletion features.

Configure backup

For backup configuration of PostgreSQL(DBaaS), refer to PostgreSQL(DBaaS) 생성하기.

To modify the backup settings of the created resource, follow the steps below.

To set up a backup, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. 1. Navigate to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. PostgreSQL(DBaaS) List page, click the resource you want to configure backup for. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Click the Edit button of the backup item. 4. Backup Settings popup window opens.
5. When setting up a backup, click Enable in the Backup Settings popup, select the retention period, backup start time, and Archive backup interval, and then click the Confirm button.
   • If you stop the backup configuration, deselect Use in the Backup Settings popup and authenticate using the logged-in user’s mobile phone.
     Once user authentication is complete, the backup configuration is disabled and backup execution stops.

Check Backup History

To view the backup history, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. PostgreSQL(DBaaS) List page, click the resource to view the backup history. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Click the Backup History button. 4. Backup History The popup window opens.
5. Backup History In the popup window, you can view the backup status, version, backup start time, backup completion time, and size.

Delete backup file

To delete the backup history, follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. Navigate to the PostgreSQL (DBaaS) List page.
3. PostgreSQL(DBaaS) List page, click the resource to view the backup history. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Click the Backup History button. 4. Backup History The popup window opens.
5. Backup History In the popup window, check the files you want to delete, then authenticate using the logged-in user’s mobile phone.
   • When user authentication is completed, the backup file is deleted.

PostgreSQL(DBaaS) Recover

If a failure or data loss requires restoration from a backup file, you can recover using the recovery feature based on a specific point in time. When performing a PostgreSQL (DBaaS) recovery, a new server is created with the OS image from the initial provisioning point, the database is installed with the version from the backup point, and the recovery proceeds with the database’s configuration information and data.

To recover PostgreSQL (DBaaS), follow these steps.

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. PostgreSQL(DBaaS) resource Click the resource you want to restore on the list page. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Click the Database Recovery button. 4. Go to the Database Recovery page.
5. After entering the relevant information in the Database Recovery Configuration area, click the Complete button.

   Category	required status	Detailed description
   Recovery Type	Required	Set the point in time the user wants to recover Backup point (recommended): Recover based on the backup file. Select from the list of backup points displayed in the list Custom point: Recover to a user-specified point within the range of recoverable backup times. The recoverable period depends on the Archive backup cycle setting, allowing recovery from the start of the first backup up to 1 hour/30 minutes/10 minutes/5 minutes before the current time. Select the desired date and time for the backup
   server name prefix	Essential	Recovery DB server name must start with a lowercase English letter and use lowercase letters, numbers, and special characters (-) to input 3 to 16 characters A postfix such as 001, 002 is appended to the base server name, generating the actual server name
   Cluster name	Required	Cluster name of the recovery DB Enter using English letters, 3 ~ 20 characters A cluster is a unit that groups multiple servers
   Service Type > Server Type	Required	Server type for the recovery DB installation Standard: standard specifications commonly used High Capacity: large-capacity server with 24 vCores or more
   Service Type > Planned Compute	Select	Status of resources with Planned Compute configured In Use: Number of resources with Planned Compute that are currently in use Configured: Number of resources with Planned Compute configured Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Navigate to the Planned Compute service request page For more details, see Planned Compute 신청하기
   Service Type > Block Storage	Required	Block Storage settings used by the recovery DB Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Same as the storage type set in the original cluster Enter capacity as a multiple of 8 within the range 16 to 5,120 Additional: Storage area for DATA, Archive, TEMP, Backup data Same as the storage type set in the original cluster In the recovery DB, only DATA, TEMP, and Archive purposes can be added. After selecting Use, enter the storage purpose and capacity To add storage, click the Add button; to delete, click the x button Capacity can be entered as a multiple of 8 within the range 16 to 5,120, and up to 9 can be created
   Database username	Required	Database username configured in the source DB
   Database Port number	Required	Database port number configured in the source DB
   IP access control	Select	IP address for accessing the recovery DB Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.1/32, 192.168.10.1/32), then click the Add button To delete an entered IP, click the x button next to the entered IP
   maintenance period	Select	Database maintenance window If you select Use, set the day of week, start time, and duration It is recommended to set a maintenance window for stable DB management. Patch operations will be performed at the scheduled time, causing service interruption If set to unused, Samsung SDS is not responsible for issues arising from unapplied patches.
   Tag	Select	Add Tag Add Tag after clicking the button Enter or select Key, Value values

   Table. PostgreSQL (DBaaS) recovery configuration items

2.2.3 - Configure Read Replica

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

Configure Replica

Through 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. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. On the PostgreSQL(DBaaS) List page, click the resource to configure a Replica. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Click the Replica configuration button. 4. Go to the Replica configuration page.
5. After entering the information in the Replica configuration area, click the Complete button.

   Category	required status	Detailed description
   Region	Required	Region to configure the Replica Replica configuration (Other Region)is displayed only when selected
   Replica count	Required	Number of Replicas to configure Up to 5 can be configured per cluster If you select more than one value, additionally enter the Replica name and service type information
   Replica name	Required	Replica server name must start with a lowercase English letter, and using lowercase letters, numbers, and special characters(-) enter 3 to 19 characters The entered Replica name is displayed as the cluster name in the list
   Service Type > Server Type	Essential	Replica server type Standard: standard specification commonly used High Capacity: large-capacity server with 24 vCores or more
   Service Type > Planned Compute	Select	Status of resources with Planned Compute configured In Use: Number of resources with Planned Compute configured that are currently in use Configured: Number of resources with Planned Compute configured Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Navigate to the Planned Compute service application page For more details, see Planned Compute 신청하기
   Service Type > Block Storage	Required	Block Storage configuration for using a replica DB Basic OS: Area used on the server where the DB is installed Applied identically according to the storage type set in the source DB Capacity cannot be set DATA: Storage area for table data, archive files, etc. Applied identically according to the storage type set in the source DB Capacity cannot be set Additional: Storage area for DATA, Archive, TEMP, Backup data Applied identically according to the storage type set in the source DB In a replica, only DATA and TEMP purposes can be added After selecting Use, enter the storage purpose and capacity. Capacity must be a multiple of 8 within the range 16 to 5,120 To add storage, click the Add button; to delete, click the x button. Up to 9 can be added.
   IP access control	Select	Service Access Policy Configuration Since the access policy is set for the IP entered on the page, a separate Security Group policy configuration is not required Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.0/24, 192.168.10.1/32) and click the Add button To delete an entered IP, click the x button next to the entered IP
   maintenance period	Select	Database maintenance window Select Use to set the day, start time, and duration It is recommended to configure a maintenance window for stable database management. Patch operations will be performed at the scheduled time, causing service interruption If set to unused, we are not responsible for issues arising from patches not being applied.
   tag	Selection	Add Tag Add Tag After clicking the Add Tag button, enter or select Key and Value

   Table. PostgreSQL (DBaaS) Replica configuration items

Reconfigure Replica

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

To reconfigure the Replica, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. On the PostgreSQL(DBaaS) List page, click the resource to reconfigure the replica. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Replica Reconstruction Click the button. 4. Replica Reconfiguration Notification A popup window opens.
5. Replica Reconfiguration Notification popup window, click the Confirm button.

Promoting a Replica Cluster to a Master Cluster

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

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

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. 1. Go to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. PostgreSQL(DBaaS) List page, click the resource to promote to Master. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Click the More button, then click the Master Promotion button. 4. Master Promotion Notification The popup window opens.
5. Master Promotion Notification In the popup window, click the Confirm button.

2.2.4 - DB Server Connection

Scenario Overview

PostgreSQL(DBaaS) Server Connection The scenario involves creating a Bastion host (Virtual Server) and a Database service, and accessing the DB service through the Bastion host. To reliably connect to PostgreSQL (DBaaS) in the Samsung Cloud Platform environment, you need to create a Bastion host and establish network connectivity using it. It is recommended to configure the Database service in a Private Subnet environment and the Bastion host in a restricted Public Subnet environment to maintain stability and a high level of security.

This scenario primarily describes creating a Bastion host and a Database service, configuring the network environment for Bastion host and Database access, and connecting through a DB client.

Scenario components

You can build the scenario using the following services.

Scenario setup method

Create the services needed to build the scenario by following the steps below.

Set up the network

This explains the process of configuring the network environment for accessing the Bastion Host and Database services.

1-1. Create VPC

1. Click the All Services > Networking > VPC menu. You will be taken to the VPC Service Home page.
2. Click the VPC Creation button on the Service Home page. You will be taken to the VPC Creation page.
3. On the VPC Creation page, enter the information required to create the service.
   • Enter the IP range as 192.168.x.0/16.
4. Summary panel, verify the detailed information and estimated billing amount generated there, and click the Complete button.
   • After creation is complete, check the created resources on the VPC List page.

1-2. Create Subnet

1. Click the All Services > Networking > VPC menu. You will be taken to the VPC Service Home page.
2. On the Service Home page, click the Subnet menu. You will be taken to the Subnet List page.
3. Click the Create Subnet button. You will be taken to the Create Subnet page.
4. On the Subnet Creation page, enter the information required to create the service.
   • Select the Subnet type as General.
   • Select a pre‑created VPC.
   • Enter the IP range as 192.168.x.0/24.
5. 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 resources on the Subnet List page.

1-3. Create Internet Gateway

1. Click the All Services > Networking > VPC menu. Go to the VPC’s Service Home page.
2. On the Service Home page, click the Internet Gateway menu. You will be taken to the Internet Gateway List page.
3. Click the Create Internet Gateway button. You will be taken to the Create Internet Gateway page.
4. On the Internet Gateway Creation page, enter the required information to create the service.
   • Select a pre‑created VPC.
   • In the Firewall usage option, select Use.
5. 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 Internet Gateway list page.

1-4. Create Public IP

1. Click the All Services > Networking > VPC menu. Navigate to the VPC’s Service Home page.
2. On the Service Home page, click the Public IP menu. You will be taken to the Public IP List page.
3. Click the Public IP Reservation button. You will be taken to the Public IP Reservation page.
4. On the Public IP reservation page, enter the required information needed to reserve the service.
5. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.
   • After creation is complete, check the created resources on the Public IP List page.

1-5. Create Security Group

1. Click the All Services > Networking > Security Group menu. Navigate to the Service Home page of Security Group.
2. Click the Create Security Group button on the Service Home page. You will be taken to the Create Security Group page.
3. Security Group creation Enter the required information needed to create the service on the page.
4. Check the input information and click the Complete button.
   • When creation is complete, check the created resources on the Security Group List page.

Create bastion host

Describes the process of configuring a Bastion Host that requires the database client to be installed.

2-1. Create Server Keypair

1. Click the All Services > Compute > Virtual Server menu. Navigate to the Service Home page of Virtual Server.
2. On the Service Home page, click the Keypair menu. You will be taken to the Keypair List page.
3. Click the Create Keypair button. You will be taken to the Create Keypair page.
4. On the Keypair Creation page, enter the required information needed to create the service.
5. Verify the creation information and click the Complete button.
   • The key can be downloaded only on the first attempt, and reissuance is not available.
   • Please store the downloaded key in a secure location.

2-2. Create Bastion host

1. Click the All Services > Compute > Virtual Server menu. Navigate to the Service Home page of Virtual Server.
2. On the Service Home page, click the Virtual Server Creation button. You will be taken to the Virtual Server Creation page.
3. On the Virtual Server Creation page, enter the required information to create the service.
   • Select Windows for the image.
   • Select the pre‑created VPC and Subnet.
   • Click Use NAT, and select the reserved Public IP from 1-4. Create Public IP.
   • 2-1. Create Server Keypair Connect the Keypair created there.
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 resources on the Virtual Server List page.

2-3. Verify Bastion host login ID and password

1. Click the All Services > Compute > Virtual Server menu. Navigate to the Service Home page of Virtual Server.
2. Click the Virtual Server menu on the Service Home page. You will be taken to the Virtual Server List page.
3. On the Virtual Serve List page, click the resource you created in 2-2. Bastion host Create. You will be taken to that resource’s detailed information page.
4. On the detail page, click the RDP password view button in the Keypair name field. The RDP password view popup window will open.
5. In the RDP password lookup popup window, attach the keypair file downloaded from 2-1. 서버 Keypair 생성하기.
6. After attaching, click the Password Check button. The ID and Password required to access the resource are displayed.
   • The ID and password will later be used as credentials to access the Bastion host in 5-1. Bastion host Connecting.

Create Database

Describes the process of creating a Database service.

3-1. Create PostgreSQL (DBaaS) Service

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) Create button on the Service Home page. You will be taken to the PostgreSQL(DBaaS) Create page.
3. PostgreSQL(DBaaS) Creation On the page, enter the required information to create the service.
   • Select the pre‑created VPC and Subnet and connect them.
   • Enter the database-related creation information on the required information input screen.
   • Add the Bastion host IP in the IP access control section.
   • The Database Port defaults to 2866, but the user can also specify it.
4. In the Summary panel, verify the detailed information and estimated billing amount, then click the Complete button.
   • After creation is complete, verify the created resource on the PostgreSQL(DBaaS) list page.

Configuring Rules

It explains the process of configuring rules for a user to connect to the Bastion host and rules for connecting to the Database from the Bastion host.

4-1. Security Group Add Security Rules

1. Click the All Services > Networking > Security Group menu. Navigate to the Service Home page of Security Group.
2. From the Service Home page, click the Security Group menu. You will be taken to the Security Group List page.
3. Select the Security Group resource created in 1-5. Create Security Group. Navigate to the detailed information page of that resource.
4. Click the Rules tab on the detail page. You will be taken to the Rules tab.
5. On the Rules tab, click the Add Rule button. You will be taken to the Add Rule popup.
6. Add Rule In the popup window, enter the rule below, and click the Confirm button.

   direction	remote	Target address	Protocol	Port	Explanation
   Inbound	CIDR	User PC IP	TCP	3389 (RDP)	Bastion client PC → Bastion host
   Outbound	CIDR	DB IP	TCP	Database Port (manual entry)	Bastion host → Database

   Table: Security Group rules that need to be added

4-2. Add IGW Firewall Rule

1. All Services > Networking > Firewall Click the menu. Go to the Service Home page of the Firewall.
2. On the Service Home page, click the Firewall menu. You will be taken to the Firewall List page.
3. On the Firewall List page, select the Internet Gateway resource name created in 1-3. Internet Gateway Creation. You will be taken to the detailed information page of that resource.
4. Click the Rules tab on the detail information page. You will be taken to the Rules tab.
5. Click the Add Rule button on the Rules tab. You will be taken to the Add Rule popup.
6. Add Rule In the popup window, enter the rule below, and click the Confirm button.

   origin address	Destination address	Protocol	Port	Operation	direction	Explanation
   Bastion connection PC IP	Bastion host IP	TCP	3389(RDP)	Allow	Inbound	User PC → Bastion host

   Table. Internet Gateway Firewall rules that need to be added

Connect to Database

Describes the process of a user accessing the database via a DB client program.

This guide explains how to connect using pgAdmin. Since there are various database client programs and CLI utilities, you may install and use the tool that best fits your needs.

5-1. Connecting to Bastion host

1. In the Windows environment of the PC that will connect to the Bastion host, run Remote Desktop Connection, then enter the NAT IP of the Bastion Host and click the Connect button.
2. When the remote desktop connection succeeds, the user credential input window opens. Enter the ID and Password you verified in 2-3. Bastion host access ID and PW verification and click the Confirm button.

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

1. Go to the official pgAdmin page and download the pgAdmin program.
   • pgAdmin program download URL: https://www.pgadmin.org/download/
2. Connect the user’s PC hard drive to upload the file to the Bastion host.
3. In the Local Resources tab of the Remote Desktop Connection, click the Details button for the Local Devices and Resources item.
4. Select the local disk of the location where the file was downloaded on the drive, and click the OK button.
5. Copy the downloaded file, upload it to the Bastion Host, and click the pgAdmin installer to install.

5-3. Connect to the database using the DB client program (pgAdmin)

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) 서비스 생성하기 into the General and Connection tabs, and click the Save button.

   Screen (tab)	Required input field	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

   Table.DB connection client program input fields
3. Click the name of the database created in pgAdmin to connect.
   • After connecting, you can perform simple queries, among other tasks.

2.2.5 - Extension Use

PostgreSQL(DBaaS) Extension usage

You can view the list of extensions that can be installed in the current database with the SQL statement below.

SQL> select * from pg_available_extensions;

PostgreSQL (DBaaS) includes the following items in addition to the default extensions for each version.

If you need to install additional extensions beyond the items above, refer to Support Center > Inquiry and contact us.

• After a request is received, we will review it and proceed with installation. Please note that some extensions may not function properly 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 contents of the Active server change, they are synchronously replicated to the Standby server, and up to five read‑only Replica servers for read load balancing and disaster recovery (DR) are provided. Additionally, it provides an automatic backup feature at user-specified times to prepare for issues with the DB server or data, enabling recovery of data at the desired point in time.

Provided Features

MariaDB (DBaaS) provides the following features.

• Auto Provisioning (Auto Provisioning): Allows installation and configuration of Database(DB) via UI, and provides an Active-standby redundancy configuration based on storage replication. * When the active server fails, 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, you can restart if there is a DB issue or to apply configuration changes. * When high availability (HA) is configured, the user can manually perform node switching between Active and Standby via a switch‑over.
• Backup and Recovery: Provides data backup functionality based on its own backup commands. * Backup time windows and storage locations can be set by the user, and additional fees are incurred based on the backup size. * It also provides a recovery function for backed‑up data, so when the user performs a recovery, a separate database is created and the recovery proceeds to the point in time selected by the user (the backup save point or a user‑specified point). * When restoring to a user-specified point in time, the restore point can be set up to 5 minutes, 10 minutes, 30 minutes, or 1 hour earlier, based on the stored backup and archive files.
• Version Management: Provides a version upgrade (Minor) feature based on some functionality improvements and security patches. * Whether to perform a backup for a version upgrade can be selected by the user, and if a backup is performed, the data is backed up before applying the patch, after which the DB engine is updated.
• Replica configuration: Up to five Read Replicas can be configured in the same or different regions for read load balancing and disaster recovery (DR).
• Audit configuration: Provides an Audit configuration feature that can monitor users’ DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) operations.
• Parameter management: Performance improvements and security-related DB configuration parameters can be modified.
• Service Status Query: Retrieves the final status of the current DB service.
• Monitoring: CPU, memory, performance monitoring information can be viewed through Cloud Monitoring and Servicewatch.
• DB User Management: Query and manage the 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 to 35 days) on 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 operational database and support migration using replication without service interruption.
• OS Kernel Upgrade: You can upgrade the OS Kernel to apply some feature improvements and security patches.

Component

MariaDB(DBaaS) provides pre‑validated engine versions and various server types in accordance with its open‑source support policy. Users can select and use it based on the scale of the service they wish 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 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.

• 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 offered by MariaDB (DBaaS), refer to MariaDB(DBaaS) Server Types.

Standard db1v2m4

Preceding Service

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

3.1.1 - Server Types

MariaDB(DBaaS) server type

MariaDB(DBaaS) provides server types composed of various combinations of CPU, memory, and network bandwidth. When creating a MariaDB(DBaaS), the Database Engine is installed according to the server type selected for 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 offered with standard specifications (vCPU, Memory) and is suitable for various database workloads.

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