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 an EPAS (DBaaS)

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

To create an EPAS (DBaaS), follow these steps.

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

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

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

   • Select the required information in the Image and Version Selection area.

     Category	Required	Detailed Description
     Image version	Required	Provide the version list for EPAS (DBaaS)

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

     Category	Required	Detailed Description
     Server Name Prefix	Required	Server name where the DB will be installed Must start with a lowercase letter and be 3 to 13 characters long, using lowercase letters, numbers, and special characters (-) A postfix such as 001 or 002 is appended to the server name to generate the actual server name
     Cluster Name	Required	The cluster name in which the DB servers are configured Enter 3 to 20 characters using English letters A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type for the DB installation Standard: Standard specifications commonly used High Capacity: High-capacity servers with 24 vCores or more For details on the server types provided by EPAS(DBaaS), refer to EPAS(DBaaS) server types
     Service Type > Planned Compute	Select	Resource status with Planned Compute configured In Use: The number of resources in use among those with Planned Compute configured Configured: The number of resources with Planned Compute configured Coverage Preview: The amount applied by Planned Compute for each resource Create Planned Compute Service: Navigate to the Planned Compute service request page For details, refer to Request Planned Compute
     Service Type > Block Storage	Required	Configure the Block Storage used by the DB according to its purpose. Default OS: The area where the DB engine is installed. DATA: The storage area for table data, archive files, and so on. Select a storage type and enter the capacity. (For details on each Block Storage type, see Create Block Storage.) 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 the capacity as a multiple of 8 within the range of 16 to 5,120. Because large-scale sorting from SQL execution or monthly batch jobs can cause service interruptions, you must allocate and use a separate TEMP storage. Additional: Storage areas for DATA, Archive, TEMP, and Backup data. Select Use, then enter the storage purpose and capacity. The storage type is applied identically to the type configured in DATA, and the capacity can be entered as a multiple of 8 within the range of 16 to 5,120. To add storage, click the Add button. To delete storage, click the x button. You can add up to 9 storage volumes. Backup data is temporarily stored in the BACKUP storage before being transferred. If the data to be backed up exceeds 100 GB and has frequent changes, it is recommended to add a separate BACKUP storage for stable backups. It is recommended to set the backup capacity to approximately 60% of the DATA capacity. If you do not add BACKUP storage, the /tmp area is used, and backups will fail if the capacity is insufficient. For each service, only one Block Storage is allocated for Archive, TEMP, and BACKUP storage.
     Redundancy Configuration	Select	Whether a high-availability configuration is in place When a high-availability configuration is used, the DB instance is configured with a separation between the Active DB and the Standby DB
     Network > Common Settings	Required	Network settings for the servers created by the service and installed Select this option to apply the same settings to all servers being installed Select a pre-created VPC, Subnet, IP, and Public NAT The IP for each server is generated automatically The Public NAT feature is available only if the VPC is connected to an Internet Gateway. When you check Use, you can select a reserved IP from the Public IPs of the VPC product. For details, see Create a Public IP
     Network > Per-Server Settings	Required	Network settings for the servers created by the service to be installed Select if you want to apply different settings for each server being installed Select a pre-created VPC, Subnet, IP, and Public NAT Enter the IP for each server The Public NAT feature is available only if the VPC is connected to an Internet Gateway. If you check Use, you can select a reserved IP from the Public IPs of the VPC product. For details, see Create a Public IP
     IP Access Control	Select	Configure Service Access Policy Access policies are configured for the IPs entered on the page, so there is no need to separately configure Security Group policies. 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 IP.
     Maintenance period	Select	DB Maintenance Window When you select Use, you can configure the day of the week, start time, and duration. The maintenance window is a feature that allows users to set the time zone for performing patch operations. Patch operations within this time are the user’s responsibility. To ensure stable system operation, please set a maintenance window. We are not responsible for any issues arising from a missing configuration or failure to perform operations within the specified window.

     Table. EPAS (DBaaS) service information input items
   • Enter or select the required information in the Database Configuration Required Information section.

     Category	Required	Detailed Description
     Database name	Required	Server name applied during DB installation
     Must start with a letter and be 3 to 20 characters long, using only letters and numbers
     Database username	Required	DB username A system account with the same name is also created on the OS Enter 2 to 20 characters using lowercase letters Restricted database usernames can be checked 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 “ ‘)
     Verify the database password	Required	Re-enter the password to be used for DB access
     Database Port Number	Required	Port number required for DB connection Enter the DB port within the range of 1200 to 65535
     Backup > Usage	Select	Whether to use backup Select Use to configure the backup file retention period, backup start time, and Archive backup frequency
     Backup > Retention Period	Select	Backup retention period Select the backup retention period. The file retention period can be set from 7 to 35 days. Additional fees apply to backup files based on their capacity.
     Backup > Backup Start Period	Select	Backup start time Select the backup start time The minutes at which the backup is performed are set randomly, and the backup end time cannot be configured
     Backup > Archive Backup Frequency	Select	Archive backup interval Select an archive backup interval A 1-hour archive backup interval is recommended. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance.
     Audit Log Configuration	Select	Whether to save the Audit Log
     Select Use to configure the Audit Log feature
     DDL, DML, SELECT, and user connection information are recorded and saved.
     Users can specify the types of SQL statements to audit using the edb_audit_statement parameter, which can be modified through the Parameter screen.
     For details on this parameter, refer to the EDB documentation.
     Enabling Audit may degrade DB performance.
     ServiceWatch log collection	Select	Whether to collect ServiceWatch logs Select Use to configure the ServiceWatch log collection feature Provided free of charge up to 5 GB for all services within the Account. If usage exceeds 5 GB, fees are charged based on storage capacity Log groups and log streams are automatically created upon collection and cannot be deleted until the resources are removed To prevent exceeding 5 GB, it is recommended to directly delete log data or shorten the retention period
     Parameter	Required	DB configuration parameters Click the View button to view detailed parameter information. Parameters can be modified only after service creation is complete. After making changes, you must restart the DB.
     Database Encoding	Required	Character encoding to use for the DB Character set used when storing text data The DB is created with the selected encoding as the default
     DB Locale	Required	Locale to use for the DB Settings related to string processing, and number/currency/date/time display formats The DB is created with the selected Locale as the default setting
     Time zone	Required	The standard time zone in which the database will be used
     License	Required	EPAS License Verification Status This is a verification item for license usage. You cannot proceed to the next step unless you click Verify.

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

     Category	Required	Detailed Description
     Tag	Select	Add Tag You can add up to 50 tags per resource Click the Add Tag button, then enter or select the Key and Value

     Table. Additional information input items for EPAS (DBaaS)

