电脑知识|欧美黑人一区二区三区|软件|欧美黑人一级爽快片淫片高清|系统|欧美黑人狂野猛交老妇|数据库|服务器|编程开发|网络运营|知识问答|技术教程文章 - 好吧啦网

您的位置:首頁技術文章
文章詳情頁

MySQL自動安裝腳本代碼實例分享

瀏覽:3日期:2023-07-12 19:49:57
目錄

這里分享一個我寫的MySQL自動安裝腳本mysql_auto_install.sh,它的功能非常簡單,就是自動化安裝MySQL單實例,讓DBA的工作更簡單、輕松一些,不用去手工安裝MySQL實例。從簡單重復的工作中釋放出來。

下面是關于mysql_auto_install.sh腳本的一些說明:

1:這個腳本運行在mysql用戶下(注意,root用戶下運行會報錯,需要修改部分地方),主要原因是因為DBA沒有root賬號權限,只有mysql用戶的權限。另外,我也寫了一個mysql_auto_install_root.sh腳本,這個腳本是在root用戶下面運行,功能更多一些。暫時還在測試當中。

2:此腳本運行在mysql用戶下,因為權限問題,不會禁用透明大頁,卸載RPM包,調整內核參數、配置systemctl服務等操作,這些工作交給系統管理員處理。而且我們也假設這些都已經是設定好了的。

3:此腳本只適用于Linux,不適用HP-UX等操作系統。

4:my.cnf的模板中的參數要跟腳本中的參數一致。否則可能有問題。另外模板中參數設置請自己保證正確性與合理性。

5:腳本經過多次測試驗證,但是并不保證各種場景都沒有bug。發現問題,歡迎反饋,我自己也在不斷完善、改進這個腳本。

6: 安裝前,要準備好MySQL安裝介質、mysql_auto_install.sh、alter_root_passwd.sql,my.cnf的模板(這里命名為mysql8_template.cnf)

其中alter_root_passwd.sql是修改root密碼的腳本,如下所示,根據實際情況輸入密碼,安裝完成后,刪除此腳本。

ALTER?USER?'root'@'localhost'?IDENTIFIED?BY?'********';flush?privileges;

mysql_auto_install.sh腳本的詳情如下(格式可能因為代碼插件展示問題,有所混亂,請自行調整。原始腳本格式不會有下面亂七八糟的縮進或不對齊問題)

