1include/master-slave.inc 2Warnings: 3Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. 4Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 5[connection master] 6include/install_semisync.inc 7call mtr.add_suppression(".*Semi-sync master failed on net_flush.*before waiting for slave reply.*"); 8call mtr.add_suppression(".*Timeout waiting for reply of binlog .* semi-sync up to file .*"); 9include/sync_slave_sql_with_master.inc 10[connection slave] 11include/stop_slave.inc 12CHANGE MASTER TO MASTER_SSL = 1; 13include/start_slave.inc 14 15# Try replicating CREATE TABLE and verify that everything is fine. 16 17[connection master] 18USE test; 19CREATE TABLE table1 (a INT); 20include/sync_slave_sql_with_master.inc 21 22# STOP SLAVE and verify that replication works fine when slave resumes. 23 24include/stop_slave_io.inc 25[connection master] 26INSERT INTO table1 VALUES(1); 27[connection slave] 28include/start_slave_io.inc 29 30# RE-START SLAVE and execute on master, verify that replication works fine. 31 32[connection master] 33INSERT INTO table1 VALUES(2); 34include/sync_slave_sql_with_master.inc 35include/assert.inc [Slave should have 2 rows(1,2)] 36 37# Clean-up 38 39[connection master] 40DROP TABLE table1; 41include/sync_slave_sql_with_master.inc 42include/uninstall_semisync.inc 43include/stop_slave.inc 44CHANGE MASTER TO MASTER_SSL = 0; 45include/rpl_end.inc 46