MySql引擎FEDERATED

启用此插件

# 在mysql.ini中
[mysqld]
federated=1

# 在mysqld中
mysqld ... --federated ...

使用engine = FEDERATED 建表

# 直接使用connection字符串
CREATE TABLE federated_table (
 id     INT(20) NOT NULL AUTO_INCREMENT,
 name   VARCHAR(32) NOT NULL DEFAULT '',
 other  INT(20) NOT NULL DEFAULT '0',
 PRIMARY KEY  (id),
 INDEX name (name),
 INDEX other_key (other)
)
ENGINE=FEDERATED
DEFAULT CHARSET=utf8mb4
CONNECTION='mysql://fed_user@remote_host:9306/federated/test_table';
#           scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name

# 使用 server配置
CREATE SERVER fedlink
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'fed_user', HOST 'remote_host', PORT 9306, DATABASE 'federated');

CREATE TABLE test_table (
    id     INT(20) NOT NULL AUTO_INCREMENT,
    name   VARCHAR(32) NOT NULL DEFAULT '',
    other  INT(20) NOT NULL DEFAULT '0',
    PRIMARY KEY  (id),
    INDEX name (name),
    INDEX other_key (other)
)
ENGINE=FEDERATED
DEFAULT CHARSET=utf8mb4
CONNECTION='fedlink/test_table';