一、环境说明

（1）CentOS-7-x86_64,内核版本

uname-r3.10.0-693.el7.x86_64

（2）Mysql版本

percona-server-5.6.29

（3）文件存放路径

/home/soft

二、安装前准备

（1）配置权限

groupaddmysqluseradd-r-gmysqlmysql

（2）创建安装目录

mkdir/usr/local/mysql#mysql安装目录chown-Rmysql:mysql/usr/local/mysqlmkdir/usr/local/mysql/dataconf#数据库配置存放目录chown-Rmysql:mysql/usr/local/mysql/dataconfmkdir/usr/local/mysql/sock#运行mysql时mysql.sock存放目录chown-Rmysql:mysql/usr/local/mysql/sockmkdir/var/log/mysql#创建日志存放目录touch/var/log/mysql/mysql.logchown-Rmysql:mysql/var/log/mysql/mysql.logtouch/usr/local/mysql/my.cnf#创建mysql配置文件

三、安装编译环境

yuminstallreadline-develgitgccgcc-c++makecmakebisonbison-develncurses-devellibaio-develperlzlib1g-devautoconf

四、编译安装percona

cd/home/soft/tarzxvfpercona-server-5.6.29-76.2.tar.gzcdpercona-server-5.6.29-76.2cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql#需要使用cmake进行安装，这里表示的是文件安装目录-DSYSCONFDIR=/usr/local/mysql#存放配置文件的目录-DMYSQL_DATADIR=/usr/local/mysql/dataconf#存放数据库的目录-DMYSQL_UNIX_ADDR=/usr/local/mysql/sock/mysqld.sock#存放mysql.sock文件的目录-DMYSQL_TCP_PORT=3306-DWITH_MYISAM_STORAGE_ENGINE=1#配置端口-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8#配置默认的字符编码格式-DDEFAULT_COLLATION=utf8_general_ci-DENABLED_LOCAL_INFILE=1-DWITH_EDITLINE=bundled-DCMAKE_BUILD_TYPE=RelWithDebInfo-DBUILD_CONFIG=mysql_release-DFEATURE_SET=community-DWITH_EMBEDDED_SERVER=OFF

之后，继续编译安装。

make-j8#大概需要30-40分钟左右。如果报错，请使用makeclean,rm-rfCMakeCache.txtmakeinstall

五、配置Percona参数

cat/usr/local/mysql/my.cnf[mysqld]#Disablingsymbolic-linksisrecommendedtopreventassortedsecurityriskssymbolic-links=0explicit_defaults_for_timestamp=truefederated#Settingsuserandgroupareignoredwhensystemdisused.#Ifyouneedtorunmysqldunderadifferentuserorgroup,#customizeyoursystemdunitfileformariadbaccordingtothe#instructionsinhttp://fedoraproject.org/wiki/Systemdbasedir=/usr/local/mysqldatadir=/usr/local/mysql/dataconfport=3306socket=/usr/local/mysql/sock/mysql.socksymbolic-links=0character_set_server=utf8pid-file=/usr/local/mysql/mysql.pidskip-grant-tables[mysqld_safe]log-error=/var/log/mysql/mysql.logpid-file=/usr/local/mysql/mysql.pidsocket=/usr/local/mysql/sock/mysql.sock[client]socket=/usr/local/mysql/mysql.sock[mysql.server]user=mysqlbasedir=/usr/local/mysqlsocket=/usr/local/mysql/sock/mysql.sock[mysql]socket=/usr/local/mysql/sock/mysql.sock

六、配置Mysql访问权限

chown-Rmysql:mysql/usr/local/mysql/binchown-Rmysql:mysql/usr/local/mysql/mysql.pid

七、初始化Mysql服务器

/usr/local/mysql/scripts/mysql_install_db--defaults-file=/usr/local/mysql/my.cnf--basedir=/usr/local/mysql--datadir=/usr/local/mysql/dataconf--user=mysql

八、配置环境变量

为了能直接调用mysql命令，需要配置环境变量vi/etc/profile在/etc/profile文件末尾添加exportPATH=/usr/local/mysql/bin:$PATH使环境变量立即生效source/etc/profile

九、配置启动脚本

cp/home/soft/percona-server-5.6.29-76.2/support-files/mysql.server/etc/init.d/mysqlchmod+x/etc/init.d/mysqlchkconfigmysqlonservicemysqlstart/stop

十、后言

此方法我也不知道为什么在CentOS7里面安装之后可以用，在Debian服务器里面无法进行编译安装使用。另外在使用的过程中，有时候可能也需要Percona-Server-client的支持。针对这个问题，可以使用以下方法解决：将文件上传到/home/soft/目录下，然后进行安装。安装方法如下：

rpm-ivhPercona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64.rpmrpm-ivhPercona-Server-shared-55-5.5.35-rel33.0.611.rhel6.x86_64.rpmrpm-ivhPercona-Server-devel-55-5.5.35-rel33.0.611.rhel6.x86_64.rpmrpm-ivhPercona-Server-client-55-5.5.35-rel33.0.611.rhel6.x86_64.rpm

或者使用rpm -ivh * 即可安装