#!/bin/bash##########################################################################################???????????????????????????????????????????????????????????????????????????????????????##?This?script?is?used?for?auto?install?mysql?8.0.xx?????????????????????????????????????##???????????????????????????????????????????????????????????????????????????????????????###########################################################################################???????????????????????????????????????????????????????????????????????????????????????##?ScriptName????????????:????mysql_auto_install.sh??????????????????????????????????????##?Author????????????????:????瀟湘隱者???????????????????????????????????????????????????##?CreateDate????????????:????2019-09-06?????????????????????????????????????????????????##?Blogs?????????????????:????www.cnblogs.com/kerrycode??????????????????????????????????##?Email?????????????????:????kerry2008code@qq.com???????????????????????????????????????##***************************************************************************************##?參數配置??????????????????????????????????????????????????????????????????????????????##---------------------------------------------------------------------------------------##?MYSQL_BASE_DIR????????/opt/mysql??????????????????????????????????????????????????????##?MYSQL_DATA_DIR????????/data/mysql?????????????????????????????????????????????????????##?MYSQL_PORT????????????3306????????????????????????????????????????????????????????????##?LOG_OUT_TYPE??????????log?????????????????????????????????????????????????????????????##---------------------------------------------------------------------------------------##?注意事項:????????????????????????????????????????????????????????????????????????????##???1:如果維護的MySQL數據庫都規范化安裝、配置的化,下面很多參數都不需要修改????????????##???2:my.cnf模板很重要,如果配置有問題,可能導致安裝失敗。腳本里面有些參數設定都是依賴?##???????my.cnf模板中的設置,請確保你的my.cnf模板中設定跟腳本參數一致????????????????????##???3:此腳本在mysql用戶下安裝,很多操作受限,例如禁用透明大頁、卸載rpm包,調整內核參數?##??????如需處理這些?建議使用另外一個版本的腳本處理。此處設定系統管理員已經處理好這些事情##??????**注意**:此腳本只能在mysql用戶下運行,root用戶下需要修改部分地方才能成功????????##---------------------------------------------------------------------------------------##***************************************************************************************##?Version????????Modified?Date????????????Description???????????????????????????????????##***************************************************************************************##?V.1.0??????????2019-09-06??????????????創建此腳本?????????????????????????????????????##?V.1.1??????????2019-10-26??????????????按SHELL編程規范,重新命名規范各類對象??????????##?V.2.0??????????2023-06-16??????????????重新改寫該腳本,增加驗證/優化步驟??????????????###########################################################################################?MySQL的安裝路徑:basedir的上層目錄MYSQL_BASE_DIR=/opt/mysql#?MySQL數據目錄:datadir的上層目錄MYSQL_DATA_DIR=/data/mysql#?MySQL安裝日志信息MYSQL_INSTALL_LOG=/tmp/soft/mysql_install.log#?MySQL壓縮包路徑MYSQL_INSTALLER_DIR=/tmp/soft#?MySQL安裝介質#?注意事項,如果安裝介質不是tar.xz?,請修改代碼中tar.xzMYSQL_INSTALLER=$MYSQL_INSTALLER_DIR/mysql-8.0.33-linux-glibc2.17-x86_64-minimal.tar.xz#?MySQL的my.cnf模板MYSQL_CONFIG_FILE=$MYSQL_INSTALLER_DIR/mysql8_template.cnf#?alter_root_passwd文件SQL_ALTER_USER_PWD=$MYSQL_INSTALLER_DIR/alter_root_passwd.sql#?Log輸出方式:log?或out或allLOG_OUT_TYPE=all#?MySQL的端口號MYSQL_PORT=3306#?記錄安裝過程的日志信息function?log_info(){????#判斷參數個數????if?[?$#?-eq?1?];then????????local?log_msg=$1????else????????echo?'[error]:`date?'+%Y%m%d?%H:%M:%S'`>?the?number?of?parameters?is?incorrect!'????fi????:<<EOF????if?[?$LOG_OUT_TYPE?=?'print'?];then????????echo?'[info?]:?`date`>?$log_msg'????else????????echo?'[info?]:?`date`>?$log_msg'?>>?$MYSQL_INSTALL_LOG????fiEOF????case?$LOG_OUT_TYPE?in????????out)????????????echo?'[info?]:?`date?'+%Y%m%d?%H:%M:%S'`>?$log_msg'????????????;;????????log)????????????echo?'[info?]:?`date?'+%Y%m%d?%H:%M:%S'`>?$log_msg'?>>?$MYSQL_INSTALL_LOG????????????;;????????all)????????????echo?'[info?]:?`date?'+%Y%m%d?%H:%M:%S'`>?$log_msg'????????????echo?'[info?]:?`date?'+%Y%m%d?%H:%M:%S'`>?$log_msg'?>>?$MYSQL_INSTALL_LOG????????????;;????????*)????esac????????}#?記錄安裝過程的錯誤信息function?log_error(){????#判斷參數個數????if?[?$#?-eq?1?];then????????local?log_msg=$1????else????????echo?'[error]:`date?'+%Y%m%d?%H:%M:%S'`>?the?number?of?parameters?is?incorrect!'????fi????:<<EOF????if?[?$LOG_OUT_TYPE?=?'print'?];then????????echo?'[error]:`date`>?$log_msg'????else????????echo?'[error]:`date`>?$log_msg'?>>?$MYSQL_INSTALL_LOG????fiEOF????case?$LOG_OUT_TYPE?in????????out)?????????????echo??'[error]:`date?'+%Y%m%d?%H:%M:%S'`>?$log_msg'?????????????;;????????log)?????????????echo??'[error]:`date?'+%Y%m%d?%H:%M:%S'`>?$log_msg'?>>?$MYSQL_INSTALL_LOG?????????????;;????????all)?????????????echo??'[error]:`date?'+%Y%m%d?%H:%M:%S'`>?$log_msg'?????????????echo??'[error]:`date?'+%Y%m%d?%H:%M:%S'`>?$log_msg'?>>?$MYSQL_INSTALL_LOG?????????????;;????????*)????esac}#?卸載系統自帶的MARIADB#rpm?-qa|grep?mariadb?|xargs?yum?remove?-y?>?/dev/nullfunction?check_env_setting(){????#?檢查操作系統是否Linux(此腳本不適用HP-UX/SunOS/AIX)????if?[?`uname?-s`='Linux'?];then????????log_info?'The?os?is?linux,mysql?auto?install?continue...'????else????????log_error?'the?os?is?not?linux,?please?check?it.'????????exit?1????fi????#?檢查存放安裝包目錄是否存在????if?[?!?-d?'$MYSQL_INSTALLER_DIR'?];then????????log_error?'the?mysql?installer?directory?$MYSQL_INSTALLER_DIR?didn't?exists,?please?check?it'????????exit?1????else????????log_info?'the?mysql?installer?directory?$MYSQL_INSTALLER_DIR?exist,?mysql?auto?install?continue...';????fi????????#?檢查MySQL安裝文件是否存在????if?[?!?-f?'$MYSQL_INSTALLER'?];then????????log_error?'the?mysql?installer?file?$MYSQL_INSTALLER?didn't?exist,?please?check?it'????????exit?1????else????????log_info??'the?mysql?installer?file?$MYSQL_INSTALLER?exist,?mysql?auto?install?continue...'????fi????????#?檢查MySQL的my.cnf的模板文件是否存在????if?[?!?-f?$MYSQL_CONFIG_FILE?];then????????log_error?'the?mysql?configuration?template?file?$MYSQL_CONFIG_FILE?did'nt?exist,?please?check?it'????????exit?1????else????????log_info?'the?mysql?configuration??template?file?$MYSQL_CONFIG_FILE?exists,mysql?auto?install?continue...'????fi????????#?檢查修改mysql數據庫用戶root密碼的SQL文件是否存在。????if?[?!?-f?$SQL_ALTER_USER_PWD?];then????????log_error?'the?sql?file?$SQL_ALTER_USER_PWD?did'nt?exist,?please?check?it'????????exit?1????else????????log_info?'the?sql?file?$SQL_ALTER_USER_PWD?exists,mysql?auto?install?continue...'????fi????????????#?檢查MySQL安裝目錄的上層目錄是否存在????if?[?!?-d?'$MYSQL_BASE_DIR'?];then????????log_error?'the?$MYSQL_BASE_DIR?didn't?exists,?please?check?it'????????exit?1????else????????log_info?'the?$MYSQL_BASE_DIR?exists,?mysql?auto?install?continue...'????fi????????#?檢查MYSQL_DATA_DIR對應的目錄是否存在,此目錄為datadir的上一層目錄????if?[?!?-d?'$MYSQL_DATA_DIR'?];then????????log_error?'the?$MYSQL_DATA_DIR?didn't?exists,?please?check?it'????????exit?1????else????????log_info?'the?$MYSQL_DATA_DIR?exists,?mysql?auto?install?continue...'????fi????????#?檢查MYSQL_DATA_DIR目錄下是否存在其目錄,如果有其它目錄,則退出安裝(擔心已經安裝了MySQL實例)????if?[?-d?${MYSQL_DATA_DIR}?-a?'`ls?-A?${MYSQL_DATA_DIR}`'?!=?''?];then????????log_error?'the?$MYSQL_DATA_DIR?directory?have?exists?files,plese?check?it'????????exit?1????else?????????log_info?'the?$MYSQL_DATA_DIR?check?is?ok?,mysql?auto?install?continue...'????fi????????#?驗證MySQL安裝介質的MD5????????????#?檢查是否存在MySQL實例????mysql_status=`netstat?-nl?|?awk?'NR>2{if?($4?~?/.*:'${MYSQL_PORT}'/)?{print?'Yes';exit?0}}'`????echo?$mysql_status????if?[?'$mysql_status'?=?'Yes'?];then????????log_error?'MySQL?instance?exists.?please?check?it'????????exit?1????else????????#只能作為一個依據,并不能完全保證。????????log_info?'MySQL?instance?didn't?exists,mysql?auto?install?continue...'????fi????????echo?'check_env_setting?run?successful.'????#read?ANS????read?-n1?-p?'Do?you?want?to?continue?[Y/N]?'?answer????case?$answer?in????????Y?|?y)????????????log_info?'mysql?auto?install?continue...';;????????N?|?n)????????????log_info?'mysql?auto?install?exit.';;????????*)????????????log_error?'your?choice?is?wrong!';;????esac}#?創建MySQL用戶和用戶組(此處注釋,用戶由系統管理員創建)#echo?'[info]:?create?the?mysql?user...'#groupadd?mysql#/usr/sbin/groupadd?mysql#useradd?-g?mysql?mysql#/usr/sbin/useradd?-g?mysql?mysql#?創建MySQL的相關目錄function?create_mysql_dir(){????cd?$MYSQL_DATA_DIR????mkdir?conf?data??logs??slow_logs??bin_logs??mysql_temp????chmod?750??$MYSQL_DATA_DIR????#對目錄進行授權????chmod?-R?760??$MYSQL_DATA_DIR/bin_logs????chmod?-R?700??$MYSQL_DATA_DIR/logs????chmod?-R?760??$MYSQL_DATA_DIR/slow_logs}function?mysql_cnf_setting(){????#?拷貝my.cnf的模板配置文件,這里不打算直接寫入生成my.cnf文件????cp?$MYSQL_CONFIG_FILE?$MYSQL_DATA_DIR/conf/my.cnf????if?[?$??-ne?0?];then????????log_error?'failed?to?cp?the?my.cnf,please?check?it'????????exit?1????else????????log_info??'cp?the?$MYSQL_CONFIG_FILE?to?my.cnf?success!'????fi}function?mysql_env_setting(){????#?設置環境變量????local?env_exist=`cat?~/.bash_profile?|grep?-E?'MYSQL_HISTFILE|$MYSQL_BASE_DIR/mysql8.0/bin'?|?wc?-l`????if?[?$env_exist?-eq?0?];then????????echo?'export?PATH=\$PATH:$MYSQL_BASE_DIR/mysql8.0/bin'?>>?~/.bash_profile????????echo?'export?MYSQL_HISTFILE=/dev/null'?>>?~/.bash_profile????????source?~/.bash_profile????else????????log_info?'the?environment?variable?exists,?please?check?it!'????fi}#?解壓MySQL的二進制安裝包function?mysql_install(){????echo?'[info]:unzip?the?mysql?installation?media....'????tar?-xvf?$MYSQL_INSTALLER?-C?$MYSQL_BASE_DIR????if?[?$??-ne?0?];then????????log_error?'mysql?media?unzip?failed,please?check?the?detail.'????????exit????else????????log_info??'mysql?media?unzip?success,mysql?auto?install?continue...'????fi????????#?創建軟連接????local?MYSQL_MEDIA_DIR=$(basename?${MYSQL_INSTALLER}?'.tar.xz')????#echo??$MYSQL_MEDIA_DIR????ln?-s?$MYSQL_BASE_DIR/$MYSQL_MEDIA_DIR??$MYSQL_BASE_DIR/mysql8.0????if?[?$??-ne?0?];then????????log_error?'create?the?mysql?soft?link?failed,?please?check?it'????????exit?1????else????????log_info?'create?the?mysql?soft?link?success,mysql?auto?install?continue...'????fi????????????#??初始化MySQL????cd?$MYSQL_BASE_DIR/mysql8.0????$MYSQL_BASE_DIR/mysql8.0/bin/mysqld?\????--defaults-file=$MYSQL_DATA_DIR/conf/my.cnf?\????--initialize?\????--basedir=$MYSQL_BASE_DIR/mysql8.0?\????--datadir=$MYSQL_DATA_DIR/data??2>&1?|?>>?$MYSQL_INSTALL_LOG????????#????$MYSQL_BASE_DIR/mysql8.0/bin/mysql_ssl_rsa_setup?--datadir=$MYSQL_DATA_DIR/data}function?mysql_startup(){????$MYSQL_BASE_DIR/mysql8.0/bin/mysqld_safe?--defaults-file=$MYSQL_DATA_DIR/conf/my.cnf?&????????#?休眠幾秒,等待MySQL服務啟動????sleep?15????????#?檢查MySQL服務是否啟動成功????mysql_status=`netstat?-nl?|?awk?'NR>2{if?($4?~?/.*:'${MYSQL_PORT}'/)?{print?'Yes';exit?0}}'`????echo?$mysql_status????if?[?'$mysql_status'?!=?'Yes'?];then????????log_error?'MySQL?did?not?start.?please?check?it'????????exit?1????else????????log_info?'MySQL?start?success,mysql?auto?install?continue...'????fi}#?修改MySQL的root用戶密碼function?change_mysql_root_pwd(){????#?獲取root初始密碼????mysql_root_init_passd=`grep?'temporary?password'?$MYSQL_DATA_DIR/logs/mysql_error.log?|awk?'{print?$NF}'`????????#?修改MySQL的root密碼????mysql?-uroot?-p'$mysql_root_init_passd'?--connect-expired-password?<?$SQL_ALTER_USER_PWD?2>?/dev/null????????if?[?$??-ne?0?];then????????log_error?'fail?to?perform?MySQL?operation!!!'????????exit?1????else????????log_info?'alter?the?mysql?user?root's?password?succeed!'????fi}#?MySQL的安全設置,此腳本在mysql用戶下運行,默認這些文件的屬主為mysqlfunction?mysql_security_setting{????#注意,此處寫死mysql_error.log,是因為my.cnf模板中命名統一規范????chmod?660??$MYSQL_DATA_DIR/logs/mysql_error.log????#注意,此處寫死mysql_binlog.*,是因為my.cnf模板中命名統一規范????chmod?600?$MYSQL_DATA_DIR/bin_logs/mysql_binlog.*????chmod?400?$MYSQL_DATA_DIR/data/*.pem????#注意,此處寫死mysql_slow.log,是因為my.cnf模板中命名統一規范????chmod?660?$MYSQL_DATA_DIR/slow_logs/mysql_slow.log????#plugin_dir的權限設置????chmod?550?$MYSQL_BASE_DIR/mysql8.0/lib/plugin/?}function?main()?{????????check_env_setting????????create_mysql_dir????????mysql_cnf_setting????????mysql_env_setting????????mysql_install????????mysql_startup????????change_mysql_root_pwd????????????if?[?$??-ne?0?];then????????????log_error?'change_mysql_root_pwd?run?failed!'????????else????????????????log_info?'the?mysql?auto?install?was?successful!'????????fi????????mysql_security_setting}#?invoke?main?functionmain?

