Debian Codegraph @

mysql-test/suite/rpl/r/rpl_mts_replica_preserve_commit_order_nobinlog.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6
7 # Setup
8
9 [connection slave]
10 CALL mtr.add_suppression("You need to use --log-bin to make --binlog-format work");
11 SET @save_replica_parallel_workers= @@global.replica_parallel_workers;
12 SET @save_replica_parallel_type= @@global.replica_parallel_type;
13 Warnings:
14 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
15 SET @save_replica_preserve_commit_order= @@global.replica_preserve_commit_order;
16 SET GLOBAL replica_parallel_type = 'LOGICAL_CLOCK';
17 Warnings:
18 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
19 SET GLOBAL replica_parallel_workers= 8;
20 SET GLOBAL replica_preserve_commit_order= ON;
21 include/start_slave.inc
22 [connection master]
23 SET @save_binlog_transaction_dependency_tracking= @@global.binlog_transaction_dependency_tracking;
24 Warnings:
25 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
26 SET @@global.binlog_transaction_dependency_tracking = COMMIT_ORDER;
27 Warnings:
28 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
29 [connection master]
30 CREATE TABLE t1 (c1 INT PRIMARY KEY) ENGINE = InnoDB; CREATE TABLE t2 (c1 INT PRIMARY KEY) ENGINE = InnoDB;;
31 include/sync_slave_sql_with_master.inc
32
33 # Block slave sql applier threads
34
35 [connection slave]
36 BEGIN; INSERT INTO t1 VALUES (1);;
37
38 # Generate the transactions which can be applied in parallel on slave
39
40 [connection master]
41 # Adding debug point 'set_commit_parent_100' to @@GLOBAL.debug
42 BEGIN; INSERT INTO t1 VALUES (1); COMMIT; BEGIN; INSERT INTO t2 VALUES (2); COMMIT; BEGIN; INSERT INTO t2 VALUES (3); COMMIT; BEGIN; INSERT INTO t2 VALUES (4); COMMIT;;
43 [connection server_1]
44 BEGIN; INSERT INTO t2 VALUES (5); COMMIT; BEGIN; INSERT INTO t2 VALUES (6); COMMIT; BEGIN; INSERT INTO t2 VALUES (7); COMMIT;;
45 # Removing debug point 'set_commit_parent_100' from @@GLOBAL.debug
46
47 # Verify the transactions are ordered correctly on slave
48
49 [connection server_2]
50 include/assert.inc [Verify table t1 is empty]
51 include/assert.inc [Verify table t2 is empty]
52
53 # Rollback the first insert so that slave applier threads can
54 # unblock and proceed. Verify the transactions are applied.
55
56 [connection slave]
57 ROLLBACK;;
58 DROP TABLE t1; DROP TABLE t2;;
59 include/sync_slave_sql_with_master.inc
60
61 # Cleanup
62
63 [connection master]
64 SET GLOBAL binlog_transaction_dependency_tracking=@save_binlog_transaction_dependency_tracking;
65 Warnings:
66 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
67 include/sync_slave_sql_with_master.inc
68 include/stop_slave.inc
69 SET GLOBAL replica_parallel_type=@save_replica_parallel_type;
70 Warnings:
71 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
72 SET GLOBAL replica_parallel_workers=@save_replica_parallel_workers;
73 SET GLOBAL replica_preserve_commit_order=@save_replica_preserve_commit_order;
74 include/start_slave.inc
75 include/rpl_end.inc