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


Originally published at:

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…