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