Debian Codegraph @

mysql-test/suite/rpl/r/rpl_xa_xplugin.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 CALL mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
7 [connection master]
8 [connection slave]
9 Starting the slave server
10 RUN CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_USER= 'root'
11
12 0 rows affected
13 RUN START SLAVE
14
15 0 rows affected
16 Mysqlx.Ok {
17 msg: "bye!"
18 }
19 ok
20 [connection master]
21 include/sync_slave_sql_with_master.inc
22 RUN USE test
23
24 0 rows affected
25 RUN CREATE TABLE T2 (C1 CHAR(20) PRIMARY KEY, C2 INT )
26
27 0 rows affected
28 RUN INSERT INTO T2 VALUES ('ABC',23)
29
30 1 rows affected
31 RUN UPDATE T2 SET C2 = C2 + 27
32
33 1 rows affected
34 Rows matched: 1 Changed: 1 Warnings: 0
35 RUN INSERT INTO T1 VALUES (4,34)
36
37 1 rows affected
38 RUN INSERT INTO T2 VALUES ('ABCDEF',23)
39
40 1 rows affected
41 RUN INSERT INTO T1 VALUES (5,1234)
42
43 1 rows affected
44 RUN INSERT INTO T2 VALUES ('ABCDEFGHIJ',23)
45
46 1 rows affected
47 RUN DELETE FROM T2 WHERE C1 = 'ABC'
48
49 1 rows affected
50 RUN INSERT INTO T2 VALUES ('XYZ',23)
51
52 1 rows affected
53 RUN UPDATE T2 SET C1 = 'ABC' WHERE C1 ='XYZ'
54
55 1 rows affected
56 Rows matched: 1 Changed: 1 Warnings: 0
57 Mysqlx.Ok {
58 msg: "bye!"
59 }
60 ok
61 Checking the value on T1
62 RUN SELECT C2 FROM test.T1 WHERE C1=1
63 Checking the value on T2
64 RUN SELECT C2 FROM test.T2 WHERE C1="ABC"
65 Mysqlx.Ok {
66 msg: "bye!"
67 }
68 ok
69 RUN USE test
70
71 0 rows affected
72 RUN DROP TABLE T2
73
74 0 rows affected
75 Mysqlx.Ok {
76 msg: "bye!"
77 }
78 ok
79 [connection master]
80 RUN USE test
81
82 0 rows affected
83 RUN DROP TABLE T1
84
85 0 rows affected
86 Mysqlx.Ok {
87 msg: "bye!"
88 }
89 ok
90 include/sync_slave_sql_with_master.inc
91 Stopping slave
92 RUN STOP SLAVE;
93
94 0 rows affected
95 Warnings generated:
96 WARNING | 1287 | 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
97 Mysqlx.Ok {
98 msg: "bye!"
99 }
100 ok
101 [connection master]
102 [connection slave]
103 include/start_slave.inc
104 include/rpl_end.inc