Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_ssl_semisync.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 include/install_semisync.inc
7 call mtr.add_suppression(".*Semi-sync source failed on net_flush.*before waiting for replica reply.*");
8 call mtr.add_suppression(".*Timeout waiting for reply of binlog .* semi-sync up to file .*");
9 include/sync_slave_sql_with_master.inc
10 [connection slave]
11 include/stop_slave.inc
12 CHANGE REPLICATION SOURCE TO SOURCE_SSL = 1;
13 include/start_slave.inc
14
15 # Try replicating CREATE TABLE and verify that everything is fine.
16
17 [connection master]
18 USE test;
19 CREATE TABLE table1 (a INT);
20 include/sync_slave_sql_with_master.inc
21
22 # STOP SLAVE and verify that replication works fine when slave resumes.
23
24 include/stop_slave_io.inc
25 [connection master]
26 INSERT INTO table1 VALUES(1);
27 [connection slave]
28 include/start_slave_io.inc
29
30 # RE-START SLAVE and execute on master, verify that replication works fine.
31
32 [connection master]
33 INSERT INTO table1 VALUES(2);
34 include/sync_slave_sql_with_master.inc
35 include/assert.inc [Slave should have 2 rows(1,2)]
36
37 # Clean-up
38
39 [connection master]
40 DROP TABLE table1;
41 include/sync_slave_sql_with_master.inc
42 include/uninstall_semisync.inc
43 include/stop_slave.inc
44 CHANGE REPLICATION SOURCE TO SOURCE_SSL = 0;
45 include/rpl_end.inc