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