shell脚本安装mysql5.7_shell脚本一键安装mysql5.7.x

使用脚本一键安装mysql5.7.x,初始化数据库。启动数据库----

mysql版本号：源代码mysql5.7.10

linux版本号：centos6.5 x86_64

#!/bin/bash

GROUP_NAME=mysql

USER_NAME=mysql

MYSQLDB_HOME=/home/mysql/mysql

MYSQLDB_DATA_HOME=/home/mysql/mysql/data

ERROR_EXIT=65

MYSQL_VERSION="mysql-5.7.10"

CMAKE_VERSION="cmake-3.4.3"

BOOST_VERSION="boost_1_59_0"

CPU_NUMBERS=$(cat /proc/cpuinfo |grep "processor"|wc -l)

MYSQL_ID=`ifconfig eth0 | grep "inet addr" | awk -F. '{print $4}' | awk '{print $1}'`

COMPUTER_MEM=`free -m |grep "Mem"|awk '{print $2}'`

MYSQL_MEM=`expr $COMPUTER_MEM - $COMPUTER_MEM / 4`

echo "$MYSQL_MEM"

echo "====================================================="

echo "setup MySQL 5.7.10 on centos6.5_64bit "

echo "your computer is $CPU_NUMBERS processes ,mysql Memory is $MYSQL_MEM M"

echo "you will input mysql's root password and mysql's memory"

echo "====================================================="

sleep 1

read -n1 -p "are you sure setup[y/n]?" answer

case $answer in

Y | y)

echo

echo "start setup....";;

N | n)

echo

echo "Cancel setup...."

exit 10 ;;

*)

echo

echo "error input parameter....."

exit 11 ;;

esac

#check if user is root

if [ $(id -u) != "0" ];then

echo "Error: You must be root to run this script!"

exit 1

fi

#addGroup

if [ -z $(cat /etc/group|awk -F: '{print $1}'| grep -w "$GROUP_NAME") ]

then

groupadd $GROUP_NAME

if(( $? == 0 ))

then

echo "group $GROUP_NAME add sucessfully!"

fi

else

echo "$GROUP_NAME is exsits"

fi

#addUser

if [ -z $(cat /etc/passwd|awk -F: '{print $1}'| grep -w "$USE_NAME") ]

then

adduser -g $GROUP_NAME $USER_NAME

if (( $? == 0 ))

then

echo "user $USER_NAME add sucessfully!"

fi

else

echo "$USER_NAME is exsits"

fi

for i in make gcc-c++ bison-devel ncurses-devel perl perl-devel wget

do

yum -y install $i

done

####down lib:System Requirements,CMAKE>=2.8,BOOST>=1.59.0

rm -rf /tmp/cmake-3.4*

wget https://cmake.org/files/v3.4/${CMAKE_VERSION}.tar.gz -P /tmp

if(( $? == 0 ))

then

echo "cmake DownLoad sucessfully!"

else

echo "cmake DownLoad failed!"

exit $ERROR_EXIT

fi

cd /tmp

tar xzvf ${CMAKE_VERSION}.tar.gz

cd ${CMAKE_VERSION}

./bootstrap

make && make install

yum install gcc gcc-c++ bzip2 bzip2-devel bzip2-libs python-devel -y

rm -rf /tmp/boost_1_59*

wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/${BOOST_VERSION}.tar.gz -P /tmp

if(( $?

== 0 ))

then

echo "boost DownLoad sucessfully!"

else

echo "boost DownLoad failed!"

exit $ERROR_EXIT

fi

cd /tmp

tar xzvf ${BOOST_VERSION}.tar.gz

cd ${BOOST_VERSION}

./bootstrap.sh

./b2 install

#downMySQL

rm -rf /tmp/mysql-5.7.*

wget http://downloads.mysql.com/archives/get/file/${MYSQL_VERSION}.tar.gz -P /tmp

if(( $? == 0 ))

then

echo "MySQL DownLoad sucessfully!"

else

echo "MySQL DownLoad failed!"

exit $ERROR_EXIT

fi

cd /tmp

tar xzvf ${MYSQL_VERSION}.tar.gz

cd ${MYSQL_VERSION}

if [ -s /etc/my.cnf ]; then

mv /etc/my.cnf /etc/my.cnf.`date +%Y%m%d%H%M%S`.bak

fi

cmake \

-DCMAKE_INSTALL_PREFIX=/home/mysql/mysql \

