听说Memcache你很豪横？-------------深入剖析Memcache 安装及管理数据库操作

root@promote memcached-1.5.6]# telnet 127.0.0.1 11211
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
set username 0 0 10       0不设置他的序列号  0  不设置他的过期时间  10 设置字符长度
evereqqqqq
STORED
gets username
VALUE username 0 10 2              更新因子  每次更新都会加一
evereqqqqq
END

------------安装Apache----下面两个插件是httpd2.4以后的版本所需要-----
tar xf apr-1.6.2.tar.gz
tar xf apr-util-1.6.0.tar.gz
tar xf httpd-2.4.29.tar.gz
mv apr-1.6.2 httpd-2.4.29/srclib/apr
mv apr-util-1.6.0 httpd-2.4.29/srclib/apr-util

yum -y install \
gcc \
gcc-c++ \
make \
pcre-devel \
expat-devel \
perl

cd httpd-2.4.29

./configure \
--prefix=/usr/local/httpd \
--enable-so \
--enable-rewrite \
--enable-charset-lite \
--enable-cgi

make && make install

cp /usr/local/httpd/bin/apachectl /etc/init.d/httpd
vi /etc/init.d/httpd

# chkconfig: 35 85 21  //35级别自动运行  第85个启动 第21个关闭
# description: Apache is a World Wide Web server

chkconfig --add httpd //将httpd加入到SERVICE管理器

vi /usr/local/httpd/conf/httpd.conf
ServerName 

ln -s /usr/local/httpd/conf/httpd.conf /etc/
ln -s /usr/local/httpd/bin/* /usr/local/bin/

systemctl stop firewalld.service
setenforce 0

httpd -t 
apachectl -t

service httpd start
netstat -anpt | grep 80


--------------以下是安装MYSQL-----http://mirrors.sohu.com/mysql/---

yum install -y ncurses-devel autoconf


tar xzvf mysql-5.6.26.tar.gz
cd mysql-5.6.26

cmake  \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DSYSCONFIDIR=/etc \
-DMYSQL_DATADIR=/home/mysql/ \
-DMYSQL_UNIX_ADDR=/home/mysql/mysql.sock

make && make install

cp support-files/my-default.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld       
chkconfig --add /etc/init.d/mysqld
chkconfig  mysqld --level 235 on

echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
echo $PATH

useradd -s /sbin/nologin mysql
chown -R mysql:mysql /usr/local/mysql/

/usr/local/mysql/scripts/mysql_install_db \
--user=mysql \
--ldata=/var/lib/mysql \
--basedir=/usr/local/mysql \
--datadir=/home/mysql

ln -s /var/lib/mysql/mysql.sock  /home/mysql/mysql.sock

vi  /etc/init.d/mysqld

basedir=/usr/local/mysql     
datadir=/home/mysql

service mysqld start
netstat -anpt | grep 3306

mysqladmin -u root -p password "abc123" //给root账号设置密码

---------以下安装PHP------------
yum -y install \
gd \
libpng \
libpng-devel \
pcre \
pcre-devel \
libxml2-devel \
libjpeg-devel

tar xjvf php-5.6.11.tar.bz2
cd php-5.6.11

./configure \
--prefix=/usr/local/php5 \
--with-gd \
--with-zlib \
--with-apxs2=/usr/local/httpd/bin/apxs \
--with-mysql=/usr/local/mysql \
--with-config-file-path=/usr/local/php5 \
--enable-mbstring 

make && make install

cp php.ini-development /usr/local/php5/php.ini
ln -s /usr/local/php5/bin/* /usr/local/bin/
ln -s /usr/local/php5/sbin/* /usr/local/sbin/

vi /etc/httpd.conf //在合适位置新增

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

 

vi /usr/local/httpd/htdocs/index.php
<?php
phpinfo();
?>

在网页测试“http://192.168.80.182/index.php”



--------下面测试数据库工作是否正常-----
mysql -u root -p

CREATE DATABASE sky;
GRANT all ON sky.* TO 'skyuser'@'%' IDENTIFIED BY 'admin123';
flush privileges; 

<?php
$link=mysql_connect('192.168.80.193','skyuser','admin123');
if($link) echo "<h1>Success!!</h1>";
else echo "Fail!!";
mysql_close();
?>

[root@localhost apache]# mysql -u root -p
GRANT all ON dog.* TO 'doguser'@'%' IDENTIFIED BY 'adc123';
mysql> flush privileges;

[root@localhost mysql]# vim /usr/local/httpd/htdocs/index.php
 <?php
$link=mysql_connect('192.168.110.133','doguser','adc123');
if($link) echo "<h1>Success!!</h1>";
else echo "Fail!!";
mysql_close();
?>

yum install telnet -y
telnet 127.0.0.1 11211   //连接本地用 127.0.0.1就可以了，连接其他主机使用对应IP地址即可

add username 0 0 7  //添加数据（两个0表示：不进行压缩和序列化标识，数据过期时间为永不过期；标识号是7就需要输入7位数。）
allways   //输入一个7位数

get username  //查询数据

gets username

set username 0 0 10       //更新信息，若键名不存在，则自行添加
everything

replace username 0 0 8    //更新信息，若键名不存在，则报错
12345678

stats                  //显示状态信息
stats items            //返回所有键值对的统计信息
stats cachedump 1 0    //返回指定存储空间的键值对 
stats slabs            //显示各个slab的信息
stats sizes           //输出所有item的大小和个数
stats reset           //清空统计数据

quit