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

Lamp

Layering mechanism:

User-- [httpd Protocol]-- apache-- [fastCGI Protocol]-- php-- [mysql Protocol]-- mysql

Layering benefits:

Apache php and mysql are both CPU-intensive services, and layering can relieve CPU pressure.

Those on the same layer can also do load balancing.

* the way Apache and PHP are combined *

1. In a modular way, php is programmed into Apache modules

At this point, php is a subfunction of Apache, so there is no need to start additional processes when calling php

Php modules are already loaded inside any httpd process

When apache uses different MPM, the module of php is also different

Prefork:libphp5.so

Worker,event:libphp5-zts.so

2, CGI interface

3 php,php 5.3.3 in the CGI mode receives the fastCGI

Compile php-fpm and start it as a service process, listening under a socket

Service process fork several idle processes for other processes to call

* php-mysql*

Connect to mysql through the client program mysql_connect ()

$link = mysql_connect ('IP','user','mypass') creates a connection between PHP and mysql

Mysql_close ()

* Primary and secondary servers of mysql *

Master: all write operations are on the master server, and data read operations are also provided.

Slave: read operation

Cache server, improve hit ratio, bypass (bypass)

* memcached pure cache server *

LAMMP

Memcached must be called by the front-end program to be valid.

#

* redis*

Work in memory

Persistent storage, non-relational database (NoSQL)

* *

Dynamic and static separation

Highly available cluster-> scripting refueling

* *

Installation sequence:

Httpd mysql, and finally php

* install mysql*

Mysql-5.5.33-linux2.6-x86_64.tar.gz

1. Add mysql user and mysql group, and set the user to nologin

Groupadd-r mysql create system group

Useradd-g mysql-r-s / sbin/nologin mysql

2, extract to / usr/local

Create the soft connection of the decompressed package as / usr/local/mysql, and you can directly reconnect the mysql directory for future upgrades.

Cd / usr/local

Tar-zxf mysql-5.5.33-linux2.6-x86_64.tar.gz

Ln-sv mysql-5.5.33-linux2.6-x86_64 mysql regenerates the mysql connection when upgrading mysql

3. Create logical volume management to store database files

Mkdir data

Fdisk / dev/sda (n; f 8e)

Kpartx-af / dev/sda

Partx-a / dev/sda informs the kernel to read the new partition

Cat / proc/partitions

Pvcreate / dev/sda2

Vgcreate mysqlvg / dev/sda2

Lvcreate-L 2G-n mysqllv1 mysqlvg

Mount / dev/mysqlvg/mysqlvg / data

Vi / etc/fstab

/ dev/mysqlvg/mysqllv1 ext4 / data defaults,noatime,nodiratime 0 0

Cd / data

Mkdir mydata plan database storage directory

Chown-R mysql:mysql mydata changes the owner of the database storage directory to mysql

4, create and configure the database

Cd / usr/local/mysql

Chown-R root:mysql. / *

Scripts/mysql_install_db-- datadir=/data/mydata-- user=mysql create database

Cp support-files/mysql.server / etc/init.d/mysqld starts the database service

Chkconfig-add mysqld

Cp support-files/my-large.cnf / etc/my.cnf

Vi / etc/my.cnf

Datadir = / data/mydata

Service mysqld start

At this point, the mysql command cannot be found and needs to be edited

Vim / etc/profile.d/mysql.sh

Export PATH=/usr/local/mysql/bin:$PATH

. ! *! * represents the parameters of the previous command

5. Log in to mysql

Security settin

Drop user'@ 'localhost'; removes anonymous users

Use mysql

Select host,user,password from user

Update user set password=PASSWORD ('mysql2009') where user='root'

Flush privileges

6 configuration files for MySQL

Create the. my.cnf under the home directory

[mysql]

User = root

Host = localhost

Password = mysql2009

Mysql configuration file read order: / etc/my.cnf-- > $MYSQL_BASE/my.cnf

-defaults-extra-file = / path/to/some_my.cnf-- > .my.cnf

7, export the library file

Ln-sv / usr/local/mysql/include/ / usr/include/mysql

8, export the header file

Vim / etc/ld.so.conf.d/mysql

/ usr/local/mysql/lib

Ldconfig refresh dynamic library

Ldconfig-p | grep mysql view

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.