Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_parallel.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 ==== Configure ====
7 ==== Initialize ====
8 connection slave;
9 include/stop_slave.inc
10 connection slave;
11 CREATE PROCEDURE show_slave_status ()
12 BEGIN
13 DECLARE name VARCHAR(100) DEFAULT('');
14 WHILE name = '' DO
15 SHOW SLAVE STATUS;
16 SELECT TABLE_NAME INTO name
17 FROM INFORMATION_SCHEMA.TABLES
18 WHERE TABLE_NAME = 't_end';
19 END WHILE;
20 END|
21 Warnings:
22 Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead
23 CREATE PROCEDURE read_gtid_executed ()
24 BEGIN
25 DECLARE name VARCHAR(100) DEFAULT('');
26 DECLARE temp VARCHAR(10000) DEFAULT('');
27 WHILE name = '' DO
28 SET temp = @@GLOBAL.GTID_EXECUTED;
29 SET temp = @@GLOBAL.GTID_OWNED;
30 SELECT TABLE_NAME INTO name
31 FROM INFORMATION_SCHEMA.TABLES
32 WHERE TABLE_NAME = 't_end';
33 END WHILE;
34 END|
35 connection master;
36 CREATE TABLE t1_1 (a INT) ENGINE = InnoDB;
37 CREATE TABLE t2_1 (a INT) ENGINE = InnoDB;
38 INSERT INTO t1_1 VALUES (0);
39 INSERT INTO t2_1 VALUES (0);
40 ==== Generate binary log ====
41 CREATE TABLE t_end (a INT);
42 ==== Apply the generated binary logs ====
43 ==== Wait for load to finish ====
44 connection slave;
45 ==== Check result ====
46 include/diff_tables.inc
47 connection slave;
48 ==== Clean up ====
49 connection master;
50 DROP TABLE t_end;
51 connection slave;
52 DROP TABLE t_end;
53 DROP PROCEDURE show_slave_status;
54 DROP PROCEDURE read_gtid_executed;
55 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;