The page has been translated by Gen AI.

Manage DB Service

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

Manage Parameters

Provides functionality to easily view and modify database configuration parameters.

View Parameters

Follow these steps to view configuration parameters.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose parameters you want to view and modify. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the Parameter Management button. The Parameter Management popup window opens.
  5. On the Parameter Management popup window, click the View button. The View Notification popup window opens.
  6. When the View Notification popup window opens, click the Confirm button. It takes some time to view.

Modify Parameters

Follow these steps to modify configuration parameters.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose parameters you want to view and modify. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the Parameter Management button. The Parameter Management popup window opens.
  5. On the Parameter Management popup window, click the View button. The View Notification popup window opens.
  6. When the View Notification popup window opens, click the Confirm button. It takes some time to view.
  7. If modification is needed, click the Edit button and enter modification content in the user-defined value area of the Parameter to modify.
  8. When input is completed, click the Complete button.
Reference

When changing character_set_server value, first check the collation matching that character set with the following command.

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

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

ItemDetailed DescriptionRestart Required
character-set-serverSpecify default character setRestart Required
collation-serverSpecify default collationRestart Required
init_connectSQL statement executed when Client connects to databaseNo Restart Required
Table. Parameter Setting Items

Manage DB Users

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

View DB Users

Follow these steps to view DB users.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose DB users you want to view. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the DB User Management button. You will move to the DB User Management page.
  5. On the DB User Management page, click the View button. It takes some time to view.

Change DB User Status

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

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose DB users you want to modify. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the DB User Management button. You will move to the DB User Management page.
  5. On the DB User Management page, click the View button. It takes some time to view.
  6. If modification is needed, click the Edit button and change the status area value or enter remarks content.
  7. When input is completed, click the Complete button.

Manage DB Access Control

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

Notice
Please perform DB user viewing before setting DB access control. For DB user viewing, refer to Manage DB Users.

View DB Access Control

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

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose access control you want to manage. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the DB Access Control Management button. You will move to the DB Access Control Management page.
  5. On the DB Access Control Management page, click the View button. It takes some time to view.

Add DB Access Control

Follow these steps to add IP access control.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose IP access control you want to add. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the DB Access Control Management button. You will move to the DB Access Control Management page.
  5. On the DB Access Control Management page, click the View button. It takes some time to view.
  6. When viewing is completed, click the Add button. The Add DB Access Control popup window opens.
  7. On the Add DB Access Control popup window, select DB username and enter IP Address.
  8. When input is completed, click the Complete button.

Delete DB Access Control

Follow these steps to delete IP access control.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose IP access control you want to delete. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the DB Access Control Management button. You will move to the DB Access Control Management page.
  5. On the DB Access Control Management page, click the View button. It takes some time to view.
  6. When viewing is completed, click the Delete button. The Delete popup window opens.
  7. On the Delete popup window, click the Confirm button.

Manage Archive

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

Notice
When creating the service, default settings are Archive mode use and retention period of 3 days.

Set Archive Mode

Follow these steps to set Archive mode.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose Archive mode you want to set. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the Archive Settings Management button. You will move to the Archive Settings Management page.
  5. On the Archive Settings Management page, click the View button. It takes some time to view.
  6. Click the Edit button and select whether to use and retention period.
  7. When modification is completed, click the Complete button.

Delete Archive Files

Follow these steps to delete Archive files.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose Archive mode you want to set. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the Archive Settings Management button. You will move 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, and if you want to delete only backed-up Archive files, click the Delete Backed-up Archives button.

Export DB Log

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

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

Set DB Log Export Mode

