DZone Database Zone
MySQL Point-in-Time Recovery: The Right Way
In this blog, I'll look at how to do MySQL point-in-time recovery (PITR) correctly.
Sometimes, we need to restore from a backup and then replay the transactions that happened after the backup was taken. This is a common procedure in most disaster recovery plans where, for example, you accidentally drop a table/database or run an update/delete without the where clause and lose data.
No comments:
Post a Comment