-DMYSQL_DATADIR=/home/mysql/mysql/data \

-DWITH_BOOST=/usr/local/include/boost \

-DSYSCONFDIR=/etc \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DEXTRA_CHARSETS=all \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

make -j$CPU_NUMBERS && make install

if [ -s /etc/my.cnf ]; then

mv /etc/my.cnf /etc/my.cnf.`date +%Y%m%d%H%M%S`.bak

fi

#custom set mysql mem

#MYSQL_MEM="800M"

#echo -e "please input Mysql Memory ,like 1G ,1M !"

#read -p "(Default Memory is: 800M):" MYSQL_MEM

#if [ "$MYSQL_MEM" = "" ];then

# MYSQL_MEM="800M"

#fi

#set mysql root password

echo "==========================="

mysqlrootpwd="root"

echo -e "Please input the root password of mysql:"

read -p "(Default password: root):" mysqlrootpwd

if [ $mysqlrootpwd = "" ]

then

mysqlrootpwd="root"

fi

echo "MySQL root's password is $mysqlrootpwd"

echo "================================="

mkdir -p $MYSQLDB_HOME/log

touch $MYSQLDB_HOME/log/mysql-error.log

touch $MYSQLDB_HOME/log/mysql-slow.log

chown -R mysql:mysql $MYSQLDB_HOME

echo "[mysql]

default-character-set=UTF8

[client]

#default-character-set=UTF8

[mysqld]

#datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

port = 3306

basedir = $MYSQLDB_HOME

datadir = $MYSQLDB_DATA_HOME

pid-file = $MYSQLDB_HOME/mysql.pid

user = mysql

server-id = $MYSQL_ID

#rpl_semi_sync_master_enabled=1

#rpl_semi_sync_master_timeout=1000

#rpl_semi_sync_slave_enabled=1

relay_log_purge=0

read_only=0

slave-skip-errors=1396

lower_case_table_names = 1

character-set-server=utf8

skip-name-resolve

skip-external-locking

back_log = 500

max_connections = 500

max_connect_errors = 2000

open_files_limit = 65535

table_open_cache = 128

max_allowed_packet = 64M

##thread_concurrency = `expr $CPU_NUMBERS + $CPU_NUMBERS`

key_buffer_size = 64M

read_buffer_size = 64M

read_rnd_buffer_size = 16M

sort_buffer_size = 16M

join_buffer_size = 16M

tmp_table_size = 96M

max_heap_table_size = 96M

query_cache_size = 8M

query_cache_limit = 8M

thread_cache_size = 64

log_bin = mysql-bin

binlog_format = mixed

binlog_cache_size = 8M

sync_binlog = 1

max_binlog_cache_size = 8M

max_binlog_size = 500M

expire_logs_days = 10

log_error = $MYSQLDB_HOME/log/mysql-error.log

slow_query_log = 1

long_query_time = 1

slow_query_log_file = $MYSQLDB_HOME/log/mysql-slow.log

default_storage_engine = InnoDB

innodb_buffer_pool_size = $MYSQL_MEM

innodb_file_per_table = 1

innodb_data_home_dir = $MYSQLDB_DATA_HOME

innodb_data_file_path = ibdata1:500M;ibdata2:1G:autoextend

innodb_log_group_home_dir = $MYSQLDB_HOME

innodb_log_file_size = 500M

innodb_log_buffer_size = 20M

innodb_flush_log_at_trx_commit = 1

innodb_print_all_deadlocks = 1

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid" >/etc/my.cnf

##$MYSQLDB_HOME/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=$MYSQLDB_HOME --datadir=$MYSQLDB_DATA_HOME --user=$USER_NAME

####Before MySQL 5.7.6使用mysql_install_db。MySQL 5.7.6 and up使用mysqld

${MYSQLDB_HOME}/bin/mysqld --initialize-insecure --basedir=$MYSQLDB_HOME --datadir=$MYSQLDB_DATA_HOME --user=$USER_NAME

cp $MYSQLDB_HOME/support-files/mysql.server /etc/init.d/mysql

chmod 755 /etc/init.d/mysql

chkconfig --add mysql

chkconfig mysql on

/etc/init.d/mysql start

cat >> /etc/profile <

PATH=$MYSQLDB_HOME/bin:\$PATH

export PATH

EOF

source /etc/profile

mysqladmin -u root password $mysqlrootpwd

echo "set up successfully!enjoy it...."

exit 0