percona mysql5.5源码安装过程

本是古典何须时尚 2022-06-10 03:17 144阅读 0赞

author：skate  
time：2012/06/27

**percona mysql5.5源码安装过程**

**安装步骤：**

方法一： source RPM安装

shell> rpmbuild --rebuild --clean MySQL-VERSION.src.rpm

然后找到编译的rpm包，执行即可

方法二：源码编译安装

\# 创建用户/用户组  
shell> groupadd mysql  
shell> useradd -r -g mysql mysql

\# 开始编译  
shell> tar zxvf mysql-VERSION.tar.gz  
shell> cd mysql-VERSION  
shell> cmake .  //In MySQL 5.5, CMake is used as the build framework on all platforms  
shell> make  
shell> make install DESTDIR=“/data/mysql”  //默认路径是“/usr/local/mysql”  
  
\# 开始配置安装  
shell> cd /data/mysql/usr/local/mysql  
shell> chown -R mysql .  
shell> chgrp -R mysql .  
shell> scripts/mysql\_install\_db --user=mysql  
shell> chown -R root .  
shell> chown -R mysql data

\# 制作my.cnf配置文件  
shell> cp support-files/my-medium.cnf /etc/my.cnf

\#启动mysqld服务  
shell> bin/mysqld\_safe --user=mysql &

\# 配置mysqld的service服务  
shell> cp support-files/mysql.server /etc/init.d/mysql.server  
shell> chmod a+x /etc/init.d/mysql.server  
shell> chkconfig --add mysql.server  
shell> service mysql.server status

案例：

下载：  
Percona-Server-5.5.19-rel24.0.tar.gz：  
[http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.19-24.0/source/Percona-Server-5.5.19-rel24.0.tar.gz][http_www.percona.com_redir_downloads_Percona-Server-5.5_Percona-Server-5.5.19-24.0_source_Percona-Server-5.5.19-rel24.0.tar.gz]

Percona-Server-55-5.5.19-rel24.0.204.rhel5.src.rpm：  
[http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.19-24.0/source/Percona-Server-55-5.5.19-rel24.0.204.rhel5.src.rpm][http_www.percona.com_redir_downloads_Percona-Server-5.5_Percona-Server-5.5.19-24.0_source_Percona-Server-55-5.5.19-rel24.0.204.rhel5.src.rpm]

方法一： 这个方法比较简单， 这里掠过

方法二：源码编译安装  
解压：  
\[root@localhost data\]\# tar -zxvf Percona-Server-5.5.24-rel26.0.tar.gz  
\[root@localhost data\]\# cd /data/Percona-Server-5.5.24-rel26.0  
\[root@localhost Percona-Server-5.5.24-rel26.0\]\# cmake .  
\[root@localhost Percona-Server-5.5.24-rel26.0\]\# make  
\[root@localhost Percona-Server-5.5.24-rel26.0\]\# make install DESTDIR="/data/mysql"

至此mysql已经被编译安装到“/data/mysql”下

\[root@localhost Percona-Server-5.5.24-rel26.0\]\# cd /data/mysql/usr/local/mysql/

\[root@localhost mysql\]\# ll  
total 72  
drwxr-xr-x  2 root root  4096 Jun 27 10:10 bin  
\-rw-r--r--  1 root root 17987 May 30 01:42 COPYING  
drwxr-xr-x  4 root root  4096 Jun 27 10:09 data  
drwxr-xr-x  2 root root  4096 Jun 27 10:09 docs  
drwxr-xr-x  3 root root  4096 Jun 27 10:09 include  
\-rw-r--r--  1 root root   316 May 30 01:42 INSTALL-BINARY  
drwxr-xr-x  3 root root  4096 Jun 27 10:09 lib  
drwxr-xr-x  4 root root  4096 Jun 27 10:10 man  
drwxr-xr-x 10 root root  4096 Jun 27 10:10 mysql-test  
\-rw-r--r--  1 root root  2552 May 30 01:42 README  
drwxr-xr-x  2 root root  4096 Jun 27 10:10 scripts  
drwxr-xr-x 27 root root  4096 Jun 27 10:10 share  
drwxr-xr-x  4 root root  4096 Jun 27 10:10 sql-bench  
drwxr-xr-x  2 root root  4096 Jun 27 10:10 support-files

\[root@localhost mysql\]\# chown -R mysql .  
\[root@localhost mysql\]\# chgrp -R mysql .

