How-to guides

Users can create the service by entering the required information for MySQL (DBaaS) and selecting detailed options through the Samsung Cloud Platform Console.

Create MySQL (DBaaS)

You can create and use a MySQL (DBaaS) service from the Samsung Cloud Platform Console.

To create a MySQL (DBaaS), follow the steps below.

1. All Services > Database > MySQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of MySQL (DBaaS).
2. On the Service Home page, click the Create MySQL(DBaaS) button. 2. Go to the MySQL(DBaaS) Creation page.
3. MySQL (DBaaS) Creation page: enter the information required to create the service and select detailed options.
   • Select the required information in the Image and version selection area.

     Category	required status	Detailed description
     Image version	Essential	Provide a list of MySQL (DBaaS) versions

     Table. MySQL (DBaaS) Image and version selection options
   • In the Service Information Input area, enter or select the required information.

     Category	required status	Detailed description
     Server name Prefix	Required	The server name where the DB will be installed starts with a lowercase English letter and uses lowercase letters, numbers, and the special character (-) to enter 3 to 13 characters A postfix such as 001, 002 is appended based on the server name, creating the actual server name
     Cluster name	Essential	Cluster name of DB servers Enter using English letters, 3 ~ 20 characters A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type for DB installation Standard: standard specifications commonly used High Capacity: large‑capacity server with 24 vCores or more For detailed information about the server types provided by MySQL (DBaaS), refer to MySQL(DBaaS) 서버 타입
     Service Type > Planned Compute	Selection	Status of resources with Planned Compute configured In Use: Number of resources with Planned Compute configured that are currently in use Configured: Number of resources with Planned Compute configured Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Navigate to the Planned Compute service request page For more details, see Planned Compute Apply
     Service Type > Block Storage	Required	Block Storage configuration used by the DB according to its purpose Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Select a storage type and then enter the capacity (see Block Storage 생성하기 for details on each Block Storage type) SSD: High‑performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volumes that use Samsung Cloud Platform KMS (Key Management System) encryption keys The configured storage type is applied identically to additional storage Capacity must be entered as a multiple of 8 within the range 16 to 5,120 Since executing SQL or monthly batch jobs can cause large sorts that may interrupt service, a separate TEMP storage must be allocated and used Add: Storage areas for DATA, Archive, TEMP, Backup data After selecting Use, enter the storage’s purpose and capacity The storage type is applied the same as the type set for DATA, and capacity can be entered as a multiple of 8 within the range 16 to 5,120 To add storage, click the Add button; to delete, click the x button. Up to 9 can be added. Temporarily store backup data in BACKUP storage before transmitting it If the data to be backed up exceeds 100 GB and undergoes frequent changes, it is recommended to add a separate BACKUP storage for reliable backup. Set the backup capacity to about 60 % of the DATA capacity. If a BACKUP storage is not added, the /tmp area is used, and backup will fail if capacity is insufficient For each service, only one Block Storage is allocated for Archive, TEMP, and BACKUP
     Redundant configuration	Select	Redundancy configuration When redundancy is used, the DB instance is configured as separate Active DB and Standby DB
     Network > Common Settings	Required	Network settings for servers created by the service Select when you want to apply the same settings to all installed servers Select a pre‑created VPC, Subnet, IP, and Public NAT IP can only be auto‑generated The Public NAT feature is available only when the VPC is connected to an Internet Gateway. Use is checked, you can select from reserved IPs in the VPC product’s Public IP. For more details, see Public IP 생성하기
     Network > Server-specific Settings	Required	Network settings where servers generated by the service are installed Select when you want to apply different settings for each installed server Select a pre‑created VPC, Subnet, IP, and Public NAT Enter the IP for each server The Public NAT feature is available only when the VPC is connected to an Internet Gateway. Use when checked, you can select from reserved IPs in the VPC product’s Public IP. For more information, see Public IP 생성하기
     IP access control	Select	Service Access Policy Configuration Since the access policy is set for the IP entered on the page, you do not need to configure a separate Security Group policy. Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.0/24, 192.168.10.1/32) and click the Add button To delete an entered IP, click the x button next to the entered IP
     maintenance period	Select	Database maintenance window If you select Use, set the day of week, start time, and duration It is recommended to set a maintenance window for stable management of the DB. Patch operations will be performed at the scheduled time, causing service interruption If set to unused, Samsung SDS is not responsible for issues arising from unapplied patches.

     Table. MySQL (DBaaS) Service Configuration Items
   • Enter required database configuration information In this section, enter or select the required information.

     Category	Required status	Detailed description
     Database name	Required	Server name applied during DB installation must start with an English letter and be entered using English letters and numbers, 3 to 20 characters
     Database username	Required	Database user name An account with the same name is also created on the OS Enter using lowercase English letters, 2 to 20 characters Restricted database user names can be viewed in the Console
     Database password	required	Password to use when accessing the DB Enter 8 to 30 characters, including letters, numbers, and special characters (excluding “ ‘)
     Database password verification	Required	Re-enter the same password to use for DB access
     Database Port number	Essential	Port number required for DB connection Enter DB port within the range 1200 ~ 65535
     Backup > Use	Select	Backup usage Use to select and set backup file retention period, backup start time, and Archive backup interval
     Backup > Retention period	Select	Backup retention period Select the backup retention period. Set the file retention period from 7 days to 35 days Backup files incur additional charges based on size
     Backup > Backup Start Period	Select	Backup start time Select backup start time The minutes during which the backup runs (minutes) are set randomly, and the backup end time cannot be set
     Backup > Archive backup cycle	Selection	Archive backup frequency Select the archive backup frequency The archive backup frequency is recommended at 1 hour. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance
     Parameter	Required	Parameters to be used in the DB Click the View button to view the parameter’s detailed information Parameters can be modified after the DB creation is complete, and after modification the DB must be restarted
     DB character set	Required	Character encoding to use for the database
     Table case sensitivity	Select	DB Table case sensitivity
     time zone	Required	Standard time zone for the database
     ServiceWatch log collection	Selection	Whether to collect ServiceWatch logs Select Use to enable the ServiceWatch log collection feature For details about the collected logs, see ServiceWatch metrics Up to 5 GB is provided free of charge for all services within the account, and charges apply based on storage size for usage exceeding 5 GB When collecting, log groups and log streams are created automatically, and they cannot be deleted until the resource is removed To prevent exceeding 5 GB, it is recommended to delete log data directly or shorten the retention period

     Table. MySQL (DBaaS) Database configuration items
   • Additional Information Input area, please enter or select the required information.

     Category	required status	Detailed description
     Tag	Select	Add Tag Up to 50 per resource can be added After clicking the Add Tag button, enter or select Key, Value values

     Table. MySQL (DBaaS) additional information input fields
