源码编译构建lnmp架构

源码编译构建lnmp架构

概述：

LNMP就是Linux+Nginx+MySQL+PHP，Linux作为服务器的操作系统，

MySQL即为数据库。是一组搭建动态网站的开源软件架构，本身是各自独立的软件服务，放在一起使用拥有很高的兼容性，共同组成了一个强大的WEB应用程序平台。

Nginx为一款高性能Web服务器，本身是不能处理PHP的，当接收到请求时，判断如果是PHP请求就会将请求交给PHP解释器处理，然后将结果返回给Client。Nginx一般把请求转发给fast-cgi管理进程处理，fast-cgi管理进程再选择cgi子进程处理请求，然后把结果返给Nginx。

LNMP就是Linux+Nginx+MySQL+PHP，Linux作为服务器的操作系统，MySQL即为数据库。

区别（lamp和lnmp）
Apache一般是把PHP当做自己的一个模块来启动；而Ngnix则是把http请求变量转发给PHP进程，即PHP独立进程，与Ngnix通信，这种方式叫做Fast-CGI运行方式。所以Apache所编译的PHP不能用于Nginx。

1.mysql

安装包：

mysql-boost-5.7.17.tar.gz     
cmake-2.8.12.2-4.el6.x86_64.rpm

实验环境：

重新建立一个子盘 
注意：内存尽量给大点（3072即可）因为编译很消耗内存和cpu

实验：

在serve5中：
[root@server5 ~]# ls
cmake-2.8.12.2-4.el6.x86_64.rpm   mysql-boost-5.7.17.tar.gz                      
[root@server5 ~]# tar  zxf mysql-boost-5.7.17.tar.gz 
[root@server5 ~]# ls
cmake-2.8.12.2-4.el6.x86_64.rpm    mysql-boost-5.7.17.tar.gz
mysql-5.7.17
[root@server5 ~]# rpm -ivh cmake-2.8.12.2-4.el6.x86_64.rpm 
warning: cmake-2.8.12.2-4.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
error: Failed dependencies:    #有依赖性
    libarchive.so.2()(64bit) is needed by cmake-2.8.12.2-4.el6.x86_64

##解决依赖性
[root@server5 ~]# yum install libarchive.so.2 -y
[root@server2 ~]# rpm -ivh cmake-2.8.12.2-4.el6.x86_64.rpm 
warning: cmake-2.8.12.2-4.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing...                ########################################### [100%]
    package cmake-2.8.12.2-4.el6.x86_64 is already installed
[root@server2 ~]# cd mysql-5.7.17/
##编译
[root@server2 mysql-5.7.17]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/lnmp/mysql  -DMYSQL_DATADIR=/usr/local/lnmp/mysql/data  -DMYSQL_UNIX_ADDR=/usr/local/lnmp/mysql/data/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1  -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all 
-- Running cmake version 2.8.12.2
-- Could NOT find Git (missing:  GIT_EXECUTABLE) 
-- Configuring with MAX_INDEXES = 64U
-- The C compiler identification is unknown
-- The CXX compiler identification is unknown
##注意error 报错信息 
CMake Error: your C compiler: "CMAKE_C_COMPILER-NOTFOUND" was not found.   Please set CMAKE_C_COMPILER to a valid compiler path or name.
CMake Error: your CXX compiler: "CMAKE_CXX_COMPILER-NOTFOUND" was not found.   Please set CMAKE_CXX_COMPILER to a valid compiler path or name.
CMake Error at cmake/os/Linux.cmake:41 (MESSAGE):
  Unsupported compiler!
Call Stack (most recent call first):
  CMakeLists.txt:162 (INCLUDE)


-- Configuring incomplete, errors occurred!
See also "/root/mysql-5.7.17/CMakeFiles/CMakeOutput.log".
See also "/root/mysql-5.7.17/CMakeFiles/CMakeError.log".

