How-to guides

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

Create MariaDB(DBaaS)

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

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

1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Go to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the Create MariaDB (DBaaS) button. 2. MariaDB(DBaaS) Creation Navigate to the page.
3. On the MariaDB(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	required	Provide a list of MariaDB (DBaaS) versions

     Table. MariaDB (DBaaS) Image and version selection items
   • Enter or select the required information in the Service Information Input area.

     Category	required status	Detailed description
     Server name Prefix	required	Server name where the DB will be installed must start with a lowercase English letter and be entered using lowercase letters, numbers, and the special character (-) with a length of 3 ~ 13 characters based on the server name, a postfix such as 001, 002 is appended to generate the actual server name
     Cluster name	Required	Cluster name of DB servers Enter using English letters, 3 to 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 vCore or more For detailed information about the server types provided by MariaDB (DBaaS), see MariaDB(DBaaS) 서버 타입
     Service Type > Planned Compute	Selection	Resources with Planned Compute configured In Use: Number of resources with Planned Compute 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: Go to the Planned Compute service application page For more details, see Planned Compute Apply
     Service Type > Block Storage	required	Block Storage settings used by the DB according to purpose Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Select the storage type and then enter the capacity. (For details on each Block Storage type, see 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 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 service interruptions due to large sorts, a separate TEMP storage should be allocated and used Add: DATA, Archive, TEMP, Backup data storage area 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 the BACKUP storage before transmitting the backup data 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. It is advised to 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 fails if capacity is insufficient For each service, Archive, TEMP, and BACKUP storages are allocated only one Block Storage each
     Redundant configuration	Select	Redundancy configuration status When redundancy configuration is used, the DB instance is set up as an Active DB and a Standby DB
     Network > Common Settings	Required	Network settings for servers created by the service
     Select this option to apply the same settings to all installed servers
     Select a pre-created VPC, Subnet, IP, and Public NAT
     Each server’s IP is generated automatically
     The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If Use is checked, you can select from reserved IPs in the VPC product’s Public IP. For more details, refer to Public IP 생성하기
     Network > Server Settings	required	Network settings for servers created by the service
     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. If you select Use, you can choose a reserved IP from the VPC product’s Public IP. For more details, see Public IP 생성하기
     IP access control	Selection	Service Access Policy Settings Since the access policy is set for the IP entered on the page, you do not need to configure Security Group policies separately. 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 If you select Use, you can set the day of the week, start time, and duration The maintenance window is a feature that allows the user to set the time slot for performing patch operations, and any patch work within that time frame must be performed directly by the user. We ask you to set a maintenance window for the stable operation of the system, and we are not responsible for any issues arising from not setting it or from failure to perform tasks within the window.

     Table. MariaDB(DBaaS) Service Information Input Items
   • Database Configuration Required Information Input Enter or select the required information in the area.

     Category	required status	Detailed description
     Database name	required	Server name applied during DB installation must start with an alphabetic character and be entered using letters and numbers, 3 to 20 characters
     Database username	Required	DB 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 checked in the Console
     Database password	required	Password to use when accessing the DB English letters, numbers, and special characters (“ ‘ excluded) to be entered as 8 to 30 characters
     Verify Database password	Required	Re-enter the same password to be used for DB access.
     Database Port number	Required	Port number required for DB connection Enter the DB port within the range 1200 ~ 65535
     Backup > Use	Select	Backup usage status Select Use to set backup file retention period, backup start time, Archive backup cycle
     Backup > Retention Period	Selection	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	Selection	Backup start time Select backup start time The minutes (minutes) at which the backup runs are set randomly, and the backup end time cannot be configured
     Backup > Archive backup cycle	Select	Archive backup interval Select the archive backup interval The archive backup interval is recommended to be 1 hour. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance
     Audit Log Settings	Selection	Whether to store Audit Log Select Use to configure the Audit Log feature User connection information records are stored Users can specify the types of events to audit via the server_audit_events parameter, and can modify it through the Parameter screen Refer to the MariaDB documentation for detailed information about this parameter Enabling Audit may degrade database performance
     ServiceWatch log collection	Select	ServiceWatch log collection status Use to set the ServiceWatch log collection feature Provided free up to 5 GB for all services within the Account, and charges apply for storage exceeding 5 GB When collected, log groups and log streams are created automatically and cannot be deleted until the resources are removed To prevent exceeding 5 GB, it is recommended to delete log data directly or shorten the retention period
     Parameter	required	Parameters to be used in the DB View button can be clicked to view detailed information of the parameter Parameters can be modified after the DB creation is complete, and after modification the DB must be restarted
     DB character set	required	Character encoding method to be used for the DB The character set used when storing text data, set as the default with the selected encoding when the DB is created
     Time zone	Required	Standard time zone for the database

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

     Category	Required status	Detailed description
     tag	Selection	Add Tag You can add up to 50 per resource Add Tag After clicking the Add Tag button, enter or select Key, Value values

     Table. MariaDB (DBaaS) Additional Information Input Items
4. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Create button.
   • Once creation is complete, check the created resource on the Resource List page.

MariaDB(DBaaS) Check detailed information

The MariaDB (DBaaS) service lets you view and modify the complete resource list and detailed information. On the MariaDB(DBaaS) Details page, it consists of Details, Tags, Activity History tabs, and for databases with a Replica configured, an additional Replica Information tab is provided.

Follow the steps below to view detailed information about the MariaDB (DBaaS) service.

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

     Category	Detailed description
     Cluster status	Cluster status with DB installed Creating: Cluster creation in progress Editing: Cluster is transitioning to an operational state Error: Cluster encountered an error during operation If it occurs continuously, contact the administrator Failed: Cluster failed during creation process Restarting: Cluster is restarting Running: Cluster is operating normally Starting: Cluster is starting Stopped: Cluster is stopped Stopping: Cluster is in the process of stopping Synchronizing: Cluster is synchronizing Terminating: Cluster is being deleted Unknown: Cluster status is unknown If it occurs continuously, contact the administrator Upgrading: Cluster is being upgraded
     Cluster control	Buttons that can 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
     View more features	Cluster management buttons Service status synchronization: Retrieve real-time DB service status Backup history: Verify backup execution status and history when backups are configured Database recovery: Restore the DB to 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): Deploy a disaster‑recovery Replica in another region; the button is disabled if the account has no available region DB user management: View and manage DB accounts (users) registered in the DB DB access control management: Register and revoke allowed IPs based on DB accounts Archive configuration management: Set archive file retention periods and enable archive mode DB Log export: Export stored logs to the user’s Object Storage via audit settings Migration configuration: Provides migration functionality using replication Block Storage usage management: Offers usage queries per Block Storage type OS (Kernel) upgrade: Upgrade the OS kernel version
     Service cancellation	Service cancellation button

     Table. MariaDB (DBaaS) status information and additional features

Detailed Information

On the MariaDB(DBaaS) List page, you can view the detailed information of the selected resource and modify 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

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

Job History

On the MariaDB(DBaaS) List page, you can view the operation history of the selected resource.

MariaDB(DBaaS) Resource Management

If you need to change or restore the existing configuration options of a provisioned MariaDB (DBaaS) resource, or require a Replica configuration, you can perform the task on the MariaDB(DBaaS) Details page.

Control Operation

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

Follow the steps below to control the operation of MariaDB(DBaaS).

1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Go to the Service Home page of MariaDB (DBaaS).
2. Click the MariaDB(DBaaS) menu on the Service Home page. 2. Navigate to the MariaDB(DBaaS) List page.
3. MariaDB(DBaaS) List On the page, click the resource you want to control. 3. MariaDB(DBaaS) Details Go to the page.
4. Check the MariaDB (DBaaS) status and complete the change using the control button below.
   • Start: The server where the DB service is installed and the DB service are running(Running).
   • Stop: The server where the DB service is installed and the DB service will be 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 MariaDB (DBaaS).

To view the service status of MariaDB (DBaaS), follow these steps.

1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
3. On the MariaDB(DBaaS) List page, click the resource to view the service status. 3. MariaDB(DBaaS) Details Go to the page.
4. Click the Service Status Synchronization 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 Running state.

Change Server Type

You can change the configured server type.

To change the server type, follow these steps.

1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
3. On the MariaDB(DBaaS) List page, click the resource to change the server type. 3. MariaDB(DBaaS) Details Go to the 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 In the popup window, after selecting the server type, click the Confirm button.

Add Storage

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

To add storage, follow these steps.

1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Go to the Service Home page of MariaDB (DBaaS).
2. Click the MariaDB(DBaaS) menu on the Service Home page. 2. MariaDB(DBaaS) List Navigate to the page.
3. MariaDB(DBaaS) List page, click the resource to add storage. 3. MariaDB(DBaaS) Details Go 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 capacity, 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 increase storage capacity, follow the steps below.

1. All Services > Database > MariaDB(DBaaS) Click the menu. 1. Navigate to the Service Home page of MariaDB (DBaaS).
2. On the Service Home page, click the MariaDB(DBaaS) menu. 2. MariaDB(DBaaS) List Navigate to the page.
3. On the MariaDB(DBaaS) List page, click the resource to change the server type. 3. MariaDB(DBaaS) Details Go to the page.
4. Click the Edit icon for 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 After entering the expansion capacity in the popup window, click the Confirm button.

Cancel MariaDB (DBaaS)

You can cancel unused MariaDB (DBaaS) to reduce operating costs. However, if you terminate the service, the running service may be discontinued immediately, so you should proceed with the termination only after fully considering the impact of the service interruption.

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

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