| 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 |
# Test Case 1: Simple MASTER-SLAVE setup. |
| 8 |
# Verify that slave displays appropriate XA_STATE in performance |
| 9 |
# schema table, post XA PREPARE AND XA COMMIT command execution. |
| 10 |
#################################################################### |
| 11 |
[connection slave] |
| 12 |
TRUNCATE TABLE performance_schema.events_transactions_current; |
| 13 |
---- Setup ---- |
| 14 |
[connection master] |
| 15 |
CREATE TABLE t ( f INT) ENGINE=INNODB; |
| 16 |
---- XA PREPARE ---- |
| 17 |
XA START 'xatest'; |
| 18 |
INSERT INTO t VALUES (10); |
| 19 |
XA END 'xatest'; |
| 20 |
XA PREPARE 'xatest'; |
| 21 |
include/sync_slave_sql_with_master.inc |
| 22 |
# Wait for XA_STATE to become PREPARED on slave |
| 23 |
# Expecting one prepared transaction |
| 24 |
XA RECOVER; |
| 25 |
formatID gtrid_length bqual_length data |
| 26 |
1 6 0 xatest |
| 27 |
---- XA COMMIT ---- |
| 28 |
[connection master] |
| 29 |
XA COMMIT 'xatest'; |
| 30 |
include/sync_slave_sql_with_master.inc |
| 31 |
# Wait for XA_STATE to become COMMITTED on slave |
| 32 |
# Expecting no prepared transactions |
| 33 |
XA RECOVER; |
| 34 |
formatID gtrid_length bqual_length data |
| 35 |
include/diff_tables.inc [master:t,slave:t] |
| 36 |
[connection master] |
| 37 |
DROP TABLE t; |
| 38 |
include/sync_slave_sql_with_master.inc |
| 39 |
include/rpl_reset.inc |
| 40 |
#################################################################### |
| 41 |
# Test Case 2: Enable Multithreaded Slave with replica_parallel_type as |
| 42 |
# DATABASE. Verify that slave displays appropriate XA_STATE in |
| 43 |
# performance schema table, post XA PREPARE AND XA COMMIT command |
| 44 |
# execution. |
| 45 |
#################################################################### |
| 46 |
[connection slave] |
| 47 |
SET @save_replica_parallel_workers=@@global.replica_parallel_workers; |
| 48 |
SET @replica_parallel_type=@@global.replica_parallel_type; |
| 49 |
include/stop_slave.inc |
| 50 |
SET GLOBAL replica_parallel_workers=4; |
| 51 |
SET GLOBAL replica_parallel_type='DATABASE'; |
| 52 |
include/start_slave.inc |
| 53 |
[connection slave] |
| 54 |
TRUNCATE TABLE performance_schema.events_transactions_current; |
| 55 |
---- Setup ---- |
| 56 |
[connection master] |
| 57 |
CREATE TABLE t ( f INT) ENGINE=INNODB; |
| 58 |
---- XA PREPARE ---- |
| 59 |
XA START 'xatest'; |
| 60 |
INSERT INTO t VALUES (10); |
| 61 |
XA END 'xatest'; |
| 62 |
XA PREPARE 'xatest'; |
| 63 |
include/sync_slave_sql_with_master.inc |
| 64 |
# Wait for XA_STATE to become PREPARED on slave |
| 65 |
# Expecting one prepared transaction |
| 66 |
XA RECOVER; |
| 67 |
formatID gtrid_length bqual_length data |
| 68 |
1 6 0 xatest |
| 69 |
---- XA COMMIT ---- |
| 70 |
[connection master] |
| 71 |
XA COMMIT 'xatest'; |
| 72 |
include/sync_slave_sql_with_master.inc |
| 73 |
# Wait for XA_STATE to become COMMITTED on slave |
| 74 |
# Expecting no prepared transactions |
| 75 |
XA RECOVER; |
| 76 |
formatID gtrid_length bqual_length data |
| 77 |
include/diff_tables.inc [master:t,slave:t] |
| 78 |
[connection master] |
| 79 |
DROP TABLE t; |
| 80 |
include/sync_slave_sql_with_master.inc |
| 81 |
include/rpl_reset.inc |
| 82 |
#################################################################### |
| 83 |
# Test Case 3: Enable Multithreaded Slave with replica_parallel_type as |
| 84 |
# LOGICAL_CLOCK. Verify that slave displays appropriate XA_STATE in |
| 85 |
# performance schema table, post XA PREPARE AND XA COMMIT command |
| 86 |
# execution. |
| 87 |
#################################################################### |
| 88 |
include/stop_slave.inc |
| 89 |
SET GLOBAL replica_parallel_workers=4; |
| 90 |
SET GLOBAL replica_parallel_type='LOGICAL_CLOCK'; |
| 91 |
include/start_slave.inc |
| 92 |
[connection slave] |
| 93 |
TRUNCATE TABLE performance_schema.events_transactions_current; |
| 94 |
---- Setup ---- |
| 95 |
[connection master] |
| 96 |
CREATE TABLE t ( f INT) ENGINE=INNODB; |
| 97 |
---- XA PREPARE ---- |
| 98 |
XA START 'xatest'; |
| 99 |
INSERT INTO t VALUES (10); |
| 100 |
XA END 'xatest'; |
| 101 |
XA PREPARE 'xatest'; |
| 102 |
include/sync_slave_sql_with_master.inc |
| 103 |
# Wait for XA_STATE to become PREPARED on slave |
| 104 |
# Expecting one prepared transaction |
| 105 |
XA RECOVER; |
| 106 |
formatID gtrid_length bqual_length data |
| 107 |
1 6 0 xatest |
| 108 |
---- XA COMMIT ---- |
| 109 |
[connection master] |
| 110 |
XA COMMIT 'xatest'; |
| 111 |
include/sync_slave_sql_with_master.inc |
| 112 |
# Wait for XA_STATE to become COMMITTED on slave |
| 113 |
# Expecting no prepared transactions |
| 114 |
XA RECOVER; |
| 115 |
formatID gtrid_length bqual_length data |
| 116 |
include/diff_tables.inc [master:t,slave:t] |
| 117 |
[connection master] |
| 118 |
DROP TABLE t; |
| 119 |
include/sync_slave_sql_with_master.inc |
| 120 |
[connection slave] |
| 121 |
include/stop_slave.inc |
| 122 |
set @@global.replica_parallel_workers= @save_replica_parallel_workers; |
| 123 |
set @@global.replica_parallel_type= @replica_parallel_type; |
| 124 |
include/start_slave.inc |
| 125 |
include/rpl_end.inc |