The page has been translated by Gen AI.

Managing DB Services

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

Parameter Management

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

Parameter View

To view configuration parameters, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Go to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. On the MariaDB(DBaaS) List page, click the resource whose parameters you want to view or modify. 3. MariaDB(DBaaS) Details Go 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 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

To modify the configuration parameters, follow the steps below.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List page, click the resource whose parameters you want to view or modify. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button and 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 The 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 area of the Parameter to be edited.
  8. When the input is complete, click the Complete button.
참고

If you change the character_set_server value, first verify the collation that matches the character set using the command below.

SQL> SHOW COLLATION WHERE Charset = 'character set name';

Set the parameter values for character-set-server, collation-server, and init_connect using the verified collation.

ItemDetailed descriptionWhether to restart
character-set-serverSpecify default character setRestart required
collation-serverSpecify default collation (Collation)Restart required
init_connectSQL statement executed when the client connects to the databaseNo restart required
Table. Parameter configuration items

Managing DB Users

Provides administrative features for viewing DB user information and modifying status information.

Query DB Users

Follow these steps to query DB users.

  1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB (DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List page, click the resource whose DB users you want to view. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button, then click the DB User Management button. 4. Navigate to the DB User Management page.
  5. DB User Management on the 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. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List On the page, click the resource you want to edit the DB user for. 3. MariaDB(DBaaS) Details Navigate to the page.
  4. Click the More button, then click the DB User Management button. 4. Navigate 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.
  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 Done 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.

안내
Perform a DB user lookup before setting DB access control. For DB user lookup, please refer to DB 사용자 관리하기.

View DB Access Control

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List On the page, click the resource you want to manage access control for. 3. MariaDB(DBaaS) Details Navigate to the 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 may take a short amount of time.

Add DB access control

To add IP access control, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. On the MariaDB(DBaaS) List page, click the resource for which you want to add IP access control. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button and then click the DB Access Control Management button. 4. Navigate 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 The 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 Done button.

Delete DB Access Control

To delete IP access control, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List page, click the resource for which you want to delete the IP access control. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button, then click the DB Access Control Management button. 4. Navigate 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 Delete button. 6. Delete popup window opens.
  7. Click the Confirm button on the Delete popup.

Configure Archive mode

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 operating environment.

안내
When creating a service, the default setting is Archive mode enabled, and the retention period is 3 days.

To set the Archive mode, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List Click the resource on the page for which you want to set Archive mode. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button and then click the Archive Settings Management button. 4. Navigate 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 Complete button.

Modify Audit Settings

You can change the Audit log storage settings of MariaDB (DBaaS).

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List On the MariaDB(DBaaS) List page, click the resource to view the service status. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the Edit icon of the Audit settings at the bottom of the detailed information. 4. Edit Audit Settings The popup window opens.
  5. Modify Audit Settings After changing the usage status in the popup window, click the Confirm button.
    • Select Use to enable the Audit log feature. * 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.

DB Log Export

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 designated Object Storage for retention according to the configured criteria. 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 the long term.

안내
  • To use the DB Log export feature, you need to create an Object Storage. * Please refer to the Object Storage 사용자 가이드 for creating Object Storage.
  • Please be sure to verify the authentication key’s expiration date and time. * If the authentication key expires, logs will not be stored in the Bucket.
  • Please ensure that the authentication key information is not exposed to external parties.

Setting DB Log Export Mode

Follow these steps to set the DB Log export mode.

  1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List On the page, click the resource for which you want to export the DB Log. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button, 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. Navigate to the Register DB Log Export page.
  6. After entering the required information on the DB Log Export Registration page, click the Complete button.
    CategoryRequired
    Detailed description
    Log typeRequiredLog type to be saved
    Save bucket nameRequiredObject Storage bucket name to be saved
    Authentication key > Access keyRequiredAccess key for accessing the Object Storage you want to store
    Authentication key > Secret keyRequiredSecret key for accessing the Object Storage you want to store
    File creation cycleRequiredFile creation frequency in Object Storage
    Whether to delete the original logSelectionWhether to delete the original logs when exporting to Object Storage
    Table. MariaDB (DBaaS) DB Log Export Configuration Items

Manage DB Log Export

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. MariaDB(DBaaS) List On this page, click the resource for which you want to manage DB Log export. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button, then click the Export DB Log button. 4. Navigate to the DB Log Export 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, 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.

Upgrade version

If a latest patch that includes security enhancements and feature improvements is available, you can apply it using the version upgrade feature.

Caution
  • First retrieve the service status via service status synchronization, then proceed with the version upgrade.
  • It is recommended to perform an immediate backup in advance to prepare for any issues that may arise during the upgrade process. * If this is not the case, a failure may occur and some data may not be recoverable.
  • In a DB with a Replica configured, the Master DB version cannot be higher than the Replica version. * Please check the version of Replica first, and if necessary, perform a version upgrade.
  • The backed-up data is automatically deleted after the version upgrade is completed.

Major version upgrade

Caution

Major version upgrades require a pre‑upgrade simulation test.

  • Please set up a separate Replica DB, promote it to Master, and pre‑validate the Major upgrade. * Afterward, we recommend proceeding only after thoroughly reviewing the service impact with the Application manager.

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. On the MariaDB(DBaaS) List page, click the resource to upgrade the Major version. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the Edit icon of the Image version item. 4. Version Upgrade A popup window opens.
  5. Version Upgrade In the popup window, select the upgrade type and patch version, then click the Confirm button.
  6. Version Upgrade Notification: Click the Confirm button in the popup window.

Minor version upgrade

Supports minor version upgrades within the same major version.

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. On the MariaDB(DBaaS) List page, click the resource to upgrade the Minor version. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the Edit icon of the Image version item. 4. Version Upgrade A popup window opens.
  5. Version Upgrade In the popup window, select the upgrade type and the patch version, then click the Confirm button.
  6. Version Upgrade Notification In the popup window, click the Confirm button.

Configure Migration

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

안내
For a detailed Migration configuration guide, please refer to Architecture Center > 마이그레이션 가이드.

To configure Migration, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Go to the page.
  3. MariaDB(DBaaS) List page, click the resource to migrate. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button, then click the Configure Migration 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. Migration configuration After entering the required information on the page, click the Check Connection button.
  7. When the connection is complete, click the Done button.
    CategoryRequired
    Detailed description
    Source DB Database nameRequiredDatabase name of the source DB to be migrated
    Source DB IPRequiredIP of the Source DB that is the migration target
    Source DB PortRequiredPort of the Source DB to be migrated
    Source DB usernameRequiredUser name of the Source DB to be migrated
    Source DB passwordRequiredPassword of the source DB for migration
    Table. MariaDB (DBaaS) migration configuration items

Promote Migration Cluster to Master Cluster

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

Caution
When the master is promoted, synchronization with the source DB that is the migration target is stopped.

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. On the MariaDB(DBaaS) List page, click the resource to promote to Master. 3. MariaDB(DBaaS) Details Go 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 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. Click the All Services > Database > MariaDB(DBaaS) menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. On the MariaDB(DBaaS) List page, click the resource to view Block Storage usage. 3. MariaDB(DBaaS) Details Go to the page.
  4. Click the More button, then click the Block Storage Usage Management button. 4. Block Storage Usage Management Navigate to the page.
  5. On the Block Storage Usage Management page, click the Search 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.

OS Kernel Upgrade

You can upgrade the OS Kernel to enhance the functionality of the operational database and apply security patches.

Caution
  • The service will be unavailable while the OS upgrade is in progress.
  • The upgrade duration may vary depending on the version, and if the upgrade fails, it will be rolled back to the previous configuration.
  • After the upgrade is complete, you cannot revert to the original OS.

Follow these steps to upgrade the OS Kernel.

  1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
  3. On the MariaDB(DBaaS) List page, click the resource to upgrade the OS Kernel. 3. MariaDB(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.
How-to guides
Backing up and restoring the DB