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 a MySQL (DBaaS) Instance

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

To create a MySQL (DBaaS) instance, 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 Create MySQL (DBaaS) button. 2. Go to the Create MySQL (DBaaS) page.
3. On the Create MySQL (DBaaS) page, enter the information required to create the service and select the detailed options.
   • Select the required information in the Image and Version Selection area.

     Category	Required	Detailed Description
     Image version	Required	Provide a list of MySQL (DBaaS) versions

     Table. MySQL (DBaaS) image and version selection options
   • Enter or select the required information in the Service Information Input area.

     Category	Required	Detailed Description
     Server Name Prefix	Required	Server name where the DB will be installed Must start with a lowercase letter and be 3 to 13 characters long, using lowercase letters, numbers, and special characters (-) A postfix such as 001 or 002 is appended to the server name to generate the actual server name
     Cluster Name	Required	The cluster name in which the DB servers are configured Enter 3 to 20 characters using letters and numbers A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type for the DB installation Standard: Standard specifications commonly used High Capacity: High-capacity servers with 24 vCores or more For details on the server types provided by MySQL(DBaaS), see MySQL(DBaaS) server types
     Service Type > Planned Compute	Select	Resource status with Planned Compute configured In Use: The number of resources in use among those with Planned Compute configured Configured: The number of resources with Planned Compute configured Coverage Preview: The amount applied by Planned Compute for each resource Create Planned Compute Service: Navigate to the Planned Compute service request page For details, refer to Request Planned Compute
     Service Type > Block Storage	Required	Configure the Block Storage used by the DB according to its purpose Base OS: The area where the DB engine is installed DATA: The storage area for table data, archive files, and more Select a storage type and enter the capacity (For details on each Block Storage type, see Create Block Storage) SSD: High-performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volumes using Samsung Cloud Platform KMS (Key Management System) encryption keys The configured Storage type is applied identically to additional storage Enter the capacity as a multiple of 8 within the range of 16 to 5,120 Service interruptions may occur due to large-scale sorting from SQL execution or monthly batch processing, so you must allocate and use a separate TEMP storage Additional: Storage area for DATA, Archive, TEMP, and Backup data Select Use, then enter the storage purpose and capacity The storage type is applied identically to the type configured in DATA, and the capacity can be entered as a multiple of 8 within the range of 16 to 5,120 To add storage, click the Add button. To delete, click the x button. You can add up to 9 storages Temporarily store backup data in the BACKUP storage before transferring the backup data If the data to be backed up exceeds 100 GB and has frequent data changes, it is recommended to add a separate BACKUP storage for stable backups. It is recommended to set the backup capacity to approximately 60% of the DATA capacity If you do not add a BACKUP storage, the /tmp area is used, and the backup will fail if the capacity is insufficient Only one Block Storage is allocated for the Archive, TEMP, and BACKUP storages per service
     Redundancy Configuration	Select	Whether a high-availability configuration is in place When a high-availability configuration is used, the DB instance is configured with a separation between the Active DB and the Standby DB.
     Network > Common Settings	Required	Network settings for the servers created by the service and installed on them. Select this option to apply the same settings to all servers being installed. Select a pre-created VPC, Subnet, IP, and Public NAT. The IP for each server is generated automatically. The Public NAT feature is available only if the VPC is connected to an Internet Gateway. When Use is checked, you can select a reserved IP from the Public IPs of the VPC product. For details, see Create a Public IP.
     Network > Per-Server Settings	Required	Network settings for the servers created by the service to be installed on. Select this to apply different settings for each server being installed. Select a pre-created VPC, Subnet, IP, and Public NAT. Enter the IP address for each server. The Public NAT feature is available only if the VPC is connected to an Internet Gateway. When Use is checked, you can select a reserved IP from the Public IPs of the VPC product. For details, see Create a Public IP.
     IP Access Control	Select	Configure Service Access Policy Access policies are configured for the IPs entered on the page, so there is no need to separately configure Security Group policies. 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 IP.
     Maintenance period	Select	DB Maintenance Window When you select Usage, you can configure the day of the week, start time, and duration. The maintenance window is a feature that allows users to set the time zone for performing patch operations. Patch operations performed within this time frame are the user’s responsibility. To ensure stable system operation, please configure a maintenance window. We are not responsible for any issues arising from a missing configuration or failure to perform operations within the specified window.

     Table. MySQL (DBaaS) service configuration items
   • Enter or select the required information in the Database Configuration Required Information section.

     Category	Required	Detailed Description
     Database name	Required	Server name applied during DB installation Must start with a letter and be 3 to 20 characters long, using only letters and numbers
     Database username	Required	DB username A system account with the same name is also created on the OS. Enter 2 to 20 characters using lowercase letters. Restricted database usernames can be checked 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 “ ‘)
     Verify the database password	Required	Re-enter the password to be used for DB access
     Database Port Number	Required	Port number required for DB connection Enter the DB port within the range of 1200 to 65535
     Backup > Usage	Select	Whether to use backup Select Use to configure the backup file retention period, backup start time, and Archive backup frequency
     Backup > Retention Period	Select	Backup retention period Select the backup retention period. The file retention period can be set from 7 to 35 days. Backup files are subject to additional charges based on capacity.
     Backup > Backup Start Period	Select	Backup start time Select the backup start time The minutes at which the backup is performed are set randomly, and the backup end time cannot be configured
     Backups > Archive backup frequency	Select	Archive backup interval Select an archive backup interval A 1-hour archive backup interval is recommended. 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 detailed parameter information. Parameters can be modified only after DB creation is complete. After making changes, you must restart the DB.
     DB character set	Required	Character encoding to use for the database
     Table Case Sensitivity	Select	Case Sensitivity of DB Tables
     Time zone	Required	The standard time zone in which the database will be used
     ServiceWatch log collection	Select	Whether to collect ServiceWatch logs Select Use to configure the ServiceWatch log collection feature Provided free of charge for all services within the Account up to 5 GB. For usage exceeding 5 GB, fees are charged based on storage capacity Log groups and log streams are automatically created upon collection and cannot be deleted until the resources are deleted To prevent exceeding 5 GB, we recommend directly deleting log data or shortening the retention period

     Table. MySQL (DBaaS) Database Configuration Items
   • Enter or select the required information in the Additional Information area.

     Category	Required	Detailed Description
     Tag	Select	Add Tag You can add up to 50 tags per resource Click the Add Tag button, then enter or select the Key and Value

     Table. MySQL (DBaaS) additional information input items
