mysql脚本安装_shell 之 mysql安装脚本

此文为mysql 服务器安装脚本。

#!/bin/bash

#ver 0.2

#by zm 2011/04/23

#安装 mysql_server;

#注意！！

#参数解释

#

# CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors \

# -fno-exceptions -fno-rtti -fomit-frame-pointer -ffixed-ebp"   // 如果是Inter处理器，使用pgcc提高1%性能

#

#

#   --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock   // 使用unix套接字链接提高7.5%性能，所以在windows下mysql性能肯定不如unix下面

#    --with-client-ldflags=-all-static

#    --with-mysqld-ldflags=-all-static     //-static  13%,静态链接提高13%性能

#

#    --with-readline   从“行”上面读取

#

#    --with-charset=utf8 指定缺省字符集

#

#    --with-collation=utf8_general_ci  指定缺省排序方式

#

#    --with-extra-charsets=complex  安装所有字符，有这个就足够了

#

#    --with-extra-charsets=all 指定安装扩展字符集

#

#    --enable-local-infile 指定允许本地导入文件

#

#    --enable-thread-safe-client 指定线程安全模式

#

#    --enable-assembler 允许使用汇编模式(优化性能)

#

#    --with-big-tables 指定支持超大表

#

#    --without-debug  去除诊断模式，如果用--with-debug=full编译，大多数查询慢20%

#

#变量

mysql_cnf_dir=/etc/my.cnf

mysql_dir=/usr/local/mysql

os_type=`uname`

user=`grep 'mysql' /etc/passwd | wc -l`

###mysql_server

#check os

if [ $os_type != "Linux" ];then

echo "the script for linux only!"

exit 1

fi

#check mysql user and group

if [ $user = 0 ];then

useradd -s /sbin/nologin mysql

echo "useradd mysql !"

fi

#

if [ ! -f "$mysql_cnf_dir" ] || [ ! -d "$mysql_dir" ];then

tar zxf mysql*.tar.gz

cd mysql*/

#

CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti -fomit-frame-pointer -ffixed-ebp" \

./configure --prefix=/usr/local/mysql --enable-assembler \

--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static \

--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \

--with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=all \

--with-readline --enable-local-infile --enable-thread-safe-client \

--with-big-tables --without-debug

make

make install

#configure file

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

cp support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

cd ../

rm -rf mysql*/

#install_mysql_db

mysql_var=`ls -l $mysql_dir/var/mysql | grep '^d' |  wc -l`

if [ "$mysql_var" = 0 ];then

chow -R mysql.mysql $mysql_dir/var

chow -R mysql.mysql $mysql_dir/tmp

$mysql_dir/bin/mysql_install_db --user=mysql

else

echo "mysql_install_db already installed !"

fi

#check !

ld_so_conf=`cat /etc/ld.so.conf | grep mysql | wc -l`

profile_mysql_bin=`cat /etc/profile | grep mysql | wc -l`

if [ -f "$mysql_cnf_dir" ] || [ -d "$mysql_dir" ];then

echo "ok!"

#

if [ $ld_so_conf = 0 ];then

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

source /etc/profile

fi

#

if [ $profile_mysql_bin = 0 ];then

echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf

ldconfig

fi

#

else

echo "error! can't install mysql_server  please check ! Will now out of the script!"

exit 1

fi

###else

else

echo "mysql_server already installed!"

#

fi