| 1 |
|
| 2 |
############################################################ |
| 3 |
# 01. Setup source-replica |
| 4 |
include/uninstall_group_replication_plugin.inc |
| 5 |
include/master-slave.inc |
| 6 |
Warnings: |
| 7 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 8 |
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. |
| 9 |
[connection master] |
| 10 |
|
| 11 |
############################################################ |
| 12 |
# 02. Setup replica as replica-cluster primary |
| 13 |
[connection slave] |
| 14 |
# restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1 --group_replication_start_on_boot=1 --group_replication_single_primary_mode=1 --group_replication_enforce_update_everywhere_checks=0 --skip_slave_start=0 |
| 15 |
include/rpl_reconnect.inc |
| 16 |
[connection slave] |
| 17 |
include/gr_wait_for_member_state.inc |
| 18 |
|
| 19 |
############################################################ |
| 20 |
# 03. Initial setup on the source |
| 21 |
[connection master] |
| 22 |
CREATE TABLE t1(c1 INT PRIMARY KEY, c2 INT, INDEX(c2)) ENGINE = InnoDB; |
| 23 |
INSERT INTO t1 VALUES |
| 24 |
(1, NULL), |
| 25 |
(2, 2), |
| 26 |
(3, NULL), |
| 27 |
(4, 4), |
| 28 |
(5, NULL), |
| 29 |
(6, 6); |
| 30 |
CREATE TABLE t2(a INT PRIMARY KEY); |
| 31 |
include/sync_slave_sql_with_master.inc |
| 32 |
[connection slave] |
| 33 |
include/stop_slave_sql.inc |
| 34 |
set session sql_log_bin=0; |
| 35 |
CALL mtr.add_suppression(".*Worker.*failed executing transaction.*at source log .*, end_log_pos.*Deadlock found when trying to get lock.*"); |
| 36 |
CALL mtr.add_suppression(".*Worker.*failed executing transaction.*at source log .*, end_log_pos.*Can not lock user management caches for processing.*"); |
| 37 |
CALL mtr.add_suppression(".*Worker.*failed executing transaction.*at source log .*, end_log_pos.*Replica worker has stopped after at least one previous worker.*"); |
| 38 |
CALL mtr.add_suppression(".*worker thread retried transaction.*time.*in vain, giving up.*"); |
| 39 |
CALL mtr.add_suppression(".*The replica coordinator and worker threads are stopped.*"); |
| 40 |
CALL mtr.add_suppression(".*Replica worker has stopped after at least one previous worker encountered an error when replica-preserve-commit-order was enabled.*"); |
| 41 |
set session sql_log_bin=1; |
| 42 |
SET GLOBAL replica_parallel_type = LOGICAL_CLOCK; |
| 43 |
Warnings: |
| 44 |
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release. |
| 45 |
SET GLOBAL replica_parallel_workers = 3; |
| 46 |
SET GLOBAL replica_preserve_commit_order = ON; |
| 47 |
SET GLOBAL replica_transaction_retries = REPLICA_TRANSACTION_RETRIES; |
| 48 |
SET GLOBAL innodb_lock_wait_timeout = INNODB_LOCK_WAIT_TIMEOUT; |
| 49 |
include/rpl_connect.inc [creating rpl_slave_connection_2] |
| 50 |
include/rpl_connect.inc [creating rpl_slave_connection_3] |
| 51 |
|
| 52 |
############################################################ |
| 53 |
# 04. Generate commit_order_deadlock on replica-cluster |
| 54 |
# primary so that transaction will be retried |
| 55 |
[connection master] |
| 56 |
INSERT INTO t1 VALUES(13, 13); |
| 57 |
[connection slave] |
| 58 |
[connection master] |
| 59 |
# Adding debug point 'set_commit_parent_100' to @@GLOBAL.debug |
| 60 |
SET GTID_NEXT = "aaaaaaaa-1111-bbbb-2222-cccccccccccc:1"; |
| 61 |
INSERT INTO t1 VALUES(14, NULL); |
| 62 |
SET GTID_NEXT = AUTOMATIC; |
| 63 |
SET GTID_NEXT = "aaaaaaaa-1111-bbbb-2222-cccccccccccc:2"; |
| 64 |
INSERT INTO t1 VALUES(15, NULL); |
| 65 |
SET GTID_NEXT = AUTOMATIC; |
| 66 |
# Removing debug point 'set_commit_parent_100' from @@GLOBAL.debug |
| 67 |
[connection slave] |
| 68 |
SET GTID_NEXT = "aaaaaaaa-1111-bbbb-2222-cccccccccccc:1"; |
| 69 |
BEGIN; |
| 70 |
[connection rpl_slave_connection_2] |
| 71 |
SET GTID_NEXT = "aaaaaaaa-1111-bbbb-2222-cccccccccccc:2"; |
| 72 |
BEGIN; |
| 73 |
[connection slave1] |
| 74 |
include/start_slave_sql.inc |
| 75 |
include/assert.inc [Replica parallel type is LOGICAL_CLOCK] |
| 76 |
include/assert.inc [MTS worker thread count is correct] |
| 77 |
include/assert.inc [Replica preserve commit order is 1] |
| 78 |
include/assert.inc [Replica transaction retries has correct configured value] |
| 79 |
include/assert.inc [InnoDB lock wait timeout has correct configured value] |
| 80 |
[connection rpl_slave_connection_2] |
| 81 |
ROLLBACK; |
| 82 |
SET GTID_NEXT = AUTOMATIC; |
| 83 |
include/wait_condition.inc [First worker must wait on commit order] |
| 84 |
[connection slave1] |
| 85 |
SET GLOBAL read_only = ON; |
| 86 |
[connection slave] |
| 87 |
ROLLBACK; |
| 88 |
SET GTID_NEXT = AUTOMATIC; |
| 89 |
[connection slave1] |
| 90 |
[connection slave1] |
| 91 |
SET GLOBAL read_only = OFF; |
| 92 |
[connection master] |
| 93 |
include/sync_slave_sql_with_master.inc |
| 94 |
include/rpl_diff.inc |
| 95 |
[connection master] |
| 96 |
include/sync_slave_sql_with_master.inc |
| 97 |
include/stop_slave_sql.inc |
| 98 |
|
| 99 |
############################################################ |
| 100 |
# 05. Cleanup |
| 101 |
# Kill and restart:--skip_slave_start=0 |
| 102 |
include/rpl_reconnect.inc |
| 103 |
[connection slave] |
| 104 |
include/start_slave_sql.inc |
| 105 |
Warnings: |
| 106 |
Note 3083 Replication thread(s) for channel '' are already runnning. |
| 107 |
[connection master] |
| 108 |
DROP TABLE t1; |
| 109 |
DROP TABLE t2; |
| 110 |
include/install_group_replication_plugin.inc |
| 111 |
include/rpl_end.inc |
| 112 |
[connection slave] |
| 113 |
SET GLOBAL replica_parallel_type = 'SAVED_REPLICA_PARALLEL_TYPE'; |
| 114 |
Warnings: |
| 115 |
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release. |
| 116 |
SET GLOBAL replica_parallel_workers = SAVED_REPLICA_PARALLEL_WORKERS; |
| 117 |
SET GLOBAL replica_preserve_commit_order = SAVED_REPLICA_PRESERVE_COMMIT_ORDER; |
| 118 |
SET GLOBAL replica_transaction_retries = SAVED_REPLICA_TRANSACTION_RETRIES; |
| 119 |
SET GLOBAL innodb_lock_wait_timeout = SAVED_INNODB_LOCK_WAIT_TIMEOUT; |
| 120 |
SET GLOBAL read_only = SAVED_READ_ONLY; |