基于LNMP的discuz论坛的实现

LNMP介绍：

#### [ LNMP的组成]

• LNMP是指一组通常一起使用来运行动态网站或者服务器的自由软件名称首字母缩写。L指Linux，N指Nginx，M一般指MySQL，也可以指MariaDB，P一般指PHP，也可以指Perl或Python。
  - [ LNMP简介]
• LNMP代表的就是:Linux系统下Nginx+MySQL+PHP这种网站服务器架构。
• Linux是一类Unix计算机操作系统的统称，是目前最流行的免费操作系统。代表版本有:debian、centos、ubuntu、fedora、gentoo等。
• Nginx是一个高性能的HTTP和反向代理服务器，也是一个IMAP/POP3/SMTP代理服务器。
• Mysql是一个小型关系型数据库管理系统。
• PHP是一种在服务器端执行的嵌入HTML文档的脚本语言。
  这四种软件均为免费开源软件，组合到一起，成为一个免费、高效、扩展性强的网站服务系统。
  ** [特点 ]**
• Nginx是一个小巧而高效的Linux下的Web服务器软件，是由 Igor Sysoev 为俄罗斯访问量第二的 Rambler 站点开发的，已经在一些俄罗斯的大型网站上运行多年，相当的稳定。
• Nginx性能稳定、功能丰富、运维简单、处理静态文件速度快且消耗系统资源极少。
  #[ 优点]
• 作为 Web 服务器:相比 Apache，Nginx 使用更少的资源，支持更多的并发连接，体现更高的效率。
• 作为负载均衡服务器:Nginx 既可以在内部直接支持Rails和PHP，也可以支持作为 HTTP代理服务器对外进行服务。Nginx 用C编写，不论是系统资源开销还是CPU使用效率都比Perlbal要好的多。
• 作为邮件代理服务器:Nginx同时也是一个非常优秀的邮件代理服务器(最早开发这个产品的目的之一也是作为邮件代理服务器)，Last/fm 描述了成功并且美妙的使用经验。
• Nginx 安装非常的简单，配置文件非常简洁(还能够支持perl语法)。Nginx支持平滑加载新的配置，还能够在不间断服务的情况下进行软件版本的升级。

• 下面开始LNMP的安装和部署

主机分配

服务	IP
LNMP	192.168.20.30

• 1.1源码安装mysql

 1  rz2  yum -y install bison cmake ncurses-devel openssl-devel  perl-Data-Dumper3  tar -zxf mysql-5.6.46.tar.gz 4  cd mysql-5.6.46/5  cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all6  make -j8 && make install

• 参数释义：