[root@server2 mysql-5.7.17]# yum install -y gcc gcc-c++
##每解决一次依赖性问题就得刷新一次
[root@server6 mysql-5.7.17]# rm -f CMakeCache.txt 
[root@server2 mysql-5.7.17]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/lnmp/mysql  -DMYSQL_DATADIR=/usr/local/lnmp/mysql/data  -DMYSQL_UNIX_ADDR=/usr/local/lnmp/mysql/data/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1  -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all 
-- Running cmake version 2.8.12.2
-- Could NOT find Git (missing:  GIT_EXECUTABLE) 
-- Configuring with MAX_INDEXES = 64U
-- The C compiler identification is GNU 4.4.7
-- The CXX compiler identification is GNU 4.4.7
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Looking for SHM_HUGETLB
-- Looking for SHM_HUGETLB - found
-- Looking for sys/types.h
-- Looking for sys/types.h - found
-- Looking for stdint.h
-- Looking for stdint.h - found
-- Looking for stddef.h
-- Looking for stddef.h - found
-- Check size of void *
-- Check size of void * - done
-- SIZEOF_VOIDP 8
-- Performing Test HAVE_C_SHIFT_OR_OPTIMIZATION_BUG
-- Performing Test HAVE_C_SHIFT_OR_OPTIMIZATION_BUG - Failed
-- Performing Test HAVE_CXX_SHIFT_OR_OPTIMIZATION_BUG
-- Performing Test HAVE_CXX_SHIFT_OR_OPTIMIZATION_BUG - Failed
-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD
-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD - Failed
-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD
-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD - Failed
-- Performing Test HAVE_C_FP_CONTRACT_FLAG
-- Performing Test HAVE_C_FP_CONTRACT_FLAG - Failed
-- Performing Test HAVE_CXX_FP_CONTRACT_FLAG
-- Performing Test HAVE_CXX_FP_CONTRACT_FLAG - Failed
-- MySQL 5.7.17
-- Packaging as: mysql-5.7.17-Linux-x86_64
-- Looked for boost/version.hpp in  and 
-- BOOST_INCLUDE_DIR BOOST_INCLUDE_DIR-NOTFOUND
-- LOCAL_BOOST_DIR 
-- LOCAL_BOOST_ZIP 
-- Could not find (the correct version of) boost.
-- MySQL currently requires boost_1_59_0
##还是有error 继续解决
CMake Error at cmake/boost.cmake:81 (MESSAGE):  #需要添加-DWITH_BOOST参数
  You can download it with -DDOWNLOAD_BOOST=1 -DWITH_BOOST=<directory>
                                                #并且参数后边跟的内容可以tab出来
  This CMake script will look for boost in <directory>.  If it is not there,
  it will download and unpack it (in that directory) for you.

  If you are inside a firewall, you may need to use an http proxy:
  export http_proxy=http://example.com:80

Call Stack (most recent call first):
  cmake/boost.cmake:238 (COULD_NOT_FIND_BOOST)
  CMakeLists.txt:455 (INCLUDE)

-- Configuring incomplete, errors occurred!
See also "/root/mysql-5.7.17/CMakeFiles/CMakeOutput.log".

[root@server6 mysql-5.7.17]# rm -f CMakeCache.txt 
[root@server2 mysql-5.7.17]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/lnmp/mysql  -DMYSQL_DATADIR=/usr/local/lnmp/mysql/data  -DMYSQL_UNIX_ADDR=/usr/local/lnmp/mysql/data/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1  -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all  -DWITH_BOOST=boost/boost_1_59_0/

-- Running cmake version 2.8.12.2
-- Could NOT find Git (missing:  GIT_EXECUTABLE) 
-- Configuring with MAX_INDEXES = 64U
-- SIZEOF_VOIDP 8
-- MySQL 5.7.17
........................
CMake Error at cmake/readline.cmake:64 (MESSAGE):
  Curses library not found.  Please install appropriate package,

      remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
