AWS has launched a new feature for Amazon Aurora: you may create an Aurora Read Replica from an Amazon RDS for MySQL DB instance. This proves extremely useful for migrating a critical database that simply cannot be taken offline, even for an hour.
To use this feature, you first need to create a DB snapshot of your RDS instance. You use this as a template for your Amazon Aurora read replica. Replication also updates it to be up to part with the source DB, after which you can start using the replica as your regular DB.
Please note that the migration can take a long time depending on how many terabytes of data you have. This process works for up to 6 terabytes of MySQL DB instances.
Also, InnoDB tables have been shown to migrate faster than MyISAM. Similarly, uncompressed tables are also faster. You may decide to move your MyISAM tables to InnoDB tables and uncompressing compressed tables.
This feature is currently available. And if you would like to know how to migrate your enterprise’s data to the cloud, we can show you how. Contact us today at PolarSeven.