1--let $CHILD3_1_ENGINE_TYPE=Spider
2--let $CHILD3_1_ENGINE=ENGINE=Spider
3--source ../include/init_spider.inc
4eval INSERT INTO mysql.spider_link_mon_servers
5(db_name, table_name, link_id, sid, server, scheme, host, port, socket,
6 username, password, ssl_ca, ssl_capath, ssl_cert, ssl_cipher, ssl_key,
7 ssl_verify_server_cert, default_file, default_group) VALUES
8('%auto_test_local%', '%ta_l%', '%', $CHILD3_1_SERVER_ID, 's_3_1', NULL, NULL,
9 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL),
10('%auto_test_local%', '%ta_l%', '%', $CHILD3_2_SERVER_ID, 's_3_2', NULL, NULL,
11 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL),
12('%auto_test_local%', '%ta_l%', '%', $CHILD3_3_SERVER_ID, 's_3_3', NULL, NULL,
13 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
14let $CHILD3_1_CHECK_LINK_STATUS=
15  SELECT db_name, table_name, link_id, link_status FROM mysql.spider_tables
16  ORDER BY db_name, table_name, link_id;
17let $CHILD3_1_CHECK_LINK_FAILED_LOG=
18  SELECT db_name, table_name, link_id FROM mysql.spider_link_failed_log;
19let $CHILD3_1_SET_RECOVERY_STATUS_2_1=
20  ALTER TABLE ta_l
21  CONNECTION='host "localhost", user "root", password "",
22  msi "$CHILD3_1_SERVER_ID", mkd "2",
23  database "auto_test_remote auto_test_remote2", lst "0 2"';
24let $CHILD3_1_SET_OK_STATUS_2_1=
25  ALTER TABLE ta_l
26  CONNECTION='host "localhost", user "root", password "",
27  msi "$CHILD3_1_SERVER_ID", mkd "2",
28  database "auto_test_remote auto_test_remote2", lst "0 1"';
29let $CHILD3_1_SET_OK_STATUS_AS_2_1=
30  ALTER TABLE ta_l
31  CONNECTION='host "localhost", user "root", password "",
32  msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1",
33  database "auto_test_remote auto_test_remote2", lst "1 0"';
34
35let $CHILD3_1_DROP_TABLES_HA_2_1=
36  DROP TABLE IF EXISTS ta_l;
37if ($VERSION_COMPILE_OS_WIN)
38{
39  let $CHILD3_1_CREATE_TABLES_HA_2_1=
40    CREATE TABLE ta_l (
41      a INT DEFAULT 10,
42      b CHAR(1) DEFAULT 'c',
43      c DATETIME DEFAULT '1999-10-10 10:10:10',
44      PRIMARY KEY(a)
45    ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
46    COMMENT='port "$CHILD2_1_MYPORT $CHILD2_2_MYPORT", table "ta_r ta_r3"'
47    CONNECTION='host "localhost", user "root", password "",
48    msi "$CHILD3_1_SERVER_ID", mkd "2",
49    database "auto_test_remote auto_test_remote2"';
50  let $CHILD3_1_CREATE_TABLES_HA_AS_2_1=
51    CREATE TABLE ta_l (
52      a INT DEFAULT 10,
53      b CHAR(1) DEFAULT 'c',
54      c DATETIME DEFAULT '1999-10-10 10:10:10',
55      PRIMARY KEY(a)
56    ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
57    COMMENT='port "$CHILD2_1_MYPORT $CHILD2_2_MYPORT", table "ta_r ta_r3"'
58    CONNECTION='host "localhost", user "root", password "",
59    msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1",
60    database "auto_test_remote auto_test_remote2"';
61}
62if (!$VERSION_COMPILE_OS_WIN)
63{
64  let $CHILD3_1_CREATE_TABLES_HA_2_1=
65    CREATE TABLE ta_l (
66      a INT DEFAULT 10,
67      b CHAR(1) DEFAULT 'c',
68      c DATETIME DEFAULT '1999-10-10 10:10:10',
69      PRIMARY KEY(a)
70    ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
71    COMMENT='socket "$CHILD2_1_MYSOCK $CHILD2_2_MYSOCK", table "ta_r ta_r3"'
72    CONNECTION='host "localhost", user "root", password "",
73    msi "$CHILD3_1_SERVER_ID", mkd "2",
74    database "auto_test_remote auto_test_remote2"';
75  let $CHILD3_1_CREATE_TABLES_HA_AS_2_1=
76    CREATE TABLE ta_l (
77      a INT DEFAULT 10,
78      b CHAR(1) DEFAULT 'c',
79      c DATETIME DEFAULT '1999-10-10 10:10:10',
80      PRIMARY KEY(a)
81    ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
82    COMMENT='socket "$CHILD2_1_MYSOCK $CHILD2_2_MYSOCK", table "ta_r ta_r3"'
83    CONNECTION='host "localhost", user "root", password "",
84    msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1",
85    database "auto_test_remote auto_test_remote2"';
86}
87let $CHILD3_1_DROP_TABLES_HA_P_2_1=
88  DROP TABLE IF EXISTS ta_l2;
89let $CHILD3_1_CREATE_TABLES_HA_P_2_1=
90  CREATE TABLE ta_l2 (
91    a INT DEFAULT 10,
92    b CHAR(1) DEFAULT 'c',
93    c DATETIME DEFAULT '1999-10-10 10:10:10',
94    PRIMARY KEY(a)
95  ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
96  COMMENT='msi "$CHILD3_1_SERVER_ID", mkd "2"'
97  PARTITION BY KEY(a) (
98    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
99    priority "1000"',
100    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
101    priority "1000001"'
102  );
103let $CHILD3_1_CREATE_TABLES_HA_AS_P_2_1=
104  CREATE TABLE ta_l2 (
105    a INT DEFAULT 10,
106    b CHAR(1) DEFAULT 'c',
107    c DATETIME DEFAULT '1999-10-10 10:10:10',
108    PRIMARY KEY(a)
109  ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
110  COMMENT='msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1"'
111  PARTITION BY KEY(a) (
112    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
113    priority "1000"',
114    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
115    priority "1000001"'
116  );
117let $CHILD3_1_SET_RECOVERY_STATUS_P_2_1=
118  ALTER TABLE ta_l2
119  PARTITION BY KEY(a) (
120    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
121    priority "1000"',
122    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
123    priority "1000001", lst "0 2"'
124  );
125let $CHILD3_1_SET_OK_STATUS_P_2_1=
126  ALTER TABLE ta_l2
127  PARTITION BY KEY(a) (
128    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
129    priority "1000"',
130    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
131    priority "1000001", lst "0 1"'
132  );
133let $CHILD3_1_SET_OK_STATUS_AS_P_2_1=
134  ALTER TABLE ta_l2
135  PARTITION BY KEY(a) (
136    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
137    priority "1000"',
138    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
139    priority "1000001", lst "1 0"'
140  );
141