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.139.55.240
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_parallel_recovery_core.test
# The following test aims at verifying MTS recovery. # It can be invoked in a standard as well as Multi-source replication environment. # # Algorithm of test # ----------------- # # A number of concurrently executable transactions are prepared on the # master. It's done with adding a "separator" group which is a DML in # myisam table. Considering their sizes and a small value of # max_relay_log_size they are relay-logged in a sequence of files # possibly being broken into pieces so different pieces of a # transaction be scattered across few logs. # At applying a number of transactions is let to complete until a separator # is found. At this point a slave local session locks random records in # the data tables which leads to a timeout error. # After the slave applier is stopped, the failure conditions are removed, # and slave resumes with two phases. When the gaps are filled up, a next # undisturbed round of applying follows. # Gaps filling is done in two branches: an immediate restart in the # "hot" server, and the slave server shutdown, restart and the slave # service restart. In either case MTS recovery must be completed with # positive data consistency check. #------------------ # Parameters: # # Number of master connection. For Logical_clock it means # parallelization window, for the Database scheduler it means a number # of databases. --let $conn_cnt=4 # Total number of failures that the slave is subject to by simulation --let $total_fail_cnt=4 --let $fail_to_shutdown=2 # max number of simulataneous errors by Workers at a time --let $simul_fail_cnt=4 # total number of transactions to be processed by slave --let $total_trx_cnt=128 # give up waiting for lock in Innodb at error simulation --let $innodb_wait_timeout=1 # small value for max relay-log-size --let $relay_log_size= 4096 --connection slave CALL mtr.add_suppression("The slave coordinator and worker threads are stopped"); SET @save.innodb_lock_wait_timeout=@@GLOBAL.innodb_lock_wait_timeout; eval SET @@global.innodb_lock_wait_timeout=$innodb_wait_timeout; SET @save.slave_transaction_retries= @@global.slave_transaction_retries; SET @@global.slave_transaction_retries= 0; SET @save.max_relay_log_size= @@global.max_relay_log_size; --eval SET @@global.max_relay_log_size=$relay_log_size --source include/stop_slave_sql.inc --source include/start_slave_sql.inc --let $assert_text= the max size of relay log must be $relay_log_size --let $assert_cond= [select @@global.max_relay_log_size] = $relay_log_size --source include/assert.inc --let $trx_max_size=`select 3*@@global.max_relay_log_size/2` # # End of parameters # ------------------ --let $index=$conn_cnt while ($index) { --connect(con$index, localhost, root,,) eval CREATE DATABASE db$index; eval CREATE TABLE db$index.t (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ENGINE=innodb; --dec $index } --connection master # Inserts into myisam will be caught/blocked on the slave side # to serve as synchronization tool by which the slave side # becomes aware of execution/scheduling point in the replicated load. # So each such insert is made to "trigger" a failure. CREATE TABLE t1m (a INT) ENGINE=myisam; if ($rpl_multi_source) { --let $rpl_channel_name= channel_1 } #--let $sync_slave_connection= server_2 --let $sync_slave_connection= slave --source include/sync_slave_sql_with_master.inc --connection slave LOCK TABLES t1m WRITE; --connection master # # Parallelizable load generator # --let $trans_no_failure=`SELECT FLOOR($total_trx_cnt / $total_fail_cnt )` --let $iter=$total_trx_cnt --disable_query_log while ($iter) { --let $index=$conn_cnt while ($index) { --connection con$index BEGIN; eval INSERT INTO db$index.t values (NULL, REPEAT('a', FLOOR(RAND()*$trx_max_size))); --dec $index } --let $index=$conn_cnt while ($index) { --connection con$index COMMIT; if (`SELECT ($total_trx_cnt-$iter) % $trans_no_failure = FLOOR($trans_no_failure/2)`) { --connection master INSERT INTO t1m SET a=1; } --dec $index --dec $iter # the outer loop counter is decremented on purpose here. } } --enable_query_log # # The slave failures loop. Slave sql threads stop and restarted # prescribed number of times. After being waited tables are unlocked # the slave must always recover. # --disable_query_log --disable_result_log --let $iter=$total_fail_cnt while ($iter) { --let $iter_err= $simul_fail_cnt --connection slave1 BEGIN; while ($iter_err) { --let $index=`SELECT 1 + FLOOR(RAND()*100) % $conn_cnt` --eval SELECT * FROM db$index .t FOR UPDATE --dec $iter_err } --connection slave UNLOCK TABLES; --let $slave_sql_errno=convert_error(ER_LOCK_WAIT_TIMEOUT) --let $show_slave_sql_error= 0 --source include/wait_for_slave_sql_error.inc --connection slave1 ROLLBACK; # first few iterations with a "warm" restart if ($iter > $fail_to_shutdown) { --connection slave if ($rpl_multi_source) { START SLAVE UNTIL SQL_AFTER_MTS_GAPS for channel 'channel_1'; --let $rpl_channel_name= channel_1 } if (!$rpl_multi_source) { START SLAVE UNTIL SQL_AFTER_MTS_GAPS; } --source include/wait_for_slave_sql_to_stop.inc } if ($iter <= $fail_to_shutdown) { --let $rpl_server_number= 2 --let $rpl_skip_start_slave= 1 --source include/rpl_restart_server.inc --connection slave SET @save.innodb_lock_wait_timeout=@@GLOBAL.innodb_lock_wait_timeout; eval SET @@global.innodb_lock_wait_timeout=$innodb_wait_timeout; SET @save.slave_transaction_retries= @@global.slave_transaction_retries; SET @@global.slave_transaction_retries= 0; SET @save.max_relay_log_size= @@global.max_relay_log_size; SET @@global.max_relay_log_size=4096; if ($rpl_multi_source) { START SLAVE UNTIL SQL_AFTER_MTS_GAPS for channel 'channel_1'; --let $rpl_channel_name= channel_1 } if (!$rpl_multi_source) { START SLAVE UNTIL SQL_AFTER_MTS_GAPS; } --source include/wait_for_slave_sql_to_stop.inc } LOCK TABLES t1m WRITE; if ($rpl_multi_source) { --let $rpl_channel_name= channel_1 } --source include/start_slave_sql.inc --dec $iter } #eof of the slave error load --enable_result_log --enable_query_log --connection slave UNLOCK TABLES; --connection master if ($rpl_multi_source) { --let $rpl_channel_name= channel_1 } --let $sync_slave_connection= slave --source include/sync_slave_sql_with_master.inc # # Cleanup # --connection master DROP TABLE t1m; --let $index=$conn_cnt while ($index) { --eval DROP DATABASE db$index --dec $index } --source include/sync_slave_sql_with_master.inc SET @@global.innodb_lock_wait_timeout=@save.innodb_lock_wait_timeout; SET @@global.slave_transaction_retries= @save.slave_transaction_retries; SET @@global.max_relay_log_size= @save.max_relay_log_size;
Close
