I currently have my database on a MySQL server hosted in a dedicated EC2 instance and planning to migrate the DB to a RDS backed MySQL server.
Now the issue I have is with migrating the data from EC2 to RDS. The database is nearly 185 GB and at this point I do not worry about downtime or having the data in sync with production. All I need at the moment is to basically take a dump and import it to the RDS.
This is what I have tried so far,
It takes almost one day for nearly 35Gb to be imported and never managed to completely import the DB. Appreciate if someone could tip me as to how I could do this.
AWS предлагает Службу миграции баз данных (DMS) именно для этого. DMS может переноситься из локальных экземпляров, экземпляров EC2 или RDS. Он предлагает прогресс, статистику и многое другое.