Follow these steps to set DB Log export mode.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose DB logs you want to export. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the DB Log Export button. You will move to the DB Log Export page.
  5. On the DB Log Export page, click the Register button. You will move to the DB Log Export Register page.
  6. On the DB Log Export Register page, enter the information and click the Complete button.
    ClassificationRequired
    Detailed Description
    Log TypeRequiredLog type to store
    Storage Bucket NameRequiredObject Storage Bucket name to store
    Authentication Key > Access keyRequiredAccess key to access Object Storage to store
    Authentication Key > Secret keyRequiredSecret key to access Object Storage to store
    File Creation CycleRequiredCycle to create files in Object Storage
    Original Log DeletionOptionalWhether to delete original log while exporting to Object Storage
    Table. MySQL(DBaaS) DB Log Export Configuration Items

Manage DB Log Export

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

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose DB Log export you want to manage. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the DB Log Export button. You will move to the DB Log Export page.
  5. On the DB Log Export page, click the More button according to the log type you want to manage and click the Immediate Export, Edit, Terminate buttons.
    • Immediate Export: Selected logs are exported to the Bucket of Object Storage previously set.
    • Edit: Modifies DB Log export mode settings.
    • Terminate: Terminates DB Log export mode settings.

Minor Version Upgrade

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

Caution
  • Please check service status through service status synchronization first, then perform version upgrade.
  • Please proceed with version upgrade after setting backup. If backup is not set, some data may not be recoverable when problems occur during update.
  • In DB where Replica is configured, Master DB version cannot be higher than Replica version. Please check Replica version first and perform version upgrade if needed.
  • Backed-up data is automatically deleted after version upgrade is completed.

Follow these steps to upgrade version.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose version you want to upgrade. You will move to the MySQL(DBaaS) Details page.
  4. Click the Edit button in the Image Version item. The Version Upgrade popup window opens.
  5. On the Version Upgrade popup window, select modified version and whether to set backup, then click the Confirm button.
  6. On the Version Upgrade Notification popup window, click the Confirm button.

Configure Migration

Provides Migration functionality that replicates in real-time while synchronizing with the operating database using Replication method without service interruption.

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

Follow these steps to configure Migration.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource to migrate. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the Migration Configuration button. The Migration Configuration popup window opens.
  5. On the Migration Configuration popup window, check the notice and click the Confirm button. You will move to the Migration Configuration page.
  6. On the Migration Configuration page, enter the information and click the Connection Check button.
  7. When connection is completed, click the Complete button.
    ClassificationRequired
    Detailed Description
    Source DB Database NameRequiredDatabase name of Source DB to be Migration target
    Source DB IPRequiredIP of Source DB to be Migration target
    Source DB PortRequiredPort of Source DB to be Migration target
    Source DB UsernameRequiredUsername of Source DB to be Migration target
    Source DB PasswordRequiredPassword of Source DB to be Migration target
    Table. MySQL(DBaaS) Migration Configuration Items

Promote Migration Cluster to Master Cluster

You can promote the configured Migration Cluster to Master Cluster.

Caution
When promoting to Master, synchronization with Source DB which is Migration target stops.

Follow these steps to promote Migration Cluster to Master.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource to promote to Master. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the Master Promotion button. The Master Promotion Notification popup window opens.
  5. On the Master Promotion Notification popup window, click the Confirm button.

Upgrade OS Kernel

You can upgrade OS Kernel for operating database feature improvements and security patch application.

Caution
  • Service is interrupted while OS upgrade is in progress.
  • Upgrade time may vary depending on version, and if upgrade fails, it reverts to previous configuration.
  • Cannot recover to previous OS after upgrade is completed.

Follow these steps to upgrade OS Kernel.

  1. Click All Services > Database > MySQL(DBaaS) menu. You will move to the Service Home page of MySQL(DBaaS).
  2. On the Service Home page, click the MySQL(DBaaS) menu. You will move to the MySQL(DBaaS) List page.
  3. On the MySQL(DBaaS) List page, click the resource whose OS Kernel you want to upgrade. You will move to the MySQL(DBaaS) Details page.
  4. Click the More button and click the OS (Kernel) Upgrade button. The OS (Kernel) Upgrade Notification popup window opens.
  5. On the OS (Kernel) Upgrade Notification popup window, check the notice and click the Confirm button.
MySQL(DBaaS) server connection
DB Backup and Recovery