您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

MySQL 5.5.40自动化安装脚本

2025/6/2 11:23:21发布16次查看
学习了两周linux shell脚本,终于写出一个mysql自动化安装脚本。加上今天一整天的测试,可以正常执行安装mysql 5.5.40. 其他版本
学习了两周linux shell脚本,,终于写出一个mysql自动化安装脚本。加上今天一整天的测试,可以正常执行安装mysql 5.5.40. 其他版本还没有测试。现分享一下。也请高手指点一下。
执行该脚本的前提是:
环境介绍:
1、redhat 6.3 x64,最小化安装
2、ram: 2g,hd:30g
3、关闭selinux
4、配置好yum源(我使用自己配置的源)
5、打开ssh,病配置好iptables,允许远程登录访问。
6、所需软件和文件:
cmake-2.8.10.1.tar.gz
bison-3.0.tar.gz
zlib-1.2.7.tar.gz
mysql-5.5.40.tar.gz
my.cnf  //老师共享的文件
脚本内容:
#!/bin/bash
echo step one: create folder and mount packages
if [ -d /mnt/share ]
then
  echo find it,don't need to create it.
else
  mkdir -p /mnt/share
    if [[ $? = 0 ]]
      then
        echo create it successfully!
      else
        echo can't create this folder!pls check out!
      fi
  mount -t cifs -o username=swen02,password=autozhao01! //172.16.11.20/lamp-all-software /mnt/share
fi
echo step two: create mysql installation path
if [ -d /project/class2 ]
then
  echo find it, don't need to create it.
else
    mkdir -p /project/class2/
 if [[ $? = 0 ]]
      then
        echo create it successfully!
      else
        echo can't create this floder!pls check out!
      fi
fi
echo step three: copy packages to the folder
cp /mnt/share/cmake-2.8.10.1.tar.gz  /project/class2/
cp /mnt/share/bison-3.0.tar.gz  /project/class2/
cp /mnt/share/zlib-1.2.7.tar.gz  /project/class2/
cp /mnt/share/mysql-5.5.40.tar.gz /project/class2/
cp /mnt/share/my.cnf  /project/class2/
echo step four: install base packages
yum -y install  gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*
cd /project/class2
tar -xzvf  cmake-2.8.10.1.tar.gz
cd cmake-2.8.10.1
./bootstrap
make && make install
if [[ $? = 0 ]]
then
  echo good job!
else
  echo sorry, pls check out!
  exit 1
fi
cd ..
tar -zxvf bison-3.0.tar.gz
cd bison-3.0
./configure
make && make install
if [[ $? = 0 ]]
then
  echo good job!
else
  echo sorry, pls check out!
  exit 1
fi
cd ..
tar -zxvf zlib-1.2.7.tar.gz
cd zlib-1.2.7
./configure
make && make install
cd ..
if [[ $? = 0 ]]
then
  echo good job!
else
  echo sorry, pls check out!
  exit 1
fi
echo step five:configure system referenc
flags=-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
echo step six: begin to install mysql
groupadd mysql
useradd -r -g mysql mysql
tar -zxvf mysql-5.5.40.tar.gz
cd mysql-5.5.40
cmake -dcmake_install_prefix=/project/class2/mysql
make
make install
if [[ $? = 0 ]]
then
  echo good job!
else
  echo sorry, pls check out!
  exit 1
fi
cd ..
#create folder and initial new db
mkdir ./mysql/run
mkdir ./mysql/log
chown -r mysql.mysql /project/class2/mysql
rm -rf /project/class2/mysql/data/*
./mysql/scripts/mysql_install_db --datadir=/project/class2/mysql/data --user=mysql --basedir=/project/class2/mysql
#modify my.cnf and copy new one
sed 's/default-character-set=gbk/default-character-set=utf8/' my.cnf | sed 's/skip-ssl/#skip-ssl/' >./mysql/my.cnf
chown -r mysql.mysql /project/class2/mysql/my.cnf
#creat ln
ln -s /project/class2/mysql/run/mysql.sock /tmp/mysql.sock
mv /root/.bash_profile /root/.bash_profile.bak
/bin/sed '/export path/i\export path=$path:/project/class2/mysql/bin/' /root/.bash_profile.bak >/root/.bash_profile
#start mysql service
./mysql/bin/mysqld_safe --defaults-file=/project/class2/mysql/my.cnf &
#waitting for service to be started
signal=0
while [[ $signal = 0 ]]
do
 if [ -z `grep 'source distribution'  /project/class2/mysql/log/alert.log` ]
then
  echo not found it
  sleep 30
else
    echo found it
  let signal+=1
fi
done
#logout and relogin, new path will be  take effect.
kill -9 $ppid
--------------------------------------分割线 --------------------------------------
ubuntu 14.04下安装mysql
《mysql权威指南(原书第2版)》清晰中文扫描版 pdf
ubuntu 14.04 lts 安装 lnmp nginx\php5 (php-fpm)\mysql
ubuntu 14.04下搭建mysql主从服务器
ubuntu 12.04 lts 构建高可用分布式 mysql 集群
ubuntu 12.04下源代码安装mysql5.6以及python-mysqldb
mysql-5.5.38通用二进制安装
--------------------------------------分割线 --------------------------------------
本文永久更新链接地址:
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product