shell脚本一键安装MySQL5.7.29的简单示例

这篇文章主要为大家详细介绍了shell脚本一键安装MySQL5.7.29的简单示例，具有一定的参考价值，可以用来参考一下。

感兴趣的小伙伴，下面一起跟随四海网的小玲来看看吧！

脚本内容：

代码如下：

vim install.mysql.sh
 
#!/bin/bash
 
[ -f /etc/init.d/functions ]&& . /etc/init.d/functions
 
###Check if user is root
if [ $UID -ne 0 ]; then
 echo "Error: You must be root to run this script, please use root to install"
 exit 1
fi
 
clear
echo "========================================================================="
echo "A tool to auto-compile & install MySQL 5.7.29 on Redhat/CentOS Linux "
echo "========================================================================="
#pkill -9 mysql
#date +%Y-%m-%d-%H-%M
#卸载系统自带的Mysql
#/bin/rpm -e $(/bin/rpm -qa | grep mysql|xargs) --nodeps
#/bin/rpm -e $(/bin/rpm -qa | grep mariadb|xargs) --nodeps
#/bin/rm -f /etc/my.cnf
 
#set mysql root password
 echo "==========================="
  mysqlrootpwd="$1"
  if [ "$1" = "" ]; then
    mysqlrootpwd="rootmysql"
  fi
 
#which MySQL Version do you want to install?
echo "==========================="
 
 isinstallmysql57="5.7.29"
 echo "Install MySQL 5.7.29,Please input y"
 read -p "(Please input y , n):"
# Initialize the installation related content.
 #Delete Old Mysql program
 rpm -qa|grep mysql
 rpm -e mysql
 
 
cat >>/etc/security/limits.conf<<EOF
* soft nproc 65535
* hard nproc 65535
* soft nofile 65535
* hard nofile 65535
EOF
 
echo "fs.file-max=65535" >> /etc/sysctl.conf
 
echo "============================Install MySQL 5.7.29=================================="
 
#Backup old my.cnf
#rm -f /etc/my.cnf
if [ -s /etc/my.cnf ]; then
 mv /etc/my.cnf /etc/my.cnf.`date +%Y%m%d%H%M%S`.bak
fi
echo "============================MySQL 5.7.29 installing…………========================="
 
##define mysql directory configuration variable
Datadir=/data/mysql/data
Binlogdir=/data/mysql/binlog
Logdir=/data/mysql/logs
 
