第1章 搭建博客與數(shù)據(jù)庫遷移
1.1 搭建博客
在LNMP環(huán)境搭建好的前提下，搭建博客谅阿。
1.1.1 確認(rèn)環(huán)境，nginx拍皮、mysql和php服務(wù)在開啟狀態(tài)
[root@web02 ~]$ netstat -lntup|egrep "80|3306|9000"
tcp 0 0 127.0.0.1:9000 0.0.0.0:* LISTEN 12214/php-fpm: mast
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 12420/nginx: master
tcp6 0 0 :::3306 :::* LISTEN 7285/mysqld
1.1.2 上傳本地下載好的開源BLOG
[root@web02 ~]$ cd /server/tools/
[root@web02 /server/tools]$ rz -y <===上傳本地壓縮包
rz waiting to receive.
[root@web02 /server/tools]$ ls
wordpress-5.1.1.zip
[root@web02 /server/tools]$ unzip wordpress-5.1.1.zip <===解壓縮
[root@web02 /server/tools]# mv wordpress/* /application/nginx/html/blog/
[root@web02 /server/tools]$ chown -R nginx.nginx /application/nginx/html/blog/
[root@web02 /server/tools]$ ls -ld /application/nginx/html/blog/
drwxr-xr-x 5 nginx nginx 4096 5月 7 09:14 /application/nginx/html/blog/
1.1.3 修改配置文件,內(nèi)容如下
[root@web02 /application/nginx/conf/extra]$ cat 03_blog.conf
server {
listen 80;
server_name blog.etiantian.org;
location / {
root html/blog;
index index.php index.html index.htm;
if (-f $request_filename/index.html){
rewrite (.*) $1/index.html break;
}
if (-f $request_filename/index.php){
rewrite (.*) $1/index.php;
}
if (!-f $request_filename){
rewrite (.*) /index.php;
}
}
location ~ \.php$ {
root html/blog;
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
include fastcgi.conf;
}
}
1.1.4 安裝博客
打開瀏覽器铆帽，在地址欄輸入blog.etiantian.org開始安裝博客
1.2 在db01上安裝數(shù)據(jù)庫
useradd mysql -s /sbin/nologin -M
id mysql
mkdir -p /server/tools/
cd /server/tools/
#上傳本地的mysql壓縮包
rz
#解壓安裝
tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
mkdir -p /application
mv mysql-5.7.26-linux-glibc2.12-x86_64 /application/mysql-5.7.26
ln -s /application/mysql-5.7.26/ /application/mysql
#配置配置文件
rpm -e --nodeps mariadb-libs
cat >/etc/my.cnf<<EOF
[mysqld]
basedir = /application/mysql/
datadir = /application/mysql/data
socket = /tmp/mysql.sock
server_id = 1
port = 3306
log_error = /application/mysql/data/oldboy_mysql.err
[mysql]
socket = /tmp/mysql.sock
prompt = oldboy [\\d]>
EOF
#5.初始化數(shù)據(jù)庫
rpm -qa mariadb-libs
yum install libaio-devel -y
mkdir -p /application/mysql/data
chown -R mysql.mysql /application/mysql/
/application/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/application/mysql/ --datadir=/application/mysql/data
#6德谅、配置啟動(dòng)
cat >/etc/systemd/system/mysqld.service<<EOF
[Unit]
Description=MySQL Server by oldboy
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
EOF
systemctl start mysqld
systemctl enable mysqld
netstat -lntup|grep mysql
#7.登錄測(cè)試
echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile
. /etc/profile
mysql
quit
1.3 數(shù)據(jù)庫遷移
從單機(jī)LNMP遷移到db01獨(dú)立的mysql
1.3.1 在web服務(wù)器上備份數(shù)據(jù)庫
[root@web02 ~]$ mysqldump -uroot -poldboy123 -A -B|gzip >/tmp/web02_db.sql.gz
mysqldump: [Warning] Using a password on the command line interface can be insecure.
1.3.2 在web上將數(shù)據(jù)庫拷貝到db01
[root@web02 ~]$ scp /tmp/web02_db.sql.gz 10.0.0.51:/tmp
[root@web02 ~]$ systemctl stop mysqld
[root@web02 ~]$ systemctl disable mysqld
[root@web02 ~]$ lsof -i :3306
1.3.3 在web上修改配置文件部分內(nèi)容
[root@web02 ~]$ cd /application/nginx/html/blog/
[root@web02 /application/nginx/html/blog]$ vim wp-config.php
define( 'DB_NAME', 'wordpress' );
/** MySQL database username */
define( 'DB_USER', 'wordpress' );
/** MySQL database password */
define( 'DB_PASSWORD', 'oldboy123' );
/** MySQL hostname */
define( 'DB_HOST', '172.16.1.51' );
1.3.4 在db01上操作
[root@db01 ~]$ lsof -i :3306
[root@db01 ~]$ cd /tmp
[root@db01 /tmp]$ gzip -d web02_db.sql.gz <===解壓壓縮包
[root@db01 /tmp]$ mysql -uroot -poldboy123 </tmp/web02_db.sql <===導(dǎo)入數(shù)據(jù)庫
1.3.5 在db01上登錄數(shù)據(jù)庫操作
[root@db01 /tmp]# mysql -uroot -poldboy123
oldboy [(none)]>grant all privileges on wordpress.* to wordpress@'172.16.1.%' identified by 'oldboy123';
oldboy [(none)]>flush privileges;
oldboy [(none)]>select user,authentication_string,host from mysql.user;
