生产库自动化MySQL5.6安装部署详细教程

自动化运维是一个dba应该掌握的技术，其中，自动化安装数据库是一项基本的技能，本文中的安装脚本已通过测试，作为生产库来说没有问题，鉴于每个公司存储规划要求不同，可以按需自行修改脚本。

脚本中已经注释说明一些基本的安装信息

本脚本默认启用5.6部分新特性

innodb_buffer_pool_dump_at_shutdown=1 它dump的不是数据，是id号
innodb_buffer_pool_load_at_startup=1

开启这个两个参数当数据库重启后把这些热数据重新加载回去

只有正常关库才会dump热数据块，宕机和kill -9不会

部分参数按需整改，例如innodb_buffer_pool_size = 512m，本文给的512m，一般给内存的50%-80%。

来看一下脚本的具体情况[root@he3 ~]# cat mysql_auto_install.sh

######二进制自动安装数据库脚本root密码manager将脚本和安装包放在/root目录即可###############
######数据库目录/usr/local/mysql############
######数据目录/data/mysql############
######日志目录/log/mysql############
######端口号默认3306其余参数按需自行修改############
##################
#author：[e-mail]#
##################
#!/bin/bash
path=/bin:/sbin:/usr/bin:/usr/sbin:/opt/bin:/opt/sbin:~/bin
export
path
#check
ifuserisroot
if[$(id
-u)!="0"];then
echo"error:youmustberoottorun
thisscript,pleaseuseroottoinstall"
exit1
fi
clear
echo
"========================================================================="
echo
"atooltoauto-compile&installmysql5.6.25onredhat/centoslinux
"
echo
"========================================================================="
cur_dir=$(pwd)
#set
mysqlrootpassword
echo"==========================="
mysqlrootpwd="manager"
echo-e"pleaseinputtherootpasswordofmysql:"
read-p"(defaultpassword:manager):"mysqlrootpwd
if["$mysqlrootpwd"=""];then
mysqlrootpwd="manager"
fi
echo"==========================="
echo"mysqlrootpassword:$mysqlrootpwd"
echo"==========================="
#which
mysqlversiondoyouwanttoinstall?
echo
"==========================="
isinstallmysql56="n"
echo"installmysql5.6.25,pleaseinputy"
read-p"(pleaseinputy,n):"isinstallmysql56
case"$isinstallmysql56"in
y|y|yes|yes|yes|yes|yes|yes|yes)
echo"youwillinstallmysql5.6.25"
isinstallmysql56="y"
;;
*)
echo"inputerror,youwillexitinstallmysql5.6.25"
isinstallmysql56="n"
exit
esac
get_char()
{
savedstty=`stty-g`
stty-echo
sttycbreak
#ddif=/dev/ttybs=1count=12>/dev/null
stty-raw
sttyecho
stty$savedstty
}
echo""
echo"pressanykeytostart...orpressctrl+ctocancel"
char=`get_char`
#
initializetheinstallationrelated
content.
function
initinstall()
{
cat/etc/issue
uname-a
memtotal=`free-m|grepmem|awk'{print$2}'`
echo-e"\nmemoryis:${memtotal}mb"
#settimezone
rm-rf/etc/localtime
ln-s/usr/share/zoneinfo/asia/shanghai/etc/localtime
#deleteoldmysqlprogram
rpm-qa|grepmysql
rpm-emysql
#yum-yremovemysql-servermysqlmysql-libs
#yum-yremovephp-mysql
#yum-yinstallyum-fastestmirror
#yum-yupdate
#disableselinux
if[-s/etc/selinux/config];then
sed-i's/selinux=enforcing/selinux=disabled/g'/etc/selinux/config
fi
setenforce0
}
#installation
ofdependonandoptimizationoptions.
function
installdependsandopt()
{
cd
$cur_dir
cat
>>/etc/security/limits.conf<>/etc/sysctl.conf
}
#install
mysql
function
installmysql56()
{
echo
"============================installmysql
5.6.22=================================="
cd
$cur_dir
#backup
oldmy.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
#mysql
directoryconfiguration
groupadd
mysql-g512
useradd-u512-gmysql-s/sbin/nologin-d/home/mysqlmysql
tarxvf/root/mysql-5.6.25-linux-glibc2.5-x86_64.tar.gz
mv/root/mysql-5.6.25-linux-glibc2.5-x86_64/usr/local/mysql
mkdir-p/data/mysql
mkdir-p/log/mysql
chown-rmysql:mysql/data/mysql
chown-rmysql:mysql/usr/local/mysql
chown-rmysql:mysql/log
#edit/etc/my.cnf
serverid=`ifconfigeth0|grep"inetaddr"|awk'{print$2}'|awk-f.'{print$4"3306"}'`
cat
>>/etc/my.cnf<>/etc/ld.so.conf.d/mysql-x86_64.conf<>/etc/profile</tmp/mysql_sec_script<&1|tee/root/mysql-install.log
checkanddownloadfiles2>&1|tee-a/root/mysql-install.log
installdependsandopt2>&1|tee-a/root/mysql-install.log
installmysql562>&1|tee-a/root/mysql-install.log
checkinstall2>&1|tee-a/root/mysql-install.log

执行脚本后，输入用户名密码（默认manager)后登录数据库成功。

wkiol1foihtqr5ktaaelfoh_fog089.jpg-wh_50

以上所述是小编给大家介绍的生产库自动化mysql5.6安装部署详细教程，希望对大家有所帮助