Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Practice of LNMP blog and database separation

2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Nginx build command

Cd / home/oldboy/tools installation storage package path

Yum install openssl openssl-devel-y installs the libraries and encryption protocols required for Nginx

Yum install pcre pcre-devel-y installs the libraries and encryption protocols required for Nginx

Rpm-qa openssl-devel pcre-devel openssl openssl-devel check to see if it is installed

Wget-Q http://nginx.org/download/nginx-1.6.3.tar.gz download package

Useradd www-s / sbin/nologin-M create user

Tar xf nginx-1.6.3.tar.gz decompression software

Cd nginx-1.6.3

. / configure-- user=www-- group=www-- with-http_ssl_module-- with-http_stub_status_module-- prefix=/application/nginx-1.6.3/ compilation installation

Make

Make install

Ln-s / application/nginx-1.6.3/ / application/nginx

/ application/nginx/sbin/nginx activate the service

Ps-ef | grep nginx check

Create a web page directory

[root@web02 html] # mkdir {www,bbs,blog}-p

[root@web02 www] # echo "www.etiantian.org" > index.html

Modify the master configuration file

Add access log and virtual host directory

Log_format main'$remote_addr-$remote_user [$time_local] "$request"'

'$status $body_bytes_sent "$http_referer"'

'"$http_user_agent"$http_x_forwarded_for"'

# nginx vhosts config

Include extra/www.conf

Include extra/bbs.conf

Include extra/blog.conf

Create a directory where the virtual host is stored

[root@web02 conf] # mkdir extra

[root@web02 extra] # touch www.conf

[root@web02 extra] # touch bbs.conf

[root@web02 extra] # touch blog.conf

Modify the conf directory of each virtual host

Server {

Listen 80

Server_name www.etiantian.org etiantian.org

Location / {

Root html/www

Index index.html index.htm

}

Access_log logs/access_www.log main

}

Set up boot boot

[root@web02 oldboy] # echo "/ application/nginx/sbin/nginx" > > / etc/rc.local

[root@web02 oldboy] # tail-1 / etc/rc.local

/ application/nginx/sbin/nginx

MySQL build command

Install MySQL

Upload MySQL

Ls mysql-5.5.49-linux2.6-x86_64.tar.gz

Tar xf mysql-5.5.49-linux2.6-x86_64.tar.gz

Mkdir / application-p

Mv mysql-5.5.49-linux2.6-x86_64 / application/mysql-5.5.49

Ln-s / application/mysql-5.5.49 / application/mysql

Useradd mysql-s / sbin/nologin-M creates user and authorization directories

Chown-R mysql.mysql / application/mysql/ create user and authorization directories

Cd / application/mysql

. / scripts/mysql_install_db-- user=mysql-- basedir=/application/mysql-- Database when datadir=/application/mysql/data/ initializes

Ll data/

\ cp support-files/my-small.cnf / etc/my.cnf create basic requirements

Cp support-files/mysql.server / etc/init.d/mysqld creates basic requirements

Chmod + x / etc/init.d/mysqld gives executive permission

Sed-I's application/mysql/bin/mysqld_safe _ etc/init.d/mysqld modify the configuration file for usr _ application/mysql/bin/mysqld_safe _ etc/init.d/mysqld

/ etc/init.d/mysqld start starts the service,

Netstat-lntup | grep mysql check

Echo "PATH=" / application/mysql/bin:$PATH "" > > / etc/profile

Chkconfig-add mysqld starts the service

Chkconfig mysqld on enables the service.

