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
|
eval INSERT INTO mysql.spider_link_mon_servers
(db_name, table_name, link_id, sid, server, scheme, host, port, socket,
username, password, ssl_ca, ssl_capath, ssl_cert, ssl_cipher, ssl_key,
ssl_verify_server_cert, default_file, default_group) VALUES
('%auto_test%', '%a%', '%', $CHILD3_1_SERVER_ID, 's_3_1', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL),
('%auto_test%', '%a%', '%', $CHILD3_2_SERVER_ID, 's_3_2', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL),
('%auto_test%', '%a%', '%', $CHILD3_3_SERVER_ID, 's_3_3', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
let $MASTER_1_CHECK_LINK_STATUS=
SELECT db_name, table_name, link_id, link_status FROM mysql.spider_tables
ORDER BY db_name, table_name, link_id;
let $MASTER_1_CHECK_LINK_FAILED_LOG=
SELECT db_name, table_name, link_id FROM mysql.spider_link_failed_log;
let $MASTER_1_SET_RECOVERY_STATUS_2_1=
ALTER TABLE auto_test_remote.ha_r_2
COMMENT='srv "s_2_1 s_2_2", tbl "ta_r_2 ta_r3_2", lst "0 2"';
let $MASTER_1_SET_OK_STATUS_2_1=
ALTER TABLE auto_test_remote.ha_r_2
COMMENT='srv "s_2_1 s_2_2", tbl "ta_r_2 ta_r3_2", lst "0 1"';
let $MASTER_1_SET_OK_STATUS_AS_2_1=
ALTER TABLE auto_test_remote.as_r_2
COMMENT='srv "s_2_1 s_2_2", tbl "ta_r_2 ta_r3_2", lst "1 0"';
let $MASTER_1_COPY_TABLES_2_1=
SELECT spider_copy_tables('auto_test_remote.ha_r_2', '0', '1');
let $MASTER_1_COMMENT_HA_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "ha_r ha_r_2"';
let $MASTER_1_COMMENT_HA_AS_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "as_r as_r_2"';
let $MASTER_1_COMMENT_HA_P_2_1=
COMMENT='default_database "auto_test_remote"'
PARTITION BY KEY(a) (
PARTITION pt1 COMMENT='tnl "ha_r ha_r_2"',
PARTITION pt2 COMMENT='tnl "ha_r2 ha_r2_2"'
);
let $MASTER_1_COMMENT_HA_AS_P_2_1=
COMMENT='default_database "auto_test_remote"'
PARTITION BY KEY(a) (
PARTITION pt1 COMMENT='tnl "as_r as_r_2"',
PARTITION pt2 COMMENT='tnl "as_r2 as_r2_2"'
);
let $MASTER_1_SET_RECOVERY_STATUS_P_2_1=
ALTER TABLE auto_test_remote.ha_r2_2
COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2_2 ta_r4_2", lst "0 2"';
let $MASTER_1_SET_OK_STATUS_P_2_1=
ALTER TABLE auto_test_remote.ha_r2_2
COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2_2 ta_r4_2", lst "0 1"';
let $MASTER_1_SET_OK_STATUS_AS_P_2_1=
ALTER TABLE auto_test_remote.as_r2_2
COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2_2 ta_r4_2", lst "1 0"';
let $MASTER_1_COPY_TABLES_P_2_1=
SELECT spider_copy_tables('auto_test_remote.ha_r2_2', '0', '1');
USE auto_test_remote;
eval CREATE TABLE ha_r (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
PRIMARY KEY(a)
) $MASTER_1_HIDDEN_ENGINE $MASTER_1_HIDDEN_CHARSET
CONNECTION='msi "$CHILD3_1_SERVER_ID", mkd "2"'
COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3"';
eval CREATE TABLE as_r (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
PRIMARY KEY(a)
) $MASTER_1_HIDDEN_ENGINE $MASTER_1_HIDDEN_CHARSET
CONNECTION='msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1"'
COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3"';
eval CREATE TABLE ha_r_2 (
a INT DEFAULT 10,
c DATETIME DEFAULT '1999-10-10 10:10:10',
PRIMARY KEY(a)
) $MASTER_1_HIDDEN_ENGINE $MASTER_1_HIDDEN_CHARSET
CONNECTION='msi "$CHILD3_1_SERVER_ID", mkd "2"'
COMMENT='srv "s_2_1 s_2_2", tbl "ta_r_2 ta_r3_2"';
eval CREATE TABLE as_r_2 (
a INT DEFAULT 10,
c DATETIME DEFAULT '1999-10-10 10:10:10',
PRIMARY KEY(a)
) $MASTER_1_HIDDEN_ENGINE $MASTER_1_HIDDEN_CHARSET
CONNECTION='msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1"'
COMMENT='srv "s_2_1 s_2_2", tbl "ta_r_2 ta_r3_2"';
eval CREATE TABLE ha_r2 (
a INT DEFAULT 10,
c DATETIME DEFAULT '1999-10-10 10:10:10',
PRIMARY KEY(a)
) $MASTER_1_HIDDEN_ENGINE $MASTER_1_HIDDEN_CHARSET
CONNECTION='msi "$CHILD3_1_SERVER_ID", mkd "2"'
COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4"';
eval CREATE TABLE as_r2 (
a INT DEFAULT 10,
c DATETIME DEFAULT '1999-10-10 10:10:10',
PRIMARY KEY(a)
) $MASTER_1_HIDDEN_ENGINE $MASTER_1_HIDDEN_CHARSET
CONNECTION='msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1"'
COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4"';
eval CREATE TABLE ha_r2_2 (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
PRIMARY KEY(a)
) $MASTER_1_HIDDEN_ENGINE $MASTER_1_HIDDEN_CHARSET
CONNECTION='msi "$CHILD3_1_SERVER_ID", mkd "2"'
COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2_2 ta_r4_2"';
eval CREATE TABLE as_r2_2 (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
PRIMARY KEY(a)
) $MASTER_1_HIDDEN_ENGINE $MASTER_1_HIDDEN_CHARSET
CONNECTION='msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1"'
COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2_2 ta_r4_2"';
let $MASTER_1_CHECK_HA_STATUS=
SHOW STATUS LIKE 'Spider_mon_table_cache_version%';
let $MASTER_1_CHANGE_HA_MON=
SELECT spider_flush_table_mon_cache();
|