mysql8.0中的dblink
1. 确保target到source端的数据库端口是通的
2. 查看target端中federated插件是否安装并启动(mysql8.0默认已安装,但未启动)
mysql> show engines;
±-------------------±--------±---------------------------------------------------------------±-------------±-----±------
| Engine | Support | Comment | Transactions | XA | Savepoints |
±-------------------±--------±---------------------------------------------------------------±-------------±-----±------
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
3. 配置启动federated插件
(1)、在 /etc/my.cnf中 [mysqd]下添加下面参数,并
federated
(2)、重新启动target端的mysql服务
service mysqld restart
4. 创建server(须知source端数据库信息)
CREATE SERVER servername
FOREIGN DATA WRAPPER mysql OPTIONS ( HOST ‘source服务器IP’, PORT source数据库端口, USE