Percona-Server数据库的安装方法

1.建立用户

groupadd -g 27mysql 

useradd -g 27 -s/sbin/nologin mysql  

 

2.安装
yum –y install perl perl-devel

tar xfPercona-Server-5.6.15-rel63.0-519.Linux.x86_64.tar.gz 

cd Percona-Server-5.6.15-rel63.0-519.Linux.x86_64     

cp  support-files/mysql.server  /etc/init.d/mysqld   

3.改变权限  

chown -R  mysql.mysql/root/Percona-Server-5.6.15-rel63.0-519.Linux.x86_64

ln -sv Percona-Server-5.6.15-rel63.0-519.Linux.x86_64 mysql-5.6.15

4.配置my.cnf文件

Vim my.cnf

[mysqld]

port = 3306

user=mysql

basedir =/home/perhome/mysql-5.6.15

datadir =/home/perdata

socket =/home/perhome/var/run/mysql.sock

[mysqld_safe]

open-files-limit =10240

log-error =/home/perhome/var/log/mysql_err.log

pid-file =/home/perhome/var/run/mysqld.pid

mkdir -p /home/perhome/var/log

mkdir -p  /home/perhome/var/run

mkdir -p /home/perhome/

mkdir -p /home/perdata

5.初始化mysql

cd ./scripts/

./mysql_install_db--user=mysql --datadir=/home/perdata/ --basedir=/home/perhome/mysql-5.6.15/

6./home/perhome/mysql-5.6.15/bin/mysqld_safe &

7.vi/etc/profile.d/mysql.sh

exportPATH=/home/perhome/mysql-5.6.15/bin/:$PATH

source /etc/profile.d/mysql.sh

chown –R mysql:mysql /usr/local/var

 

8.vim/etc/init.d/mysqld

basedir=/home/perhome/mysql-5.6.15

datadir=/home/perdata

9.service mysqld restart