PXB Lifecycle

Install

sudo yum install percona-xtrabackup-80

For xtrabackup 2.4 use this...

This version of xtrabackup has a dependency on libdev (available from the EPEL repository)

sudo yum install percona-xtrabackup-24

percona-xtrabackup-80 has the following dependencies... 
  • libdev
  • mariadb-connector-c
  • perl-DBD-MySQL
  • perl-DBI
  • perl-Data-Dumper
  • perl-Digest
  • perl-Digest-MD5
  • perl-Math-BigInt
  • perl-Math-Complex
  • rsync

Create Database User

For 8.0 and above...

CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY RANDOM PASSWORD;

NOTE: Remember to store the password in your secure backup store.

For earlier versions...

CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 'MyC0mp!expA55wRd';

NOTE: Remember to store the password in your secure backup store.

GRANT RELOAD ON *.* TO 'bkpuser'@'localhost';

GRANT LOCK TABLES ON *.* TO 'bkpuser'@'localhost';

GRANT REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';

GRANT CREATE TABLESPACE ON *.* TO 'bkpuser'@'localhost';

GRANT PROCESS ON *.* TO 'bkpuser'@'localhost';

GRANT SUPER ON *.* TO 'bkpuser'@'localhost';

GRANT CREATE ON *.* TO 'bkpuser'@'localhost';

GRANT ALTER ON *.* TO 'bkpuser'@'localhost';

GRANT INSERT ON *.* TO 'bkpuser'@'localhost';

GRANT SELECT ON *.* TO 'bkpuser'@'localhost';

For 8.0 and above, also include...

GRANT BACKUP_ADMIN ON *.* TO 'bkpuser'@'localhost';

GRANT SELECT ON performance_schema.log_status TO 'bkpuser'@'localhost';

GRANT SELECT ON performance_schema.keyring_component_status TO bkpuser@'localhost';

GRANT SELECT ON performance_schema.replication_group_members TO bkpuser@'localhost';

FLUSH PRIVILEGES;

Bibliography