Skip to content
This repository has been archived by the owner on May 9, 2023. It is now read-only.

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

Closed
ShahriyarR opened this issue Dec 31, 2017 · 1 comment
Closed

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

ShahriyarR opened this issue Dec 31, 2017 · 1 comment
Labels
enhancement

Comments

@ShahriyarR
Copy link
Owner

The needed options are:

--encrypt_binlog=ON --master_verify_checksum=ON --binlog_checksum=CRC32
ShahriyarR added a commit that referenced this issue Jan 1, 2018
@ShahriyarR
Preliminary fix for issue #250
5adc635
@ShahriyarR
Copy link
Owner Author

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

@ShahriyarR ShahriyarR mentioned this issue Jan 1, 2018
Merged
ShahriyarR pushed a commit that referenced this issue Jan 1, 2018
Bugfix issue250 (#251)
dbc7e59 
* Preliminary fix for issue #250

* Added rename basedirs bats file
ShahriyarR pushed a commit that referenced this issue Apr 24, 2018
Release v1.5.2 (#274)
8ae7927 
* Bugfix issue240 (#241)

* Preliminary fix for issue #240

* Disable header check for TestConf as it must not affect overall usage the tool

* Added check for [TestConf] header as well

* Finalizing the issue fix

* Adding --lock-ddl-per-table and --lock-ddl support (#244)

* Preliminary fix for issue #243

* Calling for first test

* Added some logging message

* Redirecting the output to /dev/null

* Adding x permission

* Running the new sql commands

* Trying to run this ddl_test.sh bash script

* Using full string

* making some changes

* fixing redirect issue

* unpexteced toke done

* Changed workflow

* Added u+x

* calling it without bash command

* fixing bash caller

* fixing the path name

* calling with /usr/bin/bash

* Removed sleep statement

* getting output from sqls

* trying to fix issue again

* trying to make cleanup actions

* changing the try/except block position

* chenged workflow again

* Disabling sysbench run

* Disabled this feature

* Bugfix issue246 (#247)

* Preliminary fix for issue #246

* Added options to config generator for --test_mode

* Fixing directory naming

* implicit conversion

* Calling shutil.copytree here

* Adding '_archive' string

* copying backup_dir

* Finalizing the feature implementation

* Bugfix issue245 (#249)

* Preliminary fix for issue #245

* Executing loop in concurrent.futures

* Changing static method to use Popen

* Reducing worker count

* Increasing worker max count to 5000

* Changed back the value to 1000

* Reducing max worker count to 100

* Calling from ordinary loop

* Implemented, finalizing the feature

* Bugfix issue250 (#251)

* Preliminary fix for issue #250

* Added rename basedirs bats file

* Preliminary fix for issue #252 (#253)

* Preliminary fix for issue #254 (#255)

* Bugfix issue260 (#261)

* Checking if archive is directory or not

* Giving the full path

* Bugfix issue264 (#265)

* Preliminary fix for issue #264

* Decrypting some tables to be altered to unencrypted general tablespace file

* Disabled converting tables to myisam

* Bugfix issue262 (#266)

* Preliminary fix for issue #262

* Unexpected argument error

* Preliminary fix for issue #263 (#267)

* Bugfix issue268 (#270)

* Added 2 temporary table creation for issue #268

* Fixing typo

* Added some bash files and removed previous calls

* Calling the staticmethod

* Fixing the table name

* Fixing the sql

* Added file permissions

* Added create index run for creating temporary tables

* Fixing the database name

* again fix for database name

* Disabled sleep query runs also added some kill process calls

* Bugfix issue271 (#273)

* Preliminary fix for issue #271:
Added several optional bash files to be executed.
Called it from take_backup.py

* Removing drop statement

* Added kill statements

* VERSION BUMP

* Bugfix issue275 (#276)

* Parsing config properly.
Added keyring_vault cmd option to pass.
For issue #275

* Fixing the .sql extension files to be in package_data

* changed a bit flow

* Enabling back the general tablespace encryption

* UnboundLocalError: local variable 'pid' referenced before assignment

* Redirecting the output
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ShahriyarR