Percona 5.7.11 装不了rocksdb Engine,故升级mysql版本到5.7到最高版本 27
我要装的mysql是从库
所以,设置主库nginx代理 到从库服务器相同端口,进行切换 此步可忽略
卸载并安装高版本 Percona-mysql-server 步骤如下:
1、查看yum 安装列表
yum list installed | grep Percona
2、停止mysql服务
需要先停掉 slave 同步
service mysql stop
3、删除 模块
yum remove Percona-Server-devel-57
yum remove Percona-Server-client-57
yum remove Percona-Server-shared-57
yum list installed | grep Percona
4、重新安装
yum install Percona-Server-devel-57.x86_64
yum install Percona-Server-client-57.x86_64
yum install Percona-Server-server-57.x86_64
注意:(centos7)这里遇到问题 centos 6.9 测试不会有问题:
The GPG keys listed for the "CentOS 7 - Percona" repository are already installed but they are not correct for this package
解决方案(据官网说是个bug):
yum install percona-release-0.1-7 && yum install percona-release
wget https://repo.percona.com/yum/PERCONA-PACKAGING-KEY && rpm --import PERCONA-PACKAGING-KEY
yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
yum list installed | grep Percona
5、安装 rocksdb engine
yum install Percona-Server-rocksdb-57.x86_64
yum list installed | grep Percona
6、启动mysql
service mysql start
启动 rocksdb
7、ps-admin --enable-rocksdb -u root -p
结束!
本文详细介绍了如何解决Percona 5.7.11无法安装RocksDB的问题,通过升级MySQL版本至5.7最高版,并提供了具体的卸载旧版本、安装新版本Percona MySQL Server的步骤,以及解决GPG密钥问题的方法。

被折叠的 条评论
为什么被折叠?



