MEGA MGC Coffee's DB Modernization Case: Migrating Mobile Ordering Service from Amazon RDS for MySQL to Amazon Aurora Serverless v2

Due to the nature of MEGA MGC Coffee's mobile app service, where order traffic is concentrated in the morning hours, the company had been experiencing cost inefficiency in its existing Amazon RDS for MySQL environment, which required maintaining a high-spec instance at all times to handle peak-time demand.

To address this, the company introduced Amazon Aurora Serverless v2 and transitioned to an architecture that can flexibly adjust capacity according to traffic patterns. The main goals of this project were as follows.

• Ensuring database processing stability during morning peak hours
• Flexible capacity operation and cost optimization through Aurora Serverless v2
• Securing high availability and read scalability through a Writer/Reader configuration

During the migration process, the company adopted an Aurora Read Replica-based migration approach to minimize service disruption. Data consistency was ensured by maintaining replication between the existing RDS and Aurora, and then performing a Promote after confirming that Replica Lag was 0 at the final cutover point.

As a result, MEGA MGC Coffee established a foundation for stably handling the surge in Select and DML transactions during the morning hours, while also optimizing operating costs by reducing resources during periods of lower traffic.