We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Backup/Restore tools performance comparison

00:00
subtitles
off
playback rate
1
subtitles
off
Englisch (auto-generated)
playback rate
0.25
0.5
0.75
1
1.25
1.5
1.75
2
quality
576p
 Cite
 Share
 Download Purchase
FOSDEM VZW
 Grippa, Vinicius Silva, Jean Da

Formal Metadata

Title
Backup/Restore tools performance comparison
Title of Series
Number of Parts
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
Backup and restore methods are concepts that everyone knows the importance of. Over the years, open-source tools emerged like MyDumper, Xtrabackup, and Mariabackup. Also, with MySQL 8 new shell, new utils for dump and restore were introduced as well. In this presentation, we are going to compare the newest backup/restore methods with the most used ones. We will see how parallelization can influence the speed of backup and restore process and also how the compression algorithms can influence the performance. In this talk, we will compare mysqldump, mydumper/myloader, mysqlpump, MySQL Shell utils, and Xtrabackup.
00:00
Multiplication signSoftware testingSequelResultantCore dumpGastropod shellPairwise comparisonXMLUML
01:05
SequelSanitary sewerWordMobile WebPosition operatorSpacetimeMedianMaizeProcedural programmingOpen sourceComputer animation
02:19
Gastropod shellDatabaseComputer fileBackupLogicMultiplicationThread (computing)Single-precision floating-point formatTotal S.A.EncryptionComputer networkRight angleSpacetimeStress (mechanics)SequelMultiplication signComputer fileCuboidPhysicalismPhysical lawMusical ensembleDegree (graph theory)Order (biology)Near-ringVideo gameOpen sourceProcess (computing)Time zoneMereologyBlogException handlingPoint cloudThread (computing)Core dumpData managementBackupDatabaseOperator (mathematics)MiniDiscGastropod shellData recoverySoftwareSheaf (mathematics)EncryptionBinary codeBootingCodeINTEGRALTask (computing)Type theoryTotal S.A.LogicXMLUML
06:54
BenchmarkNumberXMLUML
07:17
DatabaseMiniDiscTable (information)Revision controlBenchmarkBefehlsprozessorRead-only memoryGastropod shellNetwork socketFunction (mathematics)Computer configurationSequelDecision theorySoftware testingMultiplication signRow (database)Process (computing)Doubling the cubeMilitary baseDegree (graph theory)Different (Kate Ryan album)Thomas BayesInstance (computer science)Data storage device2 (number)DatabaseDefault (computer science)Boris (given name)Term (mathematics)MiniDiscArithmetic meanCuboidGastropod shellOffice suiteNetwork socketThread (computing)Network topologyBlogMetric systemMathematical singularityLoginInternet forumResultantVirtual machineData compressionLocal ringSemiconductor memoryPressureTransport Layer SecurityLevel (video gaming)Computer fileBinary codeOpen sourceTable (information)Buffer solutionRevision controlCommunications protocolMarginal distributionError messageCore dumpRun time (program lifecycle phase)Graph (mathematics)Number1 (number)BitDiagram
13:56
CoroutineGoodness of fitNumberSpeech synthesisJSONXMLUML
14:31
DatabaseMiniDiscTable (information)Revision controlBenchmarkBefehlsprozessorRead-only memoryGastropod shellPointer (computer programming)Axiom of choiceComputer configurationBitNumberParallel portGastropod shellMiniDiscBootingPoint (geometry)Goodness of fitRevision controlOperator (mathematics)BefehlsprozessorVirtual machineResultantCore dumpMereologyMultiplication signProfil (magazine)Process (computing)Computer clusterRootSingle-precision floating-point formatTerm (mathematics)SequelSystem callDiagram
17:49
NumberTotal S.A.Decision theoryUML
18:11
Menu (computing)Computer configurationGastropod shellChannel capacityMiniDiscThread (computing)Marginal distributionBinary fileACIDBlogComputer fileWeb pageLogicStructural loadServer (computing)CoroutineRadio-frequency identificationSoftware testingProcess (computing)Core dumpSoftware testingComputer configurationMiniDiscResultantEncryptionGastropod shellIntegrated development environmentAxiom of choiceSoftwareProduct (business)Complex (psychology)1 (number)BootingNumberLine (geometry)Buffer solutionRight angleDifferent (Kate Ryan album)DatabaseVirtual machineTerm (mathematics)Data compressionDoubling the cubeWritingParallel portLoginHeegaard splittingComputer fileSet (mathematics)Information securityGoodness of fitBitBlog2 (number)Chemical equationMultiplication signSpacetimeNetwork socketHypermediaInformationInternet forumBefehlsprozessorSummierbarkeitOnline chatGroup actionEqualiser (mathematics)UsabilityShared memoryReliefKey (cryptography)FingerprintSequelSpecial unitary groupSource codeAlgebraCrash (computing)Physical lawGodForcing (mathematics)FreewareKnowledge baseOpen setCuboidNetwork topologyPhysicalismWorkstation <Musikinstrument>PredictabilityMachine visionFilm editingMusical ensembleOrder (biology)SequenceXML
26:42
Multiplication signMachine vision
27:06
Computer animation
Transcript: Englisch(auto-generated)