--DCMAKE_INSTALL_PREFIX  安装路径
-DSYSCONFDIR 指定mysql配置文件目录
-DDEFAULT_CHARSET 设置mysql默认字符集
-DDEFAULT_COLLATION 默认编码格式
-DWITH_EXTRA_CHARSETS 指定mysql可用的其他字符集

    7  ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib8  ln -s /usr/local/mysql/bin/* /usr/local/bin/9  useradd -M -s /sbin/nologin mysql10  chown -R mysql:mysql /usr/local/mysql/11   cd support-files/12  cp my-default.cnf /etc/my.cnf13   cp mysql.server /etc/init.d/mysqld14  vim /etc/init.d/mysqld 46 basedir=/usr/local/mysql ##MySQL安装路径47 datadir=/usr/local/mysql/data ## 数据存放目录15   chmod +x /etc/init.d/mysqld 

• 初始化数据库

16、/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysqlInstalling MySQL system tables...2020-05-31 16:20:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-31 16:20:24 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2020-05-31 16:20:24 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.46) starting as process 21647 ...
2020-05-31 16:20:24 21647 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-05-31 16:20:24 21647 [Note] InnoDB: The InnoDB memory heap is disabled
2020-05-31 16:20:24 21647 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-31 16:20:24 21647 [Note] InnoDB: Memory barrier is not used
2020-05-31 16:20:24 21647 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-31 16:20:24 21647 [Note] InnoDB: Using CPU crc32 instructions
2020-05-31 16:20:24 21647 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-05-31 16:20:24 21647 [Note] InnoDB: Completed initialization of buffer pool
2020-05-31 16:20:24 21647 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-31 16:20:24 21647 [Note] InnoDB: 128 rollback segment(s) are active.
2020-05-31 16:20:24 21647 [Note] InnoDB: Waiting for purge to start
2020-05-31 16:20:24 21647 [Note] InnoDB: 5.6.46 started; log sequence number 1626027
2020-05-31 16:20:24 21647 [Note] RSA private key file not found: /usr/local/mysql/data//private_key.pem. Some authentication plugins will not work.
2020-05-31 16:20:24 21647 [Note] RSA public key file not found: /usr/local/mysql/data//public_key.pem. Some authentication plugins will not work.
2020-05-31 16:20:24 21647 [Note] Binlog end
2020-05-31 16:20:24 21647 [Note] InnoDB: FTS optimize thread exiting.
2020-05-31 16:20:24 21647 [Note] InnoDB: Starting shutdown...
2020-05-31 16:20:25 21647 [Note] InnoDB: Shutdown completed; log sequence number 1626037
OKFilling help tables...2020-05-31 16:20:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-31 16:20:25 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2020-05-31 16:20:25 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.46) starting as process 21670 ...
2020-05-31 16:20:25 21670 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-05-31 16:20:25 21670 [Note] InnoDB: The InnoDB memory heap is disabled
2020-05-31 16:20:25 21670 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-31 16:20:25 21670 [Note] InnoDB: Memory barrier is not used
2020-05-31 16:20:25 21670 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-31 16:20:25 21670 [Note] InnoDB: Using CPU crc32 instructions
2020-05-31 16:20:25 21670 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-05-31 16:20:25 21670 [Note] InnoDB: Completed initialization of buffer pool
2020-05-31 16:20:25 21670 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-31 16:20:25 21670 [Note] InnoDB: 128 rollback segment(s) are active.
2020-05-31 16:20:25 21670 [Note] InnoDB: Waiting for purge to start
2020-05-31 16:20:25 21670 [Note] InnoDB: 5.6.46 started; log sequence number 1626037
2020-05-31 16:20:25 21670 [Note] RSA private key file not found: /usr/local/mysql/data//private_key.pem. Some authentication plugins will not work.
2020-05-31 16:20:25 21670 [Note] RSA public key file not found: /usr/local/mysql/data//public_key.pem. Some authentication plugins will not work.
2020-05-31 16:20:25 21670 [Note] Binlog end
2020-05-31 16:20:25 21670 [Note] InnoDB: FTS optimize thread exiting.
2020-05-31 16:20:25 21670 [Note] InnoDB: Starting shutdown...
2020-05-31 16:20:27 21670 [Note] InnoDB: Shutdown completed; log sequence number 1626047
OKTo start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:/usr/local/mysql/bin/mysqladmin -u root password 'new-password'/usr/local/mysql/bin/mysqladmin -u root -h lpj3 password 'new-password'Alternatively you can run:/usr/local/mysql/bin/mysql_secure_installationwhich 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 . ; /usr/local/mysql/bin/mysqld_safe &You can test the MySQL daemon with mysql-test-run.plcd mysql-test ; perl mysql-test-run.plPlease report any problems at http://bugs.mysql.com/The latest information about MySQL is available on the web athttp://www.mysql.comSupport MySQL by buying support/licenses at http://shop.mysql.comWARNING: Found existing config file /usr/local/mysql/my.cnf on the system.
Because this file might be in use, it was not replaced,
but was used in bootstrap (unless you used --defaults-file)
and when you later start the server.
The new default config file was created as /usr/local/mysql/my-new.cnf,
please compare it with your file and take the changes you need.WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

• 启动并设置MySQL登录密码

[root@lpj3 support-files]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/usr/local/mysql/data/lpj3.err'.SUCCESS! 
[root@lpj3 support-files]# netstat -anput | grep LISTEN | grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN      21832/mysqld        
[root@lpj3 support-files]#  mysqladmin -uroot password 123456
Warning: Using a password on the command line interface can be insecure.
[root@lpj3 support-files]#  mysql -uroot -p123456
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.46 Source distributionCopyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.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>