Debian Codegraph @

mysql-test/suite/binlog_encryption/encrypted_slave.test

raw
1 #
2 # The test checks that basic DDL and DML events are encrypted
3 # in the relay and binary logs on slave.
4 # The test is to be run with all binlog formats
5 # (combinations for rpl_init.inc take care of that).
6 #
7 # The test runs with the non-encrypted master and encrypted slave.
8 # It generates a sequence of events on master and checks that
9 # relay logs and binary logs are encrypted on slave.
10 #
11
12 --source include/have_partition.inc
13 --source encryption_algorithms.inc
14 --source include/have_innodb.inc
15
16 --echo #################
17 --echo # Initialization
18 --echo #################
19
20 --let $rpl_topology= 1->2
21 --source include/rpl_init.inc
22
23 --enable_connect_log
24 --connection server_2
25
26 # We stop SQL thread because we want to have
27 # all relay logs at the end of the test flow
28
29 --disable_connect_log
30 --source include/stop_slave_sql.inc
31 --enable_connect_log
32
33 --echo #################
34 --echo # Test flow
35 --echo #################
36
37 --connection server_1
38 --source testdata.inc
39
40 --echo #################
41 --echo # Master binlog checks
42 --echo #################
43
44 --let $master_datadir= `SELECT @@datadir`
45
46 --let SEARCH_RANGE = 500000
47 --let SEARCH_FILE= $master_datadir/master-bin.0*
48 --let SEARCH_PATTERN= _to_encrypt.*
49 --source include/search_pattern_in_file.inc
50
51 --let SEARCH_FILE= $master_datadir/master-bin.0*
52 --let SEARCH_PATTERN= COMMIT.*
53 --source include/search_pattern_in_file.inc
54
55 --let SEARCH_FILE= $master_datadir/master-bin.0*
56 --let SEARCH_PATTERN= TIMESTAMP.*
57 --source include/search_pattern_in_file.inc
58
59 --disable_connect_log
60 --source include/save_master_pos.inc
61 --enable_connect_log
62
63 --echo #################
64 --echo # Relay log checks
65 --echo #################
66
67 --connection server_2
68 --disable_connect_log
69 --source include/sync_io_with_master.inc
70 --enable_connect_log
71
72 --let $slave_datadir= `SELECT @@datadir`
73
74 --let SEARCH_FILE= $slave_datadir/slave-relay-bin.0*
75 --let SEARCH_PATTERN= _to_encrypt
76 --source include/search_pattern_in_file.inc
77
78 --let SEARCH_FILE= $slave_datadir/slave-relay-bin.0*
79 --let SEARCH_PATTERN= COMMIT
80 --source include/search_pattern_in_file.inc
81
82 --let SEARCH_FILE= $slave_datadir/slave-relay-bin.0*
83 --let SEARCH_PATTERN= TIMESTAMP
84 --source include/search_pattern_in_file.inc
85
86 --echo #################
87 --echo # Slave binlog checks
88 --echo #################
89
90 # Re-enable SQL thread, let it catch up with IO thread
91 # and check slave binary logs
92
93 --disable_connect_log
94 --source include/start_slave.inc
95 --source include/sync_slave_sql_with_io.inc
96 --enable_connect_log
97
98 --disable_connect_log
99 --source include/sync_io_with_master.inc
100 --enable_connect_log
101
102 --let SEARCH_FILE= $slave_datadir/slave-bin.0*
103 --let SEARCH_PATTERN= _to_encrypt
104 --source include/search_pattern_in_file.inc
105
106 --let SEARCH_FILE= $slave_datadir/slave-bin.0*
107 --let SEARCH_PATTERN= COMMIT
108 --source include/search_pattern_in_file.inc
109
110 --let SEARCH_FILE= $slave_datadir/slave-bin.0*
111 --let SEARCH_PATTERN= TIMESTAMP
112 --source include/search_pattern_in_file.inc
113
114 --echo ##########
115 --echo # Cleanup
116 --echo ##########
117
118 --disable_connect_log
119 --source include/rpl_end.inc