4. Review the details and estimated billing amount generated in the Summary panel, and then click the Generate button.
   • After generation is complete, check the created resource on the Resource List page.

Viewing MySQL (DBaaS) Details

The MySQL (DBaaS) service allows you to view and modify the full resource list and detailed information. The MySQL (DBaaS) Details page consists of the Details, Tags, and Operation History tabs. For databases with configured replicas, an additional Replica Information tab is included.

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

1. Click the All Services > Database > MySQL(DBaaS) menu. 1. Go to the Service Home page for MySQL (DBaaS).
2. On the Service Home page, click the MySQL(DBaaS) menu. 2. Go to the MySQL(DBaaS) List page.
3. Click the resource for which you want to view detailed information on the MySQL (DBaaS) List page. 3. Go to the MySQL(DBaaS) Details page.
   • The top of the MySQL(DBaaS) Details page displays status information and information about additional features.

     Category	Detailed Description
     Cluster status	Cluster status with the DB installed Creating: The cluster is being created Editing: The cluster is transitioning to a state where it is performing an Operation Error: The cluster encountered a failure while performing a task If this occurs persistently, contact the administrator Failed: The cluster failed during the creation process Restarting: The cluster is restarting Running: The cluster is operating normally Starting: The cluster is starting Stopped: The cluster is stopped Stopping: The cluster is stopping Synchronizing: The cluster is synchronizing Terminating: The cluster is being deleted Unknown: The cluster status is unknown If this occurs persistently, contact the administrator Upgrading: The cluster is transitioning to a state where it is performing an upgrade
     Cluster Control	Buttons that can change the cluster state Start: Starts a stopped cluster Stop: Stops a running cluster Restart: Restarts a running cluster Switch-Over: Switches a Standby cluster to Active
     View additional features	Cluster-related management buttons Service Status Synchronization: Query real-time DB service status Backup History: If backups are configured, check whether backups are running normally and view the history Database Recovery: Restore the DB based on a specific point in time Parameter Management: View and modify DB configuration parameters Replica Configuration: Configure a read-only cluster replica Replica Configuration (Other-Region): Configure a disaster recovery replica in another region. If no region is available to configure in the corresponding Account, this button is disabled DB User Management: View and manage DB account (user) information registered in the DB DB Access Control Management: Register and revoke allowed access IPs based on DB accounts registered in the DB Archive Management: Set the archive file retention period and archive mode DB Log Export: Export logs stored through Audit settings to the user’s Object Storage Migration Configuration: Provides a migration feature using the Replication method Block Storage Usage Management: Provides a feature to query usage by Block Storage type OS (Kernel) Upgrade: Upgrade the OS Kernel version
     Service Cancellation	Button for canceling the service

     Table. MySQL (DBaaS) status information and additional features

Detailed Information

On the MySQL (DBaaS) List page, you can view the details of the selected resource and modify the information as needed.

Replica information

The Replica Information tab is enabled only when a Replica is configured in the cluster. You can check the master cluster name, the number of replicas, and the replica status on the Replica Information tab.

Tag

On the MySQL (DBaaS) List page, you can view the tag information for the selected resource and add, modify, or delete tags.

Job History

You can view the operation history of the selected resource on the MySQL (DBaaS) List page.

Managing MySQL (DBaaS) Resources

To modify or restore existing configuration options for a generated MySQL (DBaaS) resource, or to configure a replica, perform the task on the MySQL (DBaaS) Details page.

Controlling Operation

You can start, stop, or restart a running MySQL (DBaaS) resource when changes occur. Additionally, in an HA configuration, you can switch the Active-Standby servers through a failover.

To control the operation of MySQL (DBaaS), 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. Go to the MySQL (DBaaS) List page.
3. On the MySQL (DBaaS) List page, click the resource you want to control. 3. Go to the MySQL (DBaaS) Details page.
4. Check the MySQL (DBaaS) status and complete the change using the control buttons below.
   • Start: The DB service is installed on the server, and the DB service is running.
   • Stop: The server where the DB service is installed and the DB service are stopped.
   • Restart: Only the DB service is restarted.
   • Switch Over: You can switch the Active server and the Standby server in the DB.

Synchronize service status

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

To check the service status of MySQL (DBaaS), 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. Go to the MySQL (DBaaS) List page.
3. On the MySQL(DBaaS) List page, click the resource to check its service status. 3. Go to the MySQL(DBaaS) Details page.
4. Click the Service Status Sync button. 4. While the query is in progress, the cluster changes to the Synchronizing state.
5. Once the query is complete, the status in the server information section 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. 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. Go to the MySQL(DBaaS) List page.
3. On the MySQL(DBaaS) List page, click the resource for which you want to change the server type. 3. Go to the MySQL (DBaaS) Details page.
4. Click the Edit icon for the server type you want to change at the bottom of the details section. 4. The Edit Server Type popup opens.
5. In the Edit Server Type popup, select a server type and then click the OK button.

Add Storage

If you need more than 5 TB of data storage space, you can add storage. For a database configured for high availability, both high-availability 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. Go to the MySQL(DBaaS) List page.
3. On the MySQL(DBaaS) List page, click the resource to which you want to add storage. 3. Go to the MySQL (DBaaS) Details page.
4. Click the Add Disk button at the bottom of the details section. 4. The Request Additional Storage popup window opens.
5. In the Request Additional Storage popup, enter the purpose and capacity, then 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. For a database configured with high availability, both servers in the high-availability pair are scaled out simultaneously.

To expand storage capacity, 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. Go to the MySQL(DBaaS) List page.
3. On the MySQL (DBaaS) List page, click the resource for which you want to change the server type. 3. Go to the MySQL (DBaaS) Details page.
4. Click the Edit icon for the additional disk you want to add at the bottom of the details section. 4. The Edit Additional Storage popup opens.
5. In the Modify Additional Storage dialog box, enter the expansion capacity and click the OK button.

Terminate MySQL (DBaaS)

You can reduce operational costs by canceling unused MySQL (DBaaS). However, if you cancel the service, the running service may be terminated immediately. Therefore, you must carefully consider the impact of the service interruption before proceeding with the cancellation.

To cancel MySQL (DBaaS), 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. Go to the MySQL (DBaaS) List page.
3. On the MySQL (DBaaS) List page, select the resource to cancel and click the Cancel Service button.
4. After the cancellation is complete, verify that the resource has been canceled on the MySQL(DBaaS) list page.