mysql dblink另类实现

SQL>install plugin federated soname 'ha_federated.so';

my.cny 里[mysqld]后面增加federated

show engines;看到支持FEDERATED

被读的数据库开放权限

grant select on open_kslws_com.* to du213@'192.168.4.213'identified by '***';

创建table

create table a（）ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://user:pass@192.168.4.211:3306/database/table

查询必用索引，否则很慢