PoshJosh's Blog

AWS Database Services

June 11, 2020

Amazon Aurora

Amazon Aurora is a MySQL and PostgreSQL compatible relational database engine

  • Distributed, fault-tolerant, self-healing storage system
  • Auto-scales up to 64TB per database instance.
  • Up to 15 low-latency read replicas
  • Point-in-time recovery
  • Continuous backup to Amazon S3
  • Replication across three Availability Zones (AZs).

Amazon Relational Database Service (Amazon RDS)

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud.

  • Provides cost-efficient and resizable capacity
  • Automates time-consuming administration tasks such as: hardware provisioning,

database setup, patching and backups.

  • Six engines: Amazon Aurora, PostgreSQL, MySQL, MariaDB,

Oracle Database, and SQL Server.

Amazon RDS on VMware

Amazon Relational Database Service (Amazon RDS) on VMware lets you deploy managed databases in on-premises VMware environments using the Amazon RDS technology

Achieve low cost hybrid by replicating RDS on VMware databases to RDS instances in AWS. This could be used for disaster recovery, read replica bursting, and optional long-term backup retention in Amazon S3.

Amazon DynamoDB

Amazon DynamoDB is a fully managed key-value and document database that can handle more than 10 trillion requests per day and support peaks of more than 20 million requests per second. DynamoDB delivers:

  • Single-digit millisecond performance at any scale.
  • Multiregion, multimaster database
  • Built-in security, backup and restore
  • In-memory caching for internet-scale applications.

Use cases: mobile, web, gaming, ad tech, IoT, and other applications that need low-latency data access at any scale

Amazon ElastiCache

Amazon ElastiCache is a web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud.

Supports two open-source in-memory caching engines:

  • Amazon ElastiCache for Redis is a Redis-compatible fully managed in-memory service

  • Both single-node and up to 15-shard clusters are available

  • Scalability to up to 3.55 TiB of in-memory data.

  • Scalable, and secure.

Use cases: high-performance use cases such as web, mobile apps, gaming, ad-tech, and IoT.

  • ElastiCache for Memcached is protocol compliant with Memcached, so

popular tools that you use today with existing Memcached environments will work seamlessly with the service.

Amazon Neptune

Amazon Neptune is a fast, reliable, fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets.

  • Read replicas, point-in-time recovery,
  • Continuous backup to Amazon S3
  • Replication across Availability Zones.
  • Support for encryption at rest.
  • Supports popular graph models Property Graph and W3C’s RDF, and their

respective query languages Apache TinkerPop Gremlin and SPARQL

Use cases: recommendation engines, fraud detection, knowledge graphs, drug discovery, and network security.

Amazon Quantum Ledger Database (QLDB)

Amazon QLDB is a fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log ‎owned by a central trusted authority. Amazon QLDB tracks each and every application data change and maintains a complete and verifiable history of changes over time.

  • Provides developers with a familiar SQL-like API
  • Flexible document data model
  • Full support for transactions.
  • Automatically scales to support the demands of your application.

Amazon Timestream

Amazon Timestream is a fast, scalable, fully managed time series database service for IoT and operational applications that makes it easy to store and analyze trillions of events per day at 1/10th the cost of relational databases

Automates rollups, retention, tiering, and compression of data, so you can manage your data at the lowest possible cost.

Use cases: analyze log data for DevOps, sensor data for IoT applications, and industrial telemetry data for equipment maintenance.

Amazon DocumentDB

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads.

Use your existing MongoDB drivers and tools with Amazon DocumentDB.

Use case: operating mission-critical MongoDB workloads at scale.


Written byChinomso IkwuagwuExcélsior

Limited conversations with distributed systems.

Modifying legacy applications using domain driven design (DDD)

Gherkin Best Practices

Code Review Best Practices

Hacking Cypress in 9 minutes

Some common mistakes when developing java web applications

How to make a Spring Boot application production ready

SQL JOINS - A Refresher

Add Elasticsearch to Spring Boot Application

Add entities/tables to an existing Jhipster based project

CSS 3 Media Queries - All over again

Maven Dependency Convergence - quick reference

