0

I have 1TB size mysql database for production . Now i want to migrate this database on new mysql RDS instance . Please suggest me which backup policy should i apply here like Mysqldump,XtraBackup . ?

4
  • Depends on database complexity. Maybe simple structure backup + SELECT INTO OUTFILE/LOAD DATA INFILE will be the best solution.
    – Akina
    Jun 16, 2020 at 15:57
  • Can we restore Xtrabackup backup of Mysql to newly launched rds mysql instance ? Jun 16, 2020 at 16:12
  • Please consult with your RDS support.
    – Akina
    Jun 16, 2020 at 16:18
  • aws.amazon.com/dms is also an option worth checking, if you'd like to bypass most of the manual setup and maintenance. Mar 26, 2021 at 19:51

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.