DB Cluster details

Available in VPC

While operating the DB cluster, situations where you need to change the options related to the DB set upon creation may occur. Cloud DB Serverless supports changes of related settings simply through a few clicks, even for clusters that have already been created.

To manage DB Cluster that has been created and is in operation:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB Serverless.
2. Click the DB Cluster menu.
3. In the DB cluster list, click the cluster you want to manage, and then click [DB Management].
4. Click the necessary management tab at the DB Cluster details menu.

Manage Database

You can add a DB to the selected DB cluster or delete a DB you created. Up to 1,000 DB can be added or viewed, and the addition or deletion tasks can be performed for up to 10 DB at a time.

To perform a DB addition or creation task, click [Add Database] to add database, or click [Delete] in the same row as the created DB to delete the DB.

Manage DB Config

Various settings can be changed while the DB cluster is in the Running state. The changed settings are applied to the entire DB Cluster, and some config variables are applied after an automatic restart of the DB Cluster upon the change. To change:

1. At the DB Config Management tab, view or enter the required information.
   • Config Name: Name of config variable to set.
   • Config Value: Variable value.
2. Click the [Add] button.
   • When editing the added config variable: Click the [Edit] button.
   • When deleting the added config variable (setting it to default), click the [Delete] button.
3. Click the [Save] button.
4. View the status with the modified config from the DB Cluster list.
   • Configuring: Status in which the DB cluster is configured with the information you entered.
   • Running: status in which the DB cluster's configuration has been completed with the information you entered.

Config variable list

The following are descriptions of config variables:

Manage DB user

When creating a DB cluster, the ID and password for the account to access are created by default. However, while operating the DB cluster, you may need to add users or reset the passwords of existing user accounts. You may also need to delete user accounts. Cloud DB Serverless provides an DB User management feature that enables you to conveniently add, edit, and delete user accounts that use the DB cluster. The results of the user account change through the DB User management feature are applied to the entire DB Service. Up to 1,000 user accounts can be added.

To add or delete user accounts or change the password of the existing admin account:

1. At the Manage DB User tab, perform the required tasks for the user account.

   • Add user account: enter information in USER_ID, DB permissions, password, and system table, and click [Add DB User].
     • All DB permissions include the execute permission of the system DB.
     • The CRUD permission includes the READ permission, and the DDL permission includes the READ and CRUD permissions.
     • View procedure can be performed by any account regardless of permissions. For more information, see Official MySQL document (English).
     • Selecting a system table allows you to grant/reclaim SELECT permission for mysql DB.
   • Delete user account: Click the [Delete] button in the same row as the user account to be deleted.
   • Edit user account password: Click the [Edit] button in the same row as the user account to be edited, and click the [Save] button after editing.

2. Click the [Save] button.

3. Check the status of a DB cluster for which you've set users from the list in the DB cluster page.

   • Configuring: Status in which the DB cluster is configured with the information you entered.
   • Running: status in which the DB cluster's configuration has been completed with the information you entered.

DB Log setting management

You can change the log rotation and storage settings for the DB cluster you created. Changed settings are applied to the entire DB Cluster. To change:

1. At the Manage DB Log settings tab, see the following to change the settings:
   • Log: Check log name (select from Error Log, Slow Query Log, or General Log).
   • Log Rotate: Set the log rotation to be performed daily or by size.
     • When selecting by size, choose between 10MB and 100MB
   • Log file: Number of log files to be stored (select between 3 and 7)
2. Click the [Save] button.
3. In the DB Cluster interface, check the Status of the target with Log enabled in the DB cluster list.
   • Configuring: Status in which the DB cluster is configured with the information you entered.
   • Running: Status in which the DB cluster's configuration has been completed with the information you entered.

Manage Backup settings

You can change the backup file retention period and backup time for the selected DB cluster. To change:

1. At the Manage Backup settings tab, see the following to change the settings:
   • Backup settings: Select whether to use the backup settings of Cloud DB Serverless (currently the option cannot be changed)
   • Backup file retention period: You can enter 1 to 30
   • Backup time: Configuring backup time is performed within 15 minutes from the selected time.
     • Automatic: Backup is automatically started every day.
     • User-defined: The backup is started every day within 15 minutes from the time specified by the user
2. Click the [Save] button.