Moving Half a Million Database Tables to AWS Aurora (Part 2)


#1

Originally published at: https://pressbooks.org/blog/2017/11/07/moving-half-a-million-database-tables-to-aws-aurora-part-2/

Quick recap: Migrate half a million database tables from a single bare metal server with 1 database to 101 database slices on AWS Aurora. Wait, half a million database tables?! Answered in Part 1. Plan 1. Stop the server, take an LVM snapshot. 2. Use mydumper to dump the snapshot to SQL files. 3. rysnc these…