The page has been translated by Gen AI.

Managing DB Service

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

Managing Parameter

Provides functionality to easily view and modify database configuration parameters.

Viewing Parameters

Follow these steps to view configuration parameters.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to view or modify parameters on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click Parameter Management button. Parameter Management popup window will open.
  5. Click View button in the Parameter Management popup window. View Notification popup window will open.
  6. Click Confirm button when the View Notification popup window opens. It will take some time to view.

Modifying Parameters

Follow these steps to modify configuration parameters.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to view or modify parameters on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click Parameter Management button. Parameter Management popup window will open.
  5. Click View button in the Parameter Management popup window. View Notification popup window will open.
  6. Click Confirm button when the View Notification popup window opens. It will take some time to view.
  7. If modification is needed, click Modify button and enter the modification in the custom value area of the Parameter to be modified.
  8. When input is complete, click Complete button.
Note

If you change the character_set_server value, first check the collation that matches the character set with the following command:

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

Set the parameter values character-set-server, collation-server, and init_connect with the confirmed collation.

ItemDescriptionRestart Required
character-set-serverSpecify default character setRestart required
collation-serverSpecify default collationRestart required
init_connectSQL statement executed when Client connects to databaseRestart not required
Table. Parameter Setting Items

Managing DB Users

Provides management functionality to view DB user information and change status information.

Viewing DB Users

Follow these steps to view DB users.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to view DB users on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click DB User Management button. You will be taken to the DB User Management page.
  5. Click View button on the DB User Management page. It will take some time to view.

Changing DB User Status

Follow these steps to change the status of viewed DB users.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to modify DB users on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click DB User Management button. You will be taken to the DB User Management page.
  5. Click View button on the DB User Management page. It will take some time to view.
  6. If modification is needed, click Modify button and change the status area value or enter note content.
  7. When input is complete, click Complete button.

Managing DB Access Control

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

Notice
Before setting DB access control, perform DB user view. For DB user view, please refer to Managing DB Users.

Viewing DB Access Control

Follow these steps to view DB users with IP access control set.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to manage access control on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click DB Access Control Management button. You will be taken to the DB Access Control Management page.
  5. Click View button on the DB Access Control Management page. It will take some time to view.

Adding DB Access Control

Follow these steps to add IP access control.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to add IP access control on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click DB Access Control Management button. You will be taken to the DB Access Control Management page.
  5. Click View button on the DB Access Control Management page. It will take some time to view.
  6. When viewing is complete, click Add button. DB Access Control Add popup window will open.
  7. Enter DB username selection and IP Address in the DB Access Control Add popup window.
  8. When input is complete, click Complete button.

Deleting DB Access Control

Follow these steps to delete IP access control.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to delete IP access control on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click DB Access Control Management button. You will be taken to the DB Access Control Management page.
  5. Click View button on the DB Access Control Management page. It will take some time to view.
  6. When viewing is complete, click Delete button. Delete popup window will open.
  7. Click Confirm button in the Delete popup window.

Managing Archive

Provides Archive mode setting and Archive Log retention period setting functionality, allowing users to flexibly set Archive log management policies according to their operating environment. Additionally, it provides functionality to manually delete Archive logs, enabling effective management of system resources by cleaning up unnecessary log data.

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

Setting Archive Mode

Follow these steps to set Archive mode.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to set Archive mode on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click Archive Setting Management button. You will be taken to the Archive Setting Management page.
  5. Click View button on the Archive Setting Management page. It will take some time to view.
  6. Click Modify button and select usage and retention period.
  7. When modification is complete, click Complete button.

Deleting Archive Files

Follow these steps to delete Archive files.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to set Archive mode on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click Archive Setting Management button. You will be taken to the Archive Setting Management page.
  5. To delete all Archive files on the Archive Setting Management page, click Delete All Archives, and to delete only backed up Archive files, click Delete Backed Up Archives button.

Modifying Audit Settings

You can change MariaDB(DBaaS)’s Audit log storage settings.

Follow these steps to change MariaDB(DBaaS)’s Audit log storage settings.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to view service status on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click Modify icon in Audit Settings at the bottom of the detail information. Audit Settings Modify popup window will open.
  5. Modify usage in the Audit Settings Modify popup window and click Confirm button.
    • When Use is selected, Audit log functionality is set. When Audit log is set, DB performance may degrade.
    • When Use is disabled, the Audit log storage file is deleted. Back up the Audit log file separately before disabling use.

Exporting DB Log

Supports exporting audit (Audit) logs that require long-term preservation to Object Storage. Users can directly set the log type to be stored, the target Bucket to export to, and the cycle for exporting logs. Logs are copied and stored to the specified Object Storage according to the set criteria. Additionally, for efficient management of disk space, it also provides an option to automatically delete the original log file while exporting the log to Object Storage. By using this option, you can effectively secure storage capacity while safely storing necessary log data for the long term.

