Xtrabackup From Zero to Hero

Slide 1

Slide 1 text

© Copyright 2023 Percona® LLC. All rights reserved Percona Xtrabackup: From Zero to Hero Marcelo Altmann - Senior Software Engineer Vinicius Grippa - Senior Support Engineer Percona Live Denver / May 2023

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Marcelo Altmann ● Senior Software Engineer @ Percona ● Working on Xtrabackup Project ● Author of key features ○ FIFO Datasink / xbcloud multi-thread ○ Memory Estimation ○ ZSTD Compression Support ○ Xbcloud exponential Backoff ○ Xbcloud instance profile ○ KMIP & KMS Keyring Component Integration

Slide 4

Slide 4 text

Vinicius Grippa ● Senior Support Engineer @ Percona ● MySQL and MongoDB specialist ● Working with databases for 18 years ● Co-Author of the book Learning MySQL

Slide 5

Slide 5 text

Slide 6

Slide 6 text

© Copyright 2023 Percona® LLC. All rights reserved ● Download the PDF with examples to follow at https://bit.ly/pl_tutorial ● If you are on ARM - Ask presenter for a remote Instance credentials. Before we start

Slide 7

Slide 7 text

Slide 8

Slide 8 text

Slide 9

Slide 9 text

Slide 10

Slide 10 text

Slide 11

Slide 11 text

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

Slide 15

Slide 15 text

Slide 16

Slide 16 text

Slide 17

Slide 17 text

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Slide 20

Slide 20 text

Slide 21

Slide 21 text

Slide 22

Slide 22 text

Slide 23

Slide 23 text

Slide 24

Slide 24 text

Slide 25

Slide 25 text

Slide 26

Slide 26 text

Slide 27

Slide 27 text

Slide 28

Slide 28 text

Slide 29

Slide 29 text

Slide 30

Slide 30 text

Slide 31

Slide 31 text

Slide 32

Slide 32 text

Slide 33

Slide 33 text

Slide 34

Slide 34 text

© Copyright 2023 Percona® LLC. All rights reserved Incremental Backups ● Page Tracking (8.0.27+) ● Server Component to keep track of changed pages ● Xtrabackup calls server API and get list of changed pages between range of LSN

Slide 35

Slide 35 text

Slide 36

Slide 36 text

Slide 37

Slide 37 text

© Copyright 2023 Percona® LLC. All rights reserved ● Used to stream data to another machine or Object Storage ● Currently supported Object Storages: ○ S3 / Azure / GCP / Swift ● Uses custom xbstream format - https://bit.ly/xbstream-format ● Introduces two new binaries ○ Xbstream - responsible for interpret xbstream chunks and reassembly the original file ○ Xbcloud - responsible for downloading and uploading chunks to object storage Streaming

Slide 38

Slide 38 text

Slide 39

Slide 39 text

Slide 40

Slide 40 text

Slide 41

Slide 41 text

Slide 42

Slide 42 text

© Copyright 2023 Percona® LLC. All rights reserved ● Currently support for QuickLZ, LZ4 and ZSTD ○ QuickLZ no longer maintained ○ Deprecated on 8.0.32 ○ ZSTD will become default on 8.0.34 ○ Ability to --backup will be removed at 8.0.35 (Backward compatibility) ● Use LZ4 and ZSTD instead Compressed Backups

Slide 43

Slide 43 text

Slide 44

Slide 44 text

© Copyright 2023 Percona® LLC. All rights reserved ● Can be tuned with: ○ --parallel - number of parallel copy threads ○ --compress-threads - number of threads responsible for compression work ○ --encrypt-threads - number of threads responsible for encryption work ● Rule of thumbs - parallel > compress > encrypt Encrypted & Compressed Backups

Slide 45

Slide 45 text

Slide 46

Slide 46 text

Slide 47

Slide 47 text

© Copyright 2023 Percona® LLC. All rights reserved ● Intentionally copy just required tables ● Can be done by providing: ○ Regular Expression of matching tables ○ File with list of tables ○ File with a list of databases Partial Backups

Slide 48

Slide 48 text

© Copyright 2023 Percona® LLC. All rights reserved ● Restore just specific table(s) from full backup ● Works using Transportable Tablespace ● xtrabackup --prepare --export - produces exportable table spaces files ● For each table, user needs to: ○ Create table with same definition ○ Discard Tablespace ○ Copy table files (.ibd, .cfg) to server datadir ○ Import Tablespace Partial Restore

Slide 49

Slide 49 text

Slide 50

Slide 50 text

Slide 51

Slide 51 text

© Copyright 2023 Percona® LLC. All rights reserved ● Allows for restoring a backup and replay transactions up to a specific point in time ● Useful when a disaster has occurred and the data between the last backup and time of disaster cannot be lost ● Requires copy of binary logs Point In Time Recovery

Slide 52

Slide 52 text

Slide 53

Slide 53 text

Slide 54

Slide 54 text

Slide 55

Slide 55 text

© Copyright 2023 Percona® LLC. All rights reserved ● Which feature(s) would you like to be added to xtrabackup? ● PXB-2901 - Add Full page tracking feature in PXB ● PXB-3034 - Reduce the time the instance remains locked during the backup ● PXB-2745 - Selective table backup/restore What is next Join at slido.com #4260 437

Slide 56

Slide 56 text

Slide 57

Slide 57 text