4. Check the detailed information and estimated billing amount generated in the Summary panel, and click the Create button.
   • When creation is complete, check the created resources on the Resource List page.

View MySQL (DBaaS) detailed information

The MySQL (DBaaS) service allows you to view and edit the full list of resources and detailed information. MySQL(DBaaS) Details page consists of Details, Tags, Operation History tabs, and when the DB has a Replica configured, a Replica Information tab is added.

To view detailed information about the MySQL (DBaaS) service, follow these steps.

1. Click the All Services > Database > MySQL(DBaaS) menu. 1. Go to the Service Home page of MySQL (DBaaS).
2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Go to the page.
3. On the MySQL(DBaaS) List page, click the resource to view detailed information. 3. MySQL(DBaaS) Details Go to the page.
   • MySQL(DBaaS) Details At the top of the page, status information and additional feature details are displayed.

     Category	Detailed description
     Cluster status	Cluster status with DB installed Creating: Cluster is being created Editing: Cluster is transitioning to an operational state Error: Cluster encountered a failure while performing a task If this persists, contact the administrator Failed: Cluster failed during creation Restarting: Cluster is being restarted Running: Cluster is operating normally Starting: Cluster is starting Stopped: Cluster is stopped Stopping: Cluster is being stopped Synchronizing: Cluster is synchronizing Terminating: Cluster is being terminated Unknown: Cluster status is unknown If this persists, contact the administrator Upgrading: Cluster is being upgraded
     Cluster control	Buttons to change the cluster state Start: Start a stopped cluster Stop: Stop a running cluster Restart: Restart a running cluster Switch-Over: Switch a standby cluster to active
     More features	Cluster management buttons Service status synchronization: Real-time DB service status lookup Backup history: When backup is configured, verify whether backups run correctly and view the history Database recovery: Recover the DB based on a specific point in time Parameter management: View and modify DB configuration parameters Replica configuration: Set up a read‑only Replica cluster Replica configuration (Other-Region): Set up a disaster‑recovery Replica in another region; the button is disabled if the account has no region to configure DB user management: View and manage DB account (user) information registered in the DB DB access control management: Register and revoke allowed IPs based on DB accounts registered in the DB Archive management: Set archive file retention periods and configure archive mode DB Log export: Export stored logs to the user’s Object Storage via audit settings Migration configuration: Provides migration functionality using replication OS (Kernel) upgrade: Upgrade the OS kernel version
     Service termination	Cancel service button

     Table. MySQL (DBaaS) status information and additional features

Detailed information

MySQL (DBaaS) List page lets you view detailed information of the selected resource and edit the information if needed.

Replica information

Replica Information tab is enabled only when a Replica is configured in the cluster. Replica information tab allows you to view the Master cluster name, replica count, and Replica status.

tag

