Mysql如何在线安置其它引擎
|
这篇文章主要介绍Mysql如何在线安装其它引擎，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！ 需要在现有mysql中安装sphinx的存储引擎，要保证现有mysql运行的情况下完成。mysql也的确支持存储引擎的在线热插拔，下面介绍安装步骤： 1、查看现有mysql的运行版本 [root@localhost plugin]# mysqladmin -uroot -proot version Warning: Using a password on the command line interface can be insecure. mysqladmin Ver 8.42 Distrib 5.6.16, for Linux on x86_64 Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.6.16 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 1 day 6 hours 26 min 58 sec Threads: 1 Questions: 35 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.000 2、下载mysql和sphinx mysql：wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.16.tar.gz sphinx：http://sphinxsearch.com/downloads/release/ 进去后下载： Sphinx 2.1.7-release (r4638; Mar 30, 2014)Source tarball (tar.gz)2.1.7-release2.3MDownload 注意：mysql源码包的版本一定要与当前运行的mysql版本一致！ 解压 # tar -xzvf mysql-5.6.16.tar.gz # tar -xzvf sphinx-2.1.7-release.tar.gz 3、将sphinx-2.1.7-release下的mysqlse目录复制到mysql目录中 #cp -r sphinx-2.1.7-release/mysqlse/ mysql-5.6.16/storage/sphinx build # cd mysql-5.6.16 # sh BUILD/autorun.sh #./configure （此步可以需要yum一些依赖的软件包，否则会有错误或警告） # make 注意：这里到make这步即可，不用install 4、将make好的文件复制到当前运行的mysql目录中 [root@localhost sphinx]# pwd /u/opt/mysql-5.6.16/storage/sphinx cp ha_sphinx.so /usr/lib64/mysql/plugin/ 更改所有者（这边试不改也可以） # chown mysql.mysql /usr/lib64/mysql/plugin/* 注：我当前运行的mysql目录在/usr/local/mysql 5、登陆mysql加载sphinx引擎模块 mysql> show engines; +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ 9 rows in set (0.01 sec) mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; ERROR 1126 (HY000): Can't open shared library '/usr/lib64/mysql/plugin/ha_sphinx.so' (errno: 2 /usr/lib64/mysql/plugin/ha_sphinx.so: cannot open shared object file: No such file or directory) 这里ERROR发现第一次是ha_sphinx.so位置拷错了，拷正确后： mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; Query OK, 0 rows affected (0.05 sec) mysql> show engines; +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | SPHINX | YES | Sphinx storage engine 2.1.7-release | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ 10 rows in set (0.00 sec)
mysql> 安装完成！如果要卸载存储模块使用 mysql> UNINSTALL PLUGIN sphinx; 安装好后,过了几天: mysql> show engines; +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ 9 rows in set (0.00 sec) mysql> 不知道为什么找不到 SPHINX 引擎 只有重新安装一遍看,于是参考网上的: mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; ERROR 1062 (23000): Duplicate entry 'sphinx' for key 'PRIMARY' mysql> mysql> UNINSTALL PLUGIN sphinx; ERROR 1305 (42000): PLUGIN sphinx does not exist mysql> mysql> mysql> select * from mysql.plugin; +--------+--------------+ | name | dl | +--------+--------------+ | sphinx | ha_sphinx.so | +--------+--------------+ 1 row in set (0.00 sec) mysql> UNINSTALL PLUGIN sphinx; ERROR 1305 (42000): PLUGIN sphinx does not exist mysql> mysql> mysql> select * from mysql.plugin; +--------+--------------+ | name | dl | +--------+--------------+ | sphinx | ha_sphinx.so | +--------+--------------+ 1 row in set (0.00 sec) mysql> mysql> delete from mysql.plugin where name='SPHINX'; Query OK, 1 row affected (0.02 sec) mysql> mysql> mysql> select * from mysql.plugin; Empty set (0.00 sec) mysql> install plugin SPHINX soname 'ha_sphinx.so'; Query OK, 0 rows affected (0.00 sec) mysql> show engines; +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | SPHINX | YES | Sphinx storage engine 2.1.7-release | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ 10 rows in set (0.00 sec) mysql> 在开始安装之前,查检一下mysql.plugin表,里边是不是留有老版本的SPHINXSE没有完全清理掉. （编辑：汽车网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
