mysql安装脚本，俊哥V5

q528

　　#mysql部署过程
#version: v0.1
#date   : 2010-11-17
#by     : lee
　　cd /root
mkdir soft
mkdir /data
cd soft
wget --user=tools --password=easoutools ftp://install.easou.com/database/mysql/mysql-5.0.45.tar.gz
  
tar zxvf mysql-5.0.45.tar.gz
cd mysql-5.0.45
#建立账号和组
groupadd -g 600 mysql
useradd -u  600 mysql -g mysql -s /sbin/nologin
　　#建立日志目录
mkdir -p /log/mysql 
#修改权限            
chown mysql:mysql -R /log/mysql  
mkdir /data/mysql_log
chown mysql:mysql -R /data/mysql_log
mkdir -p /app/soft/mysql
mkdir /data/mysql
#配置
./configure --prefix=/app/soft/mysql --without-debug --with-charset=utf8 --with-extra-charsets=complex --enable-assembler --without-isam --with-pthread --enable-thread-safe-client --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static  && make && make install
　　#生成mysql用户数据库和表文件到/data/mysql下 
scripts/mysql_install_db --user=mysql --datadir=/data/mysql
　　#copy启动的mysqld文件
　　
#修改先关文件夹权限
chmod -R 750 /app/soft/mysql
chmod -R 750 /data/mysql
　　chgrp -R mysql /app/soft/mysql
mkdir -p /app/soft/mysql/var
chown -R mysql:mysql /app/soft/mysql/var
chown -R mysql:mysql /data/mysql
mkdir -p /data/mysqltmp
chown -R mysql:mysql /data/mysqltmp
　　
#配置my.cnf
cat << EOF > /etc/my.cnf
[client]
default-character-set = utf8
port=3306
socket=/tmp/mysql.sock
　　[mysqld]
character-set-server = utf8
skip-bdb
skip-locking
skip-name-resolve
#skip-networking
low_priority_updates
innodb_file_per_table
innodb_flush_log_at_trx_commit      =1
ft_min_word_len                     =1
server-id                           =1
long_query_time                     =2
innodb_log_files_in_group           =2
innodb_file_io_threads              =4
net_buffer_length                   =8K
thread_cache_size                   =8
thread_concurrency                  =16
innodb_thread_concurrency           =16
wait_timeout                        =300
interactive_timeout                 =300
innodb_lock_wait_timeout            =300
innodb_max_dirty_pages_pct          =90
delayed_insert_limit                =256
max_delayed_threads                 =256
back_log                            =512
max_user_connections                =512
port                                =3306
max_connections                     =2048
table_cache                         =1024
max_connect_errors                  =1000
table_lock_wait_timeout             =300
connect_timeout                     =300
　　thread_stack                        =192K
binlog_cache_size                   =1M
read_buffer_size                    =8M
max_allowed_packet                  =80M
innodb_log_buffer_size              =16M
sort_buffer_size                    =16M
join_buffer_size                    =16M
read_rnd_buffer_size                =16M
query_cache_limit                   =16M
query_cache_size                    =512M
query_cache_type                    =1
innodb_additional_mem_pool_size     =16M
key_buffer_size                     =32M
bulk_insert_buffer_size             =64M
tmp_table_size                      =256M
max_heap_table_size                 =64M
#innodb_log_file_size                =256M
innodb_buffer_pool_size             =1G
myisam_sort_buffer_size             =64M
　　user                                =mysql
default_table_type                  =MYISAM
innodb_flush_method                 =O_DIRECT
transaction-isolation               =READ-COMMITTED
tmpdir                              =/data/mysqltmp
basedir                             =/app/soft/mysql
socket                              =/tmp/mysql.sock
datadir                             =/data/mysql
#log-slow-queries                   =/data/mysql_log/slowquery.log
log-error                           =/log/mysql/mysql_error.log
　　#Set Master/Slave
######Master#####
log-bin                             = mysql-bin
server-id                           = 1
log-bin                             =/data/mysql_log/mysql-bin
binlog-do-db                        =contentnewdb
binlog-ignore-db                    =mysql
　　[mysqldump]
quick
max_allowed_packet=16M
　　[mysql]
no-auto-rehash
　　[myisamchk]
key_buffer=256M
sort_buffer_size=256M
read_buffer=4M
write_buffer=4M
　　[mysqlhotcopy]
interactive-timeout
　　[mysqld_safe]
open-files-limit                    =8192
EOF