How-to guides

• 1: Managing DB Services
• 2: Backing up and restoring the DB
• 3: Configure Read Replica
• 4: EPAS (DBaaS) server connection
• 5: Extension Usage

1 - Managing DB Services

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

Parameter Management

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

View Parameter

Follow these steps to retrieve configuration parameters.

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 view or modify parameters. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the More button, then click the Parameter Management button. 4. Parameter Management The popup window opens.
5. Parameter Management In the popup window, click the Search button. 5. View Notification A popup window opens.
6. When the View Notification popup appears, click the Confirm button. 6. Retrieving may take a short amount of time.

Edit Parameter

Follow the instructions.

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. Navigate to the EPAS (DBaaS) List page.
3. EPAS (DBaaS) List page, click the resource for which you want to view or modify parameters. 3. EPAS(DBaaS) Details Navigate to the page.
4. More button, click it, then click the Parameter Management button. 4. Parameter Management The popup window opens.
5. Parameter Management In the popup window, click the Search button. 5. View Notification A popup window opens.
6. View notification when the popup window opens, click the Confirm button. 6. 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 field of the Parameter to be edited.
8. When the input is complete, click the Done button.

Manage DB Users

Provides administrative features to view DB user information and modify status information.

Query DB Users

To look up DB users, 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 you wish to query the DB user for. 3. Go to the EPAS(DBaaS) Details page.
4. Click the More button and then click the DB User Management button. 4. Go to the DB User Management page.
5. On the DB User Management page, click the Search button. 5. Retrieving may take a short amount of time.

Change DB User Status

To change the status of the retrieved DB user, 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 for which you want to edit the DB user. 3. EPAS(DBaaS) Details Go to the page.
4. Click the More button and then click the DB User Management button. 4. DB User Management go to the page.
5. On the DB User Management page, click the Search button. 5. Retrieving may take a short amount of time.
6. If modification is required, click the Edit button, and change the status area 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 IP addresses that can access the database, configuring it so that only authorized IPs are allowed access.

View DB Access Control

To view DB users with IP access control enabled, follow these steps.

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

Add DB access control

Follow these steps to add IP access control.

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. EPAS (DBaaS) List Navigate to the page.
3. On the EPAS (DBaaS) List page, click the resource for which you want to add IP access control. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the More button, then click the DB Access Control Management button. 4. Go to the DB Access Control Management page.
5. Click the Search button on the DB Access Control Management page. 5. Retrieving may take a short amount of time.
6. When the query is complete, click the Add button. 6. Add DB Access Control A popup window opens.
7. Add DB Access Control In the popup window, select the DB username and enter the IP address.
8. Once the input is complete, click the Save button.

Delete DB access control

To delete IP access control, follow these steps.

1. All Services > Database > EPAS(DBaaS) 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. Navigate to the EPAS (DBaaS) List page.
3. EPAS (DBaaS) List page, click the resource for which you want to delete IP access control. 3. Navigate to the EPAS(DBaaS) Details page.
4. Click the More button, then click the DB Access Control Management button. 4. Navigate to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Search button. 5. Retrieving takes a short amount of time.
6. When the query is complete, click the Delete button. 6. Delete popup window opens.
7. Delete in the popup window Confirm click the button.

Managing Archives

Provides Archive mode configuration and Archive Log retention period settings, allowing users to flexibly configure Archive log management policies to suit their operating 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. 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. EPAS (DBaaS) List page is accessed.
3. On the EPAS (DBaaS) List page, click the resource for which you want to set Archive mode. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the More button, then click the Archive Settings Management button. 4. Go to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Search button. 5. Retrieving may take a short amount of 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. All Services > Database > EPAS(DBaaS) Click the menu. 1. Navigate to the Service Home page of EPAS (DBaaS).
2. Service Home 페이지에서 EPAS(DBaaS) 메뉴를 클릭하세요. 2. Navigate to the EPAS (DBaaS) List page.
3. EPAS(DBaaS) List Click the resource on the page for which you want to set Archive mode. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the More button and then click the Archive Settings Management button. 4. Go 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 want to delete only backed‑up Archive files, click the Delete Backed‑up Archives button.

