# apt install mariadb-plugin-spider\r\n# wget https:\/\/github.com\/xiezhenye\/mysql-plugin-spider-engine\/raw\/master\/src\/scripts\/install_spider.sql<\/pre>\n\u5b89\u88dd Spider \u5b58\u5132\u5f15\u64ce<\/p>\n
# mysql -u root -p < install_spider.sql\r\n@have_spider_plugin := 1\r\n1\r\n@have_spider_i_s_alloc_mem_plugin := 1\r\n1\r\n@have_spider_direct_sql_udf := 1\r\n1\r\n@have_spider_bg_direct_sql_udf := 1\r\n1\r\n@have_spider_ping_table_udf := 1\r\n1\r\n@have_spider_copy_tables_udf := 1\r\n1\r\n@have_spider_flush_table_mon_cache_udf := 1\r\n1<\/pre>\n\u67e5\u8a62 SPIDER \u5b58\u5132\u5f15\u64ce\u662f\u5426\u652f\u63f4<\/p>\n
# mysql -e 'SELECT engine, support, transactions, xa FROM information_schema.engines;'\r\n+--------------------+---------+--------------+------+\r\n| engine | support | transactions | xa |\r\n+--------------------+---------+--------------+------+\r\n| SPIDER | YES | YES | NO |\r\n| MRG_MyISAM | YES | NO | NO |\r\n| MEMORY | YES | NO | NO |\r\n| Aria | YES | NO | NO |\r\n| MyISAM | YES | NO | NO |\r\n| SEQUENCE | YES | YES | NO |\r\n| InnoDB | DEFAULT | YES | YES |\r\n| PERFORMANCE_SCHEMA | YES | NO | NO |\r\n| CSV | YES | NO | NO |\r\n+--------------------+---------+--------------+------+\r\n9 rows in set (0.000 sec)<\/pre>\n--<\/p>\n
\u8a2d\u5b9a<\/h2>\n
172.16.1.175 - Spider \u4e3b\u6a5f<\/p>\n
CREATE SERVER backend1 FOREIGN DATA WRAPPER mysql \r\nOPTIONS(\r\n HOST '172.16.1.170',\r\n DATABASE 'test',\r\n USER 'spider',\r\n PASSWORD 'spider',\r\n PORT 3306\r\n);\r\n\r\nCREATE SERVER backend2 FOREIGN DATA WRAPPER mysql \r\nOPTIONS(\r\n HOST '172.16.1.173',\r\n DATABASE 'test',\r\n USER 'spider',\r\n PASSWORD 'spider',\r\n PORT 3306\r\n);<\/pre>\n\u66f4\u65b0<\/p>\n
FLUSH TABLES;<\/pre>\n\u5efa\u7acb\u5206\u8868\u898f\u5247<\/p>\n
create table opportunities (\r\n id int,\r\n accountName varchar(20),\r\n name varchar(128),\r\n owner varchar(7),\r\n amount decimal(10,2),\r\n closeDate date,\r\n stageName varchar(11),\r\n primary key (id),\r\n key (accountName)\r\n) engine=spider COMMENT='wrapper \"mysql\", table \"opportunities\"'\r\n PARTITION BY HASH (id)\r\n(\r\n PARTITION pt1 COMMENT = 'srv \"backend1\"',\r\n PARTITION pt2 COMMENT = 'srv \"backend2\"'\r\n) ;<\/pre>\n172.16.1.170 - backend1<\/p>\n
create table opportunities (\r\nid int,\r\naccountName varchar(20),\r\nname varchar(128),\r\nowner varchar(7),\r\namount decimal(10,2),\r\ncloseDate date,\r\nstageName varchar(11),\r\nprimary key (id),\r\nkey (accountName)\r\n) engine=InnoDB;<\/pre>\n172.16.1.173 - backend2<\/p>\n
create table opportunities (\r\nid int,\r\naccountName varchar(20),\r\nname varchar(128),\r\nowner varchar(7),\r\namount decimal(10,2),\r\ncloseDate date,\r\nstageName varchar(11),\r\nprimary key (id),\r\nkey (accountName)\r\n) engine=InnoDB;<\/pre>\n\u5f9e Spider \u4e3b\u6a5f\u57f7\u884c\u8cc7\u6599\u5eab\u8b80\u5beb\uff0c<\/p>\n
![\"\"](\"https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2021\/10\/20211022_165816-300x285.png\")
<\/a><\/p>\n