源码安装过程:http://blog.csdn.net/bamuta/article/details/47126709 1.查看现有的引擎 mysql> show engines; +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ | CSV | YES | CSV storage engine | NO | NO | NO | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ 2.查plugin_dir下确认有ha_federated.so mysql> show variables like '%plugin_dir%'; +---------------+------------------------------+ | Variable_name | Value | +---------------+------------------------------+ | plugin_dir | /usr/local/mysql/lib/plugin/ | +---------------+------------------------------+ [root@mysql01 ~]# cd /usr/local/mysql/lib/plugin/ [root@mysql01 plugin]# ls adt_null.so debug libdaemon_example.so semisync_master.so auth.so ha_archive.so mypluglib.so semisync_slave.so auth_socket.so ha_blackhole.so qa_auth_client.so auth_test_plugin.so ha_example.so qa_auth_interface.so daemon_example.ini ha_federated.so qa_auth_server.so 3.安装FEDERATED引擎 mysql> install plugin FEDERATED soname 'ha_federated.so'; mysql> show engines; +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ | CSV | YES | CSV storage engine | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ 4.启用FEDERATED引擎 [root@mysql01 ~]# vi /etc/my.cnf [mysqld] federated [root@mysql01 plugin]# service mysql restart Shutting down MySQL... [ OK ] Starting MySQL... [ OK ] mysql> show engines; +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ | CSV | YES | CSV storage engine | NO | NO | NO | | FEDERATED | YES | Federated MySQL storage engine | NO | NO | NO | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ 7 rows in set (0.00 sec)
mysql federated安装_源码安装的mysql新增federated引擎
最新推荐文章于 2023-08-19 23:15:22 发布