Modify Audit Settings

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

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

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. EPAS (DBaaS) List Navigate to the page.
3. On the EPAS (DBaaS) List page, click the resource to view the service status. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the Edit icon of Audit Settings at the bottom of the detailed information. 4. Edit Audit Settings A popup window opens.
5. Modify Audit Settings After changing the usage in the popup window, click the Confirm button.
   • When Use is selected, the Audit log feature is enabled. * Enabling audit logging may degrade database performance.
   • If you disable use, the Audit log storage file will be deleted. * Back up the Audit log file separately before disabling.

Export DB Log

Supports exporting log data that requires long-term retention among audit (Audit) logs to Object Storage. Users can directly configure the log types that need to be stored, the destination Bucket for export, and the log export interval. Copies logs to the specified Object Storage for retention according to the configured criteria. 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 the long term.

Setting DB Log Export Mode

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

1. Click the All Services > Database > EPAS(DBaaS) menu. 1. Navigate to the Service Home page of EPAS (DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. 2. Go 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. 3. Go to the EPAS(DBaaS) Details page.
4. Click the More button and then click the DB Log Export button. 4. Navigate to the DB Log Export page.
5. On the DB Log Export page, click the Register button. 5. Go to the Register DB Log Export 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 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 the steps below.

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. Navigate to the EPAS (DBaaS) List page.
3. EPAS (DBaaS) List page, click the resource you want to manage DB Log export for. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the More button and then click the DB Log Export button. 4. Go to the Export DB Log page.
5. On the DB Log Export page, depending on the log type you want to manage, click the More button and then click the Export Now, Edit, or 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: Cancels the DB Log export mode setting.

Minor version upgrade

If a latest patch that includes security enhancements and feature improvements is available, it can be applied through the version upgrade feature. Only minor version upgrades are supported within the same major version.

To perform a minor version upgrade, follow the steps below.

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. EPAS (DBaaS) List Navigate to the page.
3. On the EPAS(DBaaS) List page, click the resource to upgrade the Minor version. 3. EPAS(DBaaS) Details Navigate to the page.
4. 4. Version Upgrade The popup window opens.
5. Version Upgrade In the popup window, select the updated version, then click the Confirm button.
6. Version Upgrade Notification Click the OK button in the popup window.

Configure Migration

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

To configure Migration, 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 the EPAS (DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource to migrate. 3. Go to the EPAS(DBaaS) Details page.
4. Click the More button and click the Migration Configuration button. 4. Migration Configuration The popup window opens.
5. Migration configuration In the popup window, review the instructions and click the Confirm button. 5. Go to the Migration configuration page.
6. After entering the required information on the Migration configuration page, 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 to be migrated
   Source DB password	Required	Password of the source DB that is the migration target

   Table. EPAS (DBaaS) Migration Configuration Items

Promote Migration Cluster to Master Cluster

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

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

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

Managing Block Storage Usage

You can view the usage of Block Storage by type allocated to the DB instance.

To view Block Storage usage, 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. Navigate to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource to view Block Storage usage. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the More button and then click the Block Storage Usage Management button. 4. Go to the Block Storage Usage Management page.
5. On the Block Storage Usage Management page, click the View button. 5. Block Storage Usage Management The page displays usage by Block Storage type.
   • Retrieving usage by Block Storage type takes a short amount of time.

Upgrade OS Kernel

You can upgrade the OS kernel to improve the functionality of the running database and apply security patches.

To upgrade the OS Kernel, 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. Navigate to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource to upgrade the OS Kernel. 3. EPAS(DBaaS) Details Navigate to the page.
4. Click the More button, then click the OS(Kernel) Upgrade button. 4. OS(Kernel) Upgrade Notification A popup window opens.
5. OS(Kernel) Upgrade Notification Check the instructions in the popup window and click the Confirm button.

2 - Backing up and restoring the DB

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

EPAS(DBaaS) Backing up

To ensure that user data is stored securely, 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

Refer to EPAS(DBaaS) 생성하기 for how to configure backup settings for EPAS (DBaaS).

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

To set up a backup, 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. Navigate to the EPAS(DBaaS) List page.
3. On the EPAS (DBaaS) List page, click the resource you want to configure backup for. 3. Go to the EPAS(DBaaS) Details page.
4. Click the Edit button of the backup item. 4. Backup Settings The popup window opens.
5. When configuring a backup, click Use in the Backup Settings popup, select retention period, backup start time, and Archive backup interval, then click the Confirm button.
   • If you want to stop the backup setting, deselect Use in the Backup Settings popup window and authenticate via the logged-in user’s mobile phone.
     Once user authentication is completed, the backup setting is disabled and backup execution stops.

Perform immediate backup

If additional data protection is required, you can quickly create a backup using the instant backup feature.

To perform an immediate backup, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) menu. 1. Navigate 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 to perform an immediate backup. 3. Go to the EPAS(DBaaS) Details page.
4. Click the Immediate Backup button of the backup item. 4. Immediate Backup Settings popup window opens.
5. In the Immediate backup setup popup, click the Confirm button.

Check backup history

To view the backup history, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) menu. 1. Navigate to the Service Home page of EPAS (DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. 2. Go to the EPAS (DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource to view the backup history. 3. Navigate 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, 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) 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. Navigate to the EPAS(DBaaS) List page.
3. EPAS(DBaaS) List page, click the resource to view the backup history. 3. Navigate 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 will be deleted.

Recover EPAS(DBaaS)

If a failure or data loss occurs and restoration from a backup file is required, recovery can be performed based on a specific point in time using the recovery feature. When you perform 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 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. Navigate to the Service Home page of EPAS (DBaaS).
2. Click the EPAS(DBaaS) menu on the Service Home page. 2. EPAS (DBaaS) List Navigate to the page.
3. EPAS(DBaaS) resource On the list page, click the resource you want to recover. 3. EPAS(DBaaS) Details page is accessed.
4. Click the Database Recovery button. 4. Go to the Database Recovery page.
5. Database Recovery Configuration After entering the relevant information in the area, click the Complete button.

   	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 file timestamps displayed in the list Custom point: Recover to a user‑desired point within the range where backups are possible. The recoverable period depends on the Archive backup cycle setting, allowing recovery from the initial backup start time up to 1 hour/30 minutes/10 minutes/5 minutes before the current time. Select the date and time to back up
   Server name prefix	Required	Recovery DB server name Start with a lowercase English letter, then use lowercase letters, numbers, and special characters (-) to input 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 ~ 20 characters A cluster is a unit that groups multiple servers
   Service Type > Server Type	Required	Recovery DB server type Standard: standard specifications commonly used High Capacity: large-capacity server with 24vCore or more
   Service Type > Planned Compute	Selection	Planned Compute가 설정된 자원 현황 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 by Planned Compute per resource Create Planned Compute Service: Go to the Planned Compute service application 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. 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; 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 as set in the original cluster
   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	DB maintenance window Use if selected, you can set the day of the week, start time, and duration The maintenance window is a feature that lets the user define the time slot for patch operations, and any patch work during that period must be performed directly by the user. We ask you to set a maintenance window for the stable operation of the system; we are not responsible for any problems arising from not setting it or from failure to perform tasks within the designated period.
   tag	Selection	Add Tag After clicking the Add Tag button, enter or select Key, Value values

   Table. EPAS (DBaaS) recovery configuration items

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.

4 - EPAS (DBaaS) server connection

Scenario Overview

EPAS(DBaaS) Server Connection scenario creates a Bastion host (Virtual Server) and a Database service, and accesses 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, we recommend configuring the Database service in a Private Subnet environment and setting up the Bastion host in a restricted Public Subnet environment.

This scenario primarily describes creating a Bastion host and 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 procedure below.

1. ## Configure Network

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

1-1. ### Create VPC

1. All Services > Networking > VPC Click the menu. 1. Navigate to the VPC’s Service Home page.
2. On the Service Home page, click the Create VPC button. 2. Navigate 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.
   • When creation is complete, check the created resources on the VPC List page.

1-2. ### Create Subnet

1. All Services > Networking > VPC Click the menu. 1. Navigate to the VPC’s Service Home page.
2. On the Service Home page, click the Subnet menu. 2. Navigate to the Subnet list page.
3. Create Subnet Click the button. 3. Navigate to the Subnet Creation 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.
   • After creation is complete, check the created resources on the Subnet List page.

1-3. ### Create Internet Gateway

1. All Services > Networking > VPC Click the menu. 1. Navigate to the VPC’s Service Home page.
2. On the Service Home page, click the Internet Gateway menu. 2. Internet Gateway List Navigate to the page.
3. Internet Gateway creation Click the button. 3. Go 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 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. All Services > Networking > VPC Click the menu. 1. Navigate to the VPC’s Service Home page.
2. On the Service Home page, click the Public IP menu. 2. Go to the Public IP List page.
3. Public IP reservation Click the button. 3. Navigate to the Public IP reservation page.
4. On the Public IP reservation page, enter the required information for service reservation.
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. 1. Go to the Service Home page of the Security Group.
2. On the Service Home page, click the Create Security Group button. 2. Go to the Security Group Creation page.
3. On the Security Group creation page, enter the required information to create the service.
4. Check the input information and click the Done button.
   • After creation is complete, verify the created resources on the Security Group List page.

2. ## Create Bastion host

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

2-1. ### Create Server Keypair

1. All Services > Compute > Virtual Server Click the menu. 1. Navigate to the Service Home page of the Virtual Server.
2. On the Service Home page, click the Keypair menu. 2. Go to the Keypair List page.
3. Create Keypair button, click it. 3. Go to the Keypair creation 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 for the first time, and reissuance is not provided.
   • Please store the downloaded key in a secure location.

2-2. ### Create Bastion host

1. Click the All Services > Compute > Virtual Server menu. 1. Navigate to the Service Home page of the Virtual Server.
2. On the Service Home page, click the Create Virtual Server button. 2. Go to the Create Virtual Server page.
3. On the Virtual Server Creation page, enter the required essential information needed 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. Public IP 생성하기.
   • Connect the Keypair 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.
   • When creation is complete, check the created resources on the Virtual Server list page.

2-3. ### Check Bastion host login ID and PW

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

3. ## Create Database

Describes the process of creating a Database service.

3-1. ### EPAS(DBaaS) Service Creation

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. Create EPAS(DBaaS) Navigate to the page.
3. Enter the required information needed to create the service on the EPAS(DBaaS) creation page.
   • Select the pre‑created VPC and Subnet and connect them.
   • Enter database-related creation information on the required information input screen.
   • Add the Bastion host IP in the IP access control item.
   • The database port defaults to 2866, but users can also specify a different one.
4. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.
   • Once creation is complete, check the created resource on the EPAS(DBaaS) list page.

4. ## Configure Rules

Describes the process of setting rules for users to connect to the Bastion host and rules for connecting to the Database from the Bastion host.

4-1. ### Security Group Add security rule

1. Click the All Services > Networking > Security Group menu. 1. Go to the Service Home page of the Security Group.
2. On the Service Home page, click the Security Group menu. 2. Navigate to the Security Group List page.
3. 1-5. 3. Security Group CreateSelect the Security Group resource created in 3. Go to the detailed information page for the resource.
4. On the detail information page, click the Rules tab. 4. Go to the Rules tab.
5. Click the Add Rule button on the Rule tab. 5. Add Rule Navigate to the popup window.
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 access 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 > FirewallClick the menu. 1. Navigate to the Firewall’s Service Home page.
2. On the Service Home page, click the Firewall menu. 2. Go to the Firewall List page.
3. On the Firewall List page, select the Internet Gateway resource name created in 1-3. Internet Gateway 생성하기. 3. Go to the detailed information page for the resource.
4. On the detail information page, click the Rules tab. 4. Go to the Rules tab.
5. Click the Add Rule button on the Rule tab. 5. Add Rule Navigate to the popup window.
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 to be added

5. ## Database Connect

Describes the process of a user connecting to a database through a DB client program.

This guide explains how to connect using pgAdmin. Database client programs and CLI utilities are diverse, so you can install and use the tool that best suits 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, user credential input window opens. 2. Enter the ID and Password verified in 2-3. Bastion host 접속 ID 및 PW 확인하기 and click the Confirm button.

5-2. ### Install the 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. Click the Details button of the Local devices and resources item on the Local Resources tab of the Remote Desktop Connection.
4. Select the local disk of the location where the file was downloaded on the drive, and click the Confirm button.
5. Copy the downloaded file, upload it to the Bastion Host, and click the pgAdmin installer to install it.

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, enter the Database server information created in 3-1. EPAS(DBaaS) 서비스 생성하기 into the General and Connection tabs, and click the Save button.

   Screen (tab)	Required input element item	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, etc.

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.