1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
#
# 0. Create asynchronous replication topology between server 1 and 2
#.
include/rpl_init.inc [topology=1->2->1]
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
#
# 1. On server1 enable option `xa_detach_on_prepare` for current session.
#.
[connection server_1]
SET @@session.xa_detach_on_prepare=1;
include/assert.inc [The value of xa_detach_on_prepare should be 1]
#
# 2. On server1 create a table.
#
#
[connection server_1]
CREATE TABLE t1 (a INT) ENGINE = InnoDB;
include/rpl_sync.inc
#
# 3. On server1 create and prepare an XA transaction which inserts a value on
# the table.
[connection server_1]
FLUSH LOGS;
XA START 'trx1';
INSERT INTO t1 VALUES (1);
XA END 'trx1';
XA PREPARE 'trx1';
include/rpl_sync.inc
#
# 4. On server2 commit the XA transaction.
#
[connection server_2]
XA COMMIT 'trx1';
XA RECOVER;
formatID gtrid_length bqual_length data
include/rpl_sync.inc
#
# 5. Verify that insert was replicated to server1.
#
[connection server_1]
#
# 6. Clean up
#
[connection server_1]
SET @@session.xa_detach_on_prepare=0;
[connection server_1]
DROP TABLE t1;
include/rpl_sync.inc
include/rpl_end.inc
|
