1let $VERSION_COMPILE_OS_WIN= 2 `SELECT IF(@@version_compile_os like 'Win%', 1, 0)`; 3if ($VERSION_COMPILE_OS_WIN) 4{ 5 INSTALL PLUGIN spider SONAME 'ha_spider.dll'; 6 if ($MASTER_1_MYPORT) 7 { 8 eval CREATE SERVER s_1 FOREIGN DATA WRAPPER mysql OPTIONS ( 9 HOST 'localhost', 10 DATABASE 'auto_test_local', 11 USER 'root', 12 PASSWORD '', 13 PORT $MASTER_1_MYPORT 14 ); 15 } 16 if ($CHILD2_1_MYPORT) 17 { 18 eval CREATE SERVER s_2_1 FOREIGN DATA WRAPPER mysql OPTIONS ( 19 HOST 'localhost', 20 DATABASE 'auto_test_remote', 21 USER 'root', 22 PASSWORD '', 23 PORT $CHILD2_1_MYPORT 24 ); 25 } 26 if ($CHILD2_2_MYPORT) 27 { 28 eval CREATE SERVER s_2_2 FOREIGN DATA WRAPPER mysql OPTIONS ( 29 HOST 'localhost', 30 DATABASE 'auto_test_remote2', 31 USER 'root', 32 PASSWORD '', 33 PORT $CHILD2_2_MYPORT 34 ); 35 } 36 if ($CHILD2_3_MYPORT) 37 { 38 eval CREATE SERVER s_2_3 FOREIGN DATA WRAPPER mysql OPTIONS ( 39 HOST 'localhost', 40 DATABASE 'auto_test_remote3', 41 USER 'root', 42 PASSWORD '', 43 PORT $CHILD2_3_MYPORT 44 ); 45 } 46 if ($CHILD3_1_MYPORT) 47 { 48 eval CREATE SERVER s_3_1 FOREIGN DATA WRAPPER mysql OPTIONS ( 49 HOST 'localhost', 50 DATABASE 'auto_test_local', 51 USER 'root', 52 PASSWORD '', 53 PORT $CHILD3_1_MYPORT 54 ); 55 } 56 if ($CHILD3_2_MYPORT) 57 { 58 eval CREATE SERVER s_3_2 FOREIGN DATA WRAPPER mysql OPTIONS ( 59 HOST 'localhost', 60 DATABASE 'auto_test_local', 61 USER 'root', 62 PASSWORD '', 63 PORT $CHILD3_2_MYPORT 64 ); 65 } 66 if ($CHILD2_3_MYPORT) 67 { 68 eval CREATE SERVER s_3_3 FOREIGN DATA WRAPPER mysql OPTIONS ( 69 HOST 'localhost', 70 DATABASE 'auto_test_local', 71 USER 'root', 72 PASSWORD '', 73 PORT $CHILD2_3_MYPORT 74 ); 75 } 76} 77if (!$VERSION_COMPILE_OS_WIN) 78{ 79 INSTALL PLUGIN spider SONAME 'ha_spider.so'; 80 if ($MASTER_1_MYSOCK) 81 { 82 eval CREATE SERVER s_1 FOREIGN DATA WRAPPER mysql OPTIONS ( 83 HOST 'localhost', 84 DATABASE 'auto_test_local', 85 USER 'root', 86 PASSWORD '', 87 SOCKET '$MASTER_1_MYSOCK' 88 ); 89 } 90 if ($CHILD2_1_MYSOCK) 91 { 92 eval CREATE SERVER s_2_1 FOREIGN DATA WRAPPER mysql OPTIONS ( 93 HOST 'localhost', 94 DATABASE 'auto_test_remote', 95 USER 'root', 96 PASSWORD '', 97 SOCKET '$CHILD2_1_MYSOCK' 98 ); 99 } 100 if ($CHILD2_2_MYSOCK) 101 { 102 eval CREATE SERVER s_2_2 FOREIGN DATA WRAPPER mysql OPTIONS ( 103 HOST 'localhost', 104 DATABASE 'auto_test_remote2', 105 USER 'root', 106 PASSWORD '', 107 SOCKET '$CHILD2_2_MYSOCK' 108 ); 109 } 110 if ($CHILD2_3_MYSOCK) 111 { 112 eval CREATE SERVER s_2_3 FOREIGN DATA WRAPPER mysql OPTIONS ( 113 HOST 'localhost', 114 DATABASE 'auto_test_remote3', 115 USER 'root', 116 PASSWORD '', 117 SOCKET '$CHILD2_3_MYSOCK' 118 ); 119 } 120 if ($CHILD3_1_MYSOCK) 121 { 122 eval CREATE SERVER s_3_1 FOREIGN DATA WRAPPER mysql OPTIONS ( 123 HOST 'localhost', 124 DATABASE 'auto_test_local', 125 USER 'root', 126 PASSWORD '', 127 SOCKET '$CHILD3_1_MYSOCK' 128 ); 129 } 130 if ($CHILD3_2_MYSOCK) 131 { 132 eval CREATE SERVER s_3_2 FOREIGN DATA WRAPPER mysql OPTIONS ( 133 HOST 'localhost', 134 DATABASE 'auto_test_local', 135 USER 'root', 136 PASSWORD '', 137 SOCKET '$CHILD3_2_MYSOCK' 138 ); 139 } 140 if ($CHILD3_3_MYSOCK) 141 { 142 eval CREATE SERVER s_3_3 FOREIGN DATA WRAPPER mysql OPTIONS ( 143 HOST 'localhost', 144 DATABASE 'auto_test_local', 145 USER 'root', 146 PASSWORD '', 147 SOCKET '$CHILD3_3_MYSOCK' 148 ); 149 } 150} 151 152let $SERVER_NAME= 153 `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(version(), '-', 2), '-', -1)`; 154if (`SELECT IF('$SERVER_NAME' REGEXP '^[0-9]+\$', 1, 0)`) 155{ 156 let $SERVER_NAME= 157 `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(version(), '-', 3), '-', -1)`; 158} 159let $SERVER_MAJOR_VERSION= 160 `SELECT SUBSTRING_INDEX(version(), '.', 1)`; 161let $SERVER_MINOR_VERSION= 162 `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(version(), '.', 2), '.', -1)`; 163let $PLUGIN_VERSION= 164 `SELECT SUBSTRING_INDEX(plugin_version, '.', 1) 165 FROM information_schema.plugins 166 WHERE plugin_name = 'SPIDER'`; 167if (`SELECT IF($PLUGIN_VERSION = 3, 1, 0)`) 168{ 169 let $HAS_REWRITE= 170 `SELECT IF (STRCMP('$SERVER_NAME', 'MariaDB') = 0, 171 IF ($SERVER_MAJOR_VERSION = 10, 172 IF ($SERVER_MINOR_VERSION < 4, 0, 1), 173 IF ($SERVER_MAJOR_VERSION < 10, 0, 1)), 174 0)`; 175 let $HAS_REWRITE= 0; 176 if ($HAS_REWRITE) 177 { 178 let $PLUGIN_NAME= spider_flush_rewrite_cache; 179 let $PLUGIN_EXIST= 180 `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`; 181 while (!$PLUGIN_EXIST) 182 { 183 let $PLUGIN_EXIST= 184 `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`; 185 } 186 } 187} 188let $PLUGIN_NAME= spider_flush_table_mon_cache; 189let $PLUGIN_EXIST= 190 `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`; 191while (!$PLUGIN_EXIST) 192{ 193 let $PLUGIN_EXIST= 194 `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`; 195} 196 197SET spider_internal_sql_log_off= 0; 198