shell自动安装mysql_shell脚本一键自动安装mysql 5.7

最近开发要经常在不同环境下测试mysql 5.7,有时候要mysql同机共存多个mysql,今天先写个单机安装单个mysql,之后再写一键安装多个mysql的脚本.

系统:centos 7.x(64位)

软件版本:mysql 5.7.17

脚本:

cat auto_install_mysql5.7.sh

#!/bin/bash

PATH=/bin:/sbin:/usr/bin:/usr/sbin:/opt/bin:/opt/sbin:~/bin

export PATH

# Check if user is root

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

echo "Error: You must be root to run this script, please use root to install"

exit 1

fi

# Check the network status

NET_NUM=`ping -c 4 www.baidu.com |awk '/packet loss/{print $6}' |sed -e 's/%//'`

if [ -z "$NET_NUM" ] || [ $NET_NUM -ne 0 ];then

echo "Please check your internet"

exit 1

fi

if [ -s mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz ];then

echo -e "\033[40;31m mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz [found]\033[40;37m"

else

#wget http://download.slogra.com/mysql/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

fi

user_mysql=`cat /etc/passwd|grep mysql|awk -F : '{print $1}'`

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

rm -f /etc/my.cnf

fi

if [ -z "$user_mysql" ];then

groupadd mysql

useradd -s /sbin/nologin -M -g mysql mysql

else

echo "user mysql already exists!"

fi

rpm=`rpm -qa libaio|awk -F "-" '{print $1}'`

if [ -z $rpm ];then

yum -y install libaio

else

echo -e "\033[40;31m libaio [found]\033[40;37m"

fi

mkdir -p /data/mysql

mkdir -p /var/log/mysql

touch /var/log/mysql/mysqld_safe.log

touch /var/log/mysql/general_query_log

touch /var/log/mysql/slow_query.log

touch /var/log/mysql/mysql-err.log

tar zxf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

mv mysql-5.7.17-linux-glibc2.5-x86_64 /usr/local/mysql

chown -R mysql:mysql /data/mysql

chown -R mysql:mysql /usr/local/mysql

chown -R mysql:mysql /var/log/mysql

/usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql --pid-file=/data/mysql/mysql.pid

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

chmod +x /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig mysqld on

sed -i "s:^datadir=.*:datadir=/data/mysql:g" /etc/init.d/mysqld

cat > /etc/ld.so.conf.d/mysql.conf<

/usr/local/mysql/lib

EOF

cat > /etc/my.cnf << EOF

[client]

port = 3306

socket = /data/mysql/mysql.sock

[mysql]

prompt = [\\u@\\h][\\d]>\\_

disable-auto-rehash

default-character-set = utf8

connect-timeout = 3

[mysqld]

port = 3306

socket = /data/mysql/mysql.sock

pid-file = /data/mysql/mysql.pid

basedir = /usr/local/mysql

datadir = /data/mysql

character-set-server=utf8

default-storage-engine = innodb

lower_case_table_names=1

##################CONNECT#################

max_connections = 2000

max_connect_errors = 1000000

interactive_timeout = 28800

wait_timeout = 28800

connect_timeout = 20

back_log = 500

#FOR FAST CREATE THREAD

thread_cache_size = 300

open_files_limit = 10240

table_open_cache = 3000

###############THREAD BUFFER##############

###############FOR EVERY THREAD###########

sort_buffer_size = 1M

join_buffer_size = 1M

read_buffer_size = 1M

read_rnd_buffer_size = 1M

#net_buffer_length = 16k

tmp_table_size = 64M

max_allowed_packet = 128M

#FOR MEMORY ENGINE

max_heap_table_size = 64M

#################BUFFER##################

###############FOR ALL THREAD############

query_cache_type = 0

query_cache_size = 32M

query_cache_limit = 1M

#################LOG BUFFER#############

binlog_cache_size = 16M

max_binlog_cache_size = 32M

binlog_stmt_cache_size = 32M

#################LOG FILE###############

sync_binlog = 0

binlog_format = row

log-error = /var/log/mysql/mysql-err.log

log-bin = /data/mysql/master-bin

max_binlog_size = 512M

relay-log = /data/mysql/relay-bin

log_output = file

slow_query_log = 1

slow_query_log_file = /var/log/mysql/slow_query.log

long_query_time=10

general_log = 0

general_log_file = /var/log/mysql/general_query_log

expire-logs-days = 3

###############INNODB##################

#innodb_page_size = 16k

innodb_file_per_table = 1

#innodb_data_file_path = ibdata1:12M:autoextend

#innodb_log_file_size = 512M

#innodb_log_files_in_group = 3

#innodb_buffer_pool_size = 500M

#innodb_buffer_pool_instance=8

innodb_log_buffer_size = 8m

innodb_max_dirty_pages_pct = 90

innodb_thread_concurrency = 0

innodb_flush_method = O_DIRECT

innodb_flush_log_at_trx_commit = 0

innodb_lock_wait_timeout = 100

innodb_fast_shutdown = 1

innodb_read_io_threads = 8

innodb_write_io_threads = 8

innodb_io_capacity = 1000

innodb_use_native_aio = 1

innodb_stats_on_metadata = 0

innodb_strict_mode = 1

innodb_file_format = barracuda

innodb_file_format_max = barracuda

innodb_file_format_check = 1

###############MYISAM###################

key_buffer_size = 64M

key_cache_block_size = 64k

myisam_sort_buffer_size = 64M

#################REPLICATE###############

server_id =1

log_slave_updates=1

#binlog-do-db = brent

#binlog-ignore-db = mysql

#replicate_ignore_db=mysql

#replicate_do_table=brent.t1

#replicate_ignore_table=brent.t2

#######GTID#######

#gtid-mode = on

#enforce-gtid-consistency = true

#master-info-repository=TABLE

#master-info-repository=TABLE

#relay-log-info-repository=TABLE

#sync-master-info=1

#slave-parallel-workers=2

#binlog-checksum=CRC32

#master-verify-checksum=1

#slave-sql-verify-checksum=1

#binlog-rows-query-log_events=1

#report-port=3306

#report-host=localip

sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]

err-log = /var/log/mysql/mysqld_safe.log

pid-file = /data/mysql/mysql.pid

EOF

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

#echo 'export PATH=$PATH:/usr/local/bin' >> /etc/profile

source /etc/profile

service mysqld start

echo -e "\033[40;31mInstall mysql success! \033[40;37m"

夜空- 本站版权

1、本站所有主题由该文章作者发表，该文章作者与夜空享有文章相关版权

2、其他单位或个人使用、转载或引用本文时必须同时征得该文章作者和夜空的同意

3、本帖部分内容转载自其它媒体，但并不代表本站赞同其观点和对其真实性负责

4、如本帖侵犯到任何版权问题，请立即告知本站，本站将及时予与删除并致以最深的歉意

5、原文链接：blog.slogra.com/post-688.html