Managing DB Service

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

Managing Parameters

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

Parameter Inquiry

To view the configuration parameters, follow these steps.

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

Modifying Parameters

To modify the configuration parameters, follow these steps.

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

Manage DB users

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

Querying DB Users

To query DB users, follow the following procedure.

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

Change DB User Status

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

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

DB Access Control Management

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

Checking DB Access Control

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

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

Add DB Access Control

To add IP access control, follow the next procedure.

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

Delete DB Access Control

To delete IP access control, follow these steps.

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

Managing Archives

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

Setting Archive Mode

To set the archive mode, follow the next procedure.

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

Delete Archive Files

To delete an Archive file, follow these steps.

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

DB Log export

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

Set DB Log Export Mode

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

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

Managing DB Log Export

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

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

• Cancel: Cancels the DB log export mode setting.

Minor Version Upgrade

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

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

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

Configuring Migration

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

To configure the migration, follow the next procedure.

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

Migrating Cluster to Master Cluster

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

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

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