MySQL FEDERATED引擎使用示例, 类似Oracle DBLINK(二)
sql> show engines;
...
| FEDERATED | YES | Federated MySQL storage engine | NO | NO | NO |
...
--如果未启用, 先确保configure MySQL时加了--with-federated-storage-engine选项, 另外还确保启动mysqld时加了--federated参数,
或者在my.cnf里[mysqld]段后面加了federated参数, 如下, 然后重启mysqld:
--------------------------------
[mysqld]
federated
--------------------------------
--在某个库下建立FEDERATED引擎表:
mysql> create database db_test;
mysql> use db_test
mysql> CREATE TABLE tab_test_fed (
id int(20) NOT NULL auto_increment,
name varchar(32) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=FEDERATED connection = 'mysql://u_fed:iamwangnc@192.168.41.197:3306/db_fed/tab_test';
--测试是否可以访问:
mysql>
select * from tab_test_fed;
+----+-------+
| id | name |
+----+-------+
| 1 | test1 |
| 3 | 测试1 |
+----+-------+
--测试是否可以修改:
mysql> delete from tab_test_fed;
ERROR 1296 (HY000): Got error 10000 'Error on remote system: 1142: DROP command denied to user 'u_fed'@'comp196'
for table 'tab_test'' from FEDERATED