Call Stack (most recent call first):
  cmake/readline.cmake:107 (FIND_CURSES)
  cmake/readline.cmake:197 (MYSQL_USE_BUNDLED_EDITLINE)
  CMakeLists.txt:483 (MYSQL_CHECK_EDITLINE)


-- Configuring incomplete, errors occurred!
See also "/root/mysql-5.7.17/CMakeFiles/CMakeOutput.log".
See also "/root/mysql-5.7.17/CMakeFiles/CMakeError.log".

[root@server2 mysql-5.7.17]# yum install -y ncurses-devel
[root@server6 mysql-5.7.17]# rm -f CMakeCache.txt 
##只要没有error即可 （warning可以忽略但 error不能）
#编译三部曲
[root@server2 mysql-5.7.17]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/lnmp/mysql  -DMYSQL_DATADIR=/usr/local/lnmp/mysql/data  -DMYSQL_UNIX_ADDR=/usr/local/lnmp/mysql/data/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1  -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all  -DWITH_BOOST=boost/boost_1_59_0/
##此过程比较慢 耐心等待吧～
[root@server6 mysql-5.7.17]# make
[root@server6 mysql-5.7.17]# make   install

[root@server5 ~]# cd /usr/local/lnmp/
[root@server5 lnmp]# ls
mysql
[root@server5 lnmp]# cd mysql/
[root@server5 mysql]# ls
bin  COPYING  data  docs  include  lib  man  mysql-test  README  share  support-files
[root@server5 mysql]# rpm -qa|grep  mysql
mysql-libs-5.1.71-1.el6.x86_64
[root@server5 mysql]# ll /etc/my.cnf 
-rw-r--r--. 1 root root 251 Aug  9  2013 /etc/my.cnf
[root@server5 mysql]# cd support-files/
[root@server5 support-files]# ls
magic  my-default.cnf  mysqld_multi.server  mysql-log-rotate  mysql.server
[root@server5 support-files]# pwd
/usr/local/lnmp/mysql/support-files
[root@server5 support-files]# cp my-default.cnf   /etc/my.cnf 
cp: overwrite `/etc/my.cnf'? y
[root@server5 support-files]# vim /etc/my.cnf 

[root@server5 support-files]# ls
magic  my-default.cnf  mysqld_multi.server  mysql-log-rotate  mysql.server
[root@server5 support-files]# file my
my-default.cnf       mysqld_multi.server  mysql-log-rotate     mysql.server
[root@server5 support-files]# file mysql.server 
mysql.server: POSIX shell script text executable
[root@server5 support-files]# cp mysql.server  /etc/init.d/mysqld
[root@server5 support-files]# ll /etc/init.d/mysqld 
-rwxr-xr-x 1 root root 10916 Aug  5 11:33 /etc/init.d/mysqld
[root@server5 support-files]# cd ..
[root@server5 mysql]# ls
bin  COPYING  data  docs  include  lib  man  mysql-test  README  share  support-files
[root@server5 mysql]# less README
[root@server5 mysql]# pwd
/usr/local/lnmp/mysql
[root@server5 mysql]# id mysql
id: mysql: No such user
[root@server5 mysql]# groupadd -g 27 mysql
[root@server5 mysql]# useradd -u 27 -g  27 -M -d /usr/local/lnmp/mysql/data/ -s /sbin/nologin  mysql
[root@server5 mysql]# chown -R mysql.mysql .
[root@server5 ~]# vim .bash_profile 

[root@server5 ~]# source  .bash_profile 
 #初始化   生成临时登陆密码
[root@server6 mysql]# mysqld --initialize --user=mysql
2018-08-04T19:26:24.791982Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-04T19:26:24.792056Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-08-04T19:26:24.792060Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2018-08-04T19:26:27.314585Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-08-04T19:26:27.823527Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-08-04T19:26:27.976935Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 48a04455-981c-