Amazon Relational Databases#
The Relational Database Building Block deploys a relational database through Amazon Relational Database Service (RDS). It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups.
The user has the choice between several database engine including:
- MySQL
- PostgreSQL
- Oracle
Database Engines#
MySQL#
MySQL is the world’s most popular open source database, enabling the cost-effective delivery of reliable, high-performance and scalable Web-based and embedded database applications. It is an integrated transaction safe, ACID-compliant database with full commit, rollback, crash recovery, and row-level locking capabilities.
PostgreSQL#
PostgreSQL has become the preferred open source relational database for many enterprise developers and start-ups, powering leading business and mobile applications.
Oracle#
Oracle® Database is a relational database management system developed by Oracle. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.
Interfaces#
- Database client applications
- TCP interfaces
- JDBC
Hardware Configuration#
A cluster configuration requires selecting the group of machines to cluster. This group consists out of a Master node and several Core nodes. Optionally Task nodes can be added as well. Below a brief explanation per type of cluster node, followed by the available machine types together with their respective pricing.
Standard Database Machines#
The currently available standard compute machines for clustering are AWS EC2 instances of the m5 type (GHz Intel Xeon® Platinum 8175 processors with new Intel Advanced Vector Extension instruction set). The following list is supported:
| Instance Size | vCPU | Memory (GiB) | Instance Storage (GiB) | Network Bandwidth (Gbps) | EBS Bandwidth (Mbps) |
|---|---|---|---|---|---|
| db.m5.xlarge | 4 | 16 | EBS-Only | Up to 10 | Up to 3,500 |
| db.m5.2xlarge | 8 | 32 | EBS-Only | Up to 10 | Up to 3,500 |
| db.m5.4xlarge | 16 | 64 | EBS-Only | Up to 10 | 3,500 |
| db.m5.12xlarge | 48 | 192 | EBS-Only | 10 | 7,000 |
| db.m5.24xlarge | 96 | 384 | EBS-Only | 25 | 14,000 |