DEV Community

Aadit Unni
Aadit Unni

Posted on

Migrate from RDS MySQL to Aurora MySQL in near zero downtime

[16/100] #100DaysOfCloud Today, I migrated from RDS MySQL database to Aurora MySQL in near zero downtime.

  • RDS :
    Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

  • Aurora :
    Amazon Aurora (Aurora) is a serverless, fully managed relational database engine that's compatible with MySQL and PostgreSQL. The code, tools, and applications you use today with your existing MySQL and PostgreSQL databases can be used with Aurora. With some workloads, Aurora can deliver up to five times the throughput of MySQL and up to three times the throughput of PostgreSQL without requiring changes to most of your existing applications.
    Aurora includes a high-performance storage subsystem. Its MySQL- and PostgreSQL-compatible database engines are customized to take advantage of that fast distributed storage. The underlying storage grows automatically as needed. An Aurora cluster volume can grow to a maximum size of 128 tebibytes (TiB). Aurora also automates and standardizes database clustering and replication, which are typically among the most challenging aspects of database configuration and administration.

RDS allows you to provision up to 5 replicas, and the process of replication is slower compared to Aurora. Aurora allows you to provision up to 15 replicas, and the replication is done in milliseconds. Aurora scales faster because it can add new read replicas quickly.

You can try to migrate from RDS MySQL database to Aurora MySQL in near zero downtime by yourself by following the steps from the link below :
GitHub

Top comments (0)