| 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; |