| 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 |