Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2, 1->3, 1->4, 1->5, 1->6, 1->7, 1->8, 1->9]
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 Warnings:
9 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
10 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.
11 Warnings:
12 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
13 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.
14 Warnings:
15 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
16 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.
17 Warnings:
18 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
19 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.
20 Warnings:
21 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
22 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.
23 Warnings:
24 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
25 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.
26 #
27 # 1. Initial data.
28 #
29 call mtr.add_suppression("Timeout waiting for reply of binlog");
30 CREATE TABLE t1(c1 INT);
31 include/rpl_sync.inc
32 #
33 # 2. Install semisync on all the 9 servers.
34 #
35 [connection server_1]
36 CALL mtr.add_suppression("Semi-sync source failed on net_flush.*");
37 include/install_semisync_source.inc
38 [connection server_2]
39 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
40 include/install_semisync_replica.inc
41 [connection server_3]
42 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
43 include/install_semisync_replica.inc
44 [connection server_4]
45 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
46 include/install_semisync_replica.inc
47 [connection server_5]
48 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
49 include/install_semisync_replica.inc
50 [connection server_6]
51 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
52 include/install_semisync_replica.inc
53 [connection server_7]
54 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
55 include/install_semisync_replica.inc
56 [connection server_8]
57 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
58 include/install_semisync_replica.inc
59 [connection server_9]
60 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
61 include/install_semisync_replica.inc
62 #
63 # 3. Make Master aware of 8 semisync slaves.
64 #
65 [connection server1_1]
66 SET GLOBAL rpl_semi_sync_source_wait_for_replica_count = 8;
67 #
68 # 4. Insert 1000 tuples in background using 10 parallel connections.
69 #
70 #
71 # 5. While the insert operations are going in the background, keep
72 # adding/removing semisync slaves randomly.
73 #
74 #
75 # 6. Add all 8 semisync slaves back to Master
76 # (if they were disconnected, in above step).
77 #
78 #
79 # 7. Make sure the data is synced on Master without any issues.
80 #
81 [connection server_1]
82 include/rpl_sync.inc
83 #
84 # 8. Check on all servers semisync is enabled after the
85 # the experiment and then uninstall semisync pluging
86 # from it.
87 #
88 [connection server_9]
89 include/assert.inc [ should be 1]
90 include/uninstall_semisync_replica.inc
91 [connection server_8]
92 include/assert.inc [ should be 1]
93 include/uninstall_semisync_replica.inc
94 [connection server_7]
95 include/assert.inc [ should be 1]
96 include/uninstall_semisync_replica.inc
97 [connection server_6]
98 include/assert.inc [ should be 1]
99 include/uninstall_semisync_replica.inc
100 [connection server_5]
101 include/assert.inc [ should be 1]
102 include/uninstall_semisync_replica.inc
103 [connection server_4]
104 include/assert.inc [ should be 1]
105 include/uninstall_semisync_replica.inc
106 [connection server_3]
107 include/assert.inc [ should be 1]
108 include/uninstall_semisync_replica.inc
109 [connection server_2]
110 include/assert.inc [ should be 1]
111 include/uninstall_semisync_replica.inc
112 [connection server_1]
113 include/assert.inc [ should be 1]
114 include/uninstall_semisync_source.inc
115 #
116 # 9. Cleanup time.
117 #
118 [connection server_1]
119 DROP TABLE t1;
120 include/rpl_end.inc