MySQL的自动化安装部署.docx

一、 实验环境操作系统: Oracle Enterprise Linux 5.7虚拟机：00（建立mysql安装模板）01（验证自动安装脚本）MySQL版本：mysql 5.5.37二、 模板机安装mysql（00）1. 安装必备的包和工具# rpm ivh gcc-4.1.2-51.el5.x86_64.rpm# rpm ivh gcc-c+-4.1.2-51.el5.x86_64.rpm# rpm ivh cmake-2.6.4-5.el5.4.x86_64.rpm# rpm ivh bison-2.3-2.1.x86_64.rpm# rpm ivh ncurses-devel-5.5-24.20060715.x86_64.rpm# rpm ivh zlib-1.2.3-4.el5.x86_64.rpm2. 创建mysql组和用户# groupadd mysql# useradd -g mysql mysql3. 上传并解压mysql源码文件# tar zxvf mysql-5.5.37.tar.gz4. 配置、编译并安装# cd mysql-5.5.37# CFLAGS=-O3 -g -fno-exceptions -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing# CXX=g+# CXXFLAGS=-O3 -g -fno-exceptions -fno-rtti -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing# export CFLAGS CXX CXXFLAGS# cmake . -DSYSCONFDIR:PATH=%prefix -DCMAKE_INSTALL_PREFIX:PATH=%prefix -DCMAKE_BUILD_TYPE:STRING=Release -DENABLE_PROFILING:BOOL=ON -DWITH_DEBUG:BOOL=OFF -DWITH_VALGRIND:BOOL=OFF -DENABLE_DEBUG_SYNC:BOOL=OFF -DWITH_EXTRA_CHARSETS:STRING=all -DWITH_SSL:STRING=bundled -DWITH_UNIT_TESTS:BOOL=OFF -DWITH_ZLIB:STRING=bundled -DWITH_PARTITION_STORAGE_ENGINE:BOOL=ON -DWITH_INNOBASE_STORAGE_ENGINE:BOOL=ON -DWITH_ARCHIVE_STORAGE_ENGINE:BOOL=ON -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_PERFSCHEMA_STORAGE_ENGINE:BOOL=ON -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE:BOOL=ON -DWITH_EMBEDDED_SERVER=0 -DINSTALL_LAYOUT:STRING=STANDALONE -DCOMMUNITY_BUILD:BOOL=ON -DMYSQL_SERVER_SUFFIX=-r5436;# make -j cat /proc/cpuinfo | grep processor| wc -l# make install5. 初始化数据库# mkdir p /project/class2/mysql/log/# chown R mysql:mysql /project/class2/mysql# chmod R 755 /project/class2/mysql# scripts/mysql_install_db-user=mysql-basedir=/project/class2/mysql-datadir=/project/class2/mysql/data6. 上传配置文件将编辑好的f文件上传到mysql根目录和/etc目录下，注意修改server_id7. 启动mysql启动msql# bin/mysqld_safe-user=mysql&使用netstat命令检查3306端口确认是否启动成功# netstat -an|grep 3306如未启动，查看/project/class2/mysql/log目录下的alert.log中错误信息8. 配置mysql自启动# cpsupport-files/mysql.server/etc/init.d/mysql# chmod+x/etc/init.d/mysql# chkconfigaddmysql至此模板机的安装结束，下一部在模板机上准备用于自动安装的文件三、 自动安装源准备（00）1. 根据MySQL的源码编译符合企业需求的RPM包# cd mysql-5.5.37# mkdir rpm2. 上传mysql.spec文件并制作rpm包# cp mysql.spec mysql-5.5.37/rpm# rpmbuild bb ./mysql.spec3. 准备数据目录模板在模板机上完成通用信息的建立（如账户等），将data目录打成tar包# cd /project/class2/mysql/data# tar cvf data.tar mysql/ performance_schema/ test/4. 将用于自动安装的文件传输到固定目录（本实验为/s01）# cp data.tar /s01# cp f /s01# cp mysql-5.5.37-1.x86_64.rpm /s01这样在模板机上完成了mysql自动安装所需文件的准备四、 自动安装mysql（01）1. 建立mysql自动安装目录# mkdir p /project/class22. 上传rpm包并编辑rpm验证文件# cp gcc-4.1.2-51.el5.x86_64.rpm /project/class2# cp gcc-c+-4.1.2-51.el5.x86_64.rpm /project/class2# cp cmake-2.6.4-5.el5.4.x86_64.rpm /project/class2# cp bison-2.3-2.1.x86_64.rpm /project/class2# cp ncurses-devel-5.5-24.20060715.x86_64.rpm /project/class2# cp zlib-1.2.3-4.el5.x86_64.rpm /project/class2# vi rpmlistgcc-4.1.2-51.el5gcc-c+-4.1.2-51.el5cmake-2.6.4-5.el5.4bison-2.3-2.1ncurses-devel-5.5-24.20060715zlib-1.2.3-4.el53. 编辑mysql自动安装脚本# vi mysql_install.sh#!/bin/bash# mysql auto-install script#Step 1: Install rpm packageif $1 = ; then echo Usage: $0 rpmlist & exit 0elif $1 != rpmlist ; then echo Usage: $0 rpmlist & exit 0fiRPMLIST=$1ERRFILE=/rpminstdate +%Y%m%d%H%m%S.errfor pkg in cat $RPMLISTdo rpm -qa | grep $pkg &/dev/null if $? -ne 0 ; then echo $pkg is not installed yet, starting to install. rpm -Uvh $pkg* 2$ERRFILE else echo $pkg already installed. fidone#Step 2: Create group & usergroup=$(more /etc/group|grep mysql)if $group != ; then echo group already created!else groupadd mysqlfiuser=$(more /etc/passwd|grep mysql)if $user != ; then echo user already created!else useradd -g mysql mysqlfi#Step 3: Get sourceftp -n frpm -ivh mysql-5.5.37-1.x86_64.rpmcp f /project/class2/mysqlchown -R mysql:mysql /project/class2/mysqltar xvf data.tar -C /project/class2/mysql/data/chown -R mysql:mysql /project/class2/mysqlmkdir -p /project/class2/mysql/logchown -R mysql:mysql /project/class2/mysql/log#step 4: Start MySQLcp /project/class2/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqldchmod 755 /etc/init.d/mysqldchkconfig mysqld on/etc/init.d/mysqld start4. 开始自动安装# sh mysql_install.sql rpmlistgcc-4.1.2-51.el5 already installed.gcc-c+-4.1.2-51.el5 already installed.cmake-2.6.4-5.el5.4 already installed.bison-2.3-2.1 already installed.ncurses-devel-5.5-24.20060715 already installed.zlib-1.2.3-4.el5 already installed.group already created!user already created!Please login with USER and PASS.Please login with USER and PASS.KERBEROS_V4 rejected as an authentication typeInteractive mode off.Preparing. # 100% 1:mysql # 100%mysql/mysql/proxies_priv.MYDmysql/help_relation.MYDmysql/slow_log.CSMmysql/time_zone_transition.MYDmysql/proc.MYImysql/help_relation.MYImysql/help_category.frmmysql/time_zone.MYDmysql/help_topic.frmmysql/columns_priv.frmmysql/help_relation.frmmysql/procs_priv.MYImysql/user.MYImysql/time_zone_transition_type.MYDmysql/time_zone_transition_type.frmmysql/time_zone.MYImysql/tables_priv.frmmysql/plugin.MYDmysql/help_category.MYDmysql/procs_priv.MYDmysql/time_zone_transition_type.MYImysql/help_keyword.MYImysql/proxies_priv.frmmysql/time_zone_name.MYImysql/event.frmmysql/tables_priv.MYImysql/user.frmmysql/host.MYImysql/help_keyword.MYDmysql/host.MYDmysql/ndb_binlog_index.MYImysql/general_log.CSVmysql/db.frmmysql/func.frmmysql/time_zone.frmmysql/slow_log.CSVmysql/time_zone_leap_second.frmmysql/servers.MYDmysql/tables_priv.MYDmysql/func.MYDmysql/time_zone_transition.MYImysql/servers.frmmysql/ndb_binlog_index.MYDmysql/time_zone_leap_second.MYImysql/help_topic.MYDmysql/time_zone_transition.frmmysql/help_topic.MYImysql/event.MYImysql/host.frmmysql/columns_priv.MYDmysql/ndb_binlog_index.frmmysql/general_log.CSMmysql/proxies_priv.MYImysql/time_zone_leap_second.MYDmysql/db.MYDmysql/slow_log.frmmysql/proc.MYDmysql/user.MYDmysql/func.MYImysql/db.MYImysql/help_keyword.frmmysql/proc.frmmysql/event.MYDmysql/help_category.MYImysql/time_zone_name.MYDmysql/general_log.frmmysql/procs_priv.frmmysql/columns_priv.MYImysql/servers.MYImysql/plugin.MYImysql/plugin.frmmysql/time_zone_name.frmperformance_schema/performance_schema/file_summary_by_instance.frmperformance_schema/mutex_instances.frmperformance_schema/events_waits_history_long.frmperformance_schema/setup_instrument