Why is it taking a long time to perform a point-in-time recovery of my Amazon RDS for MySQL instance?

Last updated: 2021-08-16

I've initiated a point-in-time recovery (PITR) in Amazon Relational Database Service (Amazon RDS) for MySQL, and it's taking longer than expected. Why is this happening?

Short description

Point-in-time recovery (PITR) is the process of restoring a database to the state that it was in at a specified date and time. When you initiate a PITR, transactional logs are applied to the most appropriate daily backups to restore your DB instance to a specified time.

Resolution

Best practices for avoiding a long point-in-time recovery

To avoid a long point-in-time recovery, follow these best practices:

Point-in-time recovery failures

The following scenarios will cause point-in-time recovery to fail:


Did this article help?


Do you need billing or technical support?