\[root@localhost mysql\]\# ll  
total 72  
drwxr-xr-x  2 mysql mysql  4096 Jun 27 10:10 bin  
\-rw-r--r--  1 mysql mysql 17987 May 30 01:42 COPYING  
drwxr-xr-x  4 mysql mysql  4096 Jun 27 10:09 data  
drwxr-xr-x  2 mysql mysql  4096 Jun 27 10:09 docs  
drwxr-xr-x  3 mysql mysql  4096 Jun 27 10:09 include  
\-rw-r--r--  1 mysql mysql   316 May 30 01:42 INSTALL-BINARY  
drwxr-xr-x  3 mysql mysql  4096 Jun 27 10:09 lib  
drwxr-xr-x  4 mysql mysql  4096 Jun 27 10:10 man  
drwxr-xr-x 10 mysql mysql  4096 Jun 27 10:10 mysql-test  
\-rw-r--r--  1 mysql mysql  2552 May 30 01:42 README  
drwxr-xr-x  2 mysql mysql  4096 Jun 27 10:10 scripts  
drwxr-xr-x 27 mysql mysql  4096 Jun 27 10:10 share  
drwxr-xr-x  4 mysql mysql  4096 Jun 27 10:10 sql-bench  
drwxr-xr-x  2 mysql mysql  4096 Jun 27 10:10 support-files  
\[root@localhost mysql\]\#

安装mysql系统表  
\[root@localhost mysql\]\# scripts/mysql\_install\_db  --user=mysql  
Installing MySQL system tables...  
120627 10:24:00 \[Note\] Flashcache bypass: disabled  
120627 10:24:00 \[Note\] Flashcache setup error is : ioctl failed

OK  
Filling help tables...  
120627 10:24:01 \[Note\] Flashcache bypass: disabled  
120627 10:24:01 \[Note\] Flashcache setup error is : ioctl failed

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 localhost 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/][http_www.percona.com_mysql-suppport]) to ensure the highest uptime,  
be eligible for hot fixes, and boost your team's productivity.  
\[root@localhost mysql\]\#

\[root@localhost mysql\]\# chown -R root .  
\[root@localhost mysql\]\# ll  
total 72  
drwxr-xr-x  2 root mysql  4096 Jun 27 10:10 bin  
\-rw-r--r--  1 root mysql 17987 May 30 01:42 COPYING  
drwxr-xr-x  5 root mysql  4096 Jun 27 10:24 data  
drwxr-xr-x  2 root mysql  4096 Jun 27 10:09 docs  
drwxr-xr-x  3 root mysql  4096 Jun 27 10:09 include  
\-rw-r--r--  1 root mysql   316 May 30 01:42 INSTALL-BINARY  
drwxr-xr-x  3 root mysql  4096 Jun 27 10:09 lib  
drwxr-xr-x  4 root mysql  4096 Jun 27 10:10 man  
drwxr-xr-x 10 root mysql  4096 Jun 27 10:10 mysql-test  
\-rw-r--r--  1 root mysql  2552 May 30 01:42 README  
drwxr-xr-x  2 root mysql  4096 Jun 27 10:10 scripts  
drwxr-xr-x 27 root mysql  4096 Jun 27 10:10 share  
drwxr-xr-x  4 root mysql  4096 Jun 27 10:10 sql-bench  
drwxr-xr-x  2 root mysql  4096 Jun 27 10:10 support-files

\[root@localhost mysql\]\# chown -R mysql data  
\[root@localhost mysql\]\# ll  
total 72  
drwxr-xr-x  2 root  mysql  4096 Jun 27 10:10 bin  
\-rw-r--r--  1 root  mysql 17987 May 30 01:42 COPYING  
drwxr-xr-x  5 mysql mysql  4096 Jun 27 10:24 data  
drwxr-xr-x  2 root  mysql  4096 Jun 27 10:09 docs  
drwxr-xr-x  3 root  mysql  4096 Jun 27 10:09 include  
\-rw-r--r--  1 root  mysql   316 May 30 01:42 INSTALL-BINARY  
drwxr-xr-x  3 root  mysql  4096 Jun 27 10:09 lib  
drwxr-xr-x  4 root  mysql  4096 Jun 27 10:10 man  
drwxr-xr-x 10 root  mysql  4096 Jun 27 10:10 mysql-test  
\-rw-r--r--  1 root  mysql  2552 May 30 01:42 README  
drwxr-xr-x  2 root  mysql  4096 Jun 27 10:10 scripts  
drwxr-xr-x 27 root  mysql  4096 Jun 27 10:10 share  
drwxr-xr-x  4 root  mysql  4096 Jun 27 10:10 sql-bench  
drwxr-xr-x  2 root  mysql  4096 Jun 27 10:10 support-files

配置my.cnf配置文件  
\[root@localhost mysql\]\# cp support-files/my-medium.cnf  /etc/my.cnf  
\[root@localhost mysql\]\# bin/mysqld\_safe --user=mysql &  
\[1\] 11934  
\[root@localhost mysql\]\# 120627 10:27:18 mysqld\_safe Logging to '/data/mysql/usr/local/mysql/data/localhost.err'.  
120627 10:27:18 mysqld\_safe Starting mysqld daemon with databases from /data/mysql/usr/local/mysql/data

***在另外一个窗口配置mysql的service服务***

\[root@localhost Percona-Server-5.5.24-rel26.0\]\# cp support-files/mysql.server /etc/init.d/mysql.server

