Percona-Server-5.5.33-31.1安装-白红宇

Percona-Server-5.5.33-31.1安装

阅读量：5091 次

发布时间：2019-06-13

本文共 8542 字，大约阅读时间需要 28 分钟。

一、下载

选择 binary

选择linux

选择x86_64

二、文档：

--主要参考这篇文档

三、安装

[root@tthost3 ~]# mv Percona-Server-5.5.33-rel31.1-566.Linux.x86_64.tar.gz /usr/local/

安装要放的真是路径

[root@tthost3 ~]# groupadd mysql

[root@tthost3 ~]# useradd –r –g mysql mysql

[root@tthost3 ~]# mv Percona-Server-5.5.33-rel31.1-566.Linux.x86_64.tar.gz /usr/local/

[root@tthost3 ~]# cd /usr/local

[root@tthost3 ~]# tar zxvf Percona-Server-5.5.33-rel31.1-566.Linux.x86_64.tar.gz

[root@tthost3 local]# ll

total 63104

drwxr-xr-x 2 root root 4096 Apr 5 01:34 bin

drwxr-xr-x 2 root root 4096 Oct 1 2009 etc

drwxr-xr-x 2 root root 4096 Oct 1 2009 games

drwxr-xr-x 2 root root 4096 Oct 1 2009 include

drwxr-xr-x 2 root root 4096 Oct 1 2009 lib

drwxr-xr-x 2 root root 4096 Oct 1 2009 lib64

drwxr-xr-x 2 root root 4096 Oct 1 2009 libexec

drwxr-xr-x 14 root root 4096 Aug 27 2013 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-x 2 root root 4096 Oct 1 2009 sbin

drwxr-xr-x 4 root root 4096 Apr 4 23:39 share

drwxr-xr-x 2 root root 4096 Oct 1 2009 src

[root@tthost3 local]# ln -s /usr/local/Percona-Server-5.5.33-rel31.1-566.Linux.x86_64 mysql

[root@tthost3 local]# ll

total 63104

drwxr-xr-x 2 root root 4096 Apr 5 01:34 bin

drwxr-xr-x 2 root root 4096 Oct 1 2009 etc

drwxr-xr-x 2 root root 4096 Oct 1 2009 games

drwxr-xr-x 2 root root 4096 Oct 1 2009 include

drwxr-xr-x 2 root root 4096 Oct 1 2009 lib

drwxr-xr-x 2 root root 4096 Oct 1 2009 lib64

drwxr-xr-x 2 root root 4096 Oct 1 2009 libexec

lrwxrwxrwx 1 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 27 2013 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-x 2 root root 4096 Oct 1 2009 sbin

drwxr-xr-x 4 root root 4096 Apr 4 23:39 share

drwxr-xr-x 2 root root 4096 Oct 1 2009 src

[root@tthost3 local]# cd mysql/

[root@tthost3 mysql]# chown -R mysql .

[root@tthost3 mysql]# chgrp -R mysql .

[root@tthost3 mysql]# ll

total 80

drwxr-xr-x 2 mysql mysql 4096 Aug 27 2013 bin

-rw-r--r-- 1 mysql mysql 17987 Aug 27 2013 COPYING

-rw-r--r-- 1 mysql mysql 1703 Aug 27 2013 COPYING-jemalloc

drwxr-xr-x 3 mysql mysql 4096 Aug 27 2013 data

drwxr-xr-x 2 mysql mysql 4096 Aug 27 2013 docs

drwxr-xr-x 4 mysql mysql 4096 Aug 27 2013 include

-rw-r--r-- 1 mysql mysql 301 Aug 27 2013 INSTALL-BINARY

drwxr-xr-x 3 mysql mysql 4096 Aug 27 2013 lib

drwxr-xr-x 4 mysql mysql 4096 Aug 27 2013 man

drwxr-xr-x 3 mysql mysql 4096 Aug 27 2013 mysql

drwxr-xr-x 10 mysql mysql 4096 Aug 27 2013 mysql-test

-rw-r--r-- 1 mysql mysql 2496 Aug 27 2013 README

