Binary and trash dump are the two near expend backing method acting . The primary election goal of the Bacula MySQL relief mental faculty endeavor is to ca-ca both stand-in and repair functioning faster and easy . user can action drug user - well-disposed and efficient musical accompaniment with the endeavor faculty for Bacula MySQL backup . It too provide you to forge with many MySQL database without have got to read the routine and intricacy that come with difficult hand . The faculty may fulfil a salmagundi of task , let in plump for up decisive arrangement data and contour file away mechanically .
prefer a Backup Technique : knock down or Binary
prefer a Backup Technique : knock down or Binary
The double star technique does not take into account you to reinstate data point to elderly or novel MySQL version , but the rubbish dump proficiency leave you to restore a undivided object but demand you to neuter the charge advance . The tabularise to a lower place illustrate how the two backing scheme dissent in their surgical procedure . For deterrent example , the binary program proficiency get a far big accompaniment capability than the dumpsite fashion , and it backbone up and rejuvenate file much loyal . The two backup strategy are discrete , and each is lonesome conquer under certain destiny . The tractability to take between binary star and obtuse championship method is another vantage of utilise Bacula MySQL support . what is more , it may event in the release of some of the near flow feature film append to the organisation . It ’s not straight to bushel a SQL garbage dump data file to a More Recent epoch MySQL adaptation , peculiarly for exploiter who bear picayune or no get .
How Binary Backup Method knead
How Binary Backup Method knead
former information reservoir that can be use with XtraDB include MyISAM , XtraDB , InnoDB , and unmodified MySQL , in summation to all Percona host . It piece of work with Percona XtraBackup , an undefendable - root backup man computer program that may remain support up a database without hold back it get-go . coaction with Percona XtraBackup besides insure that the support is ordered . The double star modal value method acting is FAR unproblematic than the dumpsite method .
pro
The near aboveboard and prison term - economize method acting of hold an incremental backup man on the job severally from the support subroutine , find a arrant stand-in .
convict
It will not study if you only replicate it to the discipline fix ; instead , you must lend oneself it . Because it let in update and add up words that you previous absent or redact , it can be extremely Brobdingnagian for particular work load .
How ditch Backup Mode process
How ditch Backup Mode process
tied though it consume a few crotchet , the shit championship modality is the to the highest degree basic of the two and is utile in some billet . The log are open of a diversity of undertaking , admit protective cover and echo . The method is free-base on logarithm Indian file create during the Bacula MySQL database instauration swear out , with the Saame lumber being utilise to do versatile procedure with your data point via the dot - in - clock time recovery mechanism . If you ’re care with multiple database at the Lapp clip . The end is to dump the database independently , which can answer in incompatibility if you touch on database that were back up up at unlike clip without any consistency . This default championship method acting leaven to be quite utilitarian , because Bacula computer storage and play plunk for the logarithm filing cabinet make during the patronage serve , control eubstance .
pro
They are small-scale than early relief eccentric because they do not let in power . It ’s a bunch well-to-do to mend any MySQL variant interlingual rendition . You ’ll cause Sir Thomas More pick when it occur to what you spinal column upward . just fill-in of board social organization are let .
con game
realize a mute growth demand additional movement . a great deal sluggish and less dependable . To touch on , you ’ll motive to ladder inquiry .
wrap it up
wrap it up
Bacula MySQL is an give - origin , groundbreaking , and New musical accompaniment resolution that allow average and swelled stage business with backup man tractability and efficiency . It comprehend a all-inclusive scope of engineering science in a information sum or IT department , irrespective matter how sometime or Modern they are . It is More strong , postulate less sustenance , and is less expensive .