MySQL is the world's most popular open source relational database and Amazon RDS makes it easier to set up, operate, and scale MySQL deployments in the cloud. With Amazon RDS, you can deploy scalable MySQL servers in minutes with cost-efficient and resizable hardware capacity.
Amazon RDS for MySQL frees you up to focus on application development by managing time-consuming database administration tasks, including backups, upgrades, software patching, performance improvements, monitoring, scaling, and replication.
Amazon RDS supports MySQL Community Edition versions 5.7 and 8.0 which means that the code, applications, and tools you already use today can be used with Amazon RDS.
Benefits of RDS for MySQL
Easy, managed deployments
It takes only a few clicks in the AWS Management Console to launch and connect to a production-ready MySQL database in minutes. Amazon RDS for MySQL database instances are pre-configured with parameters and settings for the server type you have selected. Database parameter groups provide granular control and fine-tuning of your MySQL database. When you need to make a database update, Amazon RDS Blue/Green Deployments are designed to make them safer, simpler, and faster.
Fast, predictable performance
Amazon RDS provides two SSD-backed storage options for your MySQL database. General Purpose storage provides cost-effective storage for small- or medium-sized workloads. For high-performance OLTP applications, Provisioned IOPS delivers consistent performance of up to 256,000 IOs per second. As your storage requirements grow you can provision additional storage on-the-fly with zero downtime. With Amazon RDS Optimized Writes, achieve up to 2x improved write transaction throughput, while Amazon RDS Optimized Reads provides you with up to 50% faster query processing.
Backup and recovery
The automated backup feature of Amazon RDS enables recovery of your MySQL database instance to any point in time within your specified retention period of up to 35 days. In addition, you can perform user-initiated backups of your DB Instance. These full database backups will be stored by Amazon RDS until you explicitly delete them.
High availability and read replicas
Amazon RDS Multi-AZ deployments provide enhanced availability and durability for your MySQL databases, making them a natural fit for production database workloads. Amazon RDS Read Replicas are designed to make it easier to elastically scale out beyond the capacity constraints of a single database instance for read-heavy database workloads.
Isolation and security
As a managed service, Amazon RDS provides a high level of security for your MySQL databases. These include network isolation using Amazon Virtual Private Cloud (VPC), encryption at rest using keys you create and control through AWS Key Management Service (KMS) and encryption of data in transit using SSL.