Overview

Service Overview

MariaDB(DBaaS) is an open-source relational database(RDBMS) with high compatibility with MySQL. Samsung Cloud Platform provides an environment that can automate MariaDB installation and perform management functions for operation through a web-based console.

MariaDB (DBaaS) is designed as a high‑availability architecture that performs storage‑based data replication and minimizes failover time. To prevent data loss, when the contents of the Active server change, they are synchronously replicated to the Standby server, and up to five Replicas, which are read‑only servers for read load balancing and disaster recovery (DR), are provided. Additionally, it provides an automatic backup feature at user-specified times to prepare for issues with the DB server or data, enabling data recovery at the desired point in time.

Provided features

MariaDB (DBaaS) provides the following features.

• Auto Provisioning (Auto Provisioning): Allows installation and configuration of Database(DB) via UI, and provides an Active-standby redundancy configuration based on storage replication. * When the active server fails, it automatically fails over to standby.
• Operation Control Management: Provides a function to control the status of running servers. * In addition to start and stop, a restart is possible if there is a DB issue or to apply configuration changes. * When high availability (HA) is configured, the user can manually perform node switching between Active-Standby via a switch-over.
• Backup and Recovery: Provides data backup functionality based on its own backup commands. * Backup time slots and storage locations can be set by the user, and additional fees may apply based on backup size. * It also provides a recovery function for backed‑up data, so when the user performs a recovery, a separate database is created and the recovery proceeds to the point in time selected by the user (backup save point, user‑specified point). * If you restore to a user-specified point in time, you can set the restore point to up to 5 minutes, 10 minutes, 30 minutes, or 1 hour before the stored backup and archive files.
• Version Management: Provides Major and Minor version upgrade features based on some functionality improvements and security patches.
• Replica configuration: For read load balancing and disaster recovery (DR), up to five Read Replicas can be configured in the same or different regions.
• Audit settings: Provides an Audit configuration feature that can monitor users’ DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) operations.
• Parameter Management: Performance improvement and security-related DB configuration parameters can be modified.
• Service Status Lookup: Retrieves the final status of the current DB service.
• Monitoring: CPU, memory, and performance monitoring information can be viewed through Cloud Monitoring and Servicewatch.
• DB User Management: View and manage DB accounts (users) registered in the DB.
• DB Access Control Management: You can register and revoke IPs allowed for access based on DB accounts registered in the DB.
• Archive management: You can set the Archive file retention period (1 to 35 days) on the DB server and configure the Archive mode (On/Off).
• DB Log Export: Through Audit settings, you can export stored logs to the user’s Object Storage.
• Migration: Synchronizes data in real time with the operational database and supports migration using a Replication approach without service interruption.
• OS Kernel Upgrade: You can upgrade the OS Kernel to apply some feature improvements and security patches.

Component

MariaDB (DBaaS) provides pre‑validated engine versions and various server types in accordance with the open‑source support policy. Users can select and use it based on the scale of the service they wish to configure.

Engine version

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

Technical support is available until the supplier’s EoTS (End of Technical Service) date, and the EOS date when new creation is halted is set to six months before the EoTS date.

The EOS and EoTS dates may change according to the supplier’s policy, so please refer to 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 detailed information about the server types provided by MariaDB (DBaaS), refer to MariaDB(DBaaS) Server Types.

Standard db1v2m4

Preliminary Service

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