This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Overview

EPAS (EnterpriseDB Postgres Advanced Server) is Oracle-compatible RDBMS based on PostgreSQL. Samsung Cloud Platform provides EPAS Database as a Service (DBaaS) allowing you to use EPAS without separate installation and management.

EPAS(DBaaS) Service

Service Overview

EPAS(DBaaS) is a fully managed database service that provides an easy-to-use environment for creating, configuring, and managing EPAS databases. You can focus on application development and business logic without worrying about database installation, patching, backup, and recovery.

Service Architecture

EPAS(DBaaS) consists of the following components:

  • Database Cluster: A cluster of one or more database servers that provides high availability and load balancing
  • Storage: Block storage for storing database data, archives, and backups
  • Network: VPC-based network configuration for secure data transmission
  • Monitoring: Integrated monitoring and alarming through ServiceWatch

Service Features

EPAS(DBaaS) provides the following features:

  • Auto Provisioning: Automatically provision database servers with just a few clicks without manual installation
  • Operation Control: Easily start, stop, and restart database servers
  • Backup and Recovery: Automated backup and point-in-time recovery for data protection
  • Version Management: Support for multiple EPAS versions with easy upgrades
  • Replica: Create read replicas for scaling read operations
  • Audit: Database audit logging for compliance and security
  • Parameter: Database parameter management for performance tuning
  • Monitoring: Real-time monitoring and alerting for database health
  • User Management: Database user and permission management
  • Access Control: IP-based access control for enhanced security
  • Archive: Archive management for long-term data retention
  • Log Export: Database log export for analysis and troubleshooting
  • Migration: Easy migration from on-premises or other cloud databases
  • OS Kernel Upgrade: Automated OS kernel upgrades for security and performance

Engine Versions

EPAS(DBaaS) supports the following EPAS versions:

  • EPAS 14.17
  • EPAS 15.11
  • EPAS 16.4
  • EPAS 17.6

Server Types

EPAS(DBaaS) provides the following server types:

  • Standard: Standard specifications for general workloads
  • High Capacity: Large capacity servers with 24+ vCPU for high-performance workloads

Prerequisites

To use EPAS(DBaaS), you must have a VPC configured in your project. For more information on creating a VPC, see VPC Creation Guide.

1 - Server Type

EPAS(DBaaS) Server Type

EPAS(DBaaS) provides server types with various combinations of CPU, Memory, Network Bandwidth, and more. When creating an EPAS(DBaaS), the Database Engine is installed according to the selected server type based on the intended use.

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

Standard db1v2m4
Classification
ExampleDetailed Description
Server TypeStandardClassification of provided server types
  • Standard: Composed of standard specifications (vCPU, Memory) commonly used
  • High Capacity: Server with higher capacity than Standard
Server Specificationdb1Classification of provided server types and generations
  • db1: Means general specifications, and 1 means the generation
  • dbh2: h means high-capacity server specifications, and 2 means the generation
Server Specificationv2Number of vCores
  • v2: 2 virtual cores
Server Specificationm4Memory capacity
  • m4: 4GB Memory
Table. EPAS(DBaaS) Server Type Format

db1 Server Type

The db1 server type of EPAS(DBaaS) is provided with standard specifications (vCPU, Memory) and is suitable for various database workloads.

  • Up to 3.3Ghz Intel 3rd generation (Ice Lake) Xeon Gold 6342 Processor
  • Supports up to 16 vCPUs and 256 GB of memory
  • Up to 12.5 Gbps networking speed
ClassificationServer TypevCPUMemoryNetwork Bandwidth
Standarddb1v2m42 vCore4 GBUp to 10 Gbps
Standarddb1v2m82 vCore8 GBUp to 10 Gbps
Standarddb1v2m162 vCore16 GBUp to 10 Gbps
Standarddb1v2m242 vCore24 GBUp to 10 Gbps
Standarddb1v2m322 vCore32 GBUp to 10 Gbps
Standarddb1v4m84 vCore8 GBUp to 10 Gbps
Standarddb1v4m164 vCore16 GBUp to 10 Gbps
Standarddb1v4m324 vCore32 GBUp to 10 Gbps
Standarddb1v4m484 vCore48 GBUp to 10 Gbps
Standarddb1v4m644 vCore64 GBUp to 10 Gbps
Standarddb1v6m126 vCore12 GBUp to 10 Gbps
Standarddb1v6m246 vCore24 GBUp to 10 Gbps
Standarddb1v6m486 vCore48 GBUp to 10 Gbps
Standarddb1v6m726 vCore72 GBUp to 10 Gbps
Standarddb1v6m966 vCore96 GBUp to 10 Gbps
Standarddb1v8m168 vCore16 GBUp to 10 Gbps
Standarddb1v8m328 vCore32 GBUp to 10 Gbps
Standarddb1v8m648 vCore64 GBUp to 10 Gbps
Standarddb1v8m968 vCore96 GBUp to 10 Gbps
Standarddb1v8m1288 vCore128 GBUp to 10 Gbps
Standarddb1v10m2010 vCore20 GBUp to 10 Gbps
Standarddb1v10m4010 vCore40 GBUp to 10 Gbps
Standarddb1v10m8010 vCore80 GBUp to 10 Gbps
Standarddb1v10m12010 vCore120 GBUp to 10 Gbps
Standarddb1v10m16010 vCore160 GBUp to 10 Gbps
Standarddb1v12m2412 vCore24 GBUp to 12.5 Gbps
Standarddb1v12m4812 vCore48 GBUp to 12.5 Gbps
Standarddb1v12m9612 vCore96 GBUp to 12.5 Gbps
Standarddb1v12m14412 vCore144 GBUp to 12.5 Gbps
Standarddb1v12m19212 vCore192 GBUp to 12.5 Gbps
Standarddb1v14m2814 vCore28 GBUp to 12.5 Gbps
Standarddb1v14m5614 vCore56 GBUp to 12.5 Gbps
Standarddb1v14m11214 vCore112 GBUp to 12.5 Gbps
Standarddb1v14m16814 vCore168 GBUp to 12.5 Gbps
Standarddb1v14m22414 vCore224 GBUp to 12.5 Gbps
Standarddb1v16m3216 vCore32 GBUp to 12.5 Gbps
Standarddb1v16m6416 vCore64 GBUp to 12.5 Gbps
Standarddb1v16m12816 vCore128 GBUp to 12.5 Gbps
Standarddb1v16m19216 vCore192 GBUp to 12.5 Gbps
Standarddb1v16m25616 vCore256 GBUp to 12.5 Gbps
Table. EPAS(DBaaS) Server Type Specifications - db1 Server Type