Cp-a / application/mysql/bin/* / usr/local/sbin/

Ln-s / application/mysql/bin/* / usr/local/sbin/

Mysql

1. Install the PHP basic library

Yum install zlib-devel libxml2-devel libjpeg-devel libjpeg-turbo-devel libiconv-devel-y

Yum install freetype-devel libpng-devel gd-devel libcurl-devel libxslt-devel libxslt-devel-y

Rpm-qa zlib-devel libxml2-devel libjpeg-devel libjpeg-turbo-devel libiconv-devel freetype-devel libpng-devel gd-devel libcurl-devel libxslt-devel

You need to install supported packages first.

Cd / home/oldboy/tools

Wget http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.14.tar.gz

Tar zxf libiconv-1.14.tar.gz

Cd libiconv-1.14

. / configure-- prefix=/usr/local/libiconv

Make

Make install

Cd.. /

2. PHP-related extension libraries

Wget-O / etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-6.repo

Yum-y install libmcrypt-devel

Yum-y install mhash

Yum-y install mcrypt

Rpm-qa libmcrypt-devel mhash mcrypt

Extract the php installation package, edit

Upload PHP package

Tar xf php-5.5.32.tar.gz unzipped php installation package

. / configure\

-- prefix=/application/php5.5.32\

-- with-mysql=/application/mysql/\

-- with-pdo-mysql=mysqlnd\

-- with-iconv-dir=/usr/local/libiconv\

-- with-freetype-dir\

-- with-jpeg-dir\

-- with-png-dir\

-- with-zlib\

-- with-libxml-dir=/usr\

-- enable-xml\

-- disable-rpath\

-- enable-bcmath\

-- enable-shmop\

-- enable-sysvsem\

-- enable-inline-optimization\

-- with-curl\

-- enable-mbregex\

-- enable-fpm\

-- enable-mbstring\

-- with-mcrypt\

-- with-gd\

-- enable-gd-native-ttf\

-- with-openssl\

-- with-mhash\

-- enable-pcntl\

-- enable-sockets\

-- with-xmlrpc\

-- enable-soap\

-- enable-short-tags\

-- enable-static\

-- with-xsl\

-- with-fpm-user=www\

-- with-fpm-group=www\

-- enable-ftp\

-- enable-opcache=no

Ln-s / application/mysql/lib/libmysqlclient.so.18 / usr/lib64/

Touch ext/phar/phar.phar

Make

Make install

Ln-s / application/php5.5.32/ / application/php

Ls / application/php/

Cp php.ini-production / application/php/lib/php.ini

Configure php parsing file

Cp php.ini-production / application/php/lib/php.ini

Configure php-fpm Profil

Cp php-fpm.conf.default php-fpm.conf

Start php-fpm

/ application/php/sbin/php-fpm

Lsof-I: 9000

Ps-ef | grep php-fpm

Root@web01 extra] # cat blog.conf

Server {

Listen 80

Server_name blog.etiantian.org

Location / {

Root html/blog

Index index.html index.htm

}

Location. *\. (php | php5)? ${

Root html/blog

Fastcgi_pass 127.0.0.1:9000

Fastcgi_index index.php

Include fastcgi.conf

}

}

[root@web01 extra] #.. /.. / sbin/nginx-t

Nginx: the configuration file / application/nginx-1.6.3//conf/nginx.conf syntax is ok

Nginx: configuration file / application/nginx-1.6.3//conf/nginx.conf test is successful

[root@web01 extra] #.. / sbin/nginx-s reload

[root@web01 blog] # cat test_mysql.php

Build blog command

Mysql-uroot-poldboy123

Create database wordpress

Show databases

Grant all on wordpress.* to wordpress@'localhost' identified by '123456'

Select user,host from mysql.user

Show grants for wordpress@'localhost'

Flush privileges

Download blog installation

Wget https://cn.wordpress.org/wordpress-4.5.1-zh_CN.tar.gz

Ll

Tar xf wordpress-4.5.1-zh_CN.tar.gz

Ls wordpress

Cp-a wordpress/* / application/nginx/html/blog/

Ls / application/nginx/html/blog/

Chown-R www.www / application/nginx/html/blog/

Ls / application/nginx/html/blog/

Ls / application/nginx/html/blog/-l

History

Detach command

Wed command

Mysqldump-uroot-poldboy123 wordpress-B | gzip > bak.sql.gz

Scp bak.sql.gz root@10.0.0.51:/tmp

Database MySQL command

Cd / tmp

Gzip xf bak.sql.tar.gz

Mysql-uroot-poldboy123-e "show databases like 'wordpress';"

Mysql-uroot-poldboy123-e "use wordpress;show tables;"

Mysql-uroot-poldboy123

Grant all on wordpress.* to wordpress@'172.16.1.%' identified by '123456'

Flush privileges

Select user,host from mysql.user

Change .8 profile wp-config.php

32 define ('DB_HOST',' 172.16.1.51')

Close the local database

/ etc/init.d/mysqld stop

Chkconfig mysqld off

Success.

2. Migrate the resource files of blog to NFS

[root@web01 blog] # tree wp-content/uploads/

The resource directory is: wp-content/uploads/

Nfs command

Echo "/ uploads 172.16.1.0 echo 24 (rw,sync)" / etc/exports

MySQL database command

Mount-t nfs 172.16.1.31:/uploads / application/nginx/html/blog/

Build it according to the explanation of the old boy teacher and the actual operation.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report