drwxr-xr-x 2 mysql mysql 4096 Aug 27 2013 scripts

drwxr-xr-x 27 mysql mysql 4096 Aug 27 2013 share

drwxr-xr-x 4 mysql mysql 4096 Aug 27 2013 sql-bench

drwxr-xr-x 3 mysql mysql 4096 Aug 27 2013 support-files

[root@tthost3 mysql]# ./scripts/mysql_install_db --user=mysql

Installing MySQL system tables...

Filling help tables...

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.

以上有几点很重要！

[root@tthost3 mysql]# chown -R root .

[root@tthost3 mysql]# ll

total 80

drwxr-xr-x 2 root mysql 4096 Aug 27 2013 bin

-rw-r--r-- 1 root mysql 17987 Aug 27 2013 COPYING

-rw-r--r-- 1 root mysql 1703 Aug 27 2013 COPYING-jemalloc

drwxr-xr-x 5 root mysql 4096 Jun 30 12:59 data

drwxr-xr-x 2 root mysql 4096 Aug 27 2013 docs

drwxr-xr-x 4 root mysql 4096 Aug 27 2013 include

-rw-r--r-- 1 root mysql 301 Aug 27 2013 INSTALL-BINARY

drwxr-xr-x 3 root mysql 4096 Aug 27 2013 lib

drwxr-xr-x 4 root mysql 4096 Aug 27 2013 man

drwxr-xr-x 3 root mysql 4096 Aug 27 2013 mysql

drwxr-xr-x 10 root mysql 4096 Aug 27 2013 mysql-test

-rw-r--r-- 1 root mysql 2496 Aug 27 2013 README

drwxr-xr-x 2 root mysql 4096 Aug 27 2013 scripts

drwxr-xr-x 27 root mysql 4096 Aug 27 2013 share

drwxr-xr-x 4 root mysql 4096 Aug 27 2013 sql-bench

drwxr-xr-x 3 root mysql 4096 Aug 27 2013 support-files

[root@tthost3 mysql]# chown -R mysql data

[root@tthost3 mysql]# ll

total 80

drwxr-xr-x 2 root mysql 4096 Aug 27 2013 bin

-rw-r--r-- 1 root mysql 17987 Aug 27 2013 COPYING

-rw-r--r-- 1 root mysql 1703 Aug 27 2013 COPYING-jemalloc

drwxr-xr-x 5 mysql mysql 4096 Jun 30 12:59 data

下面的这些是可选的：

[root@tthost3 mysql]# cp support-files/my-medium.cnf /etc/my.cnf

[root@tthost3 mysql]# ./bin/mysqld_safe --user=mysql &

[1] 3813

[root@tthost3 mysql]# 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

[root@tthost3 mysql]# ps -ef | grep mysql

root 3813 3607 0 13:07 pts/2 00:00:00 /bin/sh ./bin/mysqld_safe --user=mysql

mysql 4067 3813 2 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 4088 3607 0 13:07 pts/2 00:00:00 grep mysql

以下的选项是可选的：

编辑mysql.server

将Percona-Server-5.5.33-rel31.1-566.Linux.x86_64替换成mysql 真实路径

[root@tthost3 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

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

sbindir=/usr/local/mysql/bin

libexecdir=/usr/local/mysql/bin

else

[root@tthost3 mysql]# cp support-files/mysql.server /etc/init.d/mysqld

[root@tthost3 mysql]# chkconfig --add mysqld

[root@tthost3 mysql]# chkconfig --list |grep mysqld

mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off

[root@tthost3 mysql]#

[root@tthost3 mysql]# 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

[ OK ]

[1]+ Done ./bin/mysqld_safe --user=mysql

[root@tthost3 mysql]# ps -ef | grep mysql

root 4194 3607 0 13:18 pts/2 00:00:00 grep mysql

[root@tthost3 mysql]# service mysqld start

Starting MySQL (Percona Server). [ OK ]

[root@tthost3 mysql]# ps -ef | grep mysql

root 4206 1 0 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 4471 4206 1 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 4496 3607 0 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

转载于:https://www.cnblogs.com/songdeyouxiang/p/5595311.html

你可能感兴趣的文章