Service Overview

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

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

Provided Features

EPAS(DBaaS) provides the following functions.

• Auto Provisioning (Auto Provisioning): Installation and configuration of Database (DB) is possible via UI, and provides an Active-standby redundancy configuration built on storage replication. In case of an Active server failure, automatic failover to Standby occurs.
• Operation Control Management: Provides a function to control the status of running servers. In addition to start and stop, restart is possible if there is an issue with the DB or to apply configuration values. In case of high availability (HA) configuration, the user can directly perform node switching of Active-Standby via Switch-over.
• Backup and Recovery: Provides data backup functionality based on its own backup command. Backup time slots and storage agencies can be set by the user, and additional fees are incurred depending on backup volume. It also provides a recovery function for backed‑up data, and when the user performs a recovery, a separate DB is created and recovery proceeds to the point in time selected by the user (backup save point, user‑specified point). If recovery is set to a user‑specified point, the recovery point can be set to 5 minutes/10 minutes/30 minutes/1 hour before based on the stored backup file and archive file.
• Version Management: Provides version upgrade (Minor) functionality according to some feature improvements and security patches. Whether to perform a backup for the version upgrade can be selected by the user, and if a backup is performed, data is backed up before applying the patch, then the DB engine is updated.
• Replica configuration: You can add up to 5 read-only Read Replicas, enabling read performance scaling and load balancing.
• Audit setting: Provides an Audit setting feature that can monitor the user’s DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) execution.
• Parameter management: Performance improvement and security-related DB configuration parameter modifications are possible.
• Service status query: Retrieve the final status of the current DB service.
• Monitoring: CPU, memory, DB performance monitoring information can be checked through the Cloud Monitoring service.
• DB User Management: Query and manage DB account (user) information registered in the DB.
• DB Access Control Management: Based on DB accounts registered in the DB, you can register and revoke allowed IPs for access.
• Archive Management: You can set the archive file retention period (1 day~35 days) within the DB server and configure the archive mode (On/Off).
• DB Log Export: Through Audit settings, saved logs can be exported to the user’s Object Storage.
• Migration: Synchronize data in real-time with the operating database, and support migration using the Replication method without service interruption.

Components

EPAS (DBaaS) provides pre-validated engine versions and various server types. Users can select and use them according to the scale of the service they want to configure.

Engine Version

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

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

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

• EPAS: https://www.enterprisedb.com/resources/platform-compatibility

Server Type

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

For detailed information about the server types provided by EPAS(DBaaS), please refer to EPAS(DBaaS) server type.

Standard db1v2m4

Preceding Service

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