Debian Codegraph @

mysql-test/suite/rpl/r/rpl_dual_pos_advance.result

raw
1 include/rpl_init.inc [topology=1->2->1]
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 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 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.
8 create table t1 (n int);
9 include/sync_slave_sql_with_master.inc
10 include/stop_slave.inc
11 create table t2 (n int);
12 include/sync_slave_sql_with_master.inc
13 show tables;
14 Tables_in_test
15 t1
16 t2
17 create table t3 (n int) engine=innodb;
18 set @a=1;
19 insert into t3 values(@a);
20 begin;
21 insert into t3 values(2);
22 insert into t3 values(3);
23 commit;
24 insert into t3 values(4);
25 start slave until SOURCE_LOG_FILE="MASTER_LOG_FILE",SOURCE_LOG_POS=MASTER_LOG_POS;
26 Warnings:
27 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
28 Note 1278 It is recommended to use --skip-replica-start when doing step-by-step replication with START REPLICA UNTIL; otherwise, you will get problems if you get an unexpected replica's mysqld restart
29 include/wait_for_slave_sql_to_stop.inc
30 show tables;
31 Tables_in_test
32 t1
33 t2
34 start slave until SOURCE_LOG_FILE="MASTER_LOG_FILE",SOURCE_LOG_POS=MASTER_LOG_POS;
35 Warnings:
36 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
37 Note 1278 It is recommended to use --skip-replica-start when doing step-by-step replication with START REPLICA UNTIL; otherwise, you will get problems if you get an unexpected replica's mysqld restart
38 include/wait_for_slave_sql_to_stop.inc
39 select * from t3;
40 n
41 1
42 start slave until SOURCE_LOG_FILE="MASTER_LOG_FILE",SOURCE_LOG_POS=MASTER_LOG_POS;
43 Warnings:
44 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
45 Note 1278 It is recommended to use --skip-replica-start when doing step-by-step replication with START REPLICA UNTIL; otherwise, you will get problems if you get an unexpected replica's mysqld restart
46 include/wait_for_slave_sql_to_stop.inc
47 select * from t3;
48 n
49 1
50 2
51 3
52 include/start_slave.inc
53 create table t4 (n int);
54 create table t5 (n int);
55 create table t6 (n int);
56 include/sync_slave_sql_with_master.inc
57 include/sync_slave_sql_with_master.inc
58 show tables;
59 Tables_in_test
60 t1
61 t2
62 t3
63 t4
64 t5
65 t6
66 drop table t1, t2, t3, t4, t5, t6;
67 include/rpl_end.inc