\[root@localhost Percona-Server-5.5.24-rel26.0\]\# chmod a+x /etc/init.d/mysql.server  
\[root@localhost Percona-Server-5.5.24-rel26.0\]\# chkconfig --add mysql.server  
\[root@localhost Percona-Server-5.5.24-rel26.0\]\# service mysql.server status  
MySQL (Percona Server) is not running\[FAILED\]  
\[root@localhost Percona-Server-5.5.24-rel26.0\]\# service mysql.server restart  
MySQL (Percona Server) PID file could not be found!\[FAILED\]  
Starting MySQL (Percona Server)..The server quit without updating PID file (/usr/local/mysql/data/localhost.pid).\[FAILED\]  
我安装的路径是在”/data/mysql“下，说明路径不对，需要修改脚本“mysql.server”中变量“basedir”和”bindir“，然后在restart即可。

\[root@localhost Percona-Server-5.5.24-rel26.0\]\# service mysql.server restart  
Shutting down MySQL (Percona Server)...\[  OK  \]  
Starting MySQL (Percona Server)...\[  OK  \]

服务已经启动了，用mysql客户端登录验证下  
[root@localhost][root_localhost] Percona-Server-5.5.24-rel26.0\]\# cd /data/mysql/usr/local/mysql/  
\[root@localhost mysql\]\# ll  
total 72  
drwxr-xr-x  2 root  mysql  4096 Jun 27 10:10 bin  
\-rw-r--r--  1 root  mysql 17987 May 30 01:42 COPYING  
drwxr-xr-x  5 mysql mysql  4096 Jun 27 10:37 data  
drwxr-xr-x  2 root  mysql  4096 Jun 27 10:09 docs  
drwxr-xr-x  3 root  mysql  4096 Jun 27 10:09 include  
\-rw-r--r--  1 root  mysql   316 May 30 01:42 INSTALL-BINARY  
drwxr-xr-x  3 root  mysql  4096 Jun 27 10:09 lib  
drwxr-xr-x  4 root  mysql  4096 Jun 27 10:10 man  
drwxr-xr-x 10 root  mysql  4096 Jun 27 10:10 mysql-test  
\-rw-r--r--  1 root  mysql  2552 May 30 01:42 README  
drwxr-xr-x  2 root  mysql  4096 Jun 27 10:10 scripts  
drwxr-xr-x 27 root  mysql  4096 Jun 27 10:10 share  
drwxr-xr-x  4 root  mysql  4096 Jun 27 10:10 sql-bench  
drwxr-xr-x  2 root  mysql  4096 Jun 27 10:10 support-files  
\[root@localhost mysql\]\# bin/mysql  
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 1  
Server version: 5.5.24-log Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

mysql> select version();  
\+------------+  
| version()  |  
\+------------+  
| 5.5.24-log |  
\+------------+  
1 row in set (0.00 sec)

mysql> select @@innodb\_version;  
\+------------------+  
| @@innodb\_version |  
\+------------------+  
| 1.1.8-20.1       |  
\+------------------+  
1 row in set (0.00 sec)

mysql>

mysql> show engines;  
\+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+  
| Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |  
\+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+  
| PERFORMANCE\_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |  
| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |  
| MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         |  
| CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         |  
| MRG\_MYISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         |  
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |  
\+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+  
6 rows in set (0.00 sec)

更改环境变量  
\[root@localhost Percona-Server-5.5.24-rel26.0\]\# vi /root/.bash\_profile  
PATH=/data/mysql/usr/local/mysql/bin:$PATH:$HOME/bin

\[root@localhost ~\]\# mysqladmin -uroot -p status  
Enter password:  
Uptime: 4567  Threads: 2  Questions: 13  Slow queries: 0  Opens: 33  Flush tables: 1  Open tables: 26  Queries per second avg: 0.002  
\[root@localhost ~\]\# mysql  
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 6  
Server version: 5.5.24-log Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

mysql>

\----end----

参考：[http://dev.mysql.com/doc/refman/5.5/en/installing-source-distribution.html][http_dev.mysql.com_doc_refman_5.5_en_installing-source-distribution.html]

[http_www.percona.com_redir_downloads_Percona-Server-5.5_Percona-Server-5.5.19-24.0_source_Percona-Server-5.5.19-rel24.0.tar.gz]: http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.19-24.0/source/Percona-Server-5.5.19-rel24.0.tar.gz
[http_www.percona.com_redir_downloads_Percona-Server-5.5_Percona-Server-5.5.19-24.0_source_Percona-Server-55-5.5.19-rel24.0.204.rhel5.src.rpm]: http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.19-24.0/source/Percona-Server-55-5.5.19-rel24.0.204.rhel5.src.rpm
[http_www.percona.com_mysql-suppport]: http://www.percona.com/mysql-suppport/
[root_localhost]: mailto:root@localhost
[http_dev.mysql.com_doc_refman_5.5_en_installing-source-distribution.html]: http://dev.mysql.com/doc/refman/5.5/en/installing-source-distribution.html