dbh2 Server Type

The dbh2 server type of EPAS(DBaaS) is provided with high-capacity server specifications and is suitable for large-scale data processing database workloads.

  • Up to 3.2GHz Intel 4th generation (Sapphire Rapids) Xeon Gold 6448H Processor
  • Supports up to 128 vCPUs and 1,536 GB of memory
  • Up to 25Gbps networking speed
ClassificationServer TypevCPUMemoryNetwork Bandwidth
High Capacitydbh2v24m4824 vCore48 GBUp to 25 Gbps
High Capacitydbh2v24m9624 vCore96 GBUp to 25 Gbps
High Capacitydbh2v24m19224 vCore192 GBUp to 25 Gbps
High Capacitydbh2v24m28824 vCore288 GBUp to 25 Gbps
High Capacitydbh2v32m6432 vCore64 GBUp to 25 Gbps
High Capacitydbh2v32m12832 vCore128 GBUp to 25 Gbps
High Capacitydbh2v32m25632 vCore256 GBUp to 25 Gbps
High Capacitydbh2v32m38432 vCore384 GBUp to 25 Gbps
High Capacitydbh2v48m19248 vCore192 GBUp to 25 Gbps
High Capacitydbh2v48m57648 vCore576 GBUp to 25 Gbps
High Capacitydbh2v64m25664 vCore256 GBUp to 25 Gbps
High Capacitydbh2v64m76864 vCore768 GBUp to 25 Gbps
High Capacitydbh2v72m28872 vCore288 GBUp to 25 Gbps
High Capacitydbh2v72m86472 vCore864 GBUp to 25 Gbps
High Capacitydbh2v96m38496 vCore384 GBUp to 25 Gbps
High Capacitydbh2v96m115296 vCore1152 GBUp to 25 Gbps
High Capacitydbh2v128m512128 vCore512 GBUp to 25 Gbps
High Capacitydbh2v128m1536128 vCore1536 GBUp to 25 Gbps
Table. EPAS(DBaaS) Server Type Specifications - dbh2 Server Type

2 - Monitoring Metrics

EPAS(DBaaS) Monitoring Metrics

The table below shows the performance monitoring metrics of EPAS (DBaaS) that can be checked through Cloud Monitoring. For detailed usage of Cloud Monitoring, refer to the Cloud Monitoring guide.

EPAS(DBaaS) server monitoring metrics refer to the Virtual Server Monitoring Metrics guide.

Performance ItemDetailed DescriptionUnit
Active Locks [Access Exclusive]Access Exclusive Locks countcnt
Active Locks [Access Share]Access Share Lock countcnt
Active LocksActive Locks countcnt
Active Locks [Total]Active Locks total countcnt
Active SessionsNumber of Sessions in Active statecnt
Active Sessions [Total]Total number of Sessions in Active statecnt
Apply Lag TimeApply lag timemin
Check No ReplicationCheck No Replication valuecnt
Check ReplicationCheck Replication Status valuestatus
Connection UsageDB connection usage rate(%)%
Connection Usage [Total]DB connection count usage rate(%)%
DB Age MaxDatabase age (frozen XID) valueage
Exclusive LocksExclusive Locks countcnt
Idle In Transaction SessionsNumber of sessions in idle in transaction statecnt
Idle In Transaction Sessions [Total]Idle in transaction state Session total countcnt
Idle SessionsNumber of idle sessionscnt
Idle Sessions [Total]Total number of idle sessionscnt
Row Exclusive LocksRow Exclusive Locks countcnt
Row Share LocksRow Share Locks countcnt
Share LocksShare Locks countcnt
Share Row Exclusive LocksShare Row Exclusive Locks countcnt
Share Update Exclusive LocksShare Update Exclusive Locks countcnt
SlowqueriesNumber of SQL queries running for a long time (5 minutes or more)cnt
Tablespace UsedTable space sizebytes
Tablespace Used [Total]Table space sizebytes
Tablespace Used Bytes [MB]File system directory usage (MB)MB
Tablespaces [Total]File system directory usage (MB)MB
Transaction Time Max [Long]Long-running Transaction time (minutes)min
Transaction Time Max Total [Long]Long-running Transaction time (minutes)min
Wait LocksNumber of waiting lock sessions (by DB)cnt
Wait Locks [Long Total]Long duration (300 seconds) Lock waiting session countcnt
Wait Locks [Long]Number of Sessions waiting due to lock occurrencecnt
Wait Locks [Total]Total number of sessions waiting due to lock occurrencecnt
Waiting SessionsNumber of Sessions in Waiting statecnt
Waiting Sessions [Total]Total number of Sessions in Waiting statecnt
Table. EPAS(DBaaS) Monitoring Metrics