CentOS:Percona安装
安装Percona
在线安装:
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
yum install
下载rpm包安装:
wget https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.10-3/binary/redhat/7/x86_64/
Percona-Server-5.7.10-3-r63dafaf-el7-x86_64-bundle.tar
tar xvf Percona-Server-5.7.10-3-r63dafaf-el7-x86_64-bundle.tar
yum remove mariadb*
rpm -ivh Percona-Server-server-57-5.7.10-3.1.el7.x86_64.rpm \
Percona-Server-client-57-5.7.10-3.1.el7.x86_64.rpm \
Percona-Server-shared-57-5.7.10-3.1.el7.x86_64.rpm \
Percona-Server-shared-compat-57-5.7.10-3.1.el7.x86_64.rpm
[root@bogon ~]# rpm -ivh Percona-Server-server-57-5.7.10-3.1.el7.x86_64.rpm \ Percona-Server-client-57-5.7.10-3.1.el7.x86_64.rpm \ Percona-Server-shared-57-5.7.10-3.1.el7.x86_64.rpm \ Percona-Server-shared-compat-57-5.7.10-3.1.el7.x86_64.rpm 警告:Percona-Server-server-57-5.7.10-3.1.el7.x86_64.rpm: 头V4 DSA/SHA1 Signature, 密钥 ID cd2efd2a: NOKEY 准备中... ################################# [100%] 正在升级/安装... 1:Percona-Server-shared-compat-57-5################################# [ 25%] 2:Percona-Server-shared-57-5.7.10-3################################# [ 50%] 3:Percona-Server-client-57-5.7.10-3################################# [ 75%] 4:Percona-Server-server-57-5.7.10-3################################# [100%] Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit. Run the following commands to create these functions: mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'" mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'" mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'" See http://www.percona.com/doc/percona-server/5.7/management/udf_percona_toolkit.html for more details
启动MySQL
service mysql start
#centos 7
systemctl start mysql.service
grep password /var/log/mysqld.log
安装完成后,会生成一个随机的root密码:
[root@bogon ~]# grep password /var/log/mysqld.log 2016-08-22T11:26:43.128029Z 1 [Note] A temporary password is generated for root@localhost: b+wsoev6py8L 2016-08-22T11:26:53.776524Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2016-08-22T11:27:03.777697Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)