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 . ?

Improve this question
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 ?
    – Uday Raj Gupta
    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.
    – Kunal Nagpal
    Mar 26, 2021 at 19:51

0

Reset to default

Your Answer

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