Notice
  • To use the DB Log Export functionality, Object Storage creation is required. For Object Storage creation, please refer to Object Storage User Guide.
  • Please be sure to check the expiration date of the authentication key. If the authentication key expires, logs will not be stored in the Bucket.
  • Please be careful not to expose authentication key information to the outside.

Setting DB Log Export Mode

Follow these steps to set DB Log Export mode.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to export DB Log on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click DB Log Export button. You will be taken to the DB Log Export page.
  5. Click Register button on the DB Log Export page. You will be taken to the DB Log Export Register page.
  6. Enter the corresponding information on the DB Log Export Register page and click Complete button.
    CategoryRequired
    Description
    Log TypeRequiredLog type to store
    Storage Bucket NameRequiredObject Storage Bucket name to store
    Authentication Key > Access keyRequiredAccess key to access the Object Storage to store
    Authentication Key > Secret keyRequiredSecret key to access the Object Storage to store
    File Creation CycleRequiredCycle for creating files in Object Storage
    Original Log DeletionOptionalWhether to delete the original log while exporting to Object Storage
    Table. MariaDB(DBaaS) DB Log Export Configuration Items

Managing DB Log Export

Follow these steps to modify, cancel, or immediately export DB Log Export settings.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to manage DB Log Export on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click DB Log Export button. You will be taken to the DB Log Export page.
  5. On the DB Log Export page, click More button according to the log type you want to manage and click Immediate Export, Modify, or Cancel button.
    • Immediate Export: Selected logs are exported to the previously set Object Storage’s Bucket.
    • Modify: Modifies DB Log Export mode settings.
    • Cancel: Cancels DB Log Export mode settings.

Upgrading Minor Version

Provides version upgrade functionality according to some feature improvements and security patches. Only Minor version upgrade functionality within the same Major version is supported.

Warning
  • Please check the service status first through service status synchronization, then perform version upgrade.
  • Please set backup before proceeding with version upgrade. If backup is not set, some data may not be recoverable if a problem occurs during upgrade.
  • In a DB where Replica is configured, the Master DB version cannot be higher than the Replica version. First check the Replica version and perform version upgrade if necessary.
  • Backed up data is automatically deleted after version upgrade is complete.

Follow these steps to upgrade Minor Version.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to upgrade version on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click Modify icon in the Image Version item. Version Upgrade popup window will open.
  5. Select the modification version and backup setting in the Version Upgrade popup window, then click Confirm button.
  6. Click Confirm button in the Version Upgrade Notification popup window.

Configuring Migration

Provides Migration functionality that replicates in real-time with a running database using Replication method without service interruption.

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

Follow these steps to configure Migration.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to migrate on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click Migration Configuration button. Migration Configuration popup window will open.
  5. Confirm the guidelines in the Migration Configuration popup window and click Confirm button. You will be taken to the Migration Configuration page.
  6. Enter the corresponding information on the Migration Configuration page and click Connection Check button.
  7. When connection is complete, click Complete button.
    CategoryRequired
    Description
    Source DB Database NameRequiredDatabase name of the Source DB to be migrated
    Source DB IPRequiredIP of the Source DB to be migrated
    Source DB PortRequiredPort of the Source DB to be migrated
    Source DB UsernameRequiredUsername of the Source DB to be migrated
    Source DB PasswordRequiredPassword of the Source DB to be migrated
    Table. MariaDB(DBaaS) Migration Configuration Items

Promoting Migration Cluster to Master Cluster

You can promote a configured Migration Cluster to Master Cluster.

Warning
When promoting to Master, synchronization with the Source DB to be migrated is stopped.

Follow these steps to promote Migration Cluster to Master.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to promote to Master on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click Master Promotion button. Master Promotion Notification popup window will open.
  5. Click Confirm button in the Master Promotion Notification popup window.

Upgrading OS Kernel

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

Warning
  • Service is interrupted while OS upgrade is in progress.
  • Upgrade time may vary depending on the version, and if upgrade fails, it will revert to the previous configuration.
  • Cannot recover to the previous OS after upgrade is complete.

Follow these steps to upgrade OS Kernel.

  1. Click All Services > Database > MariaDB(DBaaS) menu. You will be taken to MariaDB(DBaaS)’s Service Home page.
  2. Click MariaDB(DBaaS) menu on the Service Home page. You will be taken to the MariaDB(DBaaS) List page.
  3. Click the resource for which you want to upgrade OS Kernel on the MariaDB(DBaaS) List page. You will be taken to the MariaDB(DBaaS) Detail page.
  4. Click More button and click OS(Kernel) Upgrade button. OS(Kernel) Upgrade Notification popup window will open.
  5. Confirm the guidelines in the OS(Kernel) Upgrade Notification popup window and click Confirm button.
How-to guides
DB Backup and Restore