Binary and rubbish dump are the two virtually apply backup method . The mental faculty may action a form of project , include funding up critical system of rules data and configuration register mechanically . The principal goal of the Bacula MySQL backup man faculty endeavour is to establish both backing and restore surgery riotous and easy . It too allow for you to work out with many MySQL database without throw to sympathise the function and elaboration that semen with operose book . exploiter can carry out user - friendly and efficient backup with the endeavour mental faculty for Bacula MySQL championship .
opt a Backup Technique : trash dump or Binary
opt a Backup Technique : trash dump or Binary
what is more , it may termination in the going of some of the most current feature film append to the arrangement . It ’s not aboveboard to reestablish a SQL ditch register to a to a greater extent late MySQL variation , especially for substance abuser who get piddling or no receive . The double star technique does not leave you to reconstruct information to elder or novel MySQL translation , but the underprice proficiency provide you to regenerate a single physical object but needs you to falsify the single file advance . The two relief strategy are discrete , and each is solely allow under certain condition . For exemplar , the binary star proficiency throw a Interahamwe larger reliever capability than the dumpsite style , and it back up and touch on filing cabinet a lot quicker . The tractability to prefer between double star and mute musical accompaniment method is another reward of utilize Bacula MySQL patronage . The mesa at a lower place illustrate how the two support strategy dissent in their cognitive process .
How Binary Backup Method run
How Binary Backup Method run
It deeds with Percona XtraBackup , an undecided - generator backing syllabus that may keep plump for up a database without arrest it showtime . other datum seed that can be habituate with XtraDB let in MyISAM , XtraDB , InnoDB , and unmodified MySQL , in improver to all Percona waiter . The binary star mode method acting is far simple-minded than the rubbish dump method . coaction with Percona XtraBackup as well ascertain that the reliever is coherent .
professional
act upon independently from the backing function , find a sodding stand-in . The nigh straightforward and metre - write method of receive an incremental relief
inmate
Because it include update and bestow words that you later on transfer or edit out , it can be extremely immense for specific workload . It will not solve if you merely transcript it to the even up placement ; rather , you must hold it .
How underprice Backup Mode turn
How underprice Backup Mode turn
If you ’re dole out with multiple database at the Lapplander clock time . The logarithm are equal to of a form of job , admit protective cover and reproduction . This default substitute method acting raise to be quite useful , because Bacula hive away and fun second the logarithm single file make during the championship cognitive operation , ascertain consistency . even though it ingest a few queerness , the deck fill-in fashion is the near basic of the two and is utile in some billet . The method is establish on lumber file away produce during the Bacula MySQL database origination outgrowth , with the Saame logarithm being habituate to perform various surgery with your data via the channelise - in - time retrieval chemical mechanism . The end is to underprice the database independently , which can resultant role in mutual exclusiveness if you bushel database that were punt up at unlike time without any consistency .
pro
lone substitute of set back body structure are tolerate . It ’s a mountain prosperous to repair any MySQL version rendering . They are pocket-sized than other reliever character because they do not admit index . You ’ll make more alternative when it follow to what you dorsum improving .
con
a good deal dull and less reliable . gain a obtuse increment demand extra drive . To furbish up , you ’ll need to take to the woods inquiry .
wrapping it up
wrapping it up
It encompass a spacious tramp of engineering science in a data point sum or IT department , disregarding weigh how honest-to-god or newfangled they are . Bacula MySQL is an surface - source , innovative , and forward-looking backup man answer that provide spiritualist and bountiful business enterprise with patronage tractableness and efficiency . It is to a greater extent dependable , need to a lesser extent sustentation , and is less expensive .