💡 Challenge Lab: Migrating a Database to Amazon RDS
The café application initially ran its web server, database, and app code all on a single EC2 instance. As the business grew, issues like patching, backups, scalability, and admin overhead became challenges.
The solution? I migrated the database from EC2 to Amazon RDS (MariaDB).
Key steps included:
1. Creating a new RDS instance
2. Exporting data from the existing MariaDB database on EC2 using mysqldump
3. Connecting to the RDS instance and importing the data
4. Updating the café web application to use RDS for all future orders
✅ Outcome: The application now runs seamlessly with the RDS backend, ensuring durability, scalability, automated backups, and reduced admin overhead. The café staff now focuses more on the business instead of managing databases.
