Debian Codegraph @

mysql-test/suite/rpl/t/rpl_perfschema_disabled_connection_applier_status_mts.test

raw
1 #
2 # ==== Purpose ====
3 #
4 # This test asserts that the information regarding the replication timestamps
5 # is displayed correctly when the system is running with MTS enabled.
6 #
7 # ==== Implementation ====
8 #
9 # Five transaction types are tested:
10 # - create table
11 # - insert
12 # - update
13 # - delete
14 # - drop table
15 # For each statement, the test asserts that the information concerning the
16 # transaction that is currently being processed matches what is expected
17 # before and after each of the following replication stages is completed for
18 # that transaction:
19 # 1) The connection thread queues the transaction to be processed by the
20 # MTS coordinator (table: performance_schema.replication_connection_status)
21 # 2) The MTS coordinator puts the transaction into a worker's queue
22 # (table: performance_schema.replication_applier_status_by_coordinator)
23 # 3) A worker applies the transaction
24 # (table: performance_schema.replication_applier_status_by_worker)
25 #
26 # The second part of the test checks if the table
27 # performance_schema.replication_applier_status_by_worker displays the correct
28 # information when the slave cannot apply a transaction due to an error.
29 # Two types of transactions are tested: DDL (DROP table) and DML (insert). After
30 # the slave fails applying each transaction, the test verifies that
31 # last_applied_transaction still shows the last transaction applied before the
32 # failed one, and also that applying_transaction was cleared.
33 #
34 # ==== References ====
35 #
36 # WL#7374 Performance schema tables to monitor replication lags and queue
37 # BUG#25694813 INSTRUMENTATION IS ALWAYS ENABLED FOR REPLICATION P_S STATUS
38 # TABLES
39
40 # the test is binlog-format agnostic
41 --source include/have_binlog_format_row.inc
42 --source include/have_debug_sync.inc
43 --source include/only_mts_replica_parallel_workers.inc
44 --source include/master-slave.inc
45
46 --let $is_mts= 1
47
48 --source extra/rpl_tests/rpl_ps_connection_applier_status.inc
49
50 --source extra/rpl_tests/rpl_ps_connection_applier_status_by_worker_failed_trx.inc
51
52 --source include/rpl_end.inc