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 soname 'ha_spider.so';
|
|
create table t1_remote (i int) engine=MyISAM;
|
|
eval create table t1 (i int)
|
ENGINE=spider
|
COMMENT='database "test", table "t1_remote"'
|
CONNECTION='host "localhost", socket "$MASTER_MYSOCK", user "root", password "", prt "2000000"'
|
;
|
alter table t1 engine=myisam;
|