[root@db06 database]# cp base_xtrabackup/xtrabackup_logfile ./tmp/ [root@db06 database]# mariabackup --version mariabackup based on MariaDB server 10.1.29-MariaDB Linux (x86_64) [root@db06 database]# mariabackup mariabackup --prepare --apply-log-only --target-dir=/var/database/base_xtrabackup/ mariabackup: Error: unknown argument: 'mariabackup' [root@db06 database]# mariabackup --prepare --apply-log-only --target-dir=/var/database/base_xtrabackup/ mariabackup based on MariaDB server 10.1.29-MariaDB Linux (x86_64) mariabackup: cd to /var/database/base_xtrabackup/ mariabackup: This target seems to be not prepared yet. mariabackup: xtrabackup_logfile detected: size=145752064, start_lsn=(1882645776419) mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = ./ mariabackup: innodb_log_files_in_group = 1 mariabackup: innodb_log_file_size = 145752064 mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = ./ mariabackup: innodb_log_files_in_group = 1 mariabackup: innodb_log_file_size = 145752064 mariabackup: Starting InnoDB instance for recovery. mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: The InnoDB memory heap is disabled 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: Using SSE crc32 instructions 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: Initializing buffer pool, size = 100.0M 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: Completed initialization of buffer pool 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: Highest supported file format is Barracuda. 2020-04-07 16:09:35 139657573910784 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1882645776419 2020-04-07 16:09:41 139657573910784 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer... 2020-04-07 16:09:42 139657573910784 [Note] InnoDB: Starting a batch to recover 16949 pages from redo log 2020-04-07 16:09:50 139657349420800 [Note] InnoDB: To recover: 11050 pages from log 2020-04-07 16:10:05 139657349420800 [Note] InnoDB: To recover: 342 pages from log 2020-04-07 16:10:06 139657573910784 [Note] InnoDB: Starting a batch to recover 15389 pages from redo log 2020-04-07 16:10:20 139657349420800 [Note] InnoDB: To recover: 4399 pages from log 2020-04-07 16:10:27 139657573910784 [Note] InnoDB: Starting a batch to recover 13984 pages from redo log 2020-04-07 16:10:35 139657324242688 [Note] InnoDB: To recover: 6329 pages from log 2020-04-07 16:10:44 139657573910784 [Note] InnoDB: Starting a batch to recover 14546 pages from redo log 2020-04-07 16:10:50 139657341028096 [Note] InnoDB: To recover: 9442 pages from log 2020-04-07 16:11:05 139657324242688 [Note] InnoDB: To recover: 462 pages from log 2020-04-07 16:11:06 139657573910784 [Note] InnoDB: Starting final batch to recover 1786 pages from redo log mariabackup: Recovered WSREP position: c926c607-f9ce-11e6-b203-ce70d0d27d00:824613374 mariabackup: starting shutdown with innodb_fast_shutdown = 1 2020-04-07 16:11:08 139657573910784 [Note] InnoDB: Starting shutdown... 2020-04-07 16:11:11 139657573910784 [Warning] InnoDB: Some resources were not cleaned up in shutdown: threads 0, events 19, os_mutexes 16, os_fast_mutexes 35 2020-04-07 16:11:11 139657573910784 [Note] InnoDB: Shutdown completed; log sequence number 1882775324256 200407 16:11:11 completed OK! [root@db06 database]# mariabackup --help|grep memory mariabackup based on MariaDB server 10.1.29-MariaDB Linux (x86_64) --use-memory=# The value is used instead of buffer_pool_size memory). Size of a memory pool InnoDB uses to store data The size of the memory buffer InnoDB uses to cache data use-memory 104857600 [root@db06 database]# free -m total used free shared buff/cache available Mem: 5799 298 3297 8 2203 5213 Swap: 507 0 507 [root@db06 database]# diff tmp/xtrabackup_logfile base_xtrabackup/xtrabackup_logfile De binära filerna tmp/xtrabackup_logfile och base_xtrabackup/xtrabackup_logfile skiljer [root@db06 database]# cp base_xtrabackup/xtrabackup_logfile tmp/xtrabackup_logfile-after-prepare [root@db06 database]# cp tmp/xtrabackup_logfile base_xtrabackup/xtrabackup_logfile cp: skriva över ”base_xtrabackup/xtrabackup_logfile”? y [root@db06 database]# mariabackup --prepare --apply-log-only --target-dir=/var/database/base_xtrabackup/ mariabackup based on MariaDB server 10.1.29-MariaDB Linux (x86_64) mariabackup: cd to /var/database/base_xtrabackup/ mariabackup: This target seems to be already prepared with --apply-log-only. mariabackup: xtrabackup_logfile detected: size=145752064, start_lsn=(1882645776419) mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = ./ mariabackup: innodb_log_files_in_group = 1 mariabackup: innodb_log_file_size = 145752064 mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = ./ mariabackup: innodb_log_files_in_group = 1 mariabackup: innodb_log_file_size = 145752064 mariabackup: Starting InnoDB instance for recovery. mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: The InnoDB memory heap is disabled 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: Using SSE crc32 instructions 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: Initializing buffer pool, size = 100.0M 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: Completed initialization of buffer pool 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: Highest supported file format is Barracuda. 2020-04-07 16:13:04 140169963112704 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1882645776419 2020-04-07 16:13:05 140169963112704 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer... 2020-04-07 16:13:05 140169963112704 [Note] InnoDB: Starting a batch to recover 16949 pages from redo log 2020-04-07 16:13:07 140169963112704 [Note] InnoDB: Starting a batch to recover 15389 pages from redo log 2020-04-07 16:13:09 140169963112704 [Note] InnoDB: Starting a batch to recover 13984 pages from redo log 2020-04-07 16:13:11 140169963112704 [Note] InnoDB: Starting a batch to recover 14546 pages from redo log 2020-04-07 16:13:13 140169963112704 [Note] InnoDB: Starting final batch to recover 1786 pages from redo log mariabackup: starting shutdown with innodb_fast_shutdown = 1 2020-04-07 16:13:13 140169963112704 [Note] InnoDB: Starting shutdown... 2020-04-07 16:13:14 140169963112704 [Warning] InnoDB: Some resources were not cleaned up in shutdown: threads 0, events 19, os_mutexes 16, os_fast_mutexes 35 2020-04-07 16:13:14 140169963112704 [Note] InnoDB: Shutdown completed; log sequence number 1882775324256 200407 16:13:14 completed OK! [root@db06 database]# ls -lat incremental_xtrabackup/ totalt 288 drwxr-xr-x. 8 root root 4096 7 apr 16.07 .. drwxrwxr-x. 11 backup backup 4096 7 apr 00.28 incremental-20200407-000001.1586210401 drwxr-xr-x. 71 backup backup 4096 7 apr 00.00 . drwxrwxr-x. 11 backup backup 4096 6 apr 00.28 incremental-20200406-000001.1586124001 drwxrwxr-x. 11 backup backup 4096 5 apr 00.27 incremental-20200405-000001.1586037601 drwxrwxr-x. 11 backup backup 4096 4 apr 00.29 incremental-20200404-000001.1585951201 drwxrwxr-x. 11 backup backup 4096 3 apr 00.28 incremental-20200403-000001.1585864801 drwxrwxr-x. 11 backup backup 4096 2 apr 00.27 incremental-20200402-000001.1585778401 drwxrwxr-x. 11 backup backup 4096 1 apr 00.28 incremental-20200401-000002.1585692002 drwxrwxr-x. 11 backup backup 4096 31 mar 00.26 incremental-20200331-000001.1585605601 drwxrwxr-x. 11 backup backup 4096 30 mar 00.28 incremental-20200330-000001.1585519201 drwxrwxr-x. 11 backup backup 4096 29 mar 00.26 incremental-20200329-000001.1585436401 drwxrwxr-x. 11 backup backup 4096 28 mar 00.26 incremental-20200328-000002.1585350002 drwxrwxr-x. 11 backup backup 4096 27 mar 00.27 incremental-20200327-000001.1585263601 drwxrwxr-x. 11 backup backup 4096 26 mar 00.27 incremental-20200326-000002.1585177202 drwxrwxr-x. 11 backup backup 4096 25 mar 00.27 incremental-20200325-000001.1585090801 drwxrwxr-x. 11 backup backup 4096 24 mar 00.25 incremental-20200324-000001.1585004401 drwxrwxr-x. 11 backup backup 4096 23 mar 00.28 incremental-20200323-000001.1584918001 drwxrwxr-x. 11 backup backup 4096 22 mar 00.26 incremental-20200322-000002.1584831602 drwxrwxr-x. 11 backup backup 4096 21 mar 00.26 incremental-20200321-000001.1584745201 drwxrwxr-x. 11 backup backup 4096 20 mar 00.26 incremental-20200320-000001.1584658801 drwxrwxr-x. 11 backup backup 4096 19 mar 00.26 incremental-20200319-000002.1584572402 drwxrwxr-x. 11 backup backup 4096 18 mar 00.28 incremental-20200318-000001.1584486001 drwxrwxr-x. 11 backup backup 4096 17 mar 00.27 incremental-20200317-000001.1584399601 drwxrwxr-x. 11 backup backup 4096 16 mar 00.27 incremental-20200316-000001.1584313201 drwxrwxr-x. 11 backup backup 4096 15 mar 00.26 incremental-20200315-000001.1584226801 drwxrwxr-x. 11 backup backup 4096 14 mar 00.27 incremental-20200314-000001.1584140401 drwxrwxr-x. 11 backup backup 4096 13 mar 00.27 incremental-20200313-000001.1584054001 drwxrwxr-x. 11 backup backup 4096 12 mar 00.27 incremental-20200312-000001.1583967601 drwxrwxr-x. 11 backup backup 4096 11 mar 00.27 incremental-20200311-000001.1583881201 drwxrwxr-x. 11 backup backup 4096 10 mar 00.25 incremental-20200310-000001.1583794801 drwxrwxr-x. 11 backup backup 4096 9 mar 00.26 incremental-20200309-000001.1583708401 drwxrwxr-x. 11 backup backup 4096 8 mar 00.25 incremental-20200308-000001.1583622001 drwxrwxr-x. 11 backup backup 4096 7 mar 00.25 incremental-20200307-000001.1583535601 drwxrwxr-x. 11 backup backup 4096 6 mar 00.26 incremental-20200306-000001.1583449201 drwxrwxr-x. 11 backup backup 4096 5 mar 00.26 incremental-20200305-000001.1583362801 drwxrwxr-x. 11 backup backup 4096 4 mar 00.26 incremental-20200304-000001.1583276401 drwxrwxr-x. 11 backup backup 4096 3 mar 00.25 incremental-20200303-000001.1583190001 drwxrwxr-x. 11 backup backup 4096 2 mar 00.26 incremental-20200302-000002.1583103602 drwxrwxr-x. 11 backup backup 4096 1 mar 00.24 incremental-20200301-000001.1583017201 drwxrwxr-x. 11 backup backup 4096 29 feb 00.24 incremental-20200229-000001.1582930801 drwxrwxr-x. 11 backup backup 4096 28 feb 00.28 incremental-20200228-000001.1582844401 drwxrwxr-x. 11 backup backup 4096 27 feb 00.29 incremental-20200227-000001.1582758001 drwxrwxr-x. 11 backup backup 4096 26 feb 00.27 incremental-20200226-000001.1582671601 drwxrwxr-x. 11 backup backup 4096 25 feb 00.25 incremental-20200225-000001.1582585201 drwxrwxr-x. 11 backup backup 4096 24 feb 00.25 incremental-20200224-000001.1582498801 drwxrwxr-x. 11 backup backup 4096 23 feb 00.26 incremental-20200223-000001.1582412401 drwxrwxr-x. 11 backup backup 4096 22 feb 00.24 incremental-20200222-000001.1582326001 drwxrwxr-x. 11 backup backup 4096 21 feb 00.25 incremental-20200221-000001.1582239601 drwxrwxr-x. 11 backup backup 4096 20 feb 00.24 incremental-20200220-000001.1582153201 drwxrwxr-x. 11 backup backup 4096 19 feb 00.26 incremental-20200219-000001.1582066801 drwxrwxr-x. 11 backup backup 4096 18 feb 00.24 incremental-20200218-000002.1581980402 drwxrwxr-x. 11 backup backup 4096 17 feb 00.25 incremental-20200217-000001.1581894001 drwxrwxr-x. 11 backup backup 4096 16 feb 00.27 incremental-20200216-000001.1581807601 drwxrwxr-x. 11 backup backup 4096 15 feb 00.25 incremental-20200215-000001.1581721201 drwxrwxr-x. 11 backup backup 4096 14 feb 00.26 incremental-20200214-000002.1581634802 drwxrwxr-x. 11 backup backup 4096 13 feb 00.25 incremental-20200213-000002.1581548402 drwxrwxr-x. 11 backup backup 4096 12 feb 00.25 incremental-20200212-000001.1581462001 drwxrwxr-x. 11 backup backup 4096 11 feb 00.24 incremental-20200211-000001.1581375601 drwxrwxr-x. 11 backup backup 4096 10 feb 00.26 incremental-20200210-000001.1581289201 drwxrwxr-x. 11 backup backup 4096 9 feb 00.25 incremental-20200209-000001.1581202801 drwxrwxr-x. 11 backup backup 4096 8 feb 00.25 incremental-20200208-000001.1581116401 drwxrwxr-x. 11 backup backup 4096 7 feb 00.25 incremental-20200207-000001.1581030001 drwxrwxr-x. 11 backup backup 4096 6 feb 00.25 incremental-20200206-000001.1580943601 drwxrwxr-x. 11 backup backup 4096 5 feb 00.26 incremental-20200205-000001.1580857201 drwxrwxr-x. 11 backup backup 4096 4 feb 00.24 incremental-20200204-000001.1580770801 drwxrwxr-x. 11 backup backup 4096 3 feb 00.26 incremental-20200203-000001.1580684401 drwxrwxr-x. 11 backup backup 4096 2 feb 00.25 incremental-20200202-000001.1580598001 drwxrwxr-x. 11 backup backup 4096 1 feb 00.25 incremental-20200201-000001.1580511601 drwxrwxr-x. 11 backup backup 4096 31 jan 08.15 incremental-20200130-000001.1580338801 drwxrwxr-x. 11 backup backup 4096 31 jan 00.25 incremental-20200131-000002.1580425202 [root@db06 database]# cp incremental_xtrabackup/incremental-20200130-000001.1580338801/xtrabackup_logfile tmp/xtrabackup_logfile-incremental-20200130-000001.1580338801.before [root@db06 database]# mariabackup --prepare --apply-log-only --target-dir=/var/database/base_xtrabackup/ --incremental-dir=/var/database/incremental_xtrabackup/incremental-20200130-000001.1580338801 mariabackup based on MariaDB server 10.1.29-MariaDB Linux (x86_64) incremental backup from 1882765822220 is enabled. mariabackup: cd to /var/database/base_xtrabackup/ mariabackup: This target seems to be already prepared with --apply-log-only. mariabackup: notice: xtrabackup_logfile was already used to '--prepare'. mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = /var/database/incremental_xtrabackup/incremental-20200130-000001.1580338801/ mariabackup: innodb_log_files_in_group = 2 mariabackup: innodb_log_file_size = 50331648 mariabackup: Generating a list of tablespaces mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = /var/database/incremental_xtrabackup/incremental-20200130-000001.1580338801/ mariabackup: innodb_log_files_in_group = 2 mariabackup: innodb_log_file_size = 50331648 mariabackup: Starting InnoDB instance for recovery. mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: The InnoDB memory heap is disabled 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: Using SSE crc32 instructions 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: Initializing buffer pool, size = 100.0M 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: Completed initialization of buffer pool 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: Highest supported file format is Barracuda. 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: The log sequence number 1882775324256 in ibdata file do not match the log sequence number 1882775324684 in the ib_logfiles! 2020-04-07 16:14:16 140705072347392 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer... mariabackup: error: The transaction log file is corrupted. mariabackup: error: The log was not applied to the intended LSN! mariabackup: Log applied to lsn 1882775324684 mariabackup: The intended lsn is 1883704452664 [root@db06 database]# cp incremental_xtrabackup/incremental-20200130-000001.1580338801/xtrabackup_logfile tmp/xtrabackup_logfile xtrabackup_logfile xtrabackup_logfile-after-prepare xtrabackup_logfile-incremental-20200130-000001.1580338801.before [root@db06 database]# cp incremental_xtrabackup/incremental-20200130-000001.1580338801/xtrabackup_logfile tmp/xtrabackup_logfile-incremental-20200130-000001.1580338801.after [root@db06 database]# cp tmp/xtrabackup_logfile-incremental-20200130-000001.1580338801.before incremental_xtrabackup/incremental-20200130-000001.1580338801/xtrabackup_logfile cp: skriva över ”incremental_xtrabackup/incremental-20200130-000001.1580338801/xtrabackup_logfile”? y [root@db06 database]# mariabackup --prepare --apply-log-only --target-dir=/var/database/base_xtrabackup/ --incremental-dir=/var/database/incremental_xtrabackup/incremental-20200130-000001.1580338801 mariabackup based on MariaDB server 10.1.29-MariaDB Linux (x86_64) incremental backup from 1882765822220 is enabled. mariabackup: cd to /var/database/base_xtrabackup/ mariabackup: This target seems to be already prepared with --apply-log-only. mariabackup: notice: xtrabackup_logfile was already used to '--prepare'. mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = /var/database/incremental_xtrabackup/incremental-20200130-000001.1580338801/ mariabackup: innodb_log_files_in_group = 2 mariabackup: innodb_log_file_size = 50331648 mariabackup: Generating a list of tablespaces mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = /var/database/incremental_xtrabackup/incremental-20200130-000001.1580338801/ mariabackup: innodb_log_files_in_group = 2 mariabackup: innodb_log_file_size = 50331648 mariabackup: Starting InnoDB instance for recovery. mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: The InnoDB memory heap is disabled 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: Using SSE crc32 instructions 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: Initializing buffer pool, size = 100.0M 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: Completed initialization of buffer pool 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: Highest supported file format is Barracuda. 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: The log sequence number 1882775324256 in ibdata file do not match the log sequence number 1882775324684 in the ib_logfiles! 2020-04-07 16:14:47 140138637261056 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer... mariabackup: error: The transaction log file is corrupted. mariabackup: error: The log was not applied to the intended LSN! mariabackup: Log applied to lsn 1882775324684 mariabackup: The intended lsn is 1883704452664 [root@db06 database]# yum list installed|grep -i Mariadb MariaDB-backup.x86_64 10.1.29-1.el7.centos @MariaDB MariaDB-client.x86_64 10.1.29-1.el7.centos @MariaDB MariaDB-common.x86_64 10.1.29-1.el7.centos @MariaDB MariaDB-server.x86_64 10.1.29-1.el7.centos @MariaDB MariaDB-shared.x86_64 10.1.29-1.el7.centos @MariaDB galera.x86_64 25.3.22-1.rhel7.el7.centos @MariaDB jemalloc.x86_64 3.6.0-1.el7 @MariaDB