FEDERATED存储引擎的使用，如何开启FEDERATED，FEDERATED Support NO?

最新推荐文章于 2024-09-19 18:03:47 发布

e421083458

最新推荐文章于 2024-09-19 18:03:47 发布

阅读量6.3k

点赞数

分类专栏： Mysql

本文链接：https://blog.csdn.net/e421083458/article/details/39755513

版权

Mysql 专栏收录该内容

51 篇文章 0 订阅

订阅专栏

开启FEDERATED存储的方法如下：
1.查看是否安装了federated引擎

mysql> show engines;
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
5 rows in set (0.00 sec)

从中可以看出federated引擎没有开启.

2.开启federated引擎

vi /etc/my.cnf

在[mysqld]之后添加：

federated

3.安装federated存储引擎

mysql> install plugin federated soname 'ha_federated.so';
Query OK, 0 rows affected, 1 warning (0.07 sec)

4.查看是否安装了federated引擎

mysql> show engines;
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| FEDERATED  | YES     | Federated MySQL storage engine                             | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.00 sec)

5.创建表语句：

使用FEDERATED建表语句如下：

CREATE TABLE (......) ENGINE =FEDERATED CONNECTION='mysql://[name]:[pass]@[location]:[port]/[db-name]/[table-name]'