search

ShahriyarR / MySQL-AutoXtraBackup

MySQL-AutoXtraBackup commandline tool written in Python 3 based on Percona XtraBackup
https://autoxtrabackup.azepug.az/
MIT License
140 stars 79 forks source link

Add Binlog Encryption options as part of --test_mode #250

Closed ShahriyarR closed 6 years ago

ShahriyarR commented 6 years ago

The needed options are:

--encrypt_binlog=ON --master_verify_checksum=ON --binlog_checksum=CRC32
ShahriyarR commented 6 years ago

Added and could started master and slave servers as:

$ ps aux | grep mysqld
polkitd   2708  0.0  0.1 711400 61168 ?        Sl    2017  23:55 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
shahriy+ 12841  0.3  1.3 3372948 448700 pts/1  Sl   12:07   0:05 /home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/bin/mysqld --no-defaults --secure-file-priv= --tmpdir=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/node1 --datadir=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/node1 --socket=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/sock1.sock --port=57643 --log-error=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/log/node1 --innodb_buffer_pool_size=1G --innodb_log_file_size=1G --innodb_page_size=16K --early-plugin-load=keyring_file.so --keyring_file_data=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/mysql-keyring/keyring --log-bin=mysql-bin --log-slave-updates --server-id=1 --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --encrypt_binlog=ON --master_verify_checksum=ON --binlog_checksum=CRC32 --server_id=2141 --core-file --basedir=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --plugin-load-add=rocksdb=ha_rocksdb.so
shahriy+ 13050  0.0  0.0 112648   964 pts/3    S+   12:33   0:00 grep --color=auto mysqld
shahriy+ 23107 28.2  1.9 3542440 652272 pts/1  Sl   11:58   9:39 /home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/bin/mysqld --no-defaults --core-file --basedir=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug --tmpdir=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/data --datadir=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/data --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --plugin-load-add=rocksdb=ha_rocksdb.so --socket=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/socket.sock --port=12973 --log-error=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/log/master.err --server-id=100 --innodb_buffer_pool_size=1G --innodb_log_file_size=1G --innodb_page_size=16K --early-plugin-load=keyring_file.so --keyring_file_data=/home/shahriyar.rzaev/XB_TEST/server_dir/PS010118-5.7.20-18-linux-x86_64-debug/mysql-keyring/keyring --log-bin=mysql-bin --log-slave-updates --server-id=1 --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --encrypt_binlog=ON --master_verify_checksum=ON --binlog_checksum=CRC32