vi install_mysql.sh

#!/bin/bash

#需要的安裝介質：Mysql編譯包、boost安裝包

##################################一、環境準備########################################################

#1. 創建目錄

mkdir -p $1/data && chown mysql.mysql $1/data #創建數據目錄

mkdir -p $2/log && chown mysql.mysql $2/log #創建log目錄

mkdir -p /var/lib/mysql && chown mysql.mysql /var/lib/mysql  #創建UNIX SOCK目錄

data_dir=$1/data

install_log=$2/install.log

#2. 解壓安裝介質

cd $3

tar -xzvf mysql-5.7.21.tar.gz

tar -xzvf boost_1_59_0.tar.gz -C /usr/local/

#3. 新建Mysql用戶

id mysql

if [ $? -ne 0 ]; then

echo "There are no MySQL users,Now start to create a Mysql user" >> ${install_log}

groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -M mysql

fi

#4. 卸載預裝軟件

`rpm -qa |grep -ie mysql -ie mariadb |awk {print "rpm -evh --nodeps " $1}` >> ${install_log}

#5. 安裝依賴包

yum clean all

yum list|grep tree

if [ $? -eq 0 ]; then

    yum install -y cmake gcc gcc-c++ ncurses ncurses-devel bison >> ${install_log}

else

    echo "Failed!!!There is no Yum here,please configure yum!"  >> ${install_log}

    exit;

fi

#6. 關閉防火墻和selinux

setenforce 0

perl -p -i -e "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config

perl -p -i -e "s/SELINUX=permissive/SELINUX=disabled/g" /etc/selinux/config

service iptables stop

##################################二、編譯安裝########################################################################

#1. 預編譯

cmake

 -DCMAKE_INSTALL_PREFIX=/usr/local/mysql

 -DMYSQL_DATADIR=/mysql/data

 -DSYSCONFDIR=/etc

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

 -DEXTRA_CHARSETS=all

 -DDEFAULT_CHARSET=utf8

 -DDEFAULT_COLLATION=utf8_general_ci

 -DWITH_MYISAM_STORAGE_ENGINE=1

 -DWITH_INNOBASE_STORAGE_ENGINE=1

 -DWITH_PARTITION_STORAGE_ENGINE=1

 -DENABLED_LOCAL_INFILE=1

 -DENABLED_PROFILING=1

 -DMYSQL_TCP_PORT=3306

 -DWITH_DEBUG=0

 -DDOWNLOAD_BOOST=1

 -DWITH_BOOST=/usr/local/boost_1_59_0 >> ${install_log}

if [ $? -ne 0 ]; then

    exit;

fi

#2. 編譯安裝

make -j `grep processor /proc/cpuinfo | wc -l` && make install >> ${install_log}

if [ $? -ne 0 ]; then

    exit;

fi

#3. 開機自啟

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

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

chmod +x /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig mysqld on

#4. 添加到環境變量的路徑中