Amazon SNS Quick Reference

AWS API Gateway Quick Reference

Amazon SQS Quick Reference

AWS API Gateway Quick Reference

AWS Lambda Quick Reference

Amazon DynamoDB - Quick Reference

Amazon Aurora

Amazon Relational Database Service

AWS Database Services

AWS Security Essentials

Amazon Virtual Private Cloud Connectivity Options

Summary of AWS Services

AWS Certified Solutions Architect - Quick Reference

AWS CloudFront FAQs - Curated

AWS VPC FAQs - Curated

AWS EC2 FAQs - Curated

AWS Achritect 5 - Architecting for Cost Optimization

AWS Achritect 4 - Architecting for Performance Efficiency

AWS Achritect - 6 - Passing the Certification Exam

AWS Achitect 3 - Architecting for Operational Excellence

AWS Achitect 2 - Architecting for Security

AWS Achitect 1 - Architecting for Reliability

Amazon DynamoDB Accelerator (DAX)

Questions and Answers - AWS Certified Cloud Architect Associate

Questions and Answers - AWS Certified Cloud Architect Associate

AWS Connectivity - PrivateLink, VPC-Peering, Transit-gateway and Direct-connect

AWS - VPC peering vs PrivateLink

Designing Low Latency Systems

AWS EFS vs FSx

AWS Regions, Availability Zones and Local Zones

AWS VPC Endpoints and VPC Endpoint Services (AWS Private Link)

AWS - IP Addresses

AWS Elastic Network Interfaces

AWS Titbits

Jenkins on AWS - Automation

Jenkins on AWS - Setup

Jenkins on AWS - Best practices

Introduction to CIDR Blocks

AWS Lamda - Limitations and Use Cases

AWS Certified Solutions Architect Associate - Part 10 - Services and design scenarios

AWS Certified Solutions Architect Associate - Part 9 - Databases

AWS Certified Solutions Architect Associate - Part - 8 Application deployment

AWS Certified Solutions Architect Associate - Part 7 - Autoscaling and virtual network services

AWS Certified Solutions Architect Associate - Part 6 - Identity and access management

AWS Certified Solutions Architect Associate - Part 5 - Compute services design

AWS Certified Solutions Architect Associate - Part 4 - Virtual Private Cloud

AWS Certified Solutions Architect Associate - Part 3 - Storage services

AWS Certified Solutions Architect Associate - Part 2 - Introduction to Security

AWS Certified Solutions Architect Associate - Part 1 - Key services relating to the Exam

AWS Certifications - Part 1 - Certified solutions architect associate

AWS Virtual Private Cloud (VPC) Examples

Curated info on AWS Virtual Private Cloud (VPC)

Notes on Amazon Web Services 8 - Command Line Interface (CLI)

Notes on Amazon Web Services 7 - Elastic Beanstalk

Notes on Amazon Web Services 6 - Developer, Media, Migration, Productivity, IoT and Gaming

Notes on Amazon Web Services 5 - Security, Identity and Compliance

Notes on Amazon Web Services 4 - Analytics and Machine Learning

Notes on Amazon Web Services 3 - Managment Tools, App Integration and Customer Engagement

Notes on Amazon Web Services 2 - Storages databases compute and content delivery

Notes on Amazon Web Services 1 - Introduction

AWS Auto Scaling - All you need to know

AWS Load Balancers - How they work and differences between them

AWS EC2 Instance Types - Curated

Amazon Web Services - Identity and Access Management Primer

Amazon Web Services - Create IAM User

Preparing Jenkins after Installation

Jenkins titbits, and then some

Docker Titbits

How to Add Chat Functionality to a Maven Java Web App

Packer - an introduction

Terraform - an introduction

Versioning REST Resources with Spring Data REST

Installing and running Jenkins in Docker

Automate deployment of Jenkins to AWS - Part 2 - Full automation - Single EC2 instance

Automate deployment of Jenkins to AWS - Part 1 - Semi automation - Single EC2 instance

Introduction to Jenkins

Software Engineers Reference - Dictionary, Encyclopedia or Wiki - For Software Engineers