AWS Database
Introduction
this post is a hub of AWS database notes
into AWS services there ares several database services, some of them are:
- Aurora
- RDS
- DynamoDB
- Redshift
- ElastiCache
- Neptune
Amazon Aurora
Description: Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, offering performance and availability similar to commercial databases at a fraction of the cost.
Key Features:
High performance and availability Automatic failover and backup Isolation and security Push-button scaling Advanced monitoring Backtrack to restore data at any point in time Example Use: Amazon Aurora is suitable for high-performance applications that require scalability and reliability. For instance, a social media platform can use Aurora to handle large volumes of user data and interactions with minimal latency.
Amazon RDS (Relational Database Service)
Description: Amazon RDS is a managed relational database service that supports multiple database engines, including MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server. It automates tasks such as provisioning, patching, backup, recovery, and scaling.
Key Features:
Automated provisioning and OS patching Continuous backups and Point in Time Restore Monitoring dashboards Read replicas for improved read performance Multi-AZ setup for disaster recovery Vertical and horizontal scaling Storage backed by EBS Example Use: Amazon RDS is ideal for applications that require a managed relational database with high availability and automated maintenance. For example, an e-commerce website can use Amazon RDS to store customer data, orders, and product information, ensuring data integrity and availability.
Amazon DynamoDB
Description: Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. It is designed for applications that require consistent, single-digit millisecond latency at any scale.
Key Features:
Fully managed and serverless Single-digit millisecond response times Built-in security, backup, and restore Multi-region, multi-active replication On-demand and provisioned capacity modes Example Use: Amazon DynamoDB is ideal for applications with high throughput and low latency requirements, such as real-time bidding platforms, gaming leaderboards, and IoT data storage.
Amazon Redshift
Description: Amazon Redshift is a fully managed data warehouse service that makes it simple and cost-effective to analyze all your data using standard SQL and existing business intelligence tools.
Key Features:
High performance and scalability Columnar storage and data compression Massively parallel processing (MPP) Automated backups and snapshots Integration with AWS services and third-party tools Example Use: Amazon Redshift is perfect for data warehousing and analytics workloads. For example, a marketing analytics company can use Redshift to aggregate and analyze large datasets from various sources to generate insights and reports.
Amazon ElastiCache
Description: Amazon ElastiCache is a fully managed in-memory data store and cache service that supports Redis and Memcached. It is designed to improve the performance of web applications by retrieving data from high throughput and low latency in-memory data stores.
Key Features:
Fully managed Redis and Memcached Multi-AZ with automatic failover Read replicas for read scalability Data durability with AOF persistence (Redis) Backup and restore capabilities Example Use: Amazon ElastiCache is ideal for caching frequently accessed data to reduce latency and improve application performance. For instance, an online gaming platform can use ElastiCache to store session data and leaderboards, ensuring quick access for players.
Amazon Neptune
Description: Amazon Neptune is a fully managed graph database service that supports both property graph and RDF graph models. It is designed for applications that need to navigate and query highly connected datasets.
Key Features:
Fully managed and highly available Support for Apache TinkerPop Gremlin and RDF/SPARQL ACID transactions with immediate consistency Multi-AZ deployment with automatic failover Integration with AWS services Example Use: Amazon Neptune is suitable for applications that require complex relationship queries, such as social networking, recommendation engines, and fraud detection. For example, a social media platform can use Neptune to model and query user connections and interactions.
References
- https://media.datacumulus.com/aws-dva/AWS%20Certified%20Developer%20Slides%20v37.pdf
- https://www.udemy.com/course/aws-certified-developer-associate-dva-c01/?couponCode=NEWYEARCAREER
- https://www.stephanemaarek.com/
- https://docs.aws.amazon.com/