Mysql如何在線安裝其它引擎

140次閱讀

沒有評(píng)論

共計(jì) 7746 個(gè)字符，預(yù)計(jì)需要花費(fèi) 20 分鐘才能閱讀完成。

這篇文章主要介紹 Mysql 如何在線安裝其它引擎，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！

mysql 在線安裝 sphinx 存儲(chǔ)引擎

需要在現(xiàn)有 mysql 中安裝 sphinx 的存儲(chǔ)引擎，要保證現(xiàn)有 mysql 運(yùn)行的情況下完成。mysql 也的確支持存儲(chǔ)引擎的在線熱插拔，下面介紹安裝步驟：

1、查看現(xiàn)有 mysql 的運(yùn)行版本

[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

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/ 進(jìn)去后下載：

Sphinx 2.1.7-release (r4638; Mar 30, 2014)
Source tarball (tar.gz)
2.1.7-release
2.3M
Download

注意：mysql 源碼包的版本一定要與當(dāng)前運(yùn)行的 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 目錄復(fù)制到 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 一些依賴的軟件包，否則會(huì)有錯(cuò)誤或警告）

# make

注意：這里到 make 這步即可，不用 install

4、將 make 好的文件復(fù)制到當(dāng)前運(yùn)行的 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/*

注：我當(dāng)前運(yùn)行的 mysql 目錄在 /usr/local/mysql

5、登陸 mysql 加載 sphinx 引擎模塊

mysql show engines;

+——————–+———+—————————————————————-+————–+——+————+

+——————–+———+—————————————————————-+————–+——+————+

| 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 |

| 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 發(fā)現(xiàn)第一次是 ha_sphinx.so 位置拷錯(cuò)了，拷正確后：

mysql INSTALL PLUGIN sphinx SONAME ha_sphinx.so

Query OK, 0 rows affected (0.05 sec)

mysql show engines;

+——————–+———+—————————————————————-+————–+——+————+

+——————–+———+—————————————————————-+————–+——+————+

| 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 |

| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |

+——————–+———+—————————————————————-+————–+——+————+

10 rows in set (0.00 sec)

mysql

安裝完成！如果要卸載存儲(chǔ)模塊使用

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 引擎

只有重新安裝一遍看, 于是參考網(wǎng)上的:

mysql INSTALL PLUGIN sphinx SONAME ha_sphinx.so
ERROR 1062 (23000): Duplicate entry sphinx for key PRIMARY
mysql

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 沒有完全清理掉.

以上是“Mysql 如何在線安裝其它引擎”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注丸趣 TV 行業(yè)資訊頻道！

正文完