##yum install devel and wget mysql
yum install numactl
/usr/bin/wget -P /tmp http://mirrors.163.com/mysql/Downloads/MySQL-5.7/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
sleep 2
tar xf /tmp/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
ln -s /usr/local/mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/mysql
grep mysql /etc/passwd
RETVAL=$?
if [ $RETVAL -ne 0 ];then
 useradd mysql -s /sbin/nologin -M
  action "mysql user added successfully" /bin/true
 else
  action " $(echo -e "\e[31;47;5m mysql user already exists\e[0m")" /bin/false
fi
 
if [ ! -d "$Datadir" ]
then
 mkdir -p /data/mysql/data
fi
 
 
if [ ! -d "$Binlogdir" ]
then
 mkdir -p /data/mysql/binlog
fi
 
if [ ! -d "$Logdir" ]
then
 mkdir -p /data/mysql/logs
fi
 
chown -R mysql:mysql /data/mysql
chown -R mysql:mysql /usr/local/mysql
 
#edit /etc/my.cnf
#SERVERID=`ifconfig eth0 | grep "inet addr" | awk '{ print $2}'| awk -F. '{ print $3$4}'`
cat >>/etc/my.cnf<<EOF
[client]
port   = 3306
 
[mysql]
auto-rehash
prompt="\\u@\\h [\\d]>"
#pager="less -i -n -S"
#tee=/opt/mysql/query.log
 
[mysqld]
####: for global
user        =mysql       
basedir        =/usr/local/mysql/    
datadir        =/data/mysql/data 
server_id       =2333306      
port        =3306       
character_set_server    =utf8       
explicit_defaults_for_timestamp  =off       
log_timestamps      =system      
socket        =/tmp/mysql.sock    
read_only       =0        
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      =1000       
thread_cache_size     =64       
table_open_cache     =81920       
table_definition_cache    =4096       
table_open_cache_instances   =64       
max_prepared_stmt_count    =1048576      
 
####: for binlog
binlog_format      =row       
log_bin        =/data/mysql/binlog/mysql-bin      
binlog_rows_query_log_events  =on       
log_slave_updates     =on       
expire_logs_days     =7        
binlog_cache_size     =65536       
#binlog_checksum     =none       
sync_binlog       =1        
slave-preserve-commit-order   =ON       
 
####: for error-log
log_error       =/data/mysql/logs/error.log      
 
general_log       =off       
general_log_file     =/data/mysql/logs/general.log     
 
####: for slow query log
slow_query_log      =on        
slow_query_log_file     =/data/mysql/logs/slow.log      
#log_queries_not_using_indexes  =on       
long_query_time      =1.000000      
 
####: for gtid
#gtid_executed_compression_period =1000       
gtid_mode       =on        
enforce_gtid_consistency   =on        
 
####: for replication
skip_slave_start      =1        
#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  =100       
binlog_group_commit_sync_no_delay_count = 10      
 
####: for innodb
default_storage_engine       =innodb     
default_tmp_storage_engine      =innodb     
innodb_data_file_path       =ibdata1:1024M:autoextend 
innodb_temp_data_file_path      =ibtmp1:12M:autoextend  
innodb_buffer_pool_filename      =ib_buffer_pool   
innodb_log_group_home_dir      =/data/mysql/data      
innodb_log_files_in_group      =3       
innodb_log_file_size       =1024M      
innodb_file_per_table       =on      
innodb_online_alter_log_max_size    =128M      
innodb_open_files        =65535      
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   
     # 4(刷新lru脏页)
innodb_print_all_deadlocks      =on      
innodb_deadlock_detect       =on      
innodb_lock_wait_timeout      =20      
innodb_spin_wait_delay       =128      
innodb_autoinc_lock_mode      =2       
innodb_io_capacity        =200      
innodb_io_capacity_max       =2000      
#--------Persistent Optimizer Statistics
innodb_stats_auto_recalc      =on      
innodb_stats_persistent       =on      
innodb_stats_persistent_sample_pages   =20      
 
 
innodb_adaptive_hash_index      =on      
innodb_change_buffering       =all      
innodb_change_buffer_max_size     =25      
innodb_flush_neighbors       =1       
#innodb_flush_method        =       
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       =4096M      
innodb_buffer_pool_instances     =4
autocommit          =1       
#--------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      =25      
innodb_buffer_pool_dump_at_shutdown    =ON      
innodb_buffer_pool_load_at_startup    =ON      
 
EOF
 
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
Pass=$(grep 'A temporary password' /data/mysql/logs/error.log |awk '{print $NF}')
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
/etc/init.d/mysqld start
echo "export PATH=$PATH:/usr/local/mysql/bin" > /etc/profile.d/mysql.sh
source /etc/profile.d/mysql.sh
echo "============================MySQL 5.7.29 install completed========================="
ps -eo start,cmd,pid|grep mysql
/usr/local/mysql/bin/mysqladmin -uroot -p"$Pass" password $mysqlrootpwd

shell脚本一键安装MySQL5.7.29的方法

代码如下：

[root@localhost ~]# sh install.mysql.sh mysqlroot
[root@localhost ~]# source /etc/profile.d/mysql.sh

shell脚本一键安装MySQL5.7.29的方法

说明： mysqlroot 为安装脚本修改MySQL服务默认密码后的新的密码

代码如下：

[root@localhost ~]# mysql -uroot -p'mysqlroot' -e "select now()"   
mysql: [Warning] Using a password on the command line interface can be insecure.
+---------------------+
| now()    |
+---------------------+
| 2020-10-13 16:18:47 |
+---------------------+

shell脚本一键安装MySQL5.7.29的方法

到此处MySQL服务启动成功！

 

总结

 

到此这篇关于shell脚本一键安装MySQL5.7.29 的文章就介绍到这了,更多相关shell脚本一键安装MySQL内容请搜索四海网以前的文章或继续浏览下面的相关文章希望大家以后多多支持四海网！

本文来自：http://www.q1010.com/177/19532-0.html

注：关于shell脚本一键安装MySQL5.7.29的简单示例的内容就先介绍到这里，更多相关文章的可以留意四海网的其他信息。

关键词：