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
|
include/master-slave.inc
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.
[connection master]
#
# 1. Create a table on the source and use Slap to apply load on the server
[connection master]
CREATE TABLE test.t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
#
# 2. Create 20 channels, 1 per second in the replica
[connection slave]
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_1' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_2' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_3' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_4' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_5' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_6' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_7' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_8' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_9' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_10' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_11' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_12' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_13' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_14' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_15' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_16' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_17' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_18' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_19' ;;
CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'h', SOURCE_PORT = 1 FOR CHANNEL 'channel_20' ;;
#
# 3. Check the data was replicated and 20 channel were created
include/assert.inc ['There are 21 channels in the replica']
#
# 4. Cleanup
RESET REPLICA ALL FOR CHANNEL 'channel_1' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_2' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_3' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_4' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_5' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_6' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_7' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_8' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_9' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_10' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_11' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_12' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_13' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_14' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_15' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_16' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_17' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_18' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_19' ;;
RESET REPLICA ALL FOR CHANNEL 'channel_20' ;;
[connection master]
DROP TABLE test.t1;
include/rpl_end.inc
|
