CentOS:Percona安装

来自WHY42
imported>Soleverlee2016年8月22日 (一) 03:38的版本

安装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)

OnlineDoc