如何使用rpm包方式安装Percona server

这篇文章主要介绍了如何使用rpm包方式安装Percona server，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。Percona XtraDB是 InnoDB 存储引擎的增强版，被设计用来更好的使用更新计算机硬件系统的性能，同时还包含有一些在高性能环境下的新特性。XtraDB 存储引擎是完全的向下兼容，于是完全可以使用XtraDB来替代InnoDB存储引擎。Percona XtraDB 包含有所有 InnoDB’s 健壮性，可依赖的 ACID 兼容设计和高级 MVCC 架构。XtraDB 在 InnoDB 的坚实基础上构建，使 XtraDB 具有更多的特性，更好调用，更多的参数指标和更多的扩展。尤其是，XtraDB 被设计用来在多核心的条件下更有效的使用内存和更加方便，更加可用。也解除了InnoDB的很多限制；提供了比InnoDB更多的配置和性能监控参数。Percona XtraDB engine包含在Percona Server and MariaDB中。Percona Server跟MySQL一样有多种安装方法：yum Repositories、rpm、Binary Tarball、Source Tarball、Git Source Tree等，可以根据实际环境选择，具体安装步骤请参考官方文档。下文主要以rpm包在RHEL 6上的安装为例说明主要步骤wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.29-76.2/binary/redhat/6/x86_64/Percona-Server-5.6.29-76.2-rddf26fe-el6-x86_64-bundle.tar]# tar -xvf Percona-Server-5.6.29-76.2-rddf26fe-el6-x86_64-bundle.tar]# ls *.rpmPercona-Server-56-debuginfo-5.6.29-rel76.2.el6.x86_64.rpmPercona-Server-server-56-5.6.29-rel76.2.el6.x86_64.rpmPercona-Server-tokudb-56-5.6.29-rel76.2.el6.x86_64.rpmPercona-Server-client-56-5.6.29-rel76.2.el6.x86_64.rpmPercona-Server-shared-56-5.6.29-rel76.2.el6.x86_64.rpmPercona-Server-devel-56-5.6.29-rel76.2.el6.x86_64.rpmPercona-Server-test-56-5.6.29-rel76.2.el6.x86_64.rpm]#rpm -ivh Percona-Server-server-56-5.6.29-rel76.2.el6.x86_64.rpm Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64.rpm Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64.rpm#以上三个rpm包仅仅为了完成Percona server的安装#若需要（包含debugging, testing,etc等）,则直接安装所有的rpm包即可]#rpm -ivh 免费主机域名*.rpm附：RHEL6上安装报错：libcrypto.so.10和libssl.so.10error: Failed dependencies: libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64 libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64 libcrypto.so.10(libcrypto.so.10)(64bit) is needed by Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64 libssl.so.10(libssl.so.10)(64bit) is needed by Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64#RedHat EL6自带openssl-1.0.0版本，对于Percona-Server应该安装openssl-1.0.1的版本，安装新版本后，问题解决]# rpm -ivh openssl10-libs-1.0.1e-1.ius.el6.x86_64.rpm –force免费主机域名warning: openssl10-libs-1.0.1e-1.ius.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 9cd4953f: NOKEYPreparing… ########################################### [100%] 1:openssl10-libs ########################################### [100%]Percona Server默认的数据文件路径在/var/lib/mysql/下#编辑配置文件/etc/my.cnf]# cat /etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socklog-error=/var/log/mysqld.loginnodb_buffer_pool_size = 128M注：配置文件有很多选项，具体的根据实际需求配置，此处只是简单配置了下而已]# /etc/init.d/mysql startStarting MySQL (Percona Server)………….[ OK ]]# /etc/init.d/mysql statusMySQL (Percona Server) running (3369)[ OK ]]# /etc/init.d/mysql stopShutting down MySQL (Percona Server)..[ OK ]]# /etc/init.d/mysql restartShutting down MySQL (Percona Server)..[ OK ]Starting MySQL (Percona Server)…..[ OK ]]# tail -f /var/log/mysqld.log2016-05-03 16:28:23 3595 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 16260072016-05-03 16:28:23 3595 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.2016-05-03 16:28:23 3595 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.2016-05-03 16:28:23 3595 [Note] Server hostname (bind-address): ‘*’; port: 33062016-05-03 16:28:23 3595 [Note] IPv6 is available.2016-05-03 16:28:23 3595 [Note] – ‘::’ resolves to ‘::’;2016-05-03 16:28:23 3595 [Note] Server socket created on IP: ‘::’.2016-05-03 16:28:23 3595 [Note] Event Scheduler: Loaded 0 events2016-05-03 16:28:23 3595 [Note] /usr/sbin/mysqld: ready for connections.Version: ‘5.6.29-76.2’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona Server (GPL), Release 76.2, Revision ddf26fe]# /etc/init.d/mysql stopShutting down MySQL (Percona Server)..[ OK ]]# rpm -qa|grep -i perconaPercona-Server-client-56-5.6.29-rel76.2.el6.x86_64Percona-Server-server-56-5.6.29-rel76.2.el6.x86_64Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64]# rpm -e Percona-Server-client-56-5.6.29-rel76.2.el6.x86_64 Percona-Server-server-56-5.6.29-rel76.2.el6.x86_64 Percona-Server-shared-56-5.6.29-rel76.2.el6.x86_64]# rpm -qa|grep -i percona]# rm -rf /var/lib/mysql/ /etc/my.cnf注：这里将删除所有的数据文件（databases, tables, logs, etc.），可能你环境中的datafile的位置并不是默认的/var/lib/mysql，而是其他的目录，卸载的时候根据实际情况删除文件感谢你能够认真阅读完这篇文章，希望小编分享的“如何使用rpm包方式安装Percona server”这篇文章对大家有帮助，同时也希望大家多多支持云技术，关注云技术行业资讯频道，更多相关知识等着你来学习!

相关推荐: MySQL中行转列、列转行、连接字符串 concat、concat_ws、group_concat函数怎么用

这篇文章主要介绍MySQL中行转列、列转行、连接字符串 concat、concat_ws、group_concat函数怎么用，文免费主机域名中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！使用方法：CONCAT(str1,str2,…)返回结…