Running MySQL on AWS

on YouTube ↗29m

" summary

Compares running MySQL on EC2 versus RDS with concrete trade-offs: EC2 gives shell access, raw EBS block devices, full backup and recovery tools and use of pt-online-schema-change and Percona Cloud Tools; RDS offers multi-AZ failover, automated snapshots and simplified read replicas but limits config changes and OS access and can lose up to a day of data if recovery falls back to snapshots. Notes EBS IOPS are billed, RDS shows ~3–4 ms extra latency on synthetic tests, and unexpected bills (example: $70k) are common.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 3:10Virtualization basics
3. 8:12EBS storage for MySQL
4. 9:56RDS managed MySQL
5. 13:07AWS popularity reasons
6. 15:34EC2 vs RDS for MySQL
7. 20:06Monitoring MySQL on AWS
8. 22:56Cost management tips
9. 26:04Pricing models and unexpected bills
10. 27:32EC2 vs RDS performance
11. 28:37Q&A

" related talks

• 01h 05mDatabase management made simple - Amazon RDS (Part 1 and 2)Darin Briskman · Percona Live Open Source Database Conference 2017
• 51mMySQL in the CloudColin Charles · LinuxCon + CloudOpen Europe 2013
• 32mMySQL on the Cloud: a Journey from Virtual Machines to Serverless DeploymentsRenato Losio · DevOps Pro Europe 2019
• 23mNew Amazon RDS innovations in 2022Andy Katz · AWS Summit San Francisco 2022
• 40mCloud Databases: Pros and ConsRiccardo Capecchi, Marco Careddu, Piermarco Zerbini · Incontro DevOps 2017
• 37mNavigating Managed Databases for Over a Decade as a Non-DBARenato Losio · Site Reliability Engineering (SRE) 2025
• 53mMySQL DevOpsV. Fedorkov, A. Raspopina · DevOps Pro Moscow 2019
• 52mMicrosoft SQL Server HA/DR on AWSAsif Mujawar · Conf42 Site Reliability Engineering 2021