下面是安裝測試過程的截圖

下面是安裝日志mysql_install.log的輸出信息截圖:

到此這篇關于MySQL自動安裝腳本代碼實例分享的文章就介紹到這了,更多相關MySQL自動安裝腳本內容請搜索好吧啦網以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持好吧啦網!

標簽: MySQL 數據庫
主站蜘蛛池模板: LED太阳能中国结|发光红灯笼|灯杆造型灯|节日灯|太阳能灯笼|LED路灯杆装饰造型灯-北京中海轩光电 | 带锯机|木工带锯机圆木推台锯|跑车带锯机|河北茂业机械制造有限公司| | 砂石生产线_石料生产线设备_制砂生产线设备价格_生产厂家-河南中誉鼎力智能装备有限公司 | 工业机械三维动画制作 环保设备原理三维演示动画 自动化装配产线三维动画制作公司-南京燃动数字 聚合氯化铝_喷雾聚氯化铝_聚合氯化铝铁厂家_郑州亿升化工有限公司 | 渣油泵,KCB齿轮泵,不锈钢齿轮泵,重油泵,煤焦油泵,泊头市泰邦泵阀制造有限公司 | 字典-新华字典-在线字典查字-字典趣 | 焊锡,锡膏,锡线,锡条,焊锡膏-绿志岛金属有限公司 | 国产液相色谱仪-超高效液相色谱仪厂家-上海伍丰科学仪器有限公司 | 酒店厨房设计_中央厨房设计_北京商用厨房设计公司-奇能商厨 | 太阳能发电系统-太阳能逆变器,控制器-河北沐天太阳能科技首页 | 袋式过滤器,自清洗过滤器,保安过滤器,篮式过滤器,气体过滤器,全自动过滤器,反冲洗过滤器,管道过滤器,无锡驰业环保科技有限公司 | 步入式高低温测试箱|海向仪器 | MTK核心板|MTK开发板|MTK模块|4G核心板|4G模块|5G核心板|5G模块|安卓核心板|安卓模块|高通核心板-深圳市新移科技有限公司 | 密集架-手摇-智能-移动-价格_内蒙古档案密集架生产厂家 | 防火卷帘门价格-聊城一维工贸特级防火卷帘门厂家▲ | 雷达液位计_超声波风速风向仪_雨量传感器_辐射传感器-山东风途物联网 | 货车视频监控,油管家,货车油管家-淄博世纪锐行电子科技 | 火锅底料批发-串串香技术培训[川禾川调官网]| 哔咔漫画网页版在线_下载入口访问指引 | 门禁卡_智能IC卡_滴胶卡制作_硅胶腕带-卡立方rfid定制厂家 | 校服厂家,英伦校服定做工厂,园服生产定制厂商-东莞市艾咪天使校服 | 注塑_注塑加工_注塑模具_塑胶模具_注塑加工厂家_深圳环科 | 游戏版号转让_游戏资质出售_游戏公司转让-【八九买卖网】 | 透平油真空滤油机-变压器油板框滤油机-滤油车-华之源过滤设备 | 减速机电机一体机_带电机减速器一套_德国BOSERL电动机与减速箱生产厂家 | 我车网|我关心的汽车资讯_汽车图片_汽车生活! | 塑料托盘厂家直销-吹塑托盘生产厂家-力库塑业【官网】 | 光纤测温-荧光光纤测温系统-福州华光天锐光电科技有限公司 | 5nd音乐网|最新流行歌曲|MP3歌曲免费下载|好听的歌|音乐下载 免费听mp3音乐 | 美侍宠物-专注宠物狗及宠物猫训练|喂养|医疗|繁育|品种|价格 | 赛默飞Thermo veritiproPCR仪|ProFlex3 x 32PCR系统|Countess3细胞计数仪|371|3111二氧化碳培养箱|Mirco17R|Mirco21R离心机|仟诺生物 | 成都离婚律师|成都结婚律师|成都离婚财产分割律师|成都律师-成都离婚律师网 | 湖南自考_湖南自学考试 | 小学教案模板_中学教师优秀教案_高中教学设计模板_教育巴巴 | 防渗膜厂家|养殖防渗膜|水产养殖防渗膜-泰安佳路通工程材料有限公司 | 压力变送器-上海武锐自动化设备有限公司 | 高通量组织研磨仪-多样品组织研磨仪-全自动组织研磨仪-研磨者科技(广州)有限公司 | 跨境物流_美国卡派_中大件运输_尾程派送_海外仓一件代发 - 广州环至美供应链平台 | led全彩屏-室内|学校|展厅|p3|户外|会议室|圆柱|p2.5LED显示屏-LED显示屏价格-LED互动地砖屏_蕙宇屏科技 | ALC墙板_ALC轻质隔墙板_隔音防火墙板_轻质隔墙材料-湖北博悦佳 | 北京租车牌|京牌指标租赁|小客车指标出租 |