Not the answer you need?
Register and ask your own question!

broken backups

Evgeniy DemyanenkoEvgeniy Demyanenko EntrantInactive User Role Beginner
Hi!
My name's Evgeniy and I have next question:
I have two scripts in crontab that launch 1-rst innobackupex to make the full backup(in the start of the week) and the second one - for icremental per day (Tue - Sat), so I wonder what happens if MySQL crashed (or happens something else) when innobackupex make inremental/full backup?
Or I have a full backup and next incremental that is broken how the next day incremental will be created?
Thanks a lot!

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    I would assume that the next incremental backup will have to check from the last successful incremental backup to check the lsn, if there are no successful incremental backups since then it will have to look for the last full backup. You must have it configure to make sure your script catches these nuances.
  • Evgeniy DemyanenkoEvgeniy Demyanenko Entrant Inactive User Role Beginner
    jrivera wrote: »
    You must have it configure to make sure your script catches these nuances.

    I found some option - but I can't understand how it works!
    If I wrong, please correct me:
    Additionally I must have the PERCONA_SCHEMA.xtrabackup_history in my MYSQL server?
    And when I launch the
  • Evgeniy DemyanenkoEvgeniy Demyanenko Entrant Inactive User Role Beginner
    It's done! I got it)
    Thanks a lot!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.