wordpress布置网站教程,wordpress it模板下载地址,公司网站建设的基本流程,wordpress一键生成实现Web服务器之间使用同一个MYSQL和相同的网页配置文件的方法发布时间#xff1a;2020-04-15 16:42:41来源#xff1a;亿速云阅读#xff1a;133作者#xff1a;三月栏目#xff1a;数据库亿速云负载均衡(Cloud Load Balancer)是对多台云服务器进行流量分发的服务。亿速云…实现Web服务器之间使用同一个MYSQL和相同的网页配置文件的方法发布时间2020-04-15 16:42:41来源亿速云阅读133作者三月栏目数据库亿速云负载均衡(Cloud Load Balancer)是对多台云服务器进行流量分发的服务。亿速云负载均衡可以通过流量分发扩展应用系统对外的服务能力通过消除单点故障提升应用系统的可用性。亿速云负载均衡服务通过设置虚拟服务地址(VIP)将位于同一地域的多台云服务器资源虚拟成一个高性能、高可用的应用服务池。根据应用指定的方式将来自客户端的网络请求分发到云服务器池中。亿速云负载均衡服务会检查云服务器池中云服务器实例的健康状态自动隔离异常状态的实例从而解决了云服务器的单点问题同时提高了应用的整体服务能力。今天亿速云给大家介绍下实现Web服务器之间使用同一个MYSQL和相同的网页配置文件的方法前言用NFS、LAMP、BIND结合的方法应对网络中访问量增大而导致云服务器负载运行的情况。以实现Web服务器之间使用同一个MYSQL和相同的网页配置文件。实验环境HostNameIP规划nfs.preferred.com192.168.1.6NFSns.preferred.com192.168.1.5mysql.preferred.com192.168.1.4MYSQLwww.preferred.com192.168.1.3WEBwww.preferred.com192.168.1.2WEB实验拓扑实验步骤一、搭建NFS以下操作在nfs.preferred.com服务器上实现[rootlocalhost ~]# yum install nfs-utils -y [rootlocalhost ~]# rpm -qa | grep nfs-utils --colornfs-utils-1.2.3-39.el6.x86_64创建共享目录并配置nfs文件[rootlocalhost~]# mkdir /mydata[rootlocalhost~]# mkdir /webdata[rootlocalhost~]# cd /webdata/[rootlocalhost webdata]# unzip wordpress-3.2.1-zh_CN.zip /dev/null[rootlocalhost webdata]# chmod -R 777 wordpress[rootlocalhost webdata]# ls -ldrwxrwxrwx 5 root root 4096 Oct 11 2016 wordpress-rw-r--r-- 1 root root 4372680 Oct 11 2016 wordpress-3.2.1-zh_CN.zip[rootlocalhost webdata]# vim /etc/exports/mydata 192.168.1.4(rw,no_root_squash)/webdata 192.168.1.2(rw,no_root_squash) 192.168.1.3(rw,no_root_squash)[rootlocalhost ~]# service rpcbind start注rpcbind是一个RPC服务主要是在nfs共享的时候负责通知客户端、服务器nfs端口号。[rootlocalhost ~]# service nfs startStarting NFS services: [ OK ]Starting NFS quotas: [ OK ]Starting NFS mountd: [ OK ]Starting NFS daemon: [ OK ]Starting RPC idmapd: [ OK ][rootlocalhost ~]# showmount -e 192.168.1.6 Export list for 192.168.1.6:/webdata 192.168.1.3,192.168.1.2/mydata 192.168.1.4二、搭建DNS以下操作在ns.preferred.com服务器上实现[rootlocalhost ~]# yum install bind -y | tail -n 5Installed:bind.x86_64 32:9.8.2-0.47.rc1.el6_8.1Complete![rootlocalhost ~]# vim /etc/named.rfc1912.zones zone preferred.com IN {type master;file preferred.com.zone;};zone 1.168.192.in-addr.arpa IN {type master;file 192.168.1.5.zone;};[rootlocalhost ~]# vim /var/named/preferred.com.zone $TTL 86400$ORIGIN preferred.com. IN SOA ns.preferred.com admin.preferred.com (20161010011D5M7D1D )IN NS nsns IN A 192.168.1.5www IN A 192.168.1.2www IN A 192.168.1.3nfs IN A 192.168.1.6[rootlocalhost ~]# vim /var/named/192.168.1.5.zone $TTL 86400 IN SOA ns.preferred.com. admin.preferred.com (20161010011H5M7D1D )IN NS ns.preferred.com.5 IN PTR ns.preferred.com.2 IN PTR www.preferred.com.3 IN PTR www.preferred.com.6 IN PTR nfs.preferred.com.[rootlocalhost ~]# systemctl restart named[rootlocalhost ~]# dig -t A www.preferred.com 192.168.1.5 ; DiG 9.9.4-RedHat-9.9.4-29.el7_2.4 -t A www.preferred.com 192.168.1.5;; global options: cmd;; Got answer:;; -HEADER;; flags: qr aa rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 1, ADDITIONAL: 2;; OPT PSEUDOSECTION:; EDNS: version: 0, flags:; udp: 4096;; QUESTION SECTION:;www.preferred.com.INA;; ANSWER SECTION:www.preferred.com.86400INA192.168.1.2www.preferred.com.86400INA192.168.1.3;; AUTHORITY SECTION:preferred.com.86400INNSns.preferred.com.;; ADDITIONAL SECTION:ns.preferred.com.86400INA192.168.1.5;; Query time: 0 msec;; SERVER: 192.168.1.5#53(192.168.1.5);; WHEN: Tue Oct 11 04:22:36 EDT 2016;; MSG SIZE rcvd: 111[rootlocalhost ~]# dig -x 192.168.1.2 192.168.1.5 ; DiG 9.9.4-RedHat-9.9.4-29.el7_2.4 -x 192.168.1.2 192.168.1.5;; global options: cmd;; Got answer:;; -HEADER;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 1, ADDITIONAL: 2;; OPT PSEUDOSECTION:; EDNS: version: 0, flags:; udp: 4096;; QUESTION SECTION:;2.1.168.192.in-addr.arpa.INPTR;; ANSWER SECTION:2.1.168.192.in-addr.arpa. 86400INPTRwww.preferred.com.;; AUTHORITY SECTION:1.168.192.in-addr.arpa.86400INNSns.preferred.com.;; ADDITIONAL SECTION:ns.preferred.com.86400INA192.168.1.5;; Query time: 0 msec;; SERVER: 192.168.1.5#53(192.168.1.5);; WHEN: Tue Oct 11 04:23:57 EDT 2016;; MSG SIZE rcvd: 117三、搭建MYSQL以下操作在mysql.preferred.com服务器上实现[rootlocalhost ~]# mkdir /mydata/[rootlocalhost ~]# mount -t nfs 192.168.1.6:/mydata/ /mydata/ [rootlocalhost ~]# groupadd -r mysql [rootlocalhost ~]# useradd -r -g mysql -s /sbin/nologin mysql[rootlocalhost ~]# cd /usr/local/[rootlocalhost local]# ln -sv /root/mariadb-5.5.43-linux-x86_64 mysqlmysql - /root/mariadb-5.5.43-linux-x86_64[rootlocalhost local]# cd mysql/[rootlocalhost mysql]# lsbin COPYING.LESSER EXCEPTIONS-CLIENT INSTALL-BINARY man README share support-filesCOPYING data include lib mysql-test scripts sql-bench[rootlocalhost mysql]# ./scripts/mysql_install_db --usermysql --datadir/mydata/ Installing MariaDB/MySQL system tables in /mydata ...161010 13:33:59 [Note] ./bin/mysqld (mysqld 5.5.43-MariaDB) starting as process 2183 ...OKFilling help tables...161010 13:33:59 [Note] ./bin/mysqld (mysqld 5.5.43-MariaDB) starting as process 2191 ...OK...[rootlocalhost mysql]# ls /mydata/ aria_log.00000001 aria_log_control mysql performance_schema test[rootlocalhost mysql]# mkdir /etc/mysql/[rootlocalhost mysql]# cp support-files/my-large.cnf /etc/mysql/my.cnf[rootlocalhost mysql]# vim /etc/mysql/my.cnf datadir /mydatainnodb_file_per_table onskip_name_resolve on[rootlocalhost mysql]# service mysqld startStarting MySQL... [确定][rootlocalhost mysql]# ss -tnl | grep 3306 LISTEN 0 50 *:3306 *:* *:*[rootlocalhost mysql]# mysql-bash: mysql: command not found注尝试登陆MYSQL却报错不要紧张。这是因为/usr/local/bin目录下确实mysql导致只需要建立一个软连接即可解决。[rootlocalhost ~]# ln -sv /usr/local/mysql/bin/mysql /usr/bin//usr/bin/mysql - /usr/local/mysql/bin/mysql[rootlocalhost ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 115Server version: 5.5.43-MariaDB-log MariaDB ServerCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.Type help; or \h for help. Type \c to clear the current input statement.MariaDB [(none)] CREATE DATABASE pre;Query OK, 1 rows affected (0.00 sec)MariaDB [(none)] GRANT ALL ON pre.* TO jds% IDENTIFIED BY redhat; Query OK, 0 rows affected (0.01 sec)MariaDB [(none)] FLUSH PRIVILEGES;Query OK, 0 rows affected (0.00 sec)四、搭建WEB以下操作在www.preferred.com(192.168.1.2)服务器上实现[rootlocalhost ~]# yum install httpd php-mysql php -y | tail -n 10warning: rpmts_HdrFromFdno: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEYImporting GPG key 0xC105B9DE:Userid: CentOS-6 Key (CentOS 6 Official Signing Key) Package: centos-release-6-5.el6.centos.11.1.x86_64 (anaconda-CentOS-201311272149.x86_64/6.5)From: /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6php-cli.x86_64 0:5.3.3-48.el6_8 php-common.x86_64 0:5.3.3-48.el6_8php-pdo.x86_64 0:5.3.3-48.el6_8Updated:httpd.x86_64 0:2.2.15-54.el6.centosDependency Updated:httpd-tools.x86_64 0:2.2.15-54.el6.centosComplete![rootlocalhost ~]# mkdir /webdata[rootlocalhost ~]# vim /etc/httpd/conf/httpd.conf ServerName www.preferred.com:80ServerName www.preferred.comDocumentRoot /webdata/wordpress[rootlocalhost ~]# service rpcbind start[rootlocalhost ~]# mount -t nfs 192.168.1.6:/webdata /webdata[rootlocalhost ~]# ls /webdata/wordpress wordpress-3.2.1-zh_CN.zip[rootlocalhost ~]# service httpd startStarting httpd: [ OK ]接下来安装wordpress没有的话可以自己去下载一个https://wordpress.org/download/[rootlocalhost ~]# cd /webdata/wordpress[rootlocalhost wordpress]# lsindex.php wp-app.php wp-config.php wp-includes wp-pass.php wp-settings.phplicense.txt wp-atom.php wp-config-sample.php wp-links-opml.php wp-rdf.php wp-signup.phpreadme.html wp-blog-header.php wp-content wp-load.php wp-register.php wp-trackback.phpwp-activate.php wp-comments-post.php wp-cron.php wp-login.php wp-rss2.php xmlrpc.phpwp-admin wp-commentsrss2.php wp-feed.php wp-mail.php wp-rss.php[rootlocalhost wordpress]# cp wp-config-sample.php wp-config.php [rootlocalhost wordpress]# vim wp-config.php// ** MySQL 设置 - 具体信息来自您正在使用的主机 ** ///** WordPress 数据库的名称 */define(DB_NAME, pre); /** MySQL 数据库用户名 */define(DB_USER, jds);/** MySQL 数据库密码 */define(DB_PASSWORD, redhat);/** MySQL 主机 */define(DB_HOST, 192.168.1.4);/** 创建数据表时默认的文字编码 */define(DB_CHARSET, utf8);/** 数据库整理类型。如不确定请勿更改 */define(DB_COLLATE, );[rootlocalhost ~]# mysql -ujds -predhat -h 192.168.1.4 ERROR 2003 (HY000): Cant connect to MySQL server on 192.168.1.4 (113)注遇到这个问题怎么个人都不好了在MYSQL服务器上取消防火墙也不行。所以尝试在MYSQL服务器的防火墙上加上端口的允许。[rootlocalhost ~]# iptables -L -n | grep 3306[rootlocalhost ~]# iptables -I INPUT -s 0/0 -p tcp --dport 3306 -j ACCEPT[rootlocalhost mysql]# iptables -L -n | grep 3306ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:3306[rootlocalhost ~]# mysql -ujds -predhat -h 192.168.1.4 Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 116Server version: 5.5.43-MariaDB-log MariaDB ServerCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.Type help; or \h for help. Type \c to clear the current input statement.MariaDB [(none)] SHOW DATABASES;--------------------| Database |--------------------| information_schema || mysql || performance_schema || pre | | test |--------------------5 rows in set (0.00 sec)测试访问正常以下操作在www.preferred.com(192.168.1.3)服务器上实现[rootlocalhost ~]# yum install httpd php-mysql php -y[rootlocalhost ~]# mkdir /webdata[rootlocalhost ~]# vim /etc/httpd/conf/httpd.conf ServerName www.preferred.com:80ServerName www.preferred.comDocumentRoot /webdata/wordpress[rootlocalhost ~]# service rpcbind start[rootlocalhost ~]# mount -t nfs 192.168.1.6:/webdata /webdata[rootlocalhost ~]# ls /webdata/wordpress wordpress-3.2.1-zh_CN.zip[rootlocalhost ~]# service httpd startStarting httpd:[ OK ]先用WEB(192.168.1.3)进行测试。发布一条文章用WEB(192.168.1.2)进行测试。现在访问看看看到了在WEB(192.168.1.3)上发布的文章我们在WEB(192.168.1.2)上也发布一篇最后我们在WEB(192.168.1.3)上查看至此我们实验的目的已经达到。如果大家还有什么地方需要了解的可以在亿速云官网找我们的专业技术工程师的亿速云技术工程师在行业内拥有十几年的经验了所以会比小编回答的更加详细专业。亿速云官网链接www.yisu.com
