Debian Codegraph @

mysql-test/suite/ndb/t/ndb_redo_log_reader.test

raw
1 source include/have_ndb.inc;
2
3 # Check there is no --filesystem-password* option for node 2, will happen when
4 # running for example ./mtr --defaults-extra-file=suite/ndb/secure.cnf
5 let $find_defaults_option=filesystem-password.*;
6 let $find_defaults_value=.*;
7 let $find_defaults_groups=mysql_cluster ndbd;
8 let $find_defaults_group_suffix=.2;
9 source include/find_defaults.inc;
10 if ($find_defaults_status == 0) {
11 skip TDE is on for node 2;
12 }
13
14 exec $NDB_CONFIG --nodes --type=DB --query=NodeId,EncryptedFileSystem,InitFragmentLogFiles;
15
16 let $NDB_REDO_LOG_FILE1=$MYSQLTEST_VARDIR/mysql_cluster.1/ndbd.1/ndb_1_fs/D8/DBLQH/S0.FragLog;
17 let $NDB_REDO_LOG_FILE2=$MYSQLTEST_VARDIR/mysql_cluster.1/ndbd.2/ndb_2_fs/D8/DBLQH/S0.FragLog;
18 let $NDB_REDO_LOG_FILE3=$MYSQLTEST_VARDIR/mysql_cluster.1/ndbd.3/ndb_3_fs/D8/DBLQH/S0.FragLog;
19 let $NDB_REDO_LOG_FILE4=$MYSQLTEST_VARDIR/mysql_cluster.1/ndbd.4/ndb_4_fs/D8/DBLQH/S0.FragLog;
20
21 error 1;
22 exec $NDB_REDO_LOG_READER > $NDB_TOOLS_OUTPUT;
23 exec $NDB_REDO_LOG_READER --help >> $NDB_TOOLS_OUTPUT;
24
25 # ndb_redo_log_reader should not be used on active fragment log files.
26 # Stop data node before reading the fragment log files.
27
28 echo # Node 1 uses InitFragmentLogFiles=full;
29 exec $NDB_MGM -e "1 RESTART -n";
30 echo # NDB_REDO_LOG_READER ndb_1_fs/D8/DBLQH/S0.FragLog -lap;
31 exec $NDB_REDO_LOG_READER $NDB_REDO_LOG_FILE1 -lap 2>&1 >> $NDB_TOOLS_OUTPUT;
32 echo # NDB_REDO_LOG_READER ndb_1_fs/D8/DBLQH/S0.FragLog -mbyte 2;
33 exec $NDB_REDO_LOG_READER $NDB_REDO_LOG_FILE1 -mbyte 2 2>&1 >> $NDB_TOOLS_OUTPUT;
34 exec $NDB_MGM -e "1 START";
35 exec $NDB_WAITER;
36
37 echo # Node 2 uses InitFragmentLogFiles=sparse;
38 exec $NDB_MGM -e "2 RESTART -n";
39 echo # NDB_REDO_LOG_READER --lap ndb_2_fs/D8/DBLQH/S0.FragLog;
40 exec $NDB_REDO_LOG_READER --lap $NDB_REDO_LOG_FILE2 >> $NDB_TOOLS_OUTPUT;
41 echo # NDB_REDO_LOG_READER --mbyte=2 ndb_2_fs/D8/DBLQH/S0.FragLog;
42 exec $NDB_REDO_LOG_READER --mbyte=2 $NDB_REDO_LOG_FILE2 >> $NDB_TOOLS_OUTPUT;
43 exec $NDB_MGM -e "2 START";
44 exec $NDB_WAITER;
45
46 echo # Node 3 uses InitFragmentLogFiles=full and EncryptedFileSystem=1;
47 let $secret_key3=$MYSQL_TMP_DIR/secret3.key;
48 exec $NDB_SECRETSFILE_READER
49 $MYSQLTEST_VARDIR/mysql_cluster.1/ndbd.3/ndb_3_fs/D1/NDBCNTR/S0.sysfile
50 > $secret_key3;
51 let $DECRYPTED_FILE3=$MYSQL_TMP_DIR/S0.FragLog-decrypted3;
52
53 exec $NDB_MGM -e "3 RESTART -n";
54 echo # NDBXFRM --decrypt-key-from-stdin NDB_REDO_LOG_FILE3 DECRYPTED_FILE3;
55 exec $NDBXFRM --decrypt-key-from-stdin < $secret_key3 $NDB_REDO_LOG_FILE3 $DECRYPTED_FILE3;
56 echo # NDB_REDO_LOG_READER --file-key-from-stdin NDB_REDO_LOG_FILE3 -lap;
57 exec $NDB_REDO_LOG_READER --file-key-from-stdin < $secret_key3
58 $NDB_REDO_LOG_FILE3 -lap 2>&1 >> $NDB_TOOLS_OUTPUT;
59 echo # NDB_REDO_LOG_READER --file-key-from-stdin NDB_REDO_LOG_FILE3 -mbyte 2;
60 exec $NDB_REDO_LOG_READER --file-key-from-stdin < $secret_key3
61 $NDB_REDO_LOG_FILE3 -mbyte 2 2>&1 >> $NDB_TOOLS_OUTPUT;
62 exec $NDB_REDO_LOG_READER --file-key-from-stdin < $secret_key3
63 $NDB_REDO_LOG_FILE3 >> $NDB_TOOLS_OUTPUT;
64 exec $NDB_MGM -e "3 START";
65 exec $NDB_WAITER;
66
67 echo # Node 4 uses InitFragmentLogFiles=sparse and EncryptedFileSystem=1;
68 let $secret_key4=$MYSQL_TMP_DIR/secret4.key;
69 exec $NDB_SECRETSFILE_READER
70 $MYSQLTEST_VARDIR/mysql_cluster.1/ndbd.4/ndb_4_fs/D1/NDBCNTR/S0.sysfile
71 > $secret_key4;
72 let $DECRYPTED_FILE4=$MYSQL_TMP_DIR/S0.FragLog-decrypted4;
73
74 echo # NDBXFRM --decrypt-key-from-stdin NDB_REDO_LOG_FILE4 DECRYPTED_FILE4;
75 exec $NDB_MGM -e "4 RESTART -n";
76 exec $NDBXFRM --decrypt-key-from-stdin < $secret_key4 $NDB_REDO_LOG_FILE4 $DECRYPTED_FILE4;
77 echo # NDB_REDO_LOG_READER --file-key-from-stdin --lap NDB_REDO_LOG_FILE4;
78 exec $NDB_REDO_LOG_READER --lap --file-key-from-stdin < $secret_key4
79 $NDB_REDO_LOG_FILE4 >> $NDB_TOOLS_OUTPUT;
80 echo # NDB_REDO_LOG_READER --file-key-from-stdin --mbyte=2 NDB_REDO_LOG_FILE4;
81 exec $NDB_REDO_LOG_READER --mbyte=2 --file-key-from-stdin < $secret_key4
82 $NDB_REDO_LOG_FILE4 >> $NDB_TOOLS_OUTPUT;
83 exec $NDB_REDO_LOG_READER --file-key-from-stdin < $secret_key4
84 $NDB_REDO_LOG_FILE4 >> $NDB_TOOLS_OUTPUT;
85 exec $NDB_MGM -e "4 START";
86 exec $NDB_WAITER;
87
88 remove_file $DECRYPTED_FILE3;
89 remove_file $DECRYPTED_FILE4;
90 remove_file $secret_key3;
91 remove_file $secret_key4;
92 remove_file $NDB_TOOLS_OUTPUT;