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
结束!