4. Review the detailed information and estimated billing amount generated in the Summary panel, and then click the Generate button.

   • After generation is complete, check the created resource on the Resource List page.

Viewing EPAS (DBaaS) details

The EPAS (DBaaS) service allows you to view and modify the full resource list and detailed information. The EPAS(DBaaS) Details page consists of the Details, Tags, and Operation History tabs. For databases with a configured replica, an additional Replica Information tab is included.

To view the detailed information of the EPAS (DBaaS) service, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) 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. Click the resource for which you want to view detailed information on the EPAS(DBaaS) List page. 3. Go to the EPAS(DBaaS) Details page.
   • The top of the EPAS(DBaaS) Details page displays status information and information about additional features.

     Category	Detailed Description
     Cluster Status	Cluster status with the DB installed Creating: The cluster is being created Editing: The cluster is transitioning to a state where it is performing an Operation Error: The cluster is in an error state while performing a task If this occurs persistently, contact the administrator Failed: The cluster failed during the creation process Restarting: The cluster is restarting Running: The cluster is operating normally Starting: The cluster is starting Stopped: The cluster is stopped Stopping: The cluster is stopping Synchronizing: The cluster is synchronizing Terminating: The cluster is being deleted Unknown: The cluster status is unknown If this occurs persistently, contact the administrator Upgrading: The cluster is transitioning to a state where it is performing an upgrade
     Cluster Control	Buttons that can change the cluster state Start: Starts a stopped cluster Stop: Stops a running cluster Restart: Restarts a running cluster Switch-Over: Switches a Standby cluster to Active
     View additional features	Cluster-related management buttons Service Status Synchronization: Query real-time DB service status Backup History: If backups are configured, check whether backups are running normally and view the history Database Recovery: Restore the DB based on a specific point in time Parameter Management: View and modify DB configuration parameters Replica Configuration: Configure a read-only cluster replica Replica Configuration (Other-Region): Configure a disaster recovery replica in a different region. If no region is available to configure in the corresponding Account, this 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 access IPs based on DB accounts registered in the DB Archive Configuration Management: Configure archive file retention periods and archive mode DB Log Export: Export logs stored via Audit settings to the user’s Object Storage Migration Configuration: Provides migration functionality using the Replication method Block Storage Usage Management: Provides a feature to query usage by Block Storage type OS (Kernel) Upgrade: Upgrade the OS Kernel version
     Service Cancellation	Button for canceling the service

     Table. EPAS (DBaaS) status information and additional features

