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 | : 3.145.115.135
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 /
extra /
rpl_tests /
[ HOME SHELL ]
Name
Size
Permission
Action
check_type.inc
2.29
KB
-rw-r--r--
create_recursive_construct.inc
16.61
KB
-rw-r--r--
create_recursive_construct_stm...
16.48
KB
-rw-r--r--
delayed_slave_wait_on_query.in...
1.59
KB
-rw-r--r--
gtid_disconnect_drop_temporary...
3.11
KB
-rw-r--r--
rpl_EE_err.test
1.03
KB
-rw-r--r--
rpl_auto_increment.test
8.63
KB
-rw-r--r--
rpl_auto_increment_insert_view...
1.37
KB
-rw-r--r--
rpl_auto_increment_invoke_trig...
2.47
KB
-rw-r--r--
rpl_autoinc_func_invokes_trigg...
1.78
KB
-rw-r--r--
rpl_binlog_max_cache_size.test
18.23
KB
-rw-r--r--
rpl_blackhole.test
1.03
KB
-rw-r--r--
rpl_change_master.test
10.46
KB
-rw-r--r--
rpl_change_master_bind.inc
2.23
KB
-rw-r--r--
rpl_charset.test
4.45
KB
-rw-r--r--
rpl_check_gtid.inc
4.87
KB
-rw-r--r--
rpl_commit_after_flush.test
272
B
-rw-r--r--
rpl_conflicts.test
5.45
KB
-rw-r--r--
rpl_crash_safe.inc
4.13
KB
-rw-r--r--
rpl_crash_safe.test
7.61
KB
-rw-r--r--
rpl_create_msr_channels.inc
2.53
KB
-rw-r--r--
rpl_db_stmts_ignored.inc
1.7
KB
-rw-r--r--
rpl_ddl.test
21.62
KB
-rw-r--r--
rpl_deadlock.test
6.05
KB
-rw-r--r--
rpl_delete_no_where.test
523
B
-rw-r--r--
rpl_do_table_filter_insensitiv...
492
B
-rw-r--r--
rpl_do_table_filter_sensitive....
491
B
-rw-r--r--
rpl_drop_create_temp_table.inc
29.79
KB
-rw-r--r--
rpl_drop_create_temp_table.tes...
17.8
KB
-rw-r--r--
rpl_drop_multiple_tables.inc
4
KB
-rw-r--r--
rpl_drop_multiple_tables_in_mu...
1.18
KB
-rw-r--r--
rpl_extra_col_master.test
31.93
KB
-rw-r--r--
rpl_extra_col_slave.test
28.76
KB
-rw-r--r--
rpl_failed_optimize.test
666
B
-rw-r--r--
rpl_filters.test
530
B
-rw-r--r--
rpl_flsh_tbls.test
1.86
KB
-rw-r--r--
rpl_foreign_key.test
1.7
KB
-rw-r--r--
rpl_generate_mts_gap.test
1.6
KB
-rw-r--r--
rpl_generate_mts_gap_with_miss...
3.22
KB
-rw-r--r--
rpl_generate_mts_gap_with_miss...
408
B
-rw-r--r--
rpl_get_master_version_and_clo...
2.88
KB
-rw-r--r--
rpl_gtid_drop_table.inc
1.11
KB
-rw-r--r--
rpl_gtid_mixed_rows_and_stmts_...
3.35
KB
-rw-r--r--
rpl_gtid_mts_relay_log_recover...
4.39
KB
-rw-r--r--
rpl_gtid_temp_table_in_func_or...
3.69
KB
-rw-r--r--
rpl_gtids_restart_slave_io_los...
3.48
KB
-rw-r--r--
rpl_heartbeat_2slaves.inc
4.27
KB
-rw-r--r--
rpl_ignore_super_read_only.tes...
6.19
KB
-rw-r--r--
rpl_ignore_table_filter_insens...
508
B
-rw-r--r--
rpl_ignore_table_filter_sensit...
506
B
-rw-r--r--
rpl_implicit_commit_binlog.tes...
17.22
KB
-rw-r--r--
rpl_innodb.test
4.53
KB
-rw-r--r--
rpl_insert_id.test
15.12
KB
-rw-r--r--
rpl_insert_id_pk.test
2.65
KB
-rw-r--r--
rpl_insert_ignore.test
4.9
KB
-rw-r--r--
rpl_kill_query.inc
4.14
KB
-rw-r--r--
rpl_loaddata.test
8.91
KB
-rw-r--r--
rpl_loaddata_s.inc
896
B
-rw-r--r--
rpl_loadfile.test
1.08
KB
-rw-r--r--
rpl_log.test
3.9
KB
-rw-r--r--
rpl_lower_case_table_names.tes...
4.07
KB
-rw-r--r--
rpl_max_relay_size.test
2.58
KB
-rw-r--r--
rpl_mixing_engines.inc
23.15
KB
-rw-r--r--
rpl_mixing_engines.test
54.43
KB
-rw-r--r--
rpl_mts_crash_safe.inc
5.92
KB
-rw-r--r--
rpl_mts_crash_safe.test
6.74
KB
-rw-r--r--
rpl_mts_execute_partial_trx_in...
1.11
KB
-rw-r--r--
rpl_mts_pending_events.inc
4.91
KB
-rw-r--r--
rpl_mts_relay_log_recovery.tes...
2.93
KB
-rw-r--r--
rpl_mts_transaction_retry.inc
7.9
KB
-rw-r--r--
rpl_multi_query.test
782
B
-rw-r--r--
rpl_multi_source_corrupt_repos...
18.31
KB
-rw-r--r--
rpl_multi_source_generate_mts_...
2.11
KB
-rw-r--r--
rpl_multi_update.test
805
B
-rw-r--r--
rpl_multi_update2.test
1.35
KB
-rw-r--r--
rpl_multi_update3.test
4.52
KB
-rw-r--r--
rpl_not_null.test
10.76
KB
-rw-r--r--
rpl_parallel_ddl.test
5.35
KB
-rw-r--r--
rpl_parallel_load.test
6.1
KB
-rw-r--r--
rpl_parallel_load_innodb.test
7
KB
-rw-r--r--
rpl_parallel_recovery_core.tes...
6.74
KB
-rw-r--r--
rpl_partition.test
7.88
KB
-rw-r--r--
rpl_perfschema_applier_xa_stat...
2.96
KB
-rw-r--r--
rpl_perfschema_order_by.test
3.12
KB
-rw-r--r--
rpl_record_compare.test
2.1
KB
-rw-r--r--
rpl_relayrotate.test
2.68
KB
-rw-r--r--
rpl_replication_observers_exam...
2.61
KB
-rw-r--r--
rpl_reset_slave.test
3.82
KB
-rw-r--r--
rpl_reset_slave_all_thread_saf...
1.2
KB
-rw-r--r--
rpl_rollback_to_savepoint.inc
7.54
KB
-rw-r--r--
rpl_row_001.test
2.68
KB
-rw-r--r--
rpl_row_UUID.test
2.61
KB
-rw-r--r--
rpl_row_basic.test
24.58
KB
-rw-r--r--
rpl_row_blob.test
5.57
KB
-rw-r--r--
rpl_row_empty_imgs.test
5.69
KB
-rw-r--r--
rpl_row_event_max_size.inc
4.05
KB
-rw-r--r--
rpl_row_func003.test
3.13
KB
-rw-r--r--
rpl_row_idempotency.test
8.39
KB
-rw-r--r--
rpl_row_img.test
8.23
KB
-rw-r--r--
rpl_row_img_blobs.test
5.82
KB
-rw-r--r--
rpl_row_img_diff_indexes.test
9.11
KB
-rw-r--r--
rpl_row_sp002.test
5.26
KB
-rw-r--r--
rpl_row_sp003.test
2.02
KB
-rw-r--r--
rpl_row_sp006.test
2.78
KB
-rw-r--r--
rpl_row_sp007.test
1.5
KB
-rw-r--r--
rpl_row_tabledefs.test
7.97
KB
-rw-r--r--
rpl_seconds_behind_master_mts_...
12.04
KB
-rw-r--r--
rpl_seconds_behind_master_mts_...
10.2
KB
-rw-r--r--
rpl_semi_sync_ack_thread.inc
676
B
-rw-r--r--
rpl_semi_sync_after_sync.test
4.82
KB
-rw-r--r--
rpl_semi_sync_deadlock.test
1.46
KB
-rw-r--r--
rpl_semi_sync_group_commit_dea...
1.71
KB
-rw-r--r--
rpl_set_null.test
2.85
KB
-rw-r--r--
rpl_sp.test
17.69
KB
-rw-r--r--
rpl_split_statements.test
17.96
KB
-rw-r--r--
rpl_start_stop_slave.test
5.4
KB
-rw-r--r--
rpl_stm_EE_err2.test
1.5
KB
-rw-r--r--
rpl_stm_create_if_not_exists.t...
6.87
KB
-rw-r--r--
rpl_stop_middle_group.test
5.17
KB
-rw-r--r--
rpl_stop_slave.test
1.56
KB
-rw-r--r--
rpl_stress_test.inc
2.21
KB
-rw-r--r--
rpl_sv_relay_space.test
921
B
-rw-r--r--
rpl_sync_relay_log_info.inc
9.02
KB
-rw-r--r--
rpl_sync_relay_log_info_assert...
3.23
KB
-rw-r--r--
rpl_temp_error.test
623
B
-rw-r--r--
rpl_temporary.test
10.6
KB
-rw-r--r--
rpl_test_framework.inc
2.42
KB
-rw-r--r--
rpl_tmp_table_and_DDL.test
4.8
KB
-rw-r--r--
rpl_trig004.test
1.7
KB
-rw-r--r--
rpl_truncate.test
425
B
-rw-r--r--
rpl_truncate_helper.test
976
B
-rw-r--r--
rpl_trx_boundary_parser.inc
1.59
KB
-rw-r--r--
rpl_trx_boundary_parser_all_st...
7.19
KB
-rw-r--r--
rpl_trx_boundary_parser_one_st...
3.69
KB
-rw-r--r--
rpl_trx_boundary_parser_warnin...
4.51
KB
-rw-r--r--
rpl_variables_stm.test
24.26
KB
-rw-r--r--
rpl_xa_gtid_next.inc
2.46
KB
-rw-r--r--
rpl_xa_mixed_engines.inc
1.89
KB
-rw-r--r--
type_conversions.test
23.7
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : rpl_row_blob.test
################################################# # Author: JBM # Date: 2006-01-06 # Purpose: Test test that BLOBs are replicated # correctly. ################################################ # Pre test clean up section connection master; --disable_warnings DROP TABLE IF EXISTS test.t1; DROP TABLE IF EXISTS test.t2; --enable_warnings # Start test section --echo ***** Table Create Section **** --echo --disable_warnings --replace_result $engine_type # eval CREATE TABLE test.t1 (c1 int not null auto_increment, data LONGBLOB, PRIMARY KEY(c1))ENGINE=$engine_type; --enable_warnings --echo --echo **** Data Insert Section test.t1 ***** --echo INSERT INTO test.t1 VALUES (NULL, NULL); INSERT INTO test.t1 VALUES (NULL, repeat('a',1*1024)); INSERT INTO test.t1 VALUES (NULL, repeat('b',16*1024)); --echo --echo **** Data Insert Validation Master Section test.t1 **** --echo SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1; SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2; SELECT LENGTH(data) FROM test.t1 WHERE c1 = 3; --source include/sync_slave_sql_with_master.inc --echo --echo **** Data Insert Validation Slave Section test.t1 **** --echo SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1; SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2; SELECT LENGTH(data) FROM test.t1 WHERE c1 = 3; connection master; --echo --echo **** Data Update Section test.t1 **** --echo UPDATE test.t1 set data=repeat('a',18*1024) where c1 = 1; UPDATE t1 set data=repeat('c',17*1024) where c1 = 2; --echo --echo **** Data Update Validation Master Section test.t1 **** --echo SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1; SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2; --source include/sync_slave_sql_with_master.inc --echo --echo **** Data Update Validation Slave Section test.t1 **** --echo SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1; SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2; connection master; --echo --echo **** End Test Section test.t1 **** --echo --echo **** Create Table test.t2 **** --echo --disable_warnings --replace_result $engine_type # eval CREATE TABLE test.t2 ( c1 INT NOT NULL PRIMARY KEY, c2 TEXT, c3 INT, c4 LONGBLOB, KEY(c3))ENGINE=$engine_type; --enable_warnings --echo --echo *** Setup Values For test.t2 *** # x0 size 256 (current inline size) set @x0 = '01234567012345670123456701234567'; set @x0 = concat(@x0,@x0,@x0,@x0,@x0,@x0,@x0,@x0); # b1 length 2000+256 (blob part aligned) set @b1 = 'b1'; set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1); set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1); set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1); set @b1 = concat(@b1,@x0); # d1 length 3000 set @d1 = 'dd1'; set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1); set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1); set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1); # b2 length 20000 set @b2 = 'b2'; set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2); set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2); set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2); set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2); # d2 length 30000 set @d2 = 'dd2'; set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2); set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2); set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2); set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2); --echo --echo **** Data Insert Section test.t2 ***** --echo INSERT INTO test.t2 VALUES(1,@b1,111,@d1); INSERT INTO test.t2 VALUES(2,@b2,222,@d2); --echo --echo **** Data Insert Validation Master Section test.t2 **** --echo SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3) FROM test.t2 WHERE c1=1; SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3) FROM test.t2 WHERE c1=2; --source include/sync_slave_sql_with_master.inc --echo --echo **** Data Insert Validation Slave Section test.t2 **** --echo SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3) FROM test.t2 WHERE c1=1; SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3) FROM test.t2 WHERE c1=2; connection master; --echo --echo **** Data Update Section test.t2 **** --echo UPDATE test.t2 SET c2=@b2, c4=@d2 WHERE c1=1; UPDATE test.t2 SET c2=@b1, c4=@d1 WHERE c1=2; --echo --echo **** Data Update Validation Master Section test.t2 **** --echo SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3) FROM test.t2 WHERE c1=1; SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3) FROM test.t2 WHERE c1=2; --source include/sync_slave_sql_with_master.inc --echo --echo **** Data Update Validation Slave Section test.t2 **** --echo SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3) FROM test.t2 WHERE c1=1; SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3) FROM test.t2 WHERE c1=2; connection master; --echo # Post test clean up section --exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_row_blob_master.sql --exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_row_blob_slave.sql diff_files $MYSQLTEST_VARDIR/tmp/rpl_row_blob_master.sql $MYSQLTEST_VARDIR/tmp/rpl_row_blob_slave.sql; DROP TABLE IF EXISTS test.t1; DROP TABLE IF EXISTS test.t2; # ensure cleanup on slave as well: # ndb blob tables consist of several tables # if cluster is shutdown while not all tables are # properly dropped, the table becomes inconsistent # and wrecks later test cases --source include/sync_slave_sql_with_master.inc
Close
