Initialize and start MS 8.0.20 with encryption options
./all_no_cl --log-bin=binlog --early-plugin-load=keyring_file.so --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --innodb-undo-log-encrypt --innodb-redo-log-encrypt --default-table-encryption=ON --log-slave-updates --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --master_verify_checksum=ON --binlog_checksum=CRC32 --binlog-rotate-encryption-master-key-at-startup --table-encryption-privilege-check=ON --binlog-encryption
Create 10 encrypted tables using sysbench
Take full backup
/home/mchawla/pxb_8_0_12_debug/bin/xtrabackup --user=root --password= --backup --target-dir=/home/mchawla/dbbackup_18_05_2020/full -S /home/mchawla/MS_8_0_20/socket.sock --datadir=/home/mchawla/MS_8_0_20/data --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_12_debug/bin/../lib/plugin --generate-transition-key
Run a sysbench load
sysbench /usr/share/sysbench/oltp_insert.lua --tables=10 --mysql-db=test --mysql-user=root --threads=50 --db-driver=mysql --mysql-socket=/home/mchawla/MS_8_0_20/socket.sock --time=30 run
Take incremental backup
/home/mchawla/pxb_8_0_12_debug/bin/xtrabackup --user=root --password= --backup --target-dir=/home/mchawla/dbbackup_18_05_2020/inc --incremental-basedir=/home/mchawla/dbbackup_18_05_2020/full -S /home/mchawla/MS_8_0_20/socket.sock --datadir=/home/mchawla/MS_8_0_20/data --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_12_debug/bin/../lib/plugin --generate-transition-key
Prepare full backup
/home/mchawla/pxb_8_0_12_debug/bin/xtrabackup --user=root --password= --prepare --apply-log-only --target_dir=/home/mchawla/dbbackup_18_05_2020/full --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_12_debug/bin/../lib/plugin --generate-transition-key
PXB displays error at the end
2020-05-18T10:39:51.551383Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.
Prepare incremental backup
/home/mchawla/pxb_8_0_12_debug/bin/xtrabackup --user=root --password= --prepare --target_dir=/home/mchawla/dbbackup_18_05_2020/full --incremental-dir=/home/mchawla/dbbackup_18_05_2020/inc --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_12_debug/bin/../lib/plugin --generate-transition-key
2020-05-18T10:40:14.222389Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.
Logs are attached.
Initialize and start MS 8.0.20 with encryption options
./all_no_cl --log-bin=binlog --early-plugin-load=keyring_file.so --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --innodb-undo-log-encrypt --innodb-redo-log-encrypt --default-table-encryption=ON --log-slave-updates --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --master_verify_checksum=ON --binlog_checksum=CRC32 --binlog-rotate-encryption-master-key-at-startup --table-encryption-privilege-check=ON --binlog-encryptionCreate 10 encrypted tables using sysbench
Take full backup
/home/mchawla/pxb_8_0_12_debug/bin/xtrabackup --user=root --password= --backup --target-dir=/home/mchawla/dbbackup_18_05_2020/full -S /home/mchawla/MS_8_0_20/socket.sock --datadir=/home/mchawla/MS_8_0_20/data --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_12_debug/bin/../lib/plugin --generate-transition-keyRun a sysbench load
sysbench /usr/share/sysbench/oltp_insert.lua --tables=10 --mysql-db=test --mysql-user=root --threads=50 --db-driver=mysql --mysql-socket=/home/mchawla/MS_8_0_20/socket.sock --time=30 runTake incremental backup
/home/mchawla/pxb_8_0_12_debug/bin/xtrabackup --user=root --password= --backup --target-dir=/home/mchawla/dbbackup_18_05_2020/inc --incremental-basedir=/home/mchawla/dbbackup_18_05_2020/full -S /home/mchawla/MS_8_0_20/socket.sock --datadir=/home/mchawla/MS_8_0_20/data --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_12_debug/bin/../lib/plugin --generate-transition-keyPrepare full backup
/home/mchawla/pxb_8_0_12_debug/bin/xtrabackup --user=root --password= --prepare --apply-log-only --target_dir=/home/mchawla/dbbackup_18_05_2020/full --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_12_debug/bin/../lib/plugin --generate-transition-keyPXB displays error at the end
2020-05-18T10:39:51.551383Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.Prepare incremental backup
/home/mchawla/pxb_8_0_12_debug/bin/xtrabackup --user=root --password= --prepare --target_dir=/home/mchawla/dbbackup_18_05_2020/full --incremental-dir=/home/mchawla/dbbackup_18_05_2020/inc --keyring_file_data=/home/mchawla/MS_8_0_20/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_12_debug/bin/../lib/plugin --generate-transition-keyPXB displays error at the end
2020-05-18T10:40:14.222389Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.Logs are attached.