Percona MySQL 5.5 Linux通用二進位制包安裝(CentOS 6.9)

建立軟體安裝目錄
mkdir  /mysql_software_55

下載軟體
Percona官網的下載頁面有兩個二進位制Tar包，分別對應不同的發行版本
ssl100 - Debian/Ubuntu
ssl101 - for CentOS 6 and CentOS 7

解壓安裝包
tar xvfz Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101.tar.gz -C /mysql_software_55/

建立mysql使用者
useradd mysql

建立資料目錄、日誌目錄和臨時目錄
mkdir -p /mysql_55_3306/data
mkdir -p /mysql_55_3306/log
mkdir -p /mysql_55_3306/tmp

建立錯誤日誌
touch /mysql_55_3306/log/error.log

chown -R mysql.mysql /mysql_55_3306

編輯配置檔案
vim /etc/my_55_3306.cn


初始化MySQL資料庫的資料檔案路徑，並且建立系統表
刪除Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101目錄，將軟體檔案移動到上一級目錄，否則初始化的時候會報錯
cd /mysql_software_55/Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101
[root@MySQL01 Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101]# mv * ..
[root@MySQL01 Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101]# cd ..
[root@MySQL01 mysql_software_55]# rmdir Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101/

執行初始化
[root@MySQL01 mysql_software_55]# ./scripts/mysql_install_db --user=mysql  --basedir=/mysql_software_55/ --datadir=/mysql_55_3306/data/
WARNING: The host 'MySQL01' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
171214  9:56:46 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
171214  9:56:46 [Note] /mysql_software_55//bin/mysqld (mysqld 5.5.58-38.10) starting as process 9175 ...
OK
Filling help tables...
171214  9:56:47 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
171214  9:56:47 [Note] /mysql_software_55//bin/mysqld (mysqld 5.5.58-38.10) starting as process 9182 ...
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:

/mysql_software_55//bin/mysqladmin -u root password 'new-password'
/mysql_software_55//bin/mysqladmin -u root -h MySQL01 password 'new-password'

Alternatively you can run:
/mysql_software_55//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 /mysql_software_55/ ; /mysql_software_55//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /mysql_software_55//mysql-test ; perl mysql-test-run.pl

Please report any problems at
 

Percona recommends that all production deployments be protected with a support
contract () to ensure the highest uptime,
be eligible for hot fixes, and boost your team's productivity.
[root@MySQL01 mysql_software_55]# bin/mysqld_safe --defaults-file=/etc/my_55_3306.cn &
[1] 21953
[root@MySQL01 mysql_software_55]# ps -ef|grep mysql
root     10302 10278  0 10:11 pts/1    00:00:00 su - mysql
mysql    10303 10302  0 10:11 pts/1    00:00:00 -bash
mysql    21952 10303  0 10:45 pts/1    00:00:00 tailf error.log
root     21953  1960  0 10:45 pts/0    00:00:00 /bin/sh bin/mysqld_safe --defaults-file=/etc/my_55_3306.cn
mysql    23005 21953  0 10:45 pts/0    00:00:00 /mysql_software_55/bin/mysqld --defaults-file=/etc/my_55_3306.cn --basedir=/mysql_software_55/ --datadir=/mysql_55_3306/data --plugin-dir=/mysql_software_55//lib/mysql/plugin --user=mysql --log-error=/mysql_55_3306/log/error.log --pid-file=/mysql_55_3306/data/MySQL01.pid --socket=/mysql_55_3306/tmp/mysql.sock --port=3306
root     23051  1960  0 10:46 pts/0    00:00:00 grep mysql