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
|
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. Add six rows in
# performance_schema.replication_asynchronous_connection_failover
# table.
#
SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', 3101, 'net1');
asynchronous_connection_failover_add_source('ch1', '127.0.0.1', 3101, 'net1')
The UDF asynchronous_connection_failover_add_source() executed successfully.
Warnings:
Warning 4030 The parameter network_namespace is reserved for future use. Please use the CHANGE REPLICATION SOURCE command to set channel network_namespace parameter.
SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', 3102, 'net2');
asynchronous_connection_failover_add_source('ch1', '127.0.0.1', 3102, 'net2')
The UDF asynchronous_connection_failover_add_source() executed successfully.
Warnings:
Warning 4030 The parameter network_namespace is reserved for future use. Please use the CHANGE REPLICATION SOURCE command to set channel network_namespace parameter.
SELECT asynchronous_connection_failover_add_source('ch1', '192.168.0.1', 3101, 'net2', 40);
asynchronous_connection_failover_add_source('ch1', '192.168.0.1', 3101, 'net2', 40)
The UDF asynchronous_connection_failover_add_source() executed successfully.
Warnings:
Warning 4030 The parameter network_namespace is reserved for future use. Please use the CHANGE REPLICATION SOURCE command to set channel network_namespace parameter.
SELECT asynchronous_connection_failover_add_source('ch2', '127.0.0.1', 3102);
asynchronous_connection_failover_add_source('ch2', '127.0.0.1', 3102)
The UDF asynchronous_connection_failover_add_source() executed successfully.
SELECT asynchronous_connection_failover_add_source('ch2', '127.0.0.1', 3103);
asynchronous_connection_failover_add_source('ch2', '127.0.0.1', 3103)
The UDF asynchronous_connection_failover_add_source() executed successfully.
SELECT asynchronous_connection_failover_add_source('ch2', '192.168.0.1', 3101, 'net1', 40);
asynchronous_connection_failover_add_source('ch2', '192.168.0.1', 3101, 'net1', 40)
The UDF asynchronous_connection_failover_add_source() executed successfully.
Warnings:
Warning 4030 The parameter network_namespace is reserved for future use. Please use the CHANGE REPLICATION SOURCE command to set channel network_namespace parameter.
#
# 2. Checks for
# performance_schema.replication_asynchronous_connection_failover
# table.
#
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has no rows with channel_name="ch3"']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has six rows']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has three rows with channel_name="ch1"']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has two rows with channel_name="ch1" and host="127.0.0.1"']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has one row with channel_name="ch1" and host="127.0.0.1" and port=3101']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has no rows with channel_name="ch1" and host="127.0.0.1" and port=3101 and network_namespace="net0"']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has one row with channel_name="ch1" and host="192.168.0.1" and port=3101 and network_namespace=""']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has two rows with channel_name="ch1" and port=3101']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has two rows with host="192.168.0.1" and port=3101']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has two rows with host="192.168.0.1"']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has three rows with port=3101']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has two rows with network_namespace="net2"']
include/assert.inc ['The performance_schema.replication_asynchronous_connection_failover table has two rows with weight=40']
#
# 3. Cleanup
#
SELECT asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', 3101, 'net1');
asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', 3101, 'net1')
The UDF asynchronous_connection_failover_delete_source() executed successfully.
Warnings:
Warning 4030 The parameter network_namespace is reserved for future use. Please use the CHANGE REPLICATION SOURCE command to set channel network_namespace parameter.
SELECT asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', 3102, 'net2');
asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', 3102, 'net2')
The UDF asynchronous_connection_failover_delete_source() executed successfully.
Warnings:
Warning 4030 The parameter network_namespace is reserved for future use. Please use the CHANGE REPLICATION SOURCE command to set channel network_namespace parameter.
SELECT asynchronous_connection_failover_delete_source('ch1', '192.168.0.1', 3101, 'net2');
asynchronous_connection_failover_delete_source('ch1', '192.168.0.1', 3101, 'net2')
The UDF asynchronous_connection_failover_delete_source() executed successfully.
Warnings:
Warning 4030 The parameter network_namespace is reserved for future use. Please use the CHANGE REPLICATION SOURCE command to set channel network_namespace parameter.
SELECT asynchronous_connection_failover_delete_source('ch2', '127.0.0.1', 3102);
asynchronous_connection_failover_delete_source('ch2', '127.0.0.1', 3102)
The UDF asynchronous_connection_failover_delete_source() executed successfully.
SELECT asynchronous_connection_failover_delete_source('ch2', '127.0.0.1', 3103);
asynchronous_connection_failover_delete_source('ch2', '127.0.0.1', 3103)
The UDF asynchronous_connection_failover_delete_source() executed successfully.
SELECT asynchronous_connection_failover_delete_source('ch2', '192.168.0.1', 3101, 'net1');
asynchronous_connection_failover_delete_source('ch2', '192.168.0.1', 3101, 'net1')
The UDF asynchronous_connection_failover_delete_source() executed successfully.
Warnings:
Warning 4030 The parameter network_namespace is reserved for future use. Please use the CHANGE REPLICATION SOURCE command to set channel network_namespace parameter.
include/rpl_end.inc
|
