Managing DB Services

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

Managing Parameters

It provides a feature to easily view and modify database configuration parameters.

Viewing Parameters

To view configuration parameters, follow these steps:

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

Modifying Parameters

To modify configuration parameters, follow these steps:

1. Click the All Services > Database > MySQL(DBaaS) menu. It moves to the Service Home page of MySQL(DBaaS).
2. Click the MySQL(DBaaS) menu on the Service Home page. It moves to the MySQL(DBaaS) List page.
3. Click the resource you want to view and modify parameters on the MySQL(DBaaS) List page. It moves to the MySQL(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup window opens.
5. Click the View button in the Parameter Management popup window. The View Notification popup window opens.
6. When the View Notification popup window opens, click the OK button. It takes some time to view.
7. If modification is necessary, click the Modify button and enter the modification contents in the user-defined value area of the parameter to be modified.
8. When the input is complete, click the Save button.

Managing DB Users

It provides a management feature that allows you to view DB user information and change status information.

Viewing DB Users

To view DB users, follow these steps:

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

Changing DB User Status

To change the status of the viewed DB user, follow these steps:

1. Click the All Services > Database > MySQL(DBaaS) menu. It moves to the Service Home page of MySQL(DBaaS).
2. Click the MySQL(DBaaS) menu on the Service Home page. It moves to the MySQL(DBaaS) List page.
3. Click the resource you want to modify DB users on the MySQL(DBaaS) List page. It moves to the MySQL(DBaaS) Details page.
4. Click the More button and then click the DB User Management button. It moves to the DB User Management page.
5. Click the View button on the DB User Management page. It takes some time to view.
6. If modification is necessary, click the Modify button and change the status area value or enter remarks.
7. When the input is complete, click the Save button.

Managing DB Access Control

It provides an IP-based DB user access control management feature. Users can directly specify the IP that can access the database, allowing only allowed IPs to access.

Viewing DB Access Control

To view DB users with IP access control set, follow these steps:

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

Adding DB Access Control

To add IP access control, follow these steps:

1. Click the All Services > Database > MySQL(DBaaS) menu. It moves to the Service Home page of MySQL(DBaaS).
2. Click the MySQL(DBaaS) menu on the Service Home page. It moves to the MySQL(DBaaS) List page.
3. Click the resource you want to add IP access control on the MySQL(DBaaS) List page. It moves to the MySQL(DBaaS) Details page.
4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. Click the View button on the DB Access Control Management page. It takes some time to view.
6. When the view is complete, click the Add button. The DB Access Control Add popup window opens.
7. In the DB Access Control Add popup window, select the DB user name and enter the IP address.
8. When the input is complete, click the Save button.

Deleting DB Access Control

To delete IP access control, follow these steps:

1. Click All Services > Database > MySQL(DBaaS) menu. The MySQL(DBaaS) Service Home page will be displayed.
2. Click the MySQL(DBaaS) menu on the Service Home page. The MySQL(DBaaS) list page will be displayed.
3. Click the resource for which you want to delete IP access control on the MySQL(DBaaS) list page. The MySQL(DBaaS) details page will be displayed.
4. Click the More button and then click the DB Access Control Management button. The DB Access Control Management page will be displayed.
5. Click the Inquiry button on the DB Access Control Management page. It may take some time to retrieve the data.
6. Once the inquiry is complete, click the Delete button. A Delete pop-up window will appear.
7. Click the Confirm button in the Delete pop-up window.

Managing Archive

The Archive mode setting and Archive Log retention period setting functions are provided, allowing users to flexibly set the Archive log management policy according to their operating environment. Additionally, the function to manually delete Archive logs is provided together, allowing users to clean up unnecessary log data and effectively manage system resources.

Setting Archive Mode

To set the Archive mode, follow these steps:

1. Click All Services > Database > MySQL(DBaaS) menu. The MySQL(DBaaS) Service Home page will be displayed.
2. Click the MySQL(DBaaS) menu on the Service Home page. The MySQL(DBaaS) list page will be displayed.
3. Click the resource for which you want to set the Archive mode on the MySQL(DBaaS) list page. The MySQL(DBaaS) details page will be displayed.
4. Click the More button and then click the Archive Settings Management button. The Archive Settings Management page will be displayed.
5. Click the Inquiry button on the Archive Settings Management page. It may take some time to retrieve the data.
6. Click the Modify button and select the usage and retention period.
7. Once the modification is complete, click the Save button.

Deleting Archive Files

To delete Archive files, follow these steps:

1. Click All Services > Database > MySQL(DBaaS) menu. The MySQL(DBaaS) Service Home page will be displayed.
2. Click the MySQL(DBaaS) menu on the Service Home page. The MySQL(DBaaS) list page will be displayed.
3. Click the resource for which you want to set the Archive mode on the MySQL(DBaaS) list page. The MySQL(DBaaS) details page will be displayed.
4. Click the More button and then click the Archive Settings Management button. The Archive Settings Management page will be displayed.
5. Click the Archive All Delete button to delete all Archive files, or click the Backup Archive Delete button to delete only the backed-up Archive files.

Exporting DB Logs

The function to export audit logs to Object Storage is supported, allowing users to set the log type, target bucket, and export cycle. According to the set criteria, the logs are copied to the specified Object Storage for storage. Additionally, an option to automatically delete the original log files when exporting logs to Object Storage is provided, allowing users to effectively secure storage capacity while safely storing necessary log data.

Setting DB Log Export Mode

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

1. Click All Services > Database > MySQL(DBaaS) menu. The MySQL(DBaaS) Service Home page will be displayed.
2. Click the MySQL(DBaaS) menu on the Service Home page. The MySQL(DBaaS) list page will be displayed.
3. Click the resource for which you want to export DB logs on the MySQL(DBaaS) list page. The MySQL(DBaaS) details page will be displayed.
4. Click the More button and then click the DB Log Export button. The DB Log Export page will be displayed.
5. Click the Register button on the DB Log Export page. The DB Log Export Registration page will be displayed.
6. Enter the required information on the DB Log Export Registration page and click the Save button.

Managing DB Log Export

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

1. Click All Services > Database > MySQL(DBaaS) menu. The MySQL(DBaaS) Service Home page will be displayed.
2. Click the MySQL(DBaaS) menu on the Service Home page. The MySQL(DBaaS) list page will be displayed.
3. Click the resource for which you want to manage DB log export on the MySQL(DBaaS) list page. The MySQL(DBaaS) details page will be displayed.
4. Click the More button and then click the DB Log Export button. The DB Log Export page will be displayed.
5. Click the More button for the log type you want to manage on the DB Log Export page, and then click the Immediate Export, Modify, or Cancel button.
   • Immediate Export: Exports the selected log to the Object Storage bucket.
   • Modify: Modifies the DB log export mode setting.
   • Cancel: Cancels the DB log export mode setting.

Upgrading DB Version

The function to upgrade the version for some feature improvements and security patches is provided. Only minor version upgrades are supported within the same major version.

To upgrade the version, follow these steps:

1. Click the All Services > Database > MySQL(DBaaS) menu. It moves to the Service Home page of MySQL(DBaaS).
2. Click the MySQL(DBaaS) menu on the Service Home page. It moves to the MySQL(DBaaS) List page.
3. Click the resource to be upgraded on the MySQL(DBaaS) List page. It moves to the MySQL(DBaaS) Details page.
4. Click the Modify button in the image/version item. The Version Upgrade popup window opens.
5. In the Version Upgrade popup window, select the version to be modified and the backup setting, and then click the OK button.
6. Click the OK button in the Version Upgrade Notification popup window.

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 these steps:

1. Click the All Services > Database > MySQL(DBaaS) menu. It moves to the Service Home page of MySQL(DBaaS).
2. Click the MySQL(DBaaS) menu on the Service Home page. It moves to the MySQL(DBaaS) List page.
3. Click the resource to be migrated on the MySQL(DBaaS) List page. It moves to the MySQL(DBaaS) Details page.
4. Click the More button and then click the Configure Migration button. The Configure Migration popup window opens.
5. In the Configure Migration popup window, check the instructions and click the OK button. It moves to the Configure Migration page.
6. On the Configure Migration page, enter the corresponding information and click the Connect Check button.
7. When the connection is complete, click the Complete button.

The configured migration cluster can be promoted to a master cluster.

To promote the migration cluster to a master, follow these steps:

1. Click the All Services > Database > MySQL(DBaaS) menu. It moves to the Service Home page of MySQL(DBaaS).
2. Click the MySQL(DBaaS) menu on the Service Home page. It moves to the MySQL(DBaaS) List page.
3. Click the resource to be promoted to a master on the MySQL(DBaaS) List page. It moves to the MySQL(DBaaS) Details page.
4. Click the More button and then click the Promote to Master button. The Master Promotion Notification popup window opens.
5. Click the OK button in the Master Promotion Notification popup window.