LNMP服务环境都在一台机器上（IP:125），现在要做到把mysql服务迁移出来（IP:129），把图片文件迁移到NFS服务器上（IP：130）
mysql服务器（129）
安装mysql配置过程(下载略)
useradd mysql -s /sbin/nologin -Mmkdir -p /applicationtar xf mysql-5.5.59-linux-glibc2.12-x86_64.tar.gz mv mysql-5.5.59-linux-glibc2.12-x86_64 /application/mysql-5.5.59ln -s /application/mysql-5.5.59/ /application/mysql chown -R mysql.mysql /application/mysqlcd /application/mysql ./scripts/mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data/ cp ./support-files/my-small.cnf /etc/my.cnf cp support-files/mysql.server /etc/init.d/mysqldsed -i ‘s#/usr/local/mysql#/application/mysql#g‘ /etc/my.cnf /etc/init.d/mysqld /application/mysql/bin/mysqld_safe
/etc/init.d/mysqld start
lsof -i:3306
cp -a /application/mysql/bin/* /usr/local/sbin/
mysqladmin -uroot password 123456
LNMP环境导出mysql中的数据（IP：125）
mysqldump -uroot -p123456 -B wordpress |gzip>bak.sql.gzscp bak.sql.gz root@192.168.70.129:/tmp
导入到mysql服务器中（129）
gzip -d bak.sql.gz mysql -uroot -p123456 </tmp/bak.sql
登录数据库查看
mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test || wordpress |+--------------------+5 rows in set (0.00 sec)数据库授让LNMP可以访问grant all on wordpress.* to wordpress@‘192.168.70.%‘ identified by ‘123456‘;flush privileges;
停掉LNMP中的数据库（125）
/etc/init.d/mysqld stop
修改wordpress 文件（125）
cd /application/nginx/html/blog/vim wp-config.php
/** MySQL主机 */
define(‘DB_HOST‘, ‘192.168.70.129‘);
这就可以访问了
blog.daxian.com
测试blog中的mysql
发表一篇博文
查看129的数据库
select * from daxian_posts\G ?*************************** 8. row ***************************ID: 8post_author: 1post_date: 2018-02-07 16:00:38post_date_gmt: 0000-00-00 00:00:00post_content: post_title: 123456daxian
成功
==========================图片分离到NFS=================
图片位置在于
tree /application/nginx/html/blog/wp-content/uploads/wp-content/uploads/└── 2018└── 02├── m2w500hq85lt_x_large_EQqD_500c000026851262-100x100.jpg├── m2w500hq85lt_x_large_EQqD_500c000026851262-150x150.jpg├── m2w500hq85lt_x_large_EQqD_500c000026851262-300x194.jpg├── m2w500hq85lt_x_large_EQqD_500c000026851262.jpg├── m2w500hq85lt_x_large_vIqg_741d00001d1f1262-100x100.jpg├── m2w500hq85lt_x_large_vIqg_741d00001d1f1262-150x150.jpg├── m2w500hq85lt_x_large_vIqg_741d00001d1f1262-300x216.jpg└── m2w500hq85lt_x_large_vIqg_741d00001d1f1262.jpg
在NFS服务器上创建用户
useradd -u 506 www ?（查看125上www用户uid是多少）
安装NFS（客户端跟服务端都要安装））
yum install nfs-utils rpcbind -y
NFS上启动
/etc/init.d/rpcbind start/etc/init.d/nfs start
rpcinfo -p localhost
mkdir /data/blog -p
chown -R www.www /data
vim /etc/exports
/data 192.168.70.0/24(rw,sync,all_squash,anonuid=506,anongid=506)
重启NFS
/etc/init.d/nfs reload
showmount -e 192.168.70.130
客户端启动（125）
/etc/init.d/rpcbind start
showmount -e 192.168.70.130
Export list for 192.168.70.130:
/data 192.168.70.0/24
将原有数据移动走（125
cd /application/nginx/html/blog/wp-content/uploadsmv 2018 /tmp
挂载
mount -t nfs 192.168.70.130:/data/nfs-blog /application/nginx/html/blog/wp-content/uploads/
将数据移动回来
cp -a /tmp/2018/ .
完成MYSQL分离以及图片分离
可以再NFS上查看了
pwd/data/nfs-blog/2018/02
ls
m2w500hq85lt_x_large_EQqD_500c000026851262-100x100.jpg
m2w500hq85lt_x_large_EQqD_500c000026851262-150x150.jpg
m2w500hq85lt_x_large_EQqD_500c000026851262-300x194.jpg
m2w500hq85lt_x_large_EQqD_500c000026851262.jpg
m2w500hq85lt_x_large_vIqg_741d00001d1f1262-100x100.jpg
m2w500hq85lt_x_large_vIqg_741d00001d1f1262-1-100x100.jpg
m2w500hq85lt_x_large_vIqg_741d00001d1f1262-1-150x150.jpg
m2w500hq85lt_x_large_vIqg_741d00001d1f1262-1-300x216.jpg
m2w500hq85lt_x_large_vIqg_741d00001d1f1262-150x150.jpg
m2w500hq85lt_x_large_vIqg_741d00001d1f1262-1.jpg
m2w500hq85lt_x_large_vIqg_741d00001d1f1262-300x216.jpg
m2w500hq85lt_x_large_vIqg_741d00001d1f1262.jpg
安装PHP以及搭建博客（三）服务迁移分离
原文地址：https://www.cnblogs.com/sky00747/p/8427474.html