Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.217.163.75
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
innodb /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
add_foreign_key.test
1.35
KB
-rw-r--r--
alter_crash.test
6.71
KB
-rw-r--r--
alter_foreign_crash.test
956
B
-rw-r--r--
alter_kill-master.opt
68
B
-rw-r--r--
alter_kill.test
5.1
KB
-rw-r--r--
alter_missing_tablespace.test
3.05
KB
-rw-r--r--
alter_page_size.test
705
B
-rw-r--r--
alter_rename_existing.test
5.49
KB
-rw-r--r--
alter_rename_files.test
746
B
-rw-r--r--
alter_row_format.test
1.47
KB
-rw-r--r--
alter_table_redundant.test
481
B
-rw-r--r--
alter_table_stage_progress-mas...
53
B
-rw-r--r--
alter_table_stage_progress.tes...
1.04
KB
-rw-r--r--
analyze_index.test
994
B
-rw-r--r--
analyze_table.test
896
B
-rw-r--r--
attachable_trx.test
3.32
KB
-rw-r--r--
autoinc_debug.test
2.14
KB
-rw-r--r--
blob-crash-16k.test
2.66
KB
-rw-r--r--
blob-crash-4k.test
2.76
KB
-rw-r--r--
blob-crash.test
5.95
KB
-rw-r--r--
blob-update-debug.test
525
B
-rw-r--r--
blob_page_reserve.test
3.73
KB
-rw-r--r--
blob_redo-master.opt
57
B
-rw-r--r--
blob_redo.test
1.71
KB
-rw-r--r--
buf_pool_resize_oom-master.opt
37
B
-rw-r--r--
buf_pool_resize_oom.test
1.72
KB
-rw-r--r--
bulk_create_index_online.test
1.96
KB
-rw-r--r--
cascade_lock_wait.test
1014
B
-rw-r--r--
check_ibd_filesize_16k.test
1.89
KB
-rw-r--r--
check_sector_size-master.opt
125
B
-rw-r--r--
check_sector_size.test
1.95
KB
-rw-r--r--
checksum.test
681
B
-rw-r--r--
cmp_per_index-master.opt
63
B
-rw-r--r--
cmp_per_index.test
2.5
KB
-rw-r--r--
crc32_endianness.test
1.67
KB
-rw-r--r--
crc32_endianness.zip
1.86
KB
-rw-r--r--
create-index.test
314
B
-rw-r--r--
create_isl_with_direct-master....
31
B
-rw-r--r--
create_isl_with_direct.test
1.1
KB
-rw-r--r--
create_table.test
1.33
KB
-rw-r--r--
create_tablespace.test
36.63
KB
-rw-r--r--
create_tablespace_16k.test
26.23
KB
-rw-r--r--
create_tablespace_32k.test
3.97
KB
-rw-r--r--
create_tablespace_4k.test
14.72
KB
-rw-r--r--
create_tablespace_64k.test
4.12
KB
-rw-r--r--
create_tablespace_8k.test
19.2
KB
-rw-r--r--
create_tablespace_debug.test
3.97
KB
-rw-r--r--
create_tablespace_notembedded....
670
B
-rw-r--r--
create_tablespace_partition.te...
10.38
KB
-rw-r--r--
create_tablespace_replication....
1.76
KB
-rw-r--r--
deadlock_detect.test
921
B
-rw-r--r--
default_row_format.test
1.62
KB
-rw-r--r--
default_row_format_16k.test
9.49
KB
-rw-r--r--
default_row_format_compatibili...
5.75
KB
-rw-r--r--
default_row_format_tablespace....
1.16
KB
-rw-r--r--
deprecate_part_in_shared_ts.te...
4.38
KB
-rw-r--r--
disabled.def
404
B
-rw-r--r--
doublewrite.test
10.88
KB
-rw-r--r--
dropdb.test
251
B
-rw-r--r--
end_range_check.test
3.2
KB
-rw-r--r--
end_range_check_2.test
1.25
KB
-rw-r--r--
events-merge-tmp-path-master.o...
149
B
-rw-r--r--
events-merge-tmp-path.test
1.65
KB
-rw-r--r--
file_format_defaults-master.op...
122
B
-rw-r--r--
file_format_defaults.test
2.14
KB
-rw-r--r--
file_format_upgrade_16k.test
1.91
KB
-rw-r--r--
flush-hang.test
1.51
KB
-rw-r--r--
foreign_key.test
7.61
KB
-rw-r--r--
fts_exec_interrupt.test
961
B
-rw-r--r--
help_verbose.test
1.01
KB
-rw-r--r--
high_prio_trx_1.test
1.24
KB
-rw-r--r--
high_prio_trx_2.test
1.3
KB
-rw-r--r--
high_prio_trx_3.test
1.86
KB
-rw-r--r--
high_prio_trx_4.test
1.5
KB
-rw-r--r--
high_prio_trx_5.test
2.24
KB
-rw-r--r--
high_prio_trx_6.test
2
KB
-rw-r--r--
high_prio_trx_7.test
11.13
KB
-rw-r--r--
high_prio_trx_commit_crash.tes...
2.05
KB
-rw-r--r--
high_prio_trx_debug.test
1.6
KB
-rw-r--r--
high_prio_trx_fk.test
1.42
KB
-rw-r--r--
high_prio_trx_predicate.test
1.41
KB
-rw-r--r--
high_prio_trx_rpl.test
1.95
KB
-rw-r--r--
i_s_files_debug.test
751
B
-rw-r--r--
ibuf_not_empty-master.opt
30
B
-rw-r--r--
ibuf_not_empty.test
1.67
KB
-rw-r--r--
import.test
763
B
-rw-r--r--
import_compress_encrypt.test
6.84
KB
-rw-r--r--
import_compress_encrypt_upgrad...
2.46
KB
-rw-r--r--
import_export_4k.test
1.06
KB
-rw-r--r--
import_tablespace_page_corrupt...
1.2
KB
-rw-r--r--
import_tablespace_schema_missm...
3.56
KB
-rw-r--r--
import_update_stats.test
1.46
KB
-rw-r--r--
index-online-norebuild.test
1.8
KB
-rw-r--r--
index_length.test
1.28
KB
-rw-r--r--
index_merge_threshold.test
6.25
KB
-rw-r--r--
index_tree_operation.test
2.36
KB
-rw-r--r--
innodb-2byte-collation-master....
48
B
-rw-r--r--
innodb-2byte-collation.test
2.95
KB
-rw-r--r--
innodb-ac-non-locking-select.t...
3
KB
-rw-r--r--
innodb-alter-autoinc.test
2.53
KB
-rw-r--r--
innodb-alter-debug-wl6554-mast...
21
B
-rw-r--r--
innodb-alter-debug-wl6554.test
8.65
KB
-rw-r--r--
innodb-alter-debug.test
2.68
KB
-rw-r--r--
innodb-alter-nullable.test
1.93
KB
-rw-r--r--
innodb-alter-wl6554.test
2.26
KB
-rw-r--r--
innodb-alter.test
15.61
KB
-rw-r--r--
innodb-analyze.test
1.65
KB
-rw-r--r--
innodb-autoinc-18274.test
661
B
-rw-r--r--
innodb-autoinc-44030-master.op...
81
B
-rw-r--r--
innodb-autoinc-44030.test
1.61
KB
-rw-r--r--
innodb-autoinc-56228-master.op...
29
B
-rw-r--r--
innodb-autoinc-56228.test
784
B
-rw-r--r--
innodb-autoinc-master.opt
81
B
-rw-r--r--
innodb-autoinc-optimize.test
432
B
-rw-r--r--
innodb-autoinc.test
26.79
KB
-rw-r--r--
innodb-blob.test
6.62
KB
-rw-r--r--
innodb-bug-14068765.test
2.97
KB
-rw-r--r--
innodb-bug-14084530.test
966
B
-rw-r--r--
innodb-bug12552164.test
1.46
KB
-rw-r--r--
innodb-bug14219515.test
472
B
-rw-r--r--
innodb-change-buffer-recovery-...
92
B
-rw-r--r--
innodb-change-buffer-recovery....
2.3
KB
-rw-r--r--
innodb-consistent-master.opt
29
B
-rw-r--r--
innodb-consistent.test
1.24
KB
-rw-r--r--
innodb-import-partition-rpl.te...
3.46
KB
-rw-r--r--
innodb-import-partition.test
9.51
KB
-rw-r--r--
innodb-index-debug-master.opt
30
B
-rw-r--r--
innodb-index-debug.test
4.39
KB
-rw-r--r--
innodb-index-master.opt
30
B
-rw-r--r--
innodb-index-online-delete.tes...
1.06
KB
-rw-r--r--
innodb-index-online-fk.test
15.6
KB
-rw-r--r--
innodb-index-online-master.opt
127
B
-rw-r--r--
innodb-index-online-purge.test
2.07
KB
-rw-r--r--
innodb-index-online.test
13.83
KB
-rw-r--r--
innodb-index.test
33.48
KB
-rw-r--r--
innodb-index_ucs2.test
124
B
-rw-r--r--
innodb-isolation.test
11.03
KB
-rw-r--r--
innodb-large-prefix.test
1.13
KB
-rw-r--r--
innodb-lock-inherit-read_commi...
2.58
KB
-rw-r--r--
innodb-lock.test
4.86
KB
-rw-r--r--
innodb-master.opt
136
B
-rw-r--r--
innodb-multiple-tablespaces.te...
18.21
KB
-rw-r--r--
innodb-read-view.test
4.52
KB
-rw-r--r--
innodb-replace-debug.test
399
B
-rw-r--r--
innodb-semi-consistent-master....
29
B
-rw-r--r--
innodb-semi-consistent.test
1.83
KB
-rw-r--r--
innodb-status-output.test
2.86
KB
-rw-r--r--
innodb-system-table-view.test
5.99
KB
-rw-r--r--
innodb-table-online-master.opt
126
B
-rw-r--r--
innodb-table-online.test
11.63
KB
-rw-r--r--
innodb-timeout.test
3.63
KB
-rw-r--r--
innodb-truncate-debug.test
5.27
KB
-rw-r--r--
innodb-truncate.test
2.03
KB
-rw-r--r--
innodb-ucs2.test
11.43
KB
-rw-r--r--
innodb-update-insert.test
848
B
-rw-r--r--
innodb-wl5522-1.test
145
B
-rw-r--r--
innodb-wl5522-debug.test
31
KB
-rw-r--r--
innodb-wl5522.test
20.25
KB
-rw-r--r--
innodb-wl5980-alter.test
18.47
KB
-rw-r--r--
innodb-wl5980-debug.test
2.58
KB
-rw-r--r--
innodb-wl5980-discard.test
23.6
KB
-rw-r--r--
innodb-wl5980-linux-master.opt
28
B
-rw-r--r--
innodb-wl5980-linux.test
7.75
KB
-rw-r--r--
innodb-wl5980-windows-master.o...
28
B
-rw-r--r--
innodb-wl5980-windows.test
8.42
KB
-rw-r--r--
innodb-wl6045-1-master.opt
77
B
-rw-r--r--
innodb-wl6045-1.test
6.84
KB
-rw-r--r--
innodb-wl6045-linux.test
12.82
KB
-rw-r--r--
innodb-wl6445-1.test
21.96
KB
-rw-r--r--
innodb-wl6445-2.test
7.4
KB
-rw-r--r--
innodb-wl6445.test
2.3
KB
-rw-r--r--
innodb.test
79.88
KB
-rw-r--r--
innodb_32k.test
198
B
-rw-r--r--
innodb_64k-master.opt
29
B
-rw-r--r--
innodb_64k.test
663
B
-rw-r--r--
innodb_autoinc_lock_mode_zero-...
29
B
-rw-r--r--
innodb_autoinc_lock_mode_zero....
1.1
KB
-rw-r--r--
innodb_autoinc_reset.test
519
B
-rw-r--r--
innodb_buffer_pool_dump_pct.te...
4.74
KB
-rw-r--r--
innodb_buffer_pool_load-master...
30
B
-rw-r--r--
innodb_buffer_pool_load.test
7.62
KB
-rw-r--r--
innodb_buffer_pool_load_now-ma...
113
B
-rw-r--r--
innodb_buffer_pool_load_now.te...
5.88
KB
-rw-r--r--
innodb_buffer_pool_resize-mast...
29
B
-rw-r--r--
innodb_buffer_pool_resize.test
2.26
KB
-rw-r--r--
innodb_buffer_pool_resize_debu...
64
B
-rw-r--r--
innodb_buffer_pool_resize_debu...
7.37
KB
-rw-r--r--
innodb_buffer_pool_resize_with...
65
B
-rw-r--r--
innodb_buffer_pool_resize_with...
2.06
KB
-rw-r--r--
innodb_bug-13628249.test
2.26
KB
-rw-r--r--
innodb_bug11754376.test
406
B
-rw-r--r--
innodb_bug11766634-master.opt
16
B
-rw-r--r--
innodb_bug11766634.test
1.82
KB
-rw-r--r--
innodb_bug11789106.test
546
B
-rw-r--r--
innodb_bug11933790.test
928
B
-rw-r--r--
innodb_bug12400341-master.opt
75
B
-rw-r--r--
innodb_bug12400341.test
2.65
KB
-rw-r--r--
innodb_bug12429573.test
1.4
KB
-rw-r--r--
innodb_bug12661768.test
2.03
KB
-rw-r--r--
innodb_bug14006907.test
1.38
KB
-rw-r--r--
innodb_bug14007109.test
1.19
KB
-rw-r--r--
innodb_bug14007649.test
1.1
KB
-rw-r--r--
innodb_bug14147491-master.opt
103
B
-rw-r--r--
innodb_bug14147491.test
2.76
KB
-rw-r--r--
innodb_bug14169459.test
1.96
KB
-rw-r--r--
innodb_bug14676111.test
3.92
KB
-rw-r--r--
innodb_bug14704286.test
2.03
KB
-rw-r--r--
innodb_bug19164038-master.opt
30
B
-rw-r--r--
innodb_bug19164038.test
1.27
KB
-rw-r--r--
innodb_bug21704.test
1.66
KB
-rw-r--r--
innodb_bug30113362.test
6.65
KB
-rw-r--r--
innodb_bug30423.test
6.45
KB
-rw-r--r--
innodb_bug30594501-master.opt
31
B
-rw-r--r--
innodb_bug30594501.test
552
B
-rw-r--r--
innodb_bug30919-master.opt
29
B
-rw-r--r--
innodb_bug30919.test
2.31
KB
-rw-r--r--
innodb_bug31205266.test
1.56
KB
-rw-r--r--
innodb_bug34053.test
1.6
KB
-rw-r--r--
innodb_bug34300.test
881
B
-rw-r--r--
innodb_bug35220.test
416
B
-rw-r--r--
innodb_bug38231.test
1.64
KB
-rw-r--r--
innodb_bug39438-master.opt
26
B
-rw-r--r--
innodb_bug39438.test
2.19
KB
-rw-r--r--
innodb_bug40360.test
340
B
-rw-r--r--
innodb_bug40565.test
327
B
-rw-r--r--
innodb_bug41904.test
328
B
-rw-r--r--
innodb_bug42101-nonzero-master...
30
B
-rw-r--r--
innodb_bug42101-nonzero.test
653
B
-rw-r--r--
innodb_bug42101.test
577
B
-rw-r--r--
innodb_bug42419.test
2.19
KB
-rw-r--r--
innodb_bug44032.test
543
B
-rw-r--r--
innodb_bug44369.test
530
B
-rw-r--r--
innodb_bug44571.test
788
B
-rw-r--r--
innodb_bug45357.test
326
B
-rw-r--r--
innodb_bug46000.test
941
B
-rw-r--r--
innodb_bug46676.test
602
B
-rw-r--r--
innodb_bug47167-master.opt
16
B
-rw-r--r--
innodb_bug47167.test
1.41
KB
-rw-r--r--
innodb_bug47621.test
1.79
KB
-rw-r--r--
innodb_bug47622.test
1.58
KB
-rw-r--r--
innodb_bug47777.test
972
B
-rw-r--r--
innodb_bug48024.test
863
B
-rw-r--r--
innodb_bug49164.test
928
B
-rw-r--r--
innodb_bug51378.test
2.53
KB
-rw-r--r--
innodb_bug51920.test
988
B
-rw-r--r--
innodb_bug52199.test
210
B
-rw-r--r--
innodb_bug52663.test
1003
B
-rw-r--r--
innodb_bug53046.test
1.13
KB
-rw-r--r--
innodb_bug53290.test
840
B
-rw-r--r--
innodb_bug53592.test
2.6
KB
-rw-r--r--
innodb_bug53674-master.opt
65
B
-rw-r--r--
innodb_bug53674.test
259
B
-rw-r--r--
innodb_bug53756-master.opt
36
B
-rw-r--r--
innodb_bug53756.test
4.62
KB
-rw-r--r--
innodb_bug54044.test
606
B
-rw-r--r--
innodb_bug56143.test
74.27
KB
-rw-r--r--
innodb_bug56716.test
268
B
-rw-r--r--
innodb_bug56947.test
472
B
-rw-r--r--
innodb_bug57252.test
1.27
KB
-rw-r--r--
innodb_bug57255.test
889
B
-rw-r--r--
innodb_bug57904.test
908
B
-rw-r--r--
innodb_bug59307.test
633
B
-rw-r--r--
innodb_bug59410.test
926
B
-rw-r--r--
innodb_bug59641.test
1.17
KB
-rw-r--r--
innodb_bug59733.test
2
KB
-rw-r--r--
innodb_bug60049-master.opt
25
B
-rw-r--r--
innodb_bug60049.test
1.76
KB
-rw-r--r--
innodb_bug60196-master.opt
27
B
-rw-r--r--
innodb_bug60196.test
3.15
KB
-rw-r--r--
innodb_bug60229.test
1.34
KB
-rw-r--r--
innodb_bug70867.test
1.29
KB
-rw-r--r--
innodb_bulk_create_index.test
1.89
KB
-rw-r--r--
innodb_bulk_create_index_debug...
651
B
-rw-r--r--
innodb_bulk_create_index_flush...
1.34
KB
-rw-r--r--
innodb_bulk_create_index_repli...
4.66
KB
-rw-r--r--
innodb_bulk_create_index_small...
2.81
KB
-rw-r--r--
innodb_corrupt_bit.test
2.67
KB
-rw-r--r--
innodb_corrupt_readonly.test
1.34
KB
-rw-r--r--
innodb_ctype_ldml-master.opt
80
B
-rw-r--r--
innodb_ctype_ldml.test
15.36
KB
-rw-r--r--
innodb_deadlock_with_autoinc-m...
29
B
-rw-r--r--
innodb_deadlock_with_autoinc.t...
1.22
KB
-rw-r--r--
innodb_file_format-master.opt
16
B
-rw-r--r--
innodb_file_format.test
1.32
KB
-rw-r--r--
innodb_file_limit_check.test
829
B
-rw-r--r--
innodb_force_recovery.test
3.19
KB
-rw-r--r--
innodb_fts_limit_check.test
891
B
-rw-r--r--
innodb_i_s_innodb_locks.test
4.54
KB
-rw-r--r--
innodb_i_s_innodb_trx.test
2.36
KB
-rw-r--r--
innodb_information_schema_buff...
2.39
KB
-rw-r--r--
innodb_io_pf.test
398
B
-rw-r--r--
innodb_lock_wait_timeout_1-mas...
29
B
-rw-r--r--
innodb_lock_wait_timeout_1.tes...
8.06
KB
-rw-r--r--
innodb_misc1-master.opt
55
B
-rw-r--r--
innodb_misc1.test
31.97
KB
-rw-r--r--
innodb_multi_update.test
2.04
KB
-rw-r--r--
innodb_mysql-master.opt
82
B
-rw-r--r--
innodb_mysql.test
27.09
KB
-rw-r--r--
innodb_mysql_rbk-master.opt
60
B
-rw-r--r--
innodb_mysql_rbk.test
849
B
-rw-r--r--
innodb_notembedded.test
1.13
KB
-rw-r--r--
innodb_page_size_func.test
11.26
KB
-rw-r--r--
innodb_pagesize_max_recordsize...
17.3
KB
-rw-r--r--
innodb_prefix_index_check.test
1.25
KB
-rw-r--r--
innodb_prefix_index_restart_se...
3.51
KB
-rw-r--r--
innodb_rename_index.test
16.76
KB
-rw-r--r--
innodb_rename_index_err.test
2.01
KB
-rw-r--r--
innodb_replace.test
5.42
KB
-rw-r--r--
innodb_row_log_read.test
1.42
KB
-rw-r--r--
innodb_stats.test
1.89
KB
-rw-r--r--
innodb_stats_auto_recalc.test
1.76
KB
-rw-r--r--
innodb_stats_auto_recalc_ddl.t...
1.65
KB
-rw-r--r--
innodb_stats_auto_recalc_lots....
932
B
-rw-r--r--
innodb_stats_auto_recalc_on_no...
1.87
KB
-rw-r--r--
innodb_stats_create_on_corrupt...
1.32
KB
-rw-r--r--
innodb_stats_create_table.test
1.43
KB
-rw-r--r--
innodb_stats_del_mark-master.o...
40
B
-rw-r--r--
innodb_stats_del_mark.test
3.6
KB
-rw-r--r--
innodb_stats_drop_locked.test
1.41
KB
-rw-r--r--
innodb_stats_external_pages.te...
2.62
KB
-rw-r--r--
innodb_stats_fetch.test
2.13
KB
-rw-r--r--
innodb_stats_fetch_corrupted.t...
1.64
KB
-rw-r--r--
innodb_stats_fetch_nonexistent...
1.14
KB
-rw-r--r--
innodb_stats_flag_global_off-m...
28
B
-rw-r--r--
innodb_stats_flag_global_off.t...
324
B
-rw-r--r--
innodb_stats_flag_global_on-ma...
28
B
-rw-r--r--
innodb_stats_flag_global_on.te...
323
B
-rw-r--r--
innodb_stats_rename_table.test
1.25
KB
-rw-r--r--
innodb_stats_rename_table_if_e...
1.43
KB
-rw-r--r--
innodb_stats_sample_pages.test
1.72
KB
-rw-r--r--
innodb_stats_table_flag_auto_r...
2.23
KB
-rw-r--r--
innodb_stats_table_flag_sample...
2.73
KB
-rw-r--r--
innodb_sys_var_valgrind.test
1.99
KB
-rw-r--r--
innodb_tablespace.test
13.91
KB
-rw-r--r--
innodb_tablespace_zip.test
1.32
KB
-rw-r--r--
innodb_thread_concurrency_debu...
1.16
KB
-rw-r--r--
innodb_timeout_rollback-master...
58
B
-rw-r--r--
innodb_timeout_rollback.test
108
B
-rw-r--r--
innodb_trx_weight.test
3.72
KB
-rw-r--r--
innodb_upd_stats_if_needed_not...
1.04
KB
-rw-r--r--
innodb_ut_format_name.test
298
B
-rw-r--r--
innodb_wl6326.test
14.46
KB
-rw-r--r--
innodb_wl6326_big.test
24.37
KB
-rw-r--r--
innodb_wl6469_1.test
2.08
KB
-rw-r--r--
innodb_wl6469_debug.test
2.94
KB
-rw-r--r--
innodb_wl6470.test
4.42
KB
-rw-r--r--
innodb_wl6470_debug.test
1.78
KB
-rw-r--r--
innodb_wl6501_crash_1.test
798
B
-rw-r--r--
innodb_wl6501_crash_2.test
798
B
-rw-r--r--
innodb_wl6501_crash_6.test
713
B
-rw-r--r--
innodb_wl6501_crash_7.test
713
B
-rw-r--r--
innodb_wl6501_crash_8.test
2.39
KB
-rw-r--r--
innodb_wl6560_1.test
11.71
KB
-rw-r--r--
innodb_wl6560_debug.test
5.9
KB
-rw-r--r--
innodb_wl6915.test
3.99
KB
-rw-r--r--
innodb_wl6915_debug.test
5.43
KB
-rw-r--r--
innodb_wl8114.test
1.52
KB
-rw-r--r--
insert_debug.test
1.13
KB
-rw-r--r--
iodku.test
5.65
KB
-rw-r--r--
iodku_debug.test
6.38
KB
-rw-r--r--
log_alter_table.test
1.81
KB
-rw-r--r--
log_corruption.test
7.06
KB
-rw-r--r--
log_corruption.zip
92.47
KB
-rw-r--r--
log_corruption0.zip
1.18
KB
-rw-r--r--
log_corruption1.zip
1.23
KB
-rw-r--r--
log_corruption2.zip
1.27
KB
-rw-r--r--
log_corruption3.zip
1.27
KB
-rw-r--r--
log_corruption4.zip
1.28
KB
-rw-r--r--
log_corruption4a.zip
1.28
KB
-rw-r--r--
log_corruption5.zip
1.28
KB
-rw-r--r--
log_corruption6.zip
1.28
KB
-rw-r--r--
log_file.test
8.9
KB
-rw-r--r--
log_file_name.test
9.17
KB
-rw-r--r--
log_file_name_debug.test
751
B
-rw-r--r--
log_file_size.test
6.3
KB
-rw-r--r--
log_file_size_1-master.opt
14
B
-rw-r--r--
log_file_size_1.test
8.45
KB
-rw-r--r--
log_file_size_checkpoint.test
1.14
KB
-rw-r--r--
missing_tablespaces.test
2.34
KB
-rw-r--r--
monitor.test
13.96
KB
-rw-r--r--
monitor_restart.test
807
B
-rw-r--r--
mysqldump_max_recordsize.test
13.96
KB
-rw-r--r--
optimizer_temporary_table-mast...
15
B
-rw-r--r--
optimizer_temporary_table.test
4.63
KB
-rw-r--r--
page_reorganize.test
1.31
KB
-rw-r--r--
partition-blob.test
1.43
KB
-rw-r--r--
partition-upgrade.test
7.46
KB
-rw-r--r--
partition.test
20.89
KB
-rw-r--r--
portability_wl5980_linux.zip
473.02
KB
-rw-r--r--
portability_wl5980_windows.zip
514.24
KB
-rw-r--r--
readahead.test
679
B
-rw-r--r--
readonly.test
1.17
KB
-rw-r--r--
records_in_range.test
24.93
KB
-rw-r--r--
redo_log_during_checkpoint.tes...
2.59
KB
-rw-r--r--
rename_table.test
914
B
-rw-r--r--
row_format_redundant.test
2.71
KB
-rw-r--r--
sp_temp_table.test
2.51
KB
-rw-r--r--
stored_fk.test
3.46
KB
-rw-r--r--
strict_checksum.test
2.95
KB
-rw-r--r--
strict_mode.test
3.33
KB
-rw-r--r--
sys_tablestats.test
1.01
KB
-rw-r--r--
table_compress.test
14.09
KB
-rw-r--r--
table_encrypt_1.test
10.06
KB
-rw-r--r--
table_encrypt_2-master.opt
94
B
-rw-r--r--
table_encrypt_2.test
5.46
KB
-rw-r--r--
table_encrypt_3.test
31.16
KB
-rw-r--r--
table_encrypt_4.test
6.83
KB
-rw-r--r--
table_encrypt_5-master.opt
20
B
-rw-r--r--
table_encrypt_5.test
30.54
KB
-rw-r--r--
table_encrypt_debug.test
6.16
KB
-rw-r--r--
table_encrypt_fts.test
3.22
KB
-rw-r--r--
table_encrypt_kill.test
15.3
KB
-rw-r--r--
table_encryption-master.opt
20
B
-rw-r--r--
table_encryption.test
3.25
KB
-rw-r--r--
tablespace_crash.test
7.61
KB
-rw-r--r--
tablespace_embedded.test
246
B
-rw-r--r--
tablespace_embedded_windows.te...
242
B
-rw-r--r--
tablespace_per_table.test
13.03
KB
-rw-r--r--
tablespace_per_table_not_windo...
6.58
KB
-rw-r--r--
tablespace_per_table_windows.t...
3.13
KB
-rw-r--r--
tablespace_portability.test
1.64
KB
-rw-r--r--
tablespace_portability_windows...
751
B
-rw-r--r--
timestamp.test
787
B
-rw-r--r--
tinytext-groupby.test
1.26
KB
-rw-r--r--
tmpdir.test
1.9
KB
-rw-r--r--
trx_id_future.test
1.8
KB
-rw-r--r--
undo.test
1.48
KB
-rw-r--r--
update-cascade.test
6.46
KB
-rw-r--r--
update_time-master.opt
30
B
-rw-r--r--
update_time.test
2.25
KB
-rw-r--r--
update_time_wl6658.test
8.3
KB
-rw-r--r--
virtual_basic.test
44.54
KB
-rw-r--r--
virtual_blob.test
468
B
-rw-r--r--
virtual_debug.test
18.75
KB
-rw-r--r--
virtual_debug_purge.test
4.27
KB
-rw-r--r--
virtual_fk.test
25.3
KB
-rw-r--r--
virtual_fk_restart.test
1.59
KB
-rw-r--r--
virtual_index.test
8.38
KB
-rw-r--r--
virtual_purge.test
3.21
KB
-rw-r--r--
virtual_stats.test
1.43
KB
-rw-r--r--
xa_prepare_lock_release.test
1.57
KB
-rw-r--r--
xa_recovery.test
894
B
-rw-r--r--
xa_recovery_debug.test
989
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : table_encrypt_5.test
#------------------------------------------------------------------------------ # InnoDB transparent tablespace data encryption # # This test create encrypt , non encrypt tables and try to access them after # restarting with different combinitions such as # - restart with same server option (acccess all tables) # - restart without keyring options(encrypt table not accessible , rest are) # - restart without keyring option but explicilty load plugin (access all) # - restart with keyring option but using new key_file_data # (old encrypt table not accessible , rest are. New encrypt # table creation possible) # #------------------------------------------------------------------------------ # InnoDB transparent tablespace data encryption --source include/no_valgrind_without_big.inc --source include/have_innodb.inc --source include/not_embedded.inc # Suppress warnings --disable_query_log call mtr.add_suppression("\\[ERROR\\] InnoDB: Encryption can't find master key, please check the keyring plugin is loaded."); call mtr.add_suppression("ibd can't be decrypted"); call mtr.add_suppression("InnoDB: Operating system error number"); call mtr.add_suppression("The error means the system cannot find the path specified"); call mtr.add_suppression("InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them"); call mtr.add_suppression("Could not find a valid tablespace file"); call mtr.add_suppression("InnoDB: Ignoring tablespace"); call mtr.add_suppression("InnoDB: Failed to find tablespace for table"); call mtr.add_suppression("InnoDB: Cannot open table tde_db/t_encrypt.* from the internal data dictionary of InnoDB though the .frm file for the table exists"); call mtr.add_suppression("\\[ERROR\\] InnoDB: Table tde_db/t_encrypt.* in the InnoDB data dictionary has tablespace id .*, but tablespace with that id or name does not exist"); call mtr.add_suppression("\\[Warning\\] InnoDB: Please refer to .* for how to resolve the issue"); call mtr.add_suppression("Error while loading keyring content. The keyring might be malformed"); call mtr.add_suppression("\\[ERROR\\] Plugin keyring_file reported: 'Could not create keyring directory"); call mtr.add_suppression("\\[ERROR\\] Plugin keyring_file reported: 'keyring_file initialization failure."); call mtr.add_suppression("\\[ERROR\\] Plugin keyring_file reported: 'File .*keyring' not found .*"); --enable_query_log let $innodb_file_per_table = `SELECT @@innodb_file_per_table`; --echo # Starting server with keyring plugin let $restart_parameters = restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --replace_regex /\.dll/.so/ --source include/restart_mysqld.inc #------------------------------------------------------------------------------ # Initial setup for test which create encrypt and non encrypt tables --disable_warnings DROP DATABASE IF EXISTS tde_db; DROP TABLE IF EXISTS tde_db. t_encrypt; CREATE DATABASE tde_db; USE tde_db; --enable_warnings SET GLOBAL innodb_file_per_table = 1; SELECT @@innodb_file_per_table; DELIMITER |; CREATE PROCEDURE tde_db.init_setup() begin /* Create encrypt table with encryption */ CREATE TABLE tde_db.t_encrypt(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; /* Create NON encrypt table with encryption */ CREATE TABLE tde_db.t_non_encrypt(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; /* insert into encrypt table */ INSERT INTO tde_db.t_encrypt(c3,c4,c7) VALUES(CONCAT(REPEAT('a',200),LPAD(CAST(1 AS CHAR),4,'0')),'{ "key_a": 1, "key_b": 2, "key_c": 3 }',ST_GeomFromText('POINT(383293632 1754448)')); INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT '/* select tde_db.t_encrypt */'; SELECT COUNT(*) FROM tde_db.t_encrypt; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt LIMIT 10; /* insert into non encrypt table */ INSERT INTO tde_db.t_non_encrypt(c2,c3,c4,c7) SELECT c2,c3,c4,c7 FROM tde_db.t_encrypt; SELECT '/* select tde_db.t_non_encrypt */'; SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT c2 ,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt LIMIT 10; ALTER INSTANCE ROTATE INNODB MASTER KEY; CREATE TABLE tde_db.t_encrypt_2(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; CREATE TABLE tde_db.t_non_encrypt_2(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; /* insert into encrypt table 2 */ INSERT INTO tde_db.t_encrypt_2(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT '/* select tde_db.t_encrypt_2 */'; SELECT COUNT(*) FROM tde_db.t_encrypt_2; SELECT c2 ,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt_2 LIMIT 10; /* insert into NON encrypt table 2 */ INSERT INTO tde_db.t_non_encrypt_2(c2,c3,c4,c7) SELECT c2,c3,c4,c7 FROM tde_db.t_encrypt; SELECT '/* select tde_db.t_non_encrypt_2 */'; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; SELECT c2 ,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt_2 LIMIT 10; end| DELIMITER ;| --echo #----------------------------------------------------------------------- --echo # init tables call tde_db.init_setup(); --echo # plugin already installed error --replace_regex /\.dll/.so/ --error 1125 eval INSTALL PLUGIN keyring_file SONAME '$KEYRING_PLUGIN'; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SELECT @@global.keyring_file_data; --echo # Uninstall is possible when server started with --early-plugin-load UNINSTALL PLUGIN keyring_file; --echo # variable not accessible after uninstall --error 1193 SELECT @@global.keyring_file_data; --echo # Select non encrypt table : Pass SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; --echo # Select encrypt table : No Error (after uninstall plugin -master key is cached) SELECT c2 ,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt LIMIT 10; SELECT c2 ,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt_2 LIMIT 10; SELECT COUNT(*) FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_encrypt_2; --echo # Error on "ALTER INSTANCE ..." after UNINSTALL PLUGIN --error ER_CANNOT_FIND_KEY_IN_KEYRING ALTER INSTANCE ROTATE INNODB MASTER KEY; --echo # new encrypt table creation is blocked after uninstall --error ER_CANNOT_FIND_KEY_IN_KEYRING CREATE TABLE tde_db.t_encrypt_3(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; --echo # new non encrypt table CREATE TABLE tde_db.t_non_encrypt_3(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; DROP TABLE tde_db.t_encrypt , tde_db.t_encrypt_2 ; DROP TABLE tde_db.t_non_encrypt , tde_db.t_non_encrypt_2 , tde_db.t_non_encrypt_3; SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file'; --echo #----------------------------------------------------------------------- --echo # Test 1 : Restart with same keyring option , all tables accesible --echo # restart with --early-plugin-load let $restart_parameters = restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --source include/restart_mysqld.inc SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file'; --echo # init tables call tde_db.init_setup(); --echo # restart with same --early-plugin-load and keyring_file_data option let $restart_parameters = restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --source include/restart_mysqld.inc # All tables accessible SELECT COUNT(*) FROM tde_db.t_encrypt; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt LIMIT 10; SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt LIMIT 10; SELECT COUNT(*) FROM tde_db.t_encrypt_2; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt_2 LIMIT 10; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt_2 LIMIT 10; --echo # insert into old encrypt tables SELECT COUNT(*) FROM tde_db.t_encrypt_2; INSERT INTO tde_db.t_encrypt_2(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_encrypt_2; --echo # insert into old non encrypt tables SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; INSERT INTO tde_db.t_non_encrypt_2(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; --echo # update into old encrypt tables UPDATE tde_db.t_encrypt_2 SET c2 = 1000 WHERE c2 = 1; SELECT COUNT(*) FROM tde_db.t_encrypt_2 WHERE c2 = 1000 ; --echo # update into old non encrypt tables UPDATE tde_db.t_non_encrypt_2 SET c2 = 1000 WHERE c2 = 1; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2 WHERE c2 = 1000 ; --echo # delete into old encrypt tables DELETE FROM tde_db.t_encrypt_2 WHERE c2 = 1000 ; SELECT COUNT(*) FROM tde_db.t_encrypt_2 WHERE c2 = 1000 ; --echo # delete into old non encrypt tables DELETE FROM tde_db.t_non_encrypt_2 WHERE c2 = 1000 ; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2 WHERE c2 = 1000 ; --echo # new table CREATE TABLE tde_db.t_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; CREATE TABLE tde_db.t_non_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; INSERT INTO tde_db.t_encrypt_4(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_non_encrypt_4(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_encrypt_4; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt_4 LIMIT 10; SELECT COUNT(*) FROM tde_db.t_non_encrypt_4; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt_4 LIMIT 10; ALTER INSTANCE ROTATE INNODB MASTER KEY; SELECT COUNT(*) FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_encrypt_2; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; SELECT COUNT(*) FROM tde_db.t_encrypt_4; SELECT COUNT(*) FROM tde_db.t_non_encrypt_4; DROP TABLE tde_db.t_encrypt , tde_db.t_encrypt_2 , tde_db.t_encrypt_4; DROP TABLE tde_db.t_non_encrypt , tde_db.t_non_encrypt_2 , tde_db.t_non_encrypt_4; --echo #----------------------------------------------------------------------- --echo # Test 2 : Restart without keyring option - old encrypt table not --echo # accessible but rest are. --echo # restart with --early-plugin-load to load initial data let $restart_parameters = restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --source include/restart_mysqld.inc SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file'; --echo # init tables call tde_db.init_setup(); --echo # restart without --early-plugin-load and keyring_file_data let $restart_parameters = restart: ; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --source include/restart_mysqld.inc --echo # encrypt table not accessible --error ER_CANNOT_FIND_KEY_IN_KEYRING SELECT COUNT(*) FROM tde_db.t_encrypt; --error ER_CANNOT_FIND_KEY_IN_KEYRING SELECT COUNT(*) FROM tde_db.t_encrypt_2; --echo # NON encrypt table are accessible SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; --echo # encrypt table not possible --error ER_CANNOT_FIND_KEY_IN_KEYRING CREATE TABLE tde_db.t_non_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; --echo # non encrypt table possible CREATE TABLE tde_db.t_non_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; INSERT INTO tde_db.t_non_encrypt_4(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt_4; --error ER_CANNOT_FIND_KEY_IN_KEYRING ALTER INSTANCE ROTATE INNODB MASTER KEY; --echo # encrypt table not accessible --error 3185 SELECT COUNT(*) FROM tde_db.t_encrypt; --error 3185 SELECT COUNT(*) FROM tde_db.t_encrypt_2; DROP TABLE tde_db.t_encrypt , tde_db.t_encrypt_2; DROP TABLE tde_db.t_non_encrypt , tde_db.t_non_encrypt_2 ,tde_db.t_non_encrypt_4; DROP DATABASE tde_db; #------------------------------------------------------------------------------ --echo # Initial setup --echo # Starting server with keyring plugin let $restart_parameters = restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --replace_regex /\.dll/.so/ --source include/restart_mysqld.inc --disable_warnings DROP DATABASE IF EXISTS tde_db; CREATE DATABASE tde_db; USE tde_db; --enable_warnings SET GLOBAL innodb_file_per_table = 1; SELECT @@innodb_file_per_table; DELIMITER |; CREATE PROCEDURE tde_db.init_setup() begin /* Create encrypt table with encryption */ CREATE TABLE tde_db.t_encrypt(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; /* Create NON encrypt table with encryption */ CREATE TABLE tde_db.t_non_encrypt(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; /* insert into encrypt table */ INSERT INTO tde_db.t_encrypt(c3,c4,c7) VALUES(CONCAT(REPEAT('a',200),LPAD(CAST(1 AS CHAR),4,'0')),'{ "key_a": 1, "key_b": 2, "key_c": 3 }',ST_GeomFromText('POINT(383293632 1754448)')); INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_encrypt(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT '/* select tde_db.t_encrypt */'; SELECT COUNT(*) FROM tde_db.t_encrypt; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt LIMIT 10; /* insert into non encrypt table */ INSERT INTO tde_db.t_non_encrypt(c2,c3,c4,c7) SELECT c2,c3,c4,c7 FROM tde_db.t_encrypt; SELECT '/* select tde_db.t_non_encrypt */'; SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT c2 ,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt LIMIT 10; ALTER INSTANCE ROTATE INNODB MASTER KEY; CREATE TABLE tde_db.t_encrypt_2(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; CREATE TABLE tde_db.t_non_encrypt_2(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; /* insert into encrypt table 2 */ INSERT INTO tde_db.t_encrypt_2(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT '/* select tde_db.t_encrypt_2 */'; SELECT COUNT(*) FROM tde_db.t_encrypt_2; SELECT c2 ,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt_2 LIMIT 10; /* insert into NON encrypt table 2 */ INSERT INTO tde_db.t_non_encrypt_2(c2,c3,c4,c7) SELECT c2,c3,c4,c7 FROM tde_db.t_encrypt; SELECT '/* select tde_db.t_non_encrypt_2 */'; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; SELECT c2 ,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt_2 LIMIT 10; end| DELIMITER ;| #------------------------------------------------------------------------------ --echo # Test 3 : Restart without keyring option but load plugin using command --echo # Access all tables --echo #----------------------------------------------------------------------- SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file'; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SELECT @@global.keyring_file_data; --echo # init tables call tde_db.init_setup(); --echo # restart without --early-plugin-load (still need to provide with --echo # keyring_file_data otherwise it would point to default location which might be --echo # non-writable to mtr). Instead explicitly install plugin to access old table let $restart_parameters = restart: --loose-keyring_file_data=$MYSQL_TMP_DIR/mydummy_keyring; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --source include/restart_mysqld.inc --echo # Install keyring plugin --replace_regex /\.dll/.so/ --disable_warnings eval INSTALL PLUGIN keyring_file SONAME '$KEYRING_PLUGIN'; --enable_warnings --echo # Set keyring_file_data as old file so as to access old tables --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval SET @@global.keyring_file_data='$MYSQL_TMP_DIR/mysecret_keyring'; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SELECT @@global.keyring_file_data; # All tables accessible SELECT COUNT(*) FROM tde_db.t_encrypt; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt LIMIT 10; SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt LIMIT 10; SELECT COUNT(*) FROM tde_db.t_encrypt_2; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt_2 LIMIT 10; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt_2 LIMIT 10; --echo # insert into old encrypt tables SELECT COUNT(*) FROM tde_db.t_encrypt_2; INSERT INTO tde_db.t_encrypt_2(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_encrypt_2; --echo # insert into old non encrypt tables SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; INSERT INTO tde_db.t_non_encrypt_2(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; --echo # update into old encrypt tables UPDATE tde_db.t_encrypt_2 SET c2 = 1000 WHERE c2 = 1; SELECT COUNT(*) FROM tde_db.t_encrypt_2 WHERE c2 = 1000 ; --echo # update into old non encrypt tables UPDATE tde_db.t_non_encrypt_2 SET c2 = 1000 WHERE c2 = 1; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2 WHERE c2 = 1000 ; --echo # delete into old encrypt tables DELETE FROM tde_db.t_encrypt_2 WHERE c2 = 1000 ; SELECT COUNT(*) FROM tde_db.t_encrypt_2 WHERE c2 = 1000 ; --echo # delete into old non encrypt tables DELETE FROM tde_db.t_non_encrypt_2 WHERE c2 = 1000 ; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2 WHERE c2 = 1000 ; --echo # new table CREATE TABLE tde_db.t_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; CREATE TABLE tde_db.t_non_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; INSERT INTO tde_db.t_encrypt_4(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; INSERT INTO tde_db.t_non_encrypt_4(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_encrypt_4; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_encrypt_4 LIMIT 10; SELECT COUNT(*) FROM tde_db.t_non_encrypt_4; SELECT c2,right(c3,20),c4,c5,c6,ST_AsText(c7) FROM tde_db.t_non_encrypt_4 LIMIT 10; ALTER INSTANCE ROTATE INNODB MASTER KEY; SELECT COUNT(*) FROM tde_db.t_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_encrypt_2; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; SELECT COUNT(*) FROM tde_db.t_encrypt_4; SELECT COUNT(*) FROM tde_db.t_non_encrypt_4; DROP TABLE tde_db.t_encrypt , tde_db.t_encrypt_2 , tde_db.t_encrypt_4; DROP TABLE tde_db.t_non_encrypt , tde_db.t_non_encrypt_2 , tde_db.t_non_encrypt_4; UNINSTALL PLUGIN keyring_file; --error ER_CANNOT_FIND_KEY_IN_KEYRING CREATE TABLE tde_db.t_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; --error ER_CANNOT_FIND_KEY_IN_KEYRING ALTER INSTANCE ROTATE INNODB MASTER KEY; --echo #----------------------------------------------------------------------- --echo # Test 4 : Restart with new keyring_data_file --echo # Old encrypt table not accessible , non encrypt tables accessible --echo # And creation of new encrypt,non encrypt table is also posible #------------------------------------------------------------------------------ --echo # restart with --early-plugin-load to load initial data let $restart_parameters = restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --source include/restart_mysqld.inc SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file'; --echo # init tables call tde_db.init_setup(); --echo # restart with with different keyring_file_data file let $restart_parameters = restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring_new $KEYRING_PLUGIN_OPT; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so --source include/restart_mysqld.inc --echo # encrypt table not accessible --error ER_CANNOT_FIND_KEY_IN_KEYRING SELECT COUNT(*) FROM tde_db.t_encrypt; --error ER_CANNOT_FIND_KEY_IN_KEYRING SELECT COUNT(*) FROM tde_db.t_encrypt_2; --echo # NON encrypt table are accessible SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; --echo # new encrypt table is possible CREATE TABLE tde_db.t_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENCRYPTION="Y" ENGINE = InnoDB; --echo # non encrypt table possible CREATE TABLE tde_db.t_non_encrypt_4(c2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c3 CHAR(255) Default 'No text', c4 JSON , c5 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_a')) STORED, c6 INT GENERATED ALWAYS AS (JSON_EXTRACT(c4,'$.key_b')) VIRTUAL, c7 POINT NOT NULL, spatial INDEX idx2 (c7) ) ENGINE = InnoDB; INSERT INTO tde_db.t_encrypt_4(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_encrypt_4; INSERT INTO tde_db.t_non_encrypt_4(c3,c4,c7) SELECT c3,c4,c7 FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt_4; ALTER INSTANCE ROTATE INNODB MASTER KEY; --echo # old encrypt table not accessible --error ER_CANNOT_FIND_KEY_IN_KEYRING,1146 SELECT COUNT(*) FROM tde_db.t_encrypt; --error ER_CANNOT_FIND_KEY_IN_KEYRING,1146 SELECT COUNT(*) FROM tde_db.t_encrypt_2; --echo # NON encrypt old table are accessible SELECT COUNT(*) FROM tde_db.t_non_encrypt; SELECT COUNT(*) FROM tde_db.t_non_encrypt_2; --echo # new encrypt table accessible SELECT COUNT(*) FROM tde_db.t_encrypt_4; --echo # new NON encrypt table accessible SELECT COUNT(*) FROM tde_db.t_non_encrypt_4; DROP TABLE tde_db.t_encrypt , tde_db.t_encrypt_2 ,tde_db.t_encrypt_4; DROP TABLE tde_db.t_non_encrypt , tde_db.t_non_encrypt_2 ,tde_db.t_non_encrypt_4; DROP DATABASE tde_db; --echo # Starting server without keyring let $restart_parameters = restart: ; --source include/restart_mysqld.inc # Cleanup eval SET GLOBAL innodb_file_per_table=$innodb_file_per_table; --remove_file $MYSQL_TMP_DIR/mysecret_keyring --remove_file $MYSQL_TMP_DIR/mysecret_keyring_new
Close