RockNoon的猪窝

前言：本文是根据blog.s135.com [搭建胜过Apache十倍的Web服务器] 为基础，主要讲解如何在最新版本Ubuntu 11.10下部署 PHP + Mysql + Apache + Nginx 环境的搭建。全文分文三篇 mysql , php , nginx. 这是第一篇主要讲如何部署安装mysql。

本系列所要用到的软件下载

wget http://blog.s135.com/soft/linux/nginx_php/mysql/mysql-5.5.3-m3.tar.gz
wget http://mirror.bjtu.edu.cn/apache//httpd/httpd-2.2.21.tar.gz
wget http://cn2.php.net/distributions/php-5.2.17.tar.gz
wget http://www.nginx.org/download/nginx-1.0.11.tar.gz
wget http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.14.tar.gz
wget http://blog.s135.com/soft/linux/nginx_php/mcrypt/libmcrypt-2.5.8.tar.gz
wget http://blog.s135.com/soft/linux/nginx_php/mcrypt/mcrypt-2.6.8.tar.gz
wget http://blog.s135.com/soft/linux/nginx_php/mhash/mhash-0.9.9.9.tar.gz
wget http://blog.s135.com/soft/linux/nginx_php/eaccelerator/eaccelerator-0.9.6.1.tar.bz2
wget http://blog.s135.com/soft/linux/nginx_php/pdo/PDO_MYSQL-1.0.2.tgz

1. 源更新

#编辑源

sudo vim etc/apt/source.list

deb http://mirrors.163.com/ubuntu/ oneiric main universe restricted multiverse
deb-src http://mirrors.163.com/ubuntu/ oneiric main universe restricted multiverse
deb http://mirrors.163.com/ubuntu/ oneiric-security universe main multiverse restricted
deb-src http://mirrors.163.com/ubuntu/ oneiric-security universe main multiverse restricted
deb http://mirrors.163.com/ubuntu/ oneiric-updates universe main multiverse restricted
deb http://mirrors.163.com/ubuntu/ oneiric-proposed universe main multiverse restricted
deb-src http://mirrors.163.com/ubuntu/ oneiric-proposed universe main multiverse restricted
deb http://mirrors.163.com/ubuntu/ oneiric-backports universe main multiverse restricted
deb-src http://mirrors.163.com/ubuntu/ oneiric-backports universe main multiverse restricted
deb-src http://mirrors.163.com/ubuntu/ oneiric-updates universe main multiverse restricted

#对源进行更新
sudo apt-get update

2. mysql 的编译与安装

#下边是俩个需要用到的lib

sudo apt-get install make
sudo apt-get install libncurses5-dev
sudo apt-get install g++

tar xzvf mysql-5.5.3-m3.tar.gz

./configure --prefix=/usr/local/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=partition,innobase,myisammrg

 (notice: 在使用gcc4.5版本遇到一个bug error do_abi_check 需要手动修改 makefile 里边注释掉 do_abi_check 后的内容。)

make
sudo make install

#创建mysql用户
sudo groupadd mysql
sudo useradd -g mysql mysql

#创建log和data文件夹
sudo mkdir /var/mysql

sudo mkdir /var/log/mysql/
sudo mkdir /var/log/mysql//binlog
sudo mkdir /var/log/mysql//relaylog
sudo chown -R mysql:mysql /var/mysql/

#初始化数据表

sudo /usr/local/mysql/bin/mysql_install_db --basedir=/usr/local/mysql --datadir=/var/mysql/ --user=mysql

#编码mysql配置 以下配置可以根据自己服务器环境进行配置调优

sudo vim /usr/local/mysql/my.cnf

[client]
character-set-server = utf8
port    = 3306
socket  = /tmp/mysql.sock
[mysqld]
character-set-server = utf8
replicate-ignore-db = mysql
replicate-ignore-db = test
replicate-ignore-db = information_schema
user    = mysql
port    = 3306
socket  = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /var/mysql/
log-error = /var/log/mysql/mysql_error.log
pid-file =  /usr/local/mysql/mysql.pid
open_files_limit    = 2000
back_log = 600
max_connections = 1000
max_connect_errors = 2000
table_cache = 100
external-locking = FALSE
max_allowed_packet = 16M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 20
#thread_concurrency = 8
query_cache_size = 128M
query_cache_limit = 1M
query_cache_min_res_unit = 2k
default-storage-engine = MyISAM
thread_stack = 192K
transaction_isolation = READ-UNCOMMITTED
tmp_table_size = 32M
max_heap_table_size = 64M
long_query_time = 2
log-slave-updates
log-bin = /var/log/mysql/binlog
binlog_cache_size = 2M
binlog_format = MIXED
max_binlog_cache_size = 4M
max_binlog_size = 512M
relay-log-index = /var/log/mysql/relaylog
relay-log-info-file = /var/log/mysql/relaylog
relay-log = /var/log/mysql/relaylog
expire_logs_days = 30
key_buffer_size = 32M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
bulk_insert_buffer_size = 16M
myisam_sort_buffer_size = 32M
myisam_max_sort_file_size = 1G
myisam_repair_threads = 1
myisam_recover
interactive_timeout = 120
wait_timeout = 120
skip-name-resolve
slave-skip-errors = 1032,1062,126,1114,1146,1048,1396
server-id = 1
[mysqldump]
quick
max_allowed_packet = 32M

3. 启动mysql

sudo vim /etc/init.d/mysql

#!/bin/sh
mysql_port=3306
mysql_username="root"
mysql_password="root"
function_start_mysql()
{
    printf "Starting MySQL...\n"
    sudo /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf 2>&1 > /dev/null &
}
function_stop_mysql()
{
    printf "Stoping MySQL...\n"
    sudo /usr/local/mysql/bin/mysqladmin -u${mysql_username} -p${mysql_password} -S /tmp/mysql.sock shutdown
}
function_restart_mysql()
{
    printf "Restarting MySQL...\n"
    function_stop_mysql
    sleep 5
    function_start_mysql
}
if [ "$1" = "start" ]; then
    function_start_mysql
elif [ "$1" = "stop" ]; then
    function_stop_mysql
elif [ "$1" = "restart" ]; then
    function_restart_mysql
elif [ "$1" = "kill" ]; then
    function_stop_mysql
else
    printf "Usage: mysql-server {start|stop|restart|kill}\n"
fi

#启动mysql
sudo chmod +x /etc/init.d/mysql
sudo /etc/init.d/mysql start

4. 为mysql root 用户建立密码

sudo /usr/local/mysql/bin/mysqladmin -u root password 'root'