Percona-Server-5.5.33-31.1安装
一、下载http://www.percona.com/downloads/Percona-Server-5.5/
Percona-Server-5.5.33-31.1
选择binary
选择linux
选择x86_64
二、文档：
http://www.percona.com/doc/percona-server/5.5/
http://dev.mysql.com/doc/refman/5.5/en/binary-installation.html--主要参考这篇文档
三、安装
# mv Percona-Server-5.5.33-rel31.1-566.Linux.x86_64.tar.gz/usr/local/
安装要放的真是路径
# groupadd mysql
# useradd –r –g mysql mysql
# mv Percona-Server-5.5.33-rel31.1-566.Linux.x86_64.tar.gz/usr/local/
# cd /usr/local
# tar zxvf Percona-Server-5.5.33-rel31.1-566.Linux.x86_64.tar.gz
# ll
total 63104
drwxr-xr-x2 root root 4096 Apr5 01:34 bin
drwxr-xr-x2 root root 4096 Oct12009 etc
drwxr-xr-x2 root root 4096 Oct12009 games
drwxr-xr-x2 root root 4096 Oct12009 include
drwxr-xr-x2 root root 4096 Oct12009 lib
drwxr-xr-x2 root root 4096 Oct12009 lib64
drwxr-xr-x2 root root 4096 Oct12009 libexec
drwxr-xr-x 14 root root 4096 Aug 272013 Percona-Server-5.5.33-rel31.1-566.Linux.x86_64
-rw-r--r--1 root root 64459501 Jun 30 12:44 Percona-Server-5.5.33-rel31.1-566.Linux.x86_64.tar.gz
drwxr-xr-x2 root root 4096 Oct12009 sbin
drwxr-xr-x4 root root 4096 Apr4 23:39 share
drwxr-xr-x2 root root 4096 Oct12009 src
# ln -s /usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64 mysql
# ll
total 63104
drwxr-xr-x2 root root 4096 Apr5 01:34 bin
drwxr-xr-x2 root root 4096 Oct12009 etc
drwxr-xr-x2 root root 4096 Oct12009 games
drwxr-xr-x2 root root 4096 Oct12009 include
drwxr-xr-x2 root root 4096 Oct12009 lib
drwxr-xr-x2 root root 4096 Oct12009 lib64
drwxr-xr-x2 root root 4096 Oct12009 libexec
lrwxrwxrwx1 root root 57 Jun 30 12:55 mysql -> /usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64
drwxr-xr-x 14 root root 4096 Aug 272013 Percona-Server-5.5.33-rel31.1-566.Linux.x86_64
-rw-r--r--1 root root 64459501 Jun 30 12:44 Percona-Server-5.5.33-rel31.1-566.Linux.x86_64.tar.gz
drwxr-xr-x2 root root 4096 Oct12009 sbin
drwxr-xr-x4 root root 4096 Apr4 23:39 share
drwxr-xr-x2 root root 4096 Oct12009 src
# cd mysql/
# chown -R mysql .
# chgrp -R mysql .
# ll
total 80
drwxr-xr-x2 mysql mysql4096 Aug 272013 bin
-rw-r--r--1 mysql mysql 17987 Aug 272013 COPYING
-rw-r--r--1 mysql mysql1703 Aug 272013 COPYING-jemalloc
drwxr-xr-x3 mysql mysql4096 Aug 272013 data
drwxr-xr-x2 mysql mysql4096 Aug 272013 docs
drwxr-xr-x4 mysql mysql4096 Aug 272013 include
-rw-r--r--1 mysql mysql 301 Aug 272013 INSTALL-BINARY
drwxr-xr-x3 mysql mysql4096 Aug 272013 lib
drwxr-xr-x4 mysql mysql4096 Aug 272013 man
drwxr-xr-x3 mysql mysql4096 Aug 272013 mysql
drwxr-xr-x 10 mysql mysql4096 Aug 272013 mysql-test
-rw-r--r--1 mysql mysql2496 Aug 272013 README
drwxr-xr-x2 mysql mysql4096 Aug 272013 scripts
drwxr-xr-x 27 mysql mysql4096 Aug 272013 share
drwxr-xr-x4 mysql mysql4096 Aug 272013 sql-bench
drwxr-xr-x3 mysql mysql4096 Aug 272013 support-files
# ./scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h tthost3 password 'new-password'
Alternatively you can run:
./bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default.This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd ./mysql-test ; perl mysql-test-run.pl
Please report any problems with the ./bin/mysqlbug script!
Percona recommends that all production deployments be protected with a support
contract (http://www.percona.com/mysql-suppport/) to ensure the highest uptime,
be eligible for hot fixes, and boost your team's productivity.
以上有几点很重要！
# chown -R root .
# ll
total 80
drwxr-xr-x2 root mysql4096 Aug 272013 bin
-rw-r--r--1 root mysql 17987 Aug 272013 COPYING
-rw-r--r--1 root mysql1703 Aug 272013 COPYING-jemalloc
drwxr-xr-x5 root mysql4096 Jun 30 12:59 data
drwxr-xr-x2 root mysql4096 Aug 272013 docs
drwxr-xr-x4 root mysql4096 Aug 272013 include
-rw-r--r--1 root mysql 301 Aug 272013 INSTALL-BINARY
drwxr-xr-x3 root mysql4096 Aug 272013 lib
drwxr-xr-x4 root mysql4096 Aug 272013 man
drwxr-xr-x3 root mysql4096 Aug 272013 mysql
drwxr-xr-x 10 root mysql4096 Aug 272013 mysql-test
-rw-r--r--1 root mysql2496 Aug 272013 README
drwxr-xr-x2 root mysql4096 Aug 272013 scripts
drwxr-xr-x 27 root mysql4096 Aug 272013 share
drwxr-xr-x4 root mysql4096 Aug 272013 sql-bench
drwxr-xr-x3 root mysql4096 Aug 272013 support-files
# chown -R mysql data
# ll
total 80
drwxr-xr-x2 rootmysql4096 Aug 272013 bin
-rw-r--r--1 rootmysql 17987 Aug 272013 COPYING
-rw-r--r--1 rootmysql1703 Aug 272013 COPYING-jemalloc
drwxr-xr-x5 mysql mysql4096 Jun 30 12:59 data
下面的这些是可选的：
# cp support-files/my-medium.cnf /etc/my.cnf
# ./bin/mysqld_safe --user=mysql &
3813
# 140630 13:07:39 mysqld_safe Logging to '/usr/local/mysql/data/tthost3.err'.
140630 13:07:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
# ps -ef | grep mysql
root 381336070 13:07 pts/2 00:00:00 /bin/sh ./bin/mysqld_safe --user=mysql
mysql 406738132 13:07 pts/2 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/mysql/plugin --user=mysql --log-error=/usr/local/mysql/data/tthost3.err --pid-file=/usr/local/mysql/data/tthost3.pid --socket=/tmp/mysql.sock --port=3306
root 408836070 13:07 pts/2 00:00:00 grep mysql
以下的选项是可选的：
编辑mysql.server
将Percona-Server-5.5.33-rel31.1-566.Linux.x86_64替换成mysql 真实路径
# vi support-files/mysql.server
修改前：
mysqld_pid_file_path=
if test -z "$basedir"
then
basedir=/usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64
bindir=/usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64/bin
if test -z "$datadir"
then
datadir=/usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64/data
fi
sbindir=/usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64/bin
libexecdir=/usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64/bin
else
修改后：
mysqld_pid_file_path=
if test -z "$basedir"
then
basedir=/usr/local/mysql
bindir=/usr/local/mysql/bin
if test -z "$datadir"
then
datadir=/usr/local/mysql/data
fi
sbindir=/usr/local/mysql/bin
libexecdir=/usr/local/mysql/bin
else
# cp support-files/mysql.server /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --list |grep mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
#
# service mysqld stop
Shutting down MySQL (Percona Server)..140630 13:17:40 mysqld_safe mysqld from pid file /usr/local/mysql/data/tthost3.pid ended
+Done ./bin/mysqld_safe --user=mysql
# ps -ef | grep mysql
root 419436070 13:18 pts/2 00:00:00 grep mysql
# service mysqld start
Starting MySQL (Percona Server).
# ps -ef | grep mysql
root 4206 10 13:18 pts/2 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/tthost3.pid
mysql 447142061 13:18 pts/2 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/mysql/plugin --user=mysql --log-error=/usr/local/mysql/data/tthost3.err --pid-file=/usr/local/mysql/data/tthost3.pid --socket=/tmp/mysql.sock --port=3306
root 449636070 13:18 pts/2 00:00:00 grep mysql
安装完成！
另外有个地方需要注意一下，我们的实际安装路径是：
/usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64
/usr/local/mysql只是做了一个软链接
启动脚本中，mysqld，mysqld_safe，mysql.server脚本中basedir，datadir是默认在
/usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64目录下面，就是说用脚本可以直接启动，因为percona默认建议是安装在这个下面：
/usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64
这里只是做了mysql的一个软链接和oracle mysql兼容下目录而已 ，如果要把mysql.server拷贝到/etc/init.d/目录下，脚本中目录路径也不一定要修改的，怎样都能启动：
Service mysqld start
页:
[1]