Overview

Service Overview

MariaDB(DBaaS) is an open source relational database (RDBMS) with high compatibility with MySQL. Samsung Cloud Platform provides an environment where MariaDB installation is automated through a web-based Console and management functions for operation can be performed.

MariaDB(DBaaS) is designed with a high availability architecture considering storage-based data replication and minimizing Failover time. To prevent data loss, when the content of the Active server is changed, it is synchronously replicated to the Standby server, and up to 5 read-only servers called Replicas for read load distribution and disaster recovery (DR) are provided. In addition, to prepare for problems with the DB server or data, it provides a function to automatically backup at a time specified by the user, so that data can be recovered at a desired point in time.

Provided Features

MariaDB(DBaaS) provides the following features.

• Auto Provisioning: Database (DB) installation and settings are possible through UI, and provides Active-standby redundancy configuration based on storage replication. When Active server fails, automatic Failover to Standby occurs.
• Operation Control Management: Provides function to control running server status. In addition to start and stop, restart is possible when there is a problem with the DB or to reflect settings. When high availability (HA) is configured, the user can directly perform node switching of Active-Standby through Switch-over.
• Backup and Recovery: Provides data backup function based on own backup command. Backup time period and retention period can be set by the user, and additional fees are charged depending on backup capacity. Also provides recovery function for backed up data, and when the user performs recovery, a separate DB is created and recovery proceeds to the point selected by the user (backup storage point, user-specified point). When recovering to a user-specified point, the recovery point can be set up to 5 minutes/10 minutes/30 minutes/1 hour ago based on stored backup files and archive files.
• Version Management: Provides version upgrade (Minor) function for some function improvements and security patches. Whether to perform backup according to version upgrade can be selected by the user, and if performing backup, data is backed up before patch execution and then DB engine update is performed.
• Replica Configuration: Up to 5 Read Replicas can be configured in the same/different region for read load distribution and disaster recovery (DR).
• Audit Setting: Provides Audit setting function to monitor user DB access and DDL (Data Definition Language)/DML (Data Manipulation Language) execution results.
• Parameter Management: DB configuration parameter modification for performance improvement and security is possible.
• Service Status Inquiry: Inquires the final status of current DB service.
• Monitoring: CPU, Memory, performance monitoring information can be checked through Cloud Monitoring and Servicewatch.
• DB User Management: Manages by inquiring DB account (user) information registered in DB.
• DB Access Control Management: Allows registration and termination of access allowed IP based on DB accounts registered in DB.
• Archive Management: Archive file retention period (1 day~35 days) setting and Archive mode (On/Off) setting are possible in DB server.
• DB Log Export: Logs stored through Audit settings can be exported to user’s Object Storage.
• Migration: Supports migration using Replication method by synchronizing data in real time with operating database without service interruption.
• OS Kernel Upgrade: OS Kernel can be upgraded for some function improvements and security patch application.

Components

MariaDB(DBaaS) provides engine versions pre-verified according to open source support policy and various server types. Users can select and use them according to the service scale they want to configure.

Engine Version

The engine versions supported by MariaDB(DBaaS) are as follows.

Technical support can be used until the EoTS (End of Technical Service) date of the supplier, and the EOS date when new creation stops is set to 6 months before the EoTS date.

According to supplier policy, EOS and EoTS dates may change, so please check the supplier’s license management policy page for details.

• MariaDB (Community): https://mariadb.org/about/#maintenance-policy

Server Type

The server types supported by MariaDB(DBaaS) are as follows.

For more information on server types provided by MariaDB(DBaaS), see MariaDB(DBaaS) Server Type.

Standard db1v2m4

Prerequisite Services

This is a list of services that must be pre-configured before creating this service. Please prepare in advance by referring to the guide provided for each service.