I’m creating a backup plan for my MySQL Server (5.5). I was thinking about a full backup every sunday morning and an incremental backup monday - saturday.
I figured that innobackupex pretty much will do the trick for me.
So far so good.
I was reading about how the backup is done, and I understand that the incremental backup is done by reading the changes in the logfile since last backup (Based on the LSN).
What happens if my logfile is i.e. 5 MB but in the time between two backups there is written 20 MB to the log.
I guess I won’t be able to create a valid incremental backup since 15MB of information must be missing in the log?
and I also guess I will have to increase the log file size to fix this problem?
But how do I calculate a proper size for the logfile?
any “best practices” on this matter?