MySQL Enterprise Backup, Using Incrementals

As an experiment I have been testing MySQL Enterprise Backuip (MEB) and incremental backups. 


The idea was to test backing up a multi terabyte database.   The plan was to test using incremental backups to try and get the backup time more manageable.  First thing to note is the MEB can run cummulative and differential incremental backups, which is good but the bad news is without some way of block tracking the process is slow.

The database we are testing is 4TB

Full backup (4TB) - 16 hours
Cummulative  (25GB) -  11 hours 30 mins
Differential (20GB) - 10 hours 50 mins

The problem is the time taken to run the incremental backups.  Without features like block tracking the backup has to check all the blocks to see if there are changed.   This is a long process.

Incremental backups

The process involves new using the following parameters:
--incremental
Specifies the type of backup
--incremental-backup-dir=<location>
Specifies the backup location
--incremental-base=dir:<location>
Specifies the base backup

The incremental-base backup is important if you want to run a cummulative backup use the full backup location and if you want to run a differential then use the last incremental backup location.

For example:

mysqlbackup --incremental --incremental-backup-dir=<location|> --incremental-base=dir:<location> backup

For MEB 3.10 users - there is a bug with MEB when using the thread parameters (--read-threads --process-threads --write-threads).  The backup dies without explaination, fixed in 3.11

20 comments:

  1. The actual time and effort taken to create this wonderful article were really great, thanks much for sharing here would like to read this blog regularly to get more important stuff...
    Best Online Software Training Institute | PLSQL Training

    ReplyDelete
    Replies
    1. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

      Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


      Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

      Delete
  2. This comment has been removed by the author.

    ReplyDelete