AWS DATABASE SERVICES
June 28, 2023
AWS provide a wide range of database solutions to its users.
Depending upon the nature of the data, security and the cost constraints of the customers various database types serve all users accordingly.
These Databases allow users to build use-case-specific data models, including relational, graph, wide-column, etc. AWS fully manages these databases, freeing users from some maintenance tasks such as server provisioning, patching, and backup, which are time-consuming.
Advantages:
- Fully Managed: AWS Database services are fully managed services that release many of the setup, management, and monitoring responsibilities from customers.
- Scalable: AWS provides a set of Databases that are highly scalable. This is true for both the relational and non-relational databases.
- Highly available: considering its global infrastructure setup and fault tolerance mechanism, AWS provides highly available and reliable services across the globe.
- Security: Provides secure services due to the implementation of multi-level security systems like network isolation and end-to-end encryption.
Database | Use cases | AWS services |
Relational | Traditional applications, enterprise resource planning (ERP), customer relationship management (CRM), Ecommerce | Amazon Aurora — Designed for unparalleled high performance and availability at global scale with full MySQL and PostgreSQL compatibility |
Amazon RDS — Set up, operate, and scale a relational database in the cloud with just a few clicks | ||
Amazon Redshift — Accelerate your time to insights with fast, easy, and secure cloud data warehousing at scale | ||
Key-value | High-traffic web applications, ecommerce systems, gaming applications | Amazon DynamoDB — Fast, flexible NoSQL database service for single-digit millisecond performance at any scale |
In-memory | Caching, session management, gaming leaderboards, geospatial applications | Amazon ElastiCache — Unlock microsecond latency and scale with in-memory caching |
Amazon MemoryDB for Redis — Redis-compatible, durable, in-memory database service for ultra-fast performance | ||
Document | Content management, catalogs, user profiles | Amazon DocumentDB (with MongoDB compatibility) — Scale JSON workloads with ease using a fully managed document database service |
Wide column | High-scale industrial apps for equipment maintenance, fleet management, route optimization | Amazon Keyspaces — A scalable, highly available, and managed Apache Cassandra–compatible database service |
Graph | Fraud detection, social networking, recommendation engines | Amazon Neptune — Build and run graph applications with highly connected datasets |
Time series | Internet of Things (IoT) applications, DevOps, industrial telemetry | Amazon Timestream — Fast, scalable, serverless time series database |
Ledger | Systems of record, supply chain, registrations, banking transactions | Amazon Ledger Database Service (QLDB) — Maintain an immutable, cryptographically verifiable log of data changes |
Databases | Features |
Amazon Aurora | MySQL and PostgreSQL compatible |
five times faster than standard MySQL | |
three times faster than standard PostgreSQL | |
security, availability, and reliability of commercial databases at 1/10th the cost. | |
fully managed by Amazon Relational Database Service (Amazon RDS) | |
distributed, fault-tolerant, self-healing storage system that auto-scales up to 128TB per database instance | |
15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs) | |
Amazon DynamoDB | key-value and document database |
single-digit millisecond performance at any scale | |
fully managed, multiregion, multimaster database with built-in security, backup and restore, and in-memory caching for internet-scale applications | |
key-value and document database for mobile, web, gaming, ad tech, Internet of Things (IoT), and other applications that need low-latency data access at any scale | |
10 trillion requests per day and support peaks of more than 20 million requests per second | |
Amazon ElastiCache | web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud |
service improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory caches | |
Redis | |
fast, open-source, in-memory key-value data store for use as a database, cache, message broker, and queue | |
along with the availability, reliability, and performance | |
Both single-node and up to 15-shard clusters are available, enabling scalability to up to 3.55 TiB of in-memory data | |
Memcached | |
widely adopted memory object caching system | |
Amazon Keyspaces (for Apache Cassandra) | scalable, highly available, and managed Apache Cassandra–compatible database |
don’t have to provision, patch, or manage servers, and you don’t have to install, maintain, or operate software | |
Keyspaces is serverless | |
Data is encrypted by default | |
back up your table data continuously using point-in-time recovery | |
performance, elasticity, and enterprise features | |
Amazon MemoryDB for Redis | Redis-compatible, durable, in-memory database service that delivers ultra-fast performance |
all of your data is stored in memory, which enables you to achieve microsecond read and single-digit millisecond write latency and high throughput | |
stores data durably across multiple Availability Zones using a distributed transactional log to allow fast failover, database recovery, and node restarts | |
high-performance primary database for your microservices applications | |
eliminating the need to separately manage both a cache and durable database | |
Amazon Neptune | fast, reliable, fully managed graph database |
easy to build and run applications that work with highly connected datasets | |
purpose-built, high-performance graph database engine optimized for storing billions of relationships and querying the graph with milliseconds latency | |
powers graph use cases such as recommendation engines, fraud detection, knowledge graphs, drug discovery, and network security | |
highly available, with read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across Availability Zones | |
support for encryption at rest | |
Amazon RDS | several database instances types – optimized for memory, performance or I/O |
provides you with six familiar database engines to choose | |
Amazon Aurora | |
PostgreSQL | |
MySQL | |
MariaDB | |
Oracle Database | |
SQL Server | |
AWS Database Migration Service | |
to easily migrate or replicate your existing databases to Amazon RDS | |
Amazon RDS on VMware | deploy managed databases in on-premises |
allows you to utilize the same simple interface for managing databases in on-premises VMware environments as you would use in AWS | |
enabling low-cost hybrid deployments for disaster recovery, read replica bursting, and optional long-term backup retention in Amazon Simple Storage Service (Amazon S3) | |
Amazon Quantum Ledger Database (Amazon QLDB) | transparent, immutable, and cryptographically verifiable transaction log owned by a central trusted authority |
QLDB tracks each and every application data change and maintains a complete and verifiable history of changes over time | |
record a history of economic and financial activity in an organization | |
database that eliminates the need to engage in the complex development effort of building your own ledger-like applications | |
data’s change history is immutable – it cannot be altered or deleted – and using cryptography, you can easily verify that there have been no unintended modifications | |
Amazon Timestream | fast, scalable, fully managed time series database service for IoT and operational applications |
makes it easy to store and analyze trillions of events per day at 1/10th the cost of relational databases | |
Time-series data has specific characteristics such as typically arriving in time order form, data is append-only, and queries are always over a time interval | |
automates rollups, retention, tiering, and compression of data, so you can manage your data at the lowest possible cost | |
Timestream is serverless | |
Amazon DocumentDB (with MongoDB compatibility) | fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads |
allowing you to use your existing MongoDB drivers and tools with Amazon DocumentDB | |
performance, scalability, and availability you need when operating mission-critical MongoDB workloads at scale | |
Amazon Lightsail managed databases | separate from compute workloads, so you can build applications and websites on Lightsail instances without interruption |
supports MySQL and PostgreSQL databases, and you can configure them for standard availability for regular workloads or high availability for critical workloads | |
Lightsail-managed databases bundle the underlying compute, SSD-based storage, and data transfer bandwidth into a fixed monthly price |
With this, I have attempted to brief about various AWS Database services.
Wish now you have a basic insight of it and would help utilize this knowledge in your career path.