CentOS:Percona安装：修订间差异

来自WHY42
←上一编辑
可视化wikitext
imported>Soleverlee
无编辑摘要
imported>Soleverlee
 
（未显示同一用户的1个中间版本）
第1行： 第1行：
=安装Percona=
在线安装：
在线安装：
<source lang="bash">
<source lang="bash">
第9行： 第10行：
wget https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.10-3/binary/redhat/7/x86_64/
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
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
</source>
</source>
<pre>
[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
</pre>
=启动MySQL=
<source lang="bash">
service mysql start
#centos 7
systemctl start mysql.service
grep password /var/log/mysqld.log
</source>
安装完成后，会生成一个随机的root密码：
<pre>
[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)
</pre>
[[Image:Persona_Hello.png|700px]]


[https://www.percona.com/doc/percona-server/5.7/installation/yum_repo.html OnlineDoc]
[https://www.percona.com/doc/percona-server/5.7/installation/yum_repo.html OnlineDoc]


[[Category:Linux/Unix]]
[[Category:Linux/Unix]]

2016年8月22日 (一) 03:41的最新版本

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

检索自“https://riguz.com/index.php?title=CentOS:Percona安装&oldid=1691”