Efficient way for RDS SQL Backup

0

I am researching for the most efficient way to get SQL backup from RDS database. When using SQL GUI, it takes several hours to complete, which is not ideal in our operation.

Used MySQLdump in the command line before, which is very quick. https://repost.aws/knowledge-center/rds-mysql-db-backup

However, our database is constantly growing.

Doing a MySQLdump saves the file in temporary storage before saving it to its final location. If the temporary storage is not large enough to handle this, and it ends up bringing down the whole server or severely impacting it.

Beside from increasing the temporary storage, what would be the other way to approach this?

Thanks.

Jei
已提问 7 个月前213 查看次数
1 回答
1

Hi Jei,

Assuming that you only want a logical backup via mysqldump the simplest option would be to increase the temporary store.

The other option is to rely on the AWS RDS automated backups and/or snapshots.

profile picture
Bisina
已回答 7 个月前
profile picture
专家
已审核 7 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则