The page has been translated by Gen AI.

DB Service Manage

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

Managing Parameters

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

Query Parameter

To view configuration parameters, follow these steps.

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

Modify Parameter

To modify the configuration parameters, follow the steps below.

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

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 descriptionRestart option
character-set-serverSpecify the default character setRestart required
collation-serverSpecify default collationRestart required
init_connectSQL statements executed when the client connects to the databaseNo restart required
Table. Parameter setting items

Managing DB Users

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

Query DB users

To view DB users, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. Navigate to the Service Home page of MariaDB(DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. Navigate to the MariaDB(DBaaS) List page.
  3. On the MariaDB(DBaaS) List page, click the resource for which you want to view the DB user. You will be taken to the MariaDB(DBaaS) Details page.
  4. Click the More button, then click the DB User Management button. You will be taken to the DB User Management page.
  5. DB User Management page, click the Search button. It may take a short time to retrieve the data.

Changing DB User Status

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. Navigate to the Service Home page of MariaDB(DBaaS).
  2. Click the MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. On the MariaDB(DBaaS) List page, click the resource whose DB user you want to modify. You will be taken to the MariaDB(DBaaS) Details page.
  4. Click the More button and then click the DB User Management button. You will be taken to the DB User Management page.
  5. DB User Management page, click the Search button. Retrieving the data may take a short while.
  6. If a correction is needed, click the Edit button, then change the status field value or enter remarks.
  7. When the input is complete, click the Complete button.

Managing DB Access Control

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

information
Before configuring DB access control, perform a DB user lookup. For DB user lookup, refer to DB 사용자 관리하기.

Query DB Access Control

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

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

Add DB access control

To add IP access control, follow these steps.

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

Delete DB access control

To delete IP access control, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. You will be taken to the Service Home page of MariaDB(DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. Navigate to the MariaDB(DBaaS) List page.
  3. MariaDB(DBaaS) List page, click the resource for which you want to delete IP access control. MariaDB(DBaaS) Details page will be opened.
  4. Click the More button and then click the DB Access Control Management button. You will be taken to the DB Access Control Management page.
  5. DB Access Control Management page, click the Search button. Retrieving the data may take a short time.
  6. When the query is complete, click the Delete button. The Delete popup window opens.
  7. Delete Click the Confirm button in the popup window.

Managing Archives

Provides the ability to configure Archive mode and set the retention period for Archive logs, allowing users to flexibly configure Archive log management policies to suit their operational environment. Additionally, we provide a feature that allows manual deletion of Archive logs, enabling you to clean up unnecessary log data and manage system resources effectively.

information
When creating a service, the default setting uses Archive mode, and the retention period is 3 days.

Configure Archive mode

To set the Archive mode, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. Navigate to the Service Home page of MariaDB(DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. Navigate to the MariaDB(DBaaS) List page.
  3. MariaDB(DBaaS) List page, click the resource you want to set Archive mode for. You will be taken to the MariaDB(DBaaS) Details page.
  4. Click the More button and then click the Archive Settings Management button. You will be taken to the Archive Settings Management page.
  5. On the Archive Settings Management page, click the Search button. The query may take a short time.
  6. Click the Edit button and select the usage status and retention period.
  7. When the edit is complete, click the Done button.

Delete Archive file

To delete the Archive file, follow these steps.

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

Modify Audit Settings

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

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. Navigate to the Service Home page of MariaDB(DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. Go to the MariaDB(DBaaS) List page.
  3. MariaDB(DBaaS) List page, click the resource to view the service status. You will be taken to the MariaDB(DBaaS) Details page.
  4. Click the Edit icon of Audit Settings at the bottom of the detailed information. The Edit Audit Settings popup window opens.
  5. Modify Audit Settings After changing the usage in the popup window, click the Confirm button.
    • When Use is selected, the Audit log feature is enabled. Enabling the Audit log may degrade DB performance.
    • If you disable it, 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 logs to Object Storage. Users can directly configure the log types to be stored, the target bucket for export, and the export interval. Based on the configured criteria, logs are copied to the specified Object Storage for retention. Additionally, to efficiently manage disk space, we also provide an option that exports logs to Object Storage while automatically deleting the original log files. By using this option, you can effectively free up storage capacity while safely retaining the necessary log data for long-term storage.

information
  • To use the DB Log export function, you need to create an Object Storage. For creating Object Storage, please refer to the Object Storage User Guide.
  • Please be sure to check the expiration date and time of the authentication key. If the authentication key expires, logs will not be stored in the bucket.
  • Please ensure that authentication key information is not exposed externally.

Setting DB Log Export Mode

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. Navigate to the Service Home page of MariaDB(DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. Navigate to the MariaDB(DBaaS) List page.
  3. On the MariaDB(DBaaS) List page, click the resource you want to export the DB Log from. You will be taken to the MariaDB(DBaaS) Details page.
  4. Click the More button, then click the DB Log Export button. You will be taken to the DB Log Export page.
  5. On the DB Log Export page, click the Register button. You will be taken to the DB Log Export Register page.
  6. After entering the required information on the DB Log Export Registration page, click the Complete button.
    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 interval 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

Managing DB Log Export

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

  1. Click the All Services > Database > MariaDB(DBaaS) menu. Go to the Service Home page of MariaDB(DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. Navigate to the MariaDB(DBaaS) List page.
  3. On the MariaDB(DBaaS) List page, click the resource you want to manage DB Log export for. You will be taken to the MariaDB(DBaaS) Details page.
  4. Click the More button, then click the DB Log Export button. You will be taken to the DB Log Export page.
  5. On the DB Log Export page, depending on the log type you want to manage, click the More button and then click the Export Now, Edit, or Cancel button.
    • 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: Disables the DB Log export mode setting.

Minor Version Upgrade

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

Warning
  • First retrieve the service status by synchronizing it, then perform the version upgrade.
  • Please perform the version upgrade after configuring a backup. If you do not set up a backup, you may be unable to recover some data if a problem occurs during the upgrade.
  • In a DB with a Replica configured, the Master DB version cannot be higher than the Replica version. Please check the Replica version first and, if necessary, perform a version upgrade.
  • The backed-up data will be automatically deleted after the version upgrade is completed.

To upgrade the Minor Version, follow these steps.

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

Configure Migration

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

information
For a detailed Migration configuration guide, please refer to Architecture Center > Migration Guide.

To configure Migration, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. Navigate to the Service Home page of MariaDB(DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. You will be taken to the MariaDB(DBaaS) List page.
  3. MariaDB(DBaaS) List page, click the resource to migrate. MariaDB(DBaaS) Details page will be opened.
  4. Click the More button, then click the Migration configuration button. The Migration configuration popup opens.
  5. Migration configuration In the popup window, check the instructions and click the Confirm button. You will be taken to the Migration configuration page.
  6. On the Migration configuration page, after entering the required information, click the Check connection button.
  7. When the connection is complete, click the Complete 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 for migration
    Source DB passwordRequiredPassword of the source DB that is the migration target
    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 halted.

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

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

Upgrade OS Kernel

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

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 previous OS.

To upgrade the OS Kernel, follow these steps.

  1. Click the All Services > Database > MariaDB(DBaaS) menu. Navigate to the Service Home page of MariaDB(DBaaS).
  2. On the Service Home page, click the MariaDB(DBaaS) menu. Navigate to the MariaDB(DBaaS) List page.
  3. On the MariaDB(DBaaS) List page, click the resource to upgrade the OS Kernel. You will be taken to the MariaDB(DBaaS) Details page.
  4. Click the More button, then click the OS(Kernel) Upgrade button. The OS(Kernel) Upgrade Notification popup window opens.
  5. OS(Kernel) Upgrade Notification In the popup window, review the instructions and click the Confirm button.
How-to guides
Backing up and restoring the database