AWS RDS MySQL is a managed relational database service that lets you use MySQL on the AWS cloud platform.
Features
- It handles routine database tasks such as provisioning, patching, backup, recovery, failure detection, and repair.
- It allows you to use the AWS Management Console, the Amazon RDS Command Line Interface, or simple API calls to access and manage your database instance.
- It provides high availability and reliability with the Multi-AZ deployment option and Read Replicas for scaling out read-heavy workloads.
- It supports Amazon RDS Blue/Green Deployments that enable you to make safer, simpler, and faster database updates with zero data loss.
- It automatically encrypts data at rest and in transit, and integrates with AWS security services such as IAM, KMS, and CloudTrail.
- It offers performance improvements with Amazon RDS Optimized Writes and Reads that can boost write transaction throughput by up to 2x and query processing by up to 50%.
Pricing
According to the AWS website, the pricing of AWS RDS MySQL depends on several factors:
- The instance type and size you choose, which determines the compute capacity and memory of your database.
- The deployment option you choose, which determines the availability and scalability of your database. You can choose between Single-AZ, Multi-AZ with one standby instance, or Multi-AZ with two readable standby instances.
- The storage type and size you use, which determines the performance and durability of your database. You can choose between General Purpose SSD or Provisioned IOPS SSD storage types. You can also enable auto storage scaling to adjust your storage size automatically based on your usage.
- The data transfer in and out of your database, which determines the network bandwidth and latency of your database. You are charged for data transfer across Availability Zones or regions, but not within the same Availability Zone or region.
- The additional features and services you use, such as performance insights, enhanced monitoring, backup and restore, encryption, security, and maintenance.
Pros
- It handles routine database tasks such as provisioning, patching, backup, recovery, failure detection, and repair.
- It allows you to use the AWS Management Console, the Amazon RDS Command Line Interface, or simple API calls to access and manage your database instance.
- It provides high availability and reliability with the Multi-AZ deployment option and Read Replicas for scaling out read-heavy workloads.
- It supports Amazon RDS Blue/Green Deployments that enable you to make safer, simpler, and faster database updates with zero data loss.
- It automatically encrypts data at rest and in transit, and integrates with AWS security services such as IAM, KMS, and CloudTrail.
- It offers performance improvements with Amazon RDS Optimized Writes and Reads that can boost write transaction throughput by up to 2x and query processing by up to 50%.
- It supports MySQL 8 features such as atomic DDL migrations, functional indexes, JSON features, window functions, CTE and others.
Cons
- It can be more expensive than running MySQL on EC2, especially for storage costs.
- It has some limitations compared to running MySQL on EC2, such as less control over the database configuration and maintenance window.
- It does not support performance insights on t2/t3 instances.
- It may encounter some issues with swap usage or replication lag that require manual failover or troubleshooting.