ln -s /usr/local/mysql/bin/* /usr/local/bin/

##################################三、數據庫初始化########################################################################

#1. 生成Mysql配置文件

mem_num=`free |grep Mem|awk {print $2}`

buffer_size=`echo ${mem_num}/2|bc`

cp /etc/my.cnf /etc/my.cnf.bak

echo "[mysql]

auto-rehash

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

[mysqld]

####: for global

user=mysql                  

basedir=/usr/local/bin

datadir=$1/data

server_id=1517              

port=3306                   

character_set_server=utf8   

log_bin_trust_function_creators=ON   

max_prepared_stmt_count=1048576      

log_timestamps=system

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

read_only=OFF                        

skip_name_resolve=1                  

auto_increment_increment=1           

auto_increment_offset=1              

lower_case_table_names=1             

secure_file_priv=

open_files_limit=65536               

max_connections=256                  

thread_cache_size=64                 

table_open_cache=4000                

table_definition_cache=2000          

table_open_cache_instances=32

####: for binlog

binlog_format=ROW                    

log_bin=mysql-bin                    

binlog_rows_query_log_events=ON      

log_slave_updates=ON                 

expire_logs_days=7                   

binlog_cache_size=64k                

binlog_checksum=none                 

sync_binlog=1                        

slave-preserve-commit-order=ON       

####: for error-log

log_error=$2/log/err.log                    

####: for general-log

general_log=OFF                        

general_log_file=general.log           

####: for slow query log

slow_query_log=ON                      

slow_query_log_file=slow.log           

log_queries_not_using_indexes=OFF      

long_query_time=2.0                    

####: for gtid

gtid_executed_compression_period=1000  

gtid_mode=ON                           

enforce_gtid_consistency=ON            

####: for replication

skip_slave_start=0                     

master_info_repository=table           

relay_log_info_repository=table        

slave_parallel_type=logical_clock

slave_parallel_workers=4                     

rpl_semi_sync_master_enabled=1               

rpl_semi_sync_slave_enabled=1                

rpl_semi_sync_master_timeout=1000            

plugin_load_add=semisync_master.so           

plugin_load_add=semisync_slave.so            

binlog_group_commit_sync_delay=4000          

binlog_group_commit_sync_no_delay_count= 10  

#binlog_transaction_dependency_tracking= WRITESET   

transaction_write_set_extraction= XXHASH64

####: for innodb

default_storage_engine=innodb                     

default_tmp_storage_engine=innodb                 

innodb_data_file_path=ibdata1:256M;ibdata2:256M:autoextend   

innodb_temp_data_file_path=ibtmp1:64M:autoextend 

innodb_buffer_pool_filename=ib_buffer_pool       

innodb_log_group_home_dir=./                     

innodb_log_files_in_group=8                      

innodb_log_file_size=128M                      

innodb_file_per_table=ON                         

innodb_online_alter_log_max_size=128M            

innodb_open_files=64000                    

innodb_page_size=16k                    

innodb_thread_concurrency=0                      

innodb_read_io_threads=4                         

innodb_write_io_threads=4                        

innodb_purge_threads=4                     

innodb_page_cleaners=4                     

innodb_print_all_deadlocks=ON              

innodb_deadlock_detect=ON                  

innodb_lock_wait_timeout=50                

innodb_spin_wait_delay=6                   

innodb_autoinc_lock_mode=2                 

innodb_flush_sync=OFF                      

innodb_io_capacity=400                     

innodb_io_capacity_max=2000                

#--------Persistent Optimizer Statistics

innodb_stats_auto_recalc=ON                

innodb_stats_persistent=ON                 

innodb_stats_persistent_sample_pages=20    

innodb_buffer_pool_instances=2             

innodb_adaptive_hash_index=ON              

innodb_change_buffering=all                

innodb_change_buffer_max_size=25           

innodb_flush_neighbors=1                   

innodb_flush_method=O_DIRECT               

innodb_doublewrite=ON                      

innodb_log_buffer_size=128M                

innodb_flush_log_at_timeout=1              

innodb_flush_log_at_trx_commit=1           

innodb_buffer_pool_size=${buffer_size}

autocommit=ON                        

#--------innodb scan resistant

innodb_old_blocks_pct=37                   

innodb_old_blocks_time=1000

#--------innodb read ahead

innodb_read_ahead_threshold=56 

innodb_random_read_ahead=off               

#--------innodb buffer pool state

innodb_buffer_pool_dump_pct=50             

innodb_buffer_pool_dump_at_shutdown=ON     

innodb_buffer_pool_load_at_startup=ON      

####for performance_schema

performance_schema=on

performance_schema_consumer_global_instrumentation=on   

performance_schema_consumer_thread_instrumentation=on   

performance_schema_consumer_events_stages_current=on    

performance_schema_consumer_events_stages_history=on   

performance_schema_consumer_events_stages_history_long=off   

performance_schema_consumer_statements_digest=on    

performance_schema_consumer_events_statements_current=on   

performance_schema_consumer_events_statements_history=on    

performance_schema_consumer_events_statements_history_long=off  

performance_schema_consumer_events_waits_current=on    

performance_schema_consumer_events_waits_history=on    

performance_schema_consumer_events_waits_history_long=off

performance-schema-instrument=memory/%=COUNTED " > /etc/my.cnf

#2. 初始化

/usr/local/mysql/bin/mysqld --initialize --user=mysql --defaults-file=/etc/my.cnf >> ${install_log}

#3. 打印root臨時密碼

grep "temporary password" $2/log/err.log

#4. 啟動服務

v_release=`cat /etc/redhat-release |awk {print $7}`

if [ ${v_release} -gt 7 ];then

    if [ `systemctl status mysqld|grep Active|awk {print $2}` != active ]; then

    systemctl daemon-reload

    systemctl enable mysqld

    systemctl start mysqld

    fi

    echo "mysqld server is running"

else

    if [ `service mysqld status|awk {print $4}` != OK ]; then

    service mysqld start

    fi

    echo "mysqld server is running"

fi