0 Basic Learning Cloud computing and Big Data DBA cluster Architect "enterprise-level operation and maintenance technology and practice Project January 29, 2015 Friday"

Source: Internet
Author: User
Tags bz2 configuration php php website

lnmp/Lemp Project Construction {Project Framework # linux_____web_____php_____db # rhel7_____apache__-(libphp5.so)-__php__-(php-mysql)-__mariadb-Server # rhel7_____nginx___-(spawn-fcgi)-__php__-(php-mysql)-__mariadb-Server Installation Package # WEB Program # CGI Manager @ function (1) Listen on port 9000 (2) invoke PHP command @ software spawn-fcgi # PHP program PHP # database program MARIADB-Server # PHP-db Drive php-MySQL config nginx #/etc/nginx/conf.d/Configure Spawn-FCGI #/etc/sysconfig/spawn-fcgi Configuration mariadb-Server Create data File # finished PHP website Test}
lnmp/Lemp Project Building Experiment {[email protected]~]#Mount 172.25.254.250:/content/Mnt[[email protected]~]# rpm-ivh/mnt/item/nginx/other/nginx-1.8.0-1. El7.ngx.x86_64.rpm[[email protected]~]# rpm-ivh/mnt/item/nginx/epel/spawn-fcgi-1.6.3-5. El7.x86_64.rpm[[email protected]~]#Yum Install-Y php mariadb-server php-Mysql[[email protected]~]# cd/etc/nginx/conf.d/[email protected] conf.d]#CPdefault.conf www.bbs.com.conf[[email protected] conf.d]# vim Www.bbs.com.confserver {Listen the;    server_name www.bbs.com; Root/usr/share/nginx/bbs.com;    Index index.php index.html index.htm; Location~\.php$ {fastcgi_pass127.0.0.1:9000;    Fastcgi_index index.php; Fastcgi_param Script_filename/usr/share/nginx/Bbs.com$fastcgi_script_name;    Include Fastcgi_params; }}[[email protected] conf.d]#mkdir/usr/share/nginx/Bbs.com[[email protected] conf.d]# systemctl restart Nginx.service[[email protected] conf.d]# vim/etc/sysconfig/spawn-fcgioptions="-u nginx-g nginx-p 9000-c 32-f 1-p/var/run/spawn-fcgi.pid--/usr/bin/php-cgi"[email protected] conf.d]# systemctl start Spawn-Fcgi[[email protected] conf.d]#/sbin/chkconfig spawn-fcgi on[[email protected] conf.d]# Systemctl enable Mariadb.service[[email protected] conf.d]# systemctl start Mariad B.service[[email protected] conf.d]# mysqladmin-U root Password"uplooking"[email protected] php]#CPDiscuz_x3.2_sc_utf8.Zip/tmp/[[Email protected] php]# CD/tmp/[email protected] tmp]#UnzipDiscuz_x3.2_sc_utf8.Zip[email protected] tmp]#CP-R Upload/*/usr/share/nginx/bbs.com/[[email protected] tmp]# chown nginx/usr/share/nginx/bbs.com/-r[[email protected] ~]# echo 172.25.15.10 www.bbs.com >>/etc/hosts}
Project Migration {Migration Priority #数据库>process for other software migrations {1. Migration of Programs2. configuration file Migration3Backup and migration of data files4. Address modification5. Permission Modification}} LNMP Project Migration {Migration Priority #数据库>php Php-mysql spawn-fcgi Migration Process {1. Migration of Programs2. configuration file Migration3Backup and migration of data files4. Address modification5modification of permissions} database migration PHP-related programs Migration} database migration {operation on old machine {1>back up the data file and copy it to the new machine2>Modify the address in the configuration file (the configuration file here is not a database configuration file, but the configuration file of the program that uses the database)} actions on the new machine {1>Install the program and start the service2>Import data files on the old machine3>Modify permissions for a program}} Project migration Experiment {1. Database migration Experiment #实验目的: With the increase of website users, data volume is increasing, the database needs to be expanded, now want to put the database on a single server to solve the problem of insufficient database capacity #实验要求: The database from ServerB-Serverj2. LNMP Project Migration Experiment #实验目的: The original LNMP Service server aging, and now the company bought two new servers, to the LNMP service to the new server; The database is placed on a single server; PHP related programs are placed on a single server #实验要求: Data Library ServerB-->serverj;php Related Programs serverb-->ServerC3. LNMP Project migration and configuration of the second PHP service experiment #实验要求: The original LNMP Service server aging, now the company bought three new servers, to migrate LNMP services to the new server; The database is placed on a single server, and two units, two PHP Services} Please go to Experiment Forum Database Migration detailed experiment {#实验目的: With the increase of website users, the data volume is increasing, the database needs to be expanded, now want to put the database on a single server to solve the problem of insufficient database capacity # Experimental requirements: The database from the ServerB-serverj# Experimental steps:========================================================================serverb{#数据库备份 mysqldump--all-databases-uroot-puplooking >/tmp/mariadb.all.sql <--backing up and exporting database files to/tmp/mariadb.all.sql file #复制到serveri中SCP/tmp/mariadb.all.sql serveri:/tmp #地址的修改<== in the/usr/share/nginx/bbs.com/directory to find files ending in. php, locate the Uplooking keyword in the file, but not output (-Q), instead of outputting the file name of the file.    Here uplooking is the password of the database, please make changes according to the actual situation. CD/usr/share/nginx/bbs.com; forIinch$(Find./-name"*.php"); Do grep-Q"uplooking"$i &&Echo$i; Donevim xxx.php #将找到的文件进行修改, change localhost to the IP address of the server where the database resides#define(' uc_dbhost ', ' localhost ');}serverj{#安装mariadb-Server Note version installs the same version of the packetYum Install-Y mariadb-server #开启服务, and set boot service self-systemctl enable Mariadb;systemctl start mariadb #查看数据库文件是否复制成功 ll/tmp/mariadb.all.sql #导入数据库文件 MySQL</tmp/Mariadb.all.sql #授权serverb的spawn-fcgi Accessing the database #1>Authorized IP AddressEcho "Grant all on bbs.* to [e- Mail protected] ' 192.168.0.11 ' identified by ' uplooking ';"| Mysql-u Root-P uplooking #2>Authorized Host nameEcho "Grant all on bbs.* to [e- Mail protected] ' serverb.pod15.example.com ' identified by ' uplooking ';"| Mysql-uuroot-puplooking #更新授权表 mysqladmin-uroot-puplooking flush-Privileges}--------------------------------------------------------------------------#测试serverb {#关闭数据库服务 systemctl stop mariadb}workstation{#通过浏览器登陆www. bbs.com Firefox} #问题和答案 #-U root cannot have spaces;-p uplooking cannot have spaces mysqldump--all-databases-uroot-puplooking >/tmp/Mariadb.all.sql#find Search*. PHP must be in double quotation marksFind./-name"*.php"#mysql登陆方式 MySQL-uroot-puplooking MySQL-U Root-p Enter Password #*.*What do you mean by all the files in the directory? Echo "Grant All on * * to [e-mail protected] ' 192.168.0.11 ' identifide by ' uplooking ';"| Mysql-uroot-puplooking/var/lib/MySQL} LNMP Project Migration Experiment {#实验目的: The server of the original LNMP service aged, now the company bought two new servers, to migrate the LNMP service to the new server; The database is placed on a single server; PHP related programs on one server # Experimental requirements: Database ServerB-->serverj;php Related Programs serverb-->serverc# Experimental steps:===============================================================#第一步--Database migration (ServerB-serverj) serverb{#数据库备份 mysqldump--all-databases-uroot-puplooking >/tmp/mariadb.all.sql <--backing up and exporting database files to/tmp/mariadb.all.sql file #复制到serveri中SCP/tmp/mariadb.all.sql serveri:/tmp #地址的修改<== in the/usr/share/nginx/bbs.com/directory to find files ending in. php, locate the Uplooking keyword in the file, but not output (-Q), instead of outputting the file name of the file.    Here uplooking is the password of the database, please make changes according to the actual situation. CD/usr/share/nginx/bbs.com; forIinch$(Find./-name"*.php"); Do grep-Q"uplooking"$i &&Echo$i; Done#将找到的文件进行修改, modify server_name, the IP address of the server where the database resides, vim xxx.php}serverj{#安装mariadb-Server Note version installs the same version of the packetYum Install-Y mariadb-server #开启服务, and set boot service self-systemctl enable Mariadb;systemctl start mariadb #设置数据库密码 mysqladmin-U root Password'uplooking'#查看数据库文件是否复制成功 ll/tmp/mariadb.all.sql #导入数据库文件 MySQL</tmp/Mariadb.all.sql #授权serverb的spawn-fcgi Accessing the database #1>Authorized IP AddressEcho "Grant All on * * to [e-mail protected] ' 192.168.0.11 ' identified by ' uplooking ';"| Mysql-uroot-puplooking #2>Authorized Host nameEcho "Grant All on * * to [e-mail protected] ' serverb.pod15.example.com ' identified by ' uplooking ';"| Mysql-uroot-puplooking #更新授权表 mysqladmin-uroot-puplooking flush-Privileges}}---------------------------------------------------------------------------#第二步 Migration of--php related programs (ServerB-ServerC) serverb{#操作数据 (lazy approach, copy files directly to the past can be)SCP/etc/sysconfig/spawn-fcgi serverc:/etc/sysconfig/spawn-fcgi #将serverb中的php相关文件转移到 ServerC (requires the same directory, preferably packaged in a tar command to be copied to ServerC)Tar-CJF BBS.Tar. bz2/usr/share/nginx/bbs.com;SCPBbs.Tar. bz2 serverc:/usr/share/nginx/bbs.com #地址修改 ServerB in the/etc/nginx/CONF.D directory in the configuration file about PHP configuration PHP point to ServerC address location~\.php$ {fastcgi_pass127.0.0.1:9000; (instead of Servec's address) Fastcgi_index index.php; Fastcgi_param Script_filename/usr/share/nginx/Yeliangcheng.com$fastcgi_script_name;                   Include Fastcgi_params; }}serverc{#迁移程序--Install the same package PHP PHP-mysql/mnt/item/nginx/epel/spawn-fcgi-1.6.3-5. el7.x86_64.rpm #启动服务并设置开机自启 systemctl start Spawn-fcgi; /sbin/chkconfig spawn-fcgi on #php相关文件Tar-jxf/usr/share/nginx/bbs.com/bbs.Tar. bz2}===================================================================================#测试serverb {#关闭数据库服务 systemctl stop mariadb #关闭spawn-fcgi service Systemctl stop Spawn-fcgi/sbin/chkconfig spawn-fcgi off}workstation{#通过浏览器登陆www. bbs.com Firefox} #问题和解决}

0 Basic Learning Cloud computing and Big Data DBA cluster Architect "enterprise-level operation and maintenance technology and practice Project January 29, 2015 Friday"

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.