MySQL(DBaaS) List page lets you view the tag information of the selected resource, and you can add, modify, or delete it.

Work History

MySQL(DBaaS) List page allows you to view the operation history of the selected resource.

Managing MySQL(DBaaS) Resources

If you need to change or restore the existing configuration options of a provisioned MySQL (DBaaS) resource, or set up a replica, you can perform the tasks on the MySQL(DBaaS) Detailed Information page.

Control operation

If changes occur to a running MySQL (DBaaS) resource, you can start, stop, or restart it. Additionally, when HA is configured, you can switch the Active‑Standby servers using a switch‑over.

To control the operation of MySQL (DBaaS), follow the steps below.

1. All Services > Database > MySQL(DBaaS) Click the menu. 1. Go to the Service Home page of MySQL (DBaaS).
2. On the Service Home page, click the MySQL(DBaaS) menu. 2. Navigate to the MySQL(DBaaS) List page.
3. MySQL(DBaaS) List page, click the resource to control its operation. 3. MySQL(DBaaS) Details Go to the page.
4. Check the MySQL (DBaaS) status and complete the change using the control button below.
   • Start: DB service is installed on the server and the DB service is running (Running).
   • Stop: The server where the DB service is installed and the DB service are stopped (Stopped).
   • Restart: Only the DB service will be restarted.
   • Switch Over: You can switch the DB’s Active server and Standby server.

Synchronize Service Status

You can synchronize the real-time service status of MySQL (DBaaS).

To check the service status of MySQL (DBaaS), follow the steps below.

1. Click the All Services > Database > MySQL (DBaaS) menu. 1. Go to the Service Home page of MySQL (DBaaS).
2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Navigate to the page.
3. MySQL (DBaaS) List page, click the resource to view its service status. 3. MySQL(DBaaS) Details Navigate to the page.
4. Click the Service Status Sync button. 4. While it is being queried, the cluster changes to Synchronizing state.
5. When the query completes, the status in the server information field is updated, and the cluster changes to the Running state.

Change server type

You can change the configured server type.

To change the server type, follow these steps.

1. All Services > Database > MySQL(DBaaS) Click the menu. 1. Go to the Service Home page of MySQL (DBaaS).
2. On the Service Home page, click the MySQL(DBaaS) menu. 2. Navigate to the MySQL(DBaaS) List page.
3. MySQL(DBaaS) List page: click the resource for which you want to change the server type. 3. Navigate to the MySQL (DBaaS) Details page.
4. Click the Edit icon of the server type you want to change at the bottom of the detailed information. 4. Edit Server Type The popup window opens.
5. Server Type Edit After selecting the server type in the popup window, click the Confirm button.

Add storage

If you need more than 5 TB of data storage, you can add additional storage. For a redundant DB configuration, all redundant servers are added simultaneously.

To add storage, follow these steps.

1. Click the All Services > Database > MySQL(DBaaS) menu. 1. Go to the Service Home page of MySQL (DBaaS).
2. On the Service Home page, click the MySQL(DBaaS) menu. 2. Navigate to the MySQL(DBaaS) List page.
3. On the MySQL(DBaaS) List page, click the resource to add storage. 3. MySQL(DBaaS) Details Navigate to the page.
4. Click the Add Disk button at the bottom of the detailed information. 4. Additional Storage Request The popup window opens.
5. Additional Storage Request In the popup window, after entering the purpose and size, click the Confirm button.

Expanding storage

Storage added to the data area can be expanded up to a maximum of 5 TB based on the initially allocated capacity. In the case of a redundant DB configuration, all redundant servers are expanded simultaneously.

To expand storage capacity, follow the steps below.

1. All Services > Database > MySQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of MySQL (DBaaS).
2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Navigate to the page.
3. MySQL(DBaaS) List page, click the resource whose server type you want to change. 3. MySQL(DBaaS) Details Go to the page.
4. Click the Edit icon of the additional Disk you want to add at the bottom of the detailed information. 4. Edit Additional Storage The popup window opens.
5. Edit Additional Storage In the popup window, after entering the expansion capacity, click the Confirm button.

Cancel MySQL (DBaaS)

You can cancel unused MySQL (DBaaS) to reduce operating costs. However, if you terminate the service, the running service may be stopped immediately, so you should proceed with the termination only after fully considering the impact that may occur when the service is discontinued.

To cancel MySQL (DBaaS), follow the steps below.

1. Click the All Services > Database > MySQL(DBaaS) menu. 1. Go to the Service Home page of MySQL (DBaaS).
2. On the Service Home page, click the MySQL(DBaaS) menu. 2. MySQL(DBaaS) List Navigate to the page.
3. On the MySQL(DBaaS) List page, select the resource to cancel and click the Cancel Service button.
4. After termination is complete, check on the MySQL(DBaaS) list page whether the resource has been terminated.