Managing DB Services

Users can manage MariaDB (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 > MariaDB (DBaaS) menu. You will be taken 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. Click the resource you want to view and modify parameters 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 Parameter Management button. The Parameter Management popup window will open.
5. Click the View button in the Parameter Management popup window. The View Notification popup window will open.
6. When the View Notification popup window opens, click the OK button. It may take some time to view.

Modifying Parameters

To modify configuration parameters, 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. Click the MariaDB (DBaaS) menu on the Service Home page. You will be taken to the MariaDB (DBaaS) List page.
3. Click the resource you want to view and modify parameters 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 Parameter Management button. The Parameter Management popup window will open.
5. Click the View button in the Parameter Management popup window. The View Notification popup window will open.
6. When the View Notification popup window opens, click the OK button. It may take some time to view.
7. If modification is necessary, click the Modify button and enter the modification contents in the custom 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 > MariaDB (DBaaS) menu. You will be taken 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. Click the resource you want to view DB users 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 User Management button. You will be taken to the DB User Management page.
5. Click the View button on the DB User Management page. It may take 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 > MariaDB (DBaaS) menu. You will be taken 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. Click the resource you want to modify DB users 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 User Management button. You will be taken to the DB User Management page.
5. Click the View button on the DB User Management page. It may take some time to view.
6. If modification is necessary, click the Modify button and change the status value or enter notes.
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 authorized 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 > MariaDB (DBaaS) menu. You will be taken 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. Click the resource you want to manage access control 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. Click the View button on the DB Access Control Management page. It may take some time to view.

Adding DB Access Control

To add 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. Click the MariaDB (DBaaS) menu on the Service Home page. You will be taken to the MariaDB (DBaaS) List page.
3. Click the resource you want to add IP access control 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. Click the View button on the DB Access Control Management page. It may take some time to view.
6. When the view is complete, click the Add button. The DB Access Control Add popup window will open.
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. All Services > Database > MariaDB(DBaaS) menu, click. Move to the Service Home page of MariaDB(DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. Move to the MariaDB(DBaaS) list page.
3. On the MariaDB(DBaaS) list page, click the resource for which you want to delete IP access control. Move to the MariaDB(DBaaS) details page.
4. Click the More button and then click the DB Access Control Management button. Move to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Inquire button. It takes some time to inquire.
6. Once the inquiry is complete, click the Delete button. The Delete pop-up window opens.
7. In the Delete pop-up window, click the Confirm button.

Managing Archives

The Archive mode setting and Archive Log storage period setting functions are provided to allow users to flexibly set the Archive log management policy according to their operating environment. In addition, 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. All Services > Database > MariaDB(DBaaS) menu, click. Move to the Service Home page of MariaDB(DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. Move to the MariaDB(DBaaS) list page.
3. On the MariaDB(DBaaS) list page, click the resource for which you want to set the Archive mode. Move to the MariaDB(DBaaS) details page.
4. Click the More button and then click the Archive Settings Management button. Move to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Inquire button. It takes some time to inquire.
6. Click the Modify button and select the usage and storage period.
7. Once the modification is complete, click the Save button.

Deleting Archive Files

To delete Archive files, follow these steps:

1. All Services > Database > MariaDB(DBaaS) menu, click. Move to the Service Home page of MariaDB(DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. Move to the MariaDB(DBaaS) list page.
3. On the MariaDB(DBaaS) list page, click the resource for which you want to set the Archive mode. Move to the MariaDB(DBaaS) details page.
4. Click the More button and then click the Archive Settings Management button. Move to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Delete All Archives button to delete all Archive files, or click the Delete Backed-up Archives button to delete only the backed-up Archive files.

Exporting DB Logs

Supports exporting log data that requires long-term storage among audit logs to Object Storage. Users can directly set the type of log to be stored, the target bucket to be exported, and the cycle of exporting logs. According to the set criteria, logs are copied to the specified Object Storage for storage. In addition, an option to automatically delete the original log file while exporting logs to Object Storage is provided to efficiently manage disk space. By utilizing this option, users can safely store necessary log data for a long time while effectively securing storage capacity.

Setting DB Log Export Mode

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

1. All Services > Database > MariaDB(DBaaS) menu, click. Move to the Service Home page of MariaDB(DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. Move to the MariaDB(DBaaS) list page.
3. On the MariaDB(DBaaS) list page, click the resource for which you want to export DB logs. Move to the MariaDB(DBaaS) details page.
4. Click the More button and then click the DB Log Export button. Move to the DB Log Export page.
5. On the DB Log Export page, click the Registration button. Move to the DB Log Export Registration page.
6. On the DB Log Export Registration page, enter the corresponding information and click the Save button.

Managing DB Log Export

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

1. All Services > Database > MariaDB(DBaaS) menu, click. Move to the Service Home page of MariaDB(DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. Move to the MariaDB(DBaaS) list page.
3. On the MariaDB(DBaaS) list page, click the resource for which you want to manage DB log export. Move to the MariaDB(DBaaS) details page.
4. Click the More button and then click the DB Log Export button. 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 then click the Immediate Export, Modify, or Cancel button.
   • Immediate Export: Exports the selected log to the Object Storage bucket set earlier.
   • Modify: Modifies the DB log export mode setting.
   • Cancel: Cancels the DB log export mode setting.

Upgrading DB Version

Provides a version upgrade function due to some feature improvements and security patches. Only minor version upgrades are supported within the same major version.

To upgrade the version, follow the procedure below.

1. Click the All Services > Database > MariaDB(DBaaS) menu. It moves to the Service Home page of MariaDB(DBaaS).
2. Click the MariaDB(DBaaS) menu on the Service Home page. It moves to the MariaDB(DBaaS) list page.
3. Click the resource to be upgraded on the MariaDB(DBaaS) list page. It moves to the MariaDB(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 Confirm button.
6. Click the Confirm 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 the procedure below.

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 to click the Configure Migration button. The Configure Migration popup window opens.
5. In the Configure Migration popup window, check the instructions and click the Confirm 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 the procedure below.

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 to click the Promote to Master button. The Master Promotion Notification popup window opens.
5. Click the Confirm button in the Master Promotion Notification popup window.