自動化運維是一個DBA應(yīng)該掌握的技術(shù)，其中，自動化安裝數(shù)據(jù)庫是一項基本的技能，本文中的安裝腳本已通過測試，作為生產(chǎn)庫來說沒有問題，鑒于每個公司存儲規(guī)劃要求不同，可以按需自行修改腳本。
腳本中已經(jīng)注釋說明一些基本的安裝信息
本腳本默認(rèn)啟用5.6部分新特性
|
1
2
|
innodb_buffer_pool_dump_at_shutdown=1 它dump的不是數(shù)據(jù)，是Id號innodb_buffer_pool_load_at_startup=1 |
開啟這個兩個參數(shù)當(dāng)數(shù)據(jù)庫重啟后把這些熱數(shù)據(jù)重新加載回去
只有正常關(guān)庫才會dump熱數(shù)據(jù)塊，宕機和kill -9不會
部分參數(shù)按需整改，例如innodb_buffer_pool_size = 512M，本文給的512M，一般給內(nèi)存的50%-80%。
來看一下腳本的具體情況[root@HE3 ~]# cat mysql_auto_install.sh
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
######二進制自動安裝數(shù)據(jù)庫腳本root密碼MANAGER將腳本和安裝包放在/root目錄即可#####################數(shù)據(jù)庫目錄/usr/local/mysql##################數(shù)據(jù)目錄/data/mysql##################日志目錄/log/mysql##################端口號默認(rèn)3306其余參數(shù)按需自行修改###############################author：[email protected]####################!/bin/bashPATH=/bin:/sbin:/usr/bin:/usr/sbin:/opt/bin:/opt/sbin:~/binexportPATH#Checkifuserisrootif[$(id-u)!="0"];thenecho"Error:Youmustberoottorunthisscript,pleaseuseroottoinstall"exit1ficlearecho"========================================================================="echo"Atooltoauto-compile&installMySQL5.6.25onRedhat/CentOSLinux"echo"========================================================================="cur_dir=$(pwd)#setmysqlrootpasswordecho"==========================="mysqlrootpwd="MANAGER"echo-e"Pleaseinputtherootpasswordofmysql:"read-p"(Defaultpassword:MANAGER):"mysqlrootpwdif["$mysqlrootpwd"=""];thenmysqlrootpwd="MANAGER"fiecho"==========================="echo"MySQLrootpassword:$mysqlrootpwd"echo"==========================="#whichMySQLVersiondoyouwanttoinstall?echo"==========================="isinstallmysql56="n"echo"InstallMySQL5.6.25,Pleaseinputy"read-p"(Pleaseinputy,n):"isinstallmysql56case"$isinstallmysql56"iny|Y|Yes|YES|yes|yES|yEs|YeS|yeS)echo"YouwillinstallMySQL5.6.25"isinstallmysql56="y";;*)echo"INPUTerror,YouwillexitinstallMySQL5.6.25"isinstallmysql56="n"exitesacget_char(){SAVEDSTTY=`stty-g`stty-echosttycbreak#ddif=/dev/ttybs=1count=12>/dev/nullstty-rawsttyechostty$SAVEDSTTY}echo""echo"Pressanykeytostart...orPressCtrl+ctocancel"char=`get_char`#Initializetheinstallationrelatedcontent.functionInitInstall(){cat/etc/issueuname-aMemTotal=`free-m|grepMem|awk'{print$2}'`echo-e"\nMemoryis:${MemTotal}MB"#Settimezonerm-rf/etc/localtimeln-s/usr/share/zoneinfo/Asia/Shanghai/etc/localtime#DeleteOldMysqlprogramrpm-qa|grepmysqlrpm-emysql#yum-yremovemysql-servermysqlmysql-libs#yum-yremovephp-mysql#yum-yinstallyum-fastestmirror#yum-yupdate#DisableSeLinuxif[-s/etc/selinux/config];thensed-i's/SELINUX=enforcing/SELINUX=disabled/g'/etc/selinux/configfisetenforce0}#Installationofdependonandoptimizationoptions.functionInstallDependsAndOpt(){cd$cur_dircat>>/etc/security/limits.conf<>/etc/sysctl.conf}#InstallMySQLfunctionInstallMySQL56(){echo"============================InstallMySQL5.6.22=================================="cd$cur_dir#Backupoldmy.cnf#rm-f/etc/my.cnfif[-s/etc/my.cnf];thenmv/etc/my.cnf/etc/my.cnf.`date+%Y%m%d%H%M%S`.bakfi#mysqldirectoryconfigurationgroupaddmysql-g512useradd-u512-gmysql-s/sbin/nologin-d/home/mysqlmysqltarxvf/root/mysql-5.6.25-linux-glibc2.5-x86_64.tar.gzmv/root/mysql-5.6.25-linux-glibc2.5-x86_64/usr/local/mysqlmkdir-p/data/mysqlmkdir-p/log/mysqlchown-Rmysql:mysql/data/mysqlchown-Rmysql:mysql/usr/local/mysqlchown-Rmysql:mysql/log#edit/etc/my.cnfSERVERID=`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.logCheckAndDownloadFiles2>&1|tee-a/root/mysql-install.logInstallDependsAndOpt2>&1|tee-a/root/mysql-install.logInstallMySQL562>&1|tee-a/root/mysql-install.logCheckInstall2>&1|tee-a/root/mysql-install.log |
執(zhí)行腳本后，輸入用戶名密碼（默認(rèn)MANAGER)后登錄數(shù)據(jù)庫成功。
|
1
|
wKioL1fOIHTQR5ktAAElfoh_FOg089.jpg-wh_50 |
以上所述是小編給大家介紹的生產(chǎn)庫自動化MySQL5.6安裝部署詳細(xì)教程，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復(fù)大家的。在此也非常感謝大家對服務(wù)器之家網(wǎng)站的支持！
