DROP TABLE IF EXISTS mysql.spider_xa;
|
CREATE TABLE mysql.spider_xa(
|
format_id int not null default 0,
|
gtrid_length int not null default 0,
|
bqual_length int not null default 0,
|
data char(128) charset binary not null default '',
|
status char(8) not null default '',
|
PRIMARY KEY (data, format_id, gtrid_length),
|
KEY idx1 (status)
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
DROP TABLE IF EXISTS mysql.spider_xa_member;
|
CREATE TABLE mysql.spider_xa_member(
|
format_id int not null default 0,
|
gtrid_length int not null default 0,
|
bqual_length int not null default 0,
|
data char(128) charset binary not null default '',
|
scheme char(64) not null default '',
|
host char(64) not null default '',
|
port char(5) not null default '',
|
socket text not null default '',
|
username char(64) not null default '',
|
password char(64) not null default '',
|
ssl_ca text default null,
|
ssl_capath text default null,
|
ssl_cert text default null,
|
ssl_cipher char(64) default null,
|
ssl_key text default null,
|
ssl_verify_server_cert tinyint not null default 0,
|
default_file text default null,
|
default_group char(64) default null,
|
KEY idx1 (data, format_id, gtrid_length, host)
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
DROP TABLE IF EXISTS mysql.spider_tables;
|
CREATE TABLE mysql.spider_tables(
|
db_name char(64) not null default '',
|
table_name char(64) not null default '',
|
link_id int not null default 0,
|
priority bigint not null default 0,
|
server char(64) default null,
|
scheme char(64) default null,
|
host char(64) default null,
|
port char(5) default null,
|
socket text default null,
|
username char(64) default null,
|
password char(64) default null,
|
ssl_ca text default null,
|
ssl_capath text default null,
|
ssl_cert text default null,
|
ssl_cipher char(64) default null,
|
ssl_key text default null,
|
ssl_verify_server_cert tinyint not null default 0,
|
default_file text default null,
|
default_group char(64) default null,
|
tgt_db_name char(64) default null,
|
tgt_table_name char(64) default null,
|
link_status tinyint not null default 1,
|
PRIMARY KEY (db_name, table_name, link_id),
|
KEY idx1 (priority)
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
DROP TABLE IF EXISTS mysql.spider_link_mon_servers;
|
CREATE TABLE mysql.spider_link_mon_servers(
|
db_name char(64) not null default '',
|
table_name char(64) not null default '',
|
link_id char(5) not null default '',
|
sid int not null default 0,
|
server char(64) default null,
|
scheme char(64) default null,
|
host char(64) default null,
|
port char(5) default null,
|
socket text default null,
|
username char(64) default null,
|
password char(64) default null,
|
ssl_ca text default null,
|
ssl_capath text default null,
|
ssl_cert text default null,
|
ssl_cipher char(64) default null,
|
ssl_key text default null,
|
ssl_verify_server_cert tinyint not null default 0,
|
default_file text default null,
|
default_group char(64) default null,
|
PRIMARY KEY (db_name, table_name, link_id, sid)
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
DROP TABLE IF EXISTS mysql.spider_link_failed_log;
|
CREATE TABLE mysql.spider_link_failed_log(
|
db_name char(64) not null default '',
|
table_name char(64) not null default '',
|
link_id int not null default 0,
|
failed_time timestamp not null default current_timestamp
|
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
install plugin spider soname 'ha_spider.so';
|
eval create temporary table t1 (i int) ENGINE=spider;
|