Detailed Information

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

Replica information

The Replica Information tab is enabled only when a Replica is configured in the cluster. You can check the master cluster name, the number of replicas, and the replica status through the Replica Information tab.

Tag

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

Job History

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

Managing EPAS (DBaaS) Resources

To modify or restore the existing configuration options of a generated EPAS (DBaaS) resource, or to configure a replica, perform the task on the EPAS (DBaaS) Details page.

Controlling Operation

You can start, stop, or restart a running EPAS (DBaaS) resource when changes occur. Additionally, in an HA configuration, you can switch the Active-Standby servers through a failover.

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

1. Click the All Services > Database > EPAS(DBaaS) 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 you want to control. 3. Go to the EPAS(DBaaS) Details page.
4. Check the status of EPAS (DBaaS) and complete the change using the control buttons below.
   • Start: The DB service is installed on the server, and the DB service is running.
   • Stop: The server where the DB service is installed and the DB service are stopped.
   • Restart: Only the DB service is restarted.
   • Switch Over: You can switch the Active server and the Standby server in the DB.

Synchronize service status

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

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

1. Click the All Services > Database > EPAS(DBaaS) 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 whose service status you want to check. 3. Go to the EPAS(DBaaS) Details page.
4. Click the Service Status Sync button. 4. While the query is in progress, the cluster changes to the Synchronizing state.
5. When the query is complete, the status in the server information section 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. Click the All Services > Database > EPAS(DBaaS) 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 change the server type. 3. Go to the EPAS(DBaaS) Details page.
4. Click the Edit icon for the server type you want to change at the bottom of the details section. 4. The Edit Server Type popup window opens.
5. In the Edit Server Type popup, select a server type and then click the OK button.

Add Storage

If you need more than 5 TB of data storage space, you can add storage. For a database configured for high availability, both high-availability servers are added simultaneously.

To add storage, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) 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 which you want to add storage. 3. Go to the EPAS(DBaaS) Details page.
4. Click the Add Disk button at the bottom of the details section. 4. The Request Additional Storage popup window opens.
5. In the Request Additional Storage popup, enter the purpose and capacity, then click the Confirm button.

Expanding Storage

Storage added to the data area can be expanded up to a maximum of 5 TB based on the initially allocated capacity. For a database configured with high availability, both redundant servers are scaled out simultaneously.

To expand storage capacity, follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) 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 change the server type. 3. Go to the EPAS(DBaaS) Details page.
4. Click the Edit icon for the additional disk you want to add at the bottom of the details section. 4. The Edit Additional Storage popup opens.
5. In the Modify Additional Storage dialog box, enter the expansion capacity and click the OK button.

Terminate EPAS (DBaaS)

You can reduce operational costs by canceling unused EPAS (DBaaS). However, if you cancel the service, the running service may be immediately interrupted. Therefore, you must carefully consider the impact of the service interruption before proceeding with the cancellation.

To cancel EPAS (DBaaS), follow these steps.

1. Click the All Services > Database > EPAS(DBaaS) 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, select the resource to cancel and click the Cancel Service button.
4. After the cancellation is complete, verify that the resource has been canceled on the EPAS(DBaaS) list page.