刚刚接触federeate 引擎 , 想知道
1 他是否支持触发器 ??2 为什么我装了mysql-5.1.49-win32.msi show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+------------我已经在 my.ini 里加上了 [mysql]federated
但
show engines;还显示FEDERATED | NO 如何让 这个最新的版本支持FEDERATED
1 他是否支持触发器 ??2 为什么我装了mysql-5.1.49-win32.msi show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+------------我已经在 my.ini 里加上了 [mysql]federated
但
show engines;还显示FEDERATED | NO 如何让 这个最新的版本支持FEDERATED
做个试验就知道了。2 为什么我装了mysql-5.1.49-win32.msi
加在 [mysqld]
加在 [mysqld] -------------解决
现在测试 第1个
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), KEY name (name), KEY other_key (other)) ENGINE=FEDERATED
DEFAULT CHARSET=latin1 CONNECTION='mysql://lh:[email protected]:3306/test/test_table';成功
CREATE TABLE `federated_table1` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL DEFAULT '',
`other` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `other_key` (`other`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;CREATE TRIGGER `federated_table_insert` AFTER INSERT ON federated_table FOR EACH ROW BEGIN
IF NEW.id>0 THEN
insert into federated_table1 values
(NEW.id,NEW.name,new.other);
end if;
END; --------执行倒是成功倒是数据验证失败很遗憾 发现 这么好用的 东西 居然不支持触发器。 导致我的完美方案再次搁浅
他的优点就是相当于视图 (支持对远程表的 增加 删除 修改 )
(测试 过程 的过程下 有新发现
本地插入的federated_table能被federated_table1收录 (有效)
但 远程的 数据插入不能被federated_table1收录
)
支持 db级别 的事务日志
dblink ---federate
据说可以更改数据库名字其他 欢迎补充 。 我准别年内把当前的5.0升级到5.1
有在线应用的 欢迎支持 5.1.多少 是最稳定可靠的 ???
sqlsever oracle都支持视图索引的 ???/