MySQL集群自动安装脚本

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MySQL集群自动安装脚本，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含9740字，纯文字阅读大概需要14分钟。

内容图文

1. 在MySQL源代码目录下新建脚本 install.sh，把下面的代码添加到这个脚本中：


#!/bin/bash

############################################
######### MySQL Server Config ##############
############################################
#Determine to install MySQL server
#"0" means do not install server programs
INST_SERVER=1
#MySQL installation path
INST_PATH="/usr/local/mysql"
#Define the ports of MySQL installation, intput strings of 
#PORT with whitespace separated.
#e.g. "3306 3307" means install two MySQL servers:
#     The first server will be installed to $INST_PATH/1 and listen 3306 port.
#     The second server will be installed to $INST_PATH/2 and listen 3307 port.
#     ... ...
INST_PORTS="3306"
#The management server information
MGM_HOST="192.168.1.253"
MGM_PORT="2200"
###########################################
######### MySQL Cluster Config ############
###########################################
#Determine to install cluster
#"0" means do not install cluster programs
INST_CLUSTER=1
#Define COMPUTERs in config.ini, intput strings of HostName with 
#whitespace separated.
#The Id attribute is auto increment and start with 1.
#e.g. "192.168.1.253 192.168.252" will generate the following code
#  [COMPUTER]
#    Id=1
#    HostName=192.168.1.253
#  [COMPUTER]
#    Id=2
#    HostName=192.168.1.252
COMPUTERS="192.168.1.253 192.168.1.252"
#Define MGMs in config.ini, intput strings of HostName with whitespace separated.
#e.g. "192.168.1.253 192.168.252" will generate the following code
#  [MGM]
#    HostName=192.168.1.253
#  [MGM]
#    HostName=192.168.1.252
MGMS="192.168.1.253"
#Define DBs in config.ini, intput ids of ExecuteOnComputer with whitespace separated.
#e.g. "1 2" will generate the following code
#  [DB]
#    ExecuteOnComputer=1
#  [DB]
#    ExecuteOnComputer=2
DBS="1"
#Define APIs in config.ini, intput ids of ExecuteOnComputer with whitespace separated.
#e.g. "1 0 1 2" will generate the following code
#  [API]
#    ExecuteOnComputer=1
#  [API]
#  [API]
#    ExecuteOnComputer=1
#  [API]
#    ExecuteOnComputer=2
APIS="1 0 2 2"
######################################################################
########## Starting to install programs, do not modify them! #########
######################################################################
echo "Starting to install programs" > install.log
#Find installation path
if [ $# -gt 0 ] 
then 
  INST_PATH="$1"
else 
  INST_PATH="/usr/local/mysql"
fi
if [ 0 -lt $INST_SERVER ]
then
 echo "Now, installing the MySQL servers..."
 
 #Loop to install mysql servers
 INSTALLED_SERVER_COUNT=1
 for PORT in $INST_PORTS
 do
  #Define the current mysql server installation path
   MYSL_PATH=$INST_PATH/$INSTALLED_SERVER_COUNT
   
   #Configure mysql server
   echo "Exec ./configure --prefix=$MYSL_PATH --with-pthread 
--with-unix-socket-path=$MYSL_PATH/var/mysql.sock --with-mysqld-user=root 
--with-tcp-port=$PORT --with-charset=gbk --with-ndbcluster" >> install.log
   ./configure --prefix=$MYSL_PATH --with-pthread 
--with-unix-socket-path=$MYSL_PATH/var/mysql.sock 
--with-mysqld-user=root --with-tcp-port=$PORT 
--with-charset=gbk --with-ndbcluster
 
   #Make mysql server
   echo "Exec make && make install" >> install.log
   make && make install
   
   #Create var directory for mysql data
   mkdir -p $MYSL_PATH/var
   
   #Create my.cnf
   echo "Create $MYSL_PATH/var/my.cnf" >> install.log
   echo "[client]" > $MYSL_PATH/var/my.cnf
   echo "port=$PORT" >> $MYSL_PATH/var/my.cnf
   echo "socket=$MYSL_PATH/var/mysql.sock" >> $MYSL_PATH/var/my.cnf
   echo "" >> $MYSL_PATH/var/my.cnf
   echo "[mysqld]" >> $MYSL_PATH/var/my.cnf
   echo "ndbcluster" >> $MYSL_PATH/var/my.cnf
   echo "ndb_connectstring=host=$MGM_HOST:$MGM_PORT" >> $MYSL_PATH/var/my.cnf
   echo "user=root" >> $MYSL_PATH/var/my.cnf
   echo "port=$PORT" >> $MYSL_PATH/var/my.cnf
   echo "basedir=$MYSL_PATH/" >> $MYSL_PATH/var/my.cnf
   echo "datadir=$MYSL_PATH/var/" >> $MYSL_PATH/var/my.cnf
   echo "socket=$MYSL_PATH/var/mysql.sock" >> $MYSL_PATH/var/my.cnf
   echo "default-character-set=gbk" >> $MYSL_PATH/var/my.cnf
   echo "default-storage-engine=INNODB" >> $MYSL_PATH/var/my.cnf
   echo "max_connections=500" >> $MYSL_PATH/var/my.cnf
   echo "" >> $MYSL_PATH/var/my.cnf
   echo "query_cache_size=33M" >> $MYSL_PATH/var/my.cnf
   echo "table_cache=1520" >> $MYSL_PATH/var/my.cnf
   echo "tmp_table_size=16M" >> $MYSL_PATH/var/my.cnf
   echo "thread_cache=38" >> $MYSL_PATH/var/my.cnf
   echo "" >> $MYSL_PATH/var/my.cnf
   echo "#MyISAM Specific options" >> $MYSL_PATH/var/my.cnf
   echo "#skip-myisam" >> $MYSL_PATH/var/my.cnf
   echo "" >> $MYSL_PATH/var/my.cnf
   echo "#INNODB Specific options" >> $MYSL_PATH/var/my.cnf
   echo "#skip-innodb" >> $MYSL_PATH/var/my.cnf
   chmod 755 $MYSL_PATH/var/my.cnf
   
   #Install mysql database
   echo "Exec $MYSL_PATH/bin/mysql_install_db" >> install.log
   $MYSL_PATH/bin/mysql_install_db
   
   #Create mysql control script
   if [ -e $MYSL_PATH/share/mysql/mysql.server ]
   then
   
    #Use default mysql control script
    
    #Create mysql server start script
    echo "Create $MYSL_PATH/start" >> install.log
    echo "$MYSL_PATH/share/mysql/mysql.server start" > $MYSL_PATH/start
    echo "Chmod 755 $MYSL_PATH/start" >> install.log
    chmod 755 $MYSL_PATH/start
    
    #Create mysql server stop script
    echo "Create $MYSL_PATH/stop" >> install.log
    echo "$MYSL_PATH/share/mysql/mysql.server stop" > $MYSL_PATH/stop
    echo "Chmod 755 $MYSL_PATH/stop" >> install.log
    chmod 755 $MYSL_PATH/stop
    
    #Create mysql server restart script
    echo "Create $MYSL_PATH/restart" >> install.log
    echo "$MYSL_PATH/share/mysql/mysql.server restart" > $MYSL_PATH/restart
    echo "Chmod 755 $MYSL_PATH/restart" >> install.log
    chmod 755 $MYSL_PATH/restart
   else
   
     #Use custom mysql control script
     
    #Create mysql server start script
    echo "Create $MYSL_PATH/start" >> install.log
    echo "$MYSL_PATH/libexec/mysqld &" > $MYSL_PATH/start
    echo "Chmod 755 $MYSL_PATH/start" >> install.log
    chmod 755 $MYSL_PATH/start
    
    #Create mysql server stop script
    echo "Create $MYSL_PATH/stop" >> install.log
    echo "$MYSL_PATH/bin/mysqladmin -u root -p shutdown" > $MYSL_PATH/stop
    echo "Chmod 755 $MYSL_PATH/stop" >> install.log
    chmod 755 $MYSL_PATH/stop
    
    #Create mysql server restart script
    echo "Create $MYSL_PATH/restart" >> install.log
    echo "$MYSL_PATH/bin/mysqladmin -u root -p shutdown" > $MYSL_PATH/restart
    echo "$MYSL_PATH/libexec/mysqld &" >> $MYSL_PATH/restart
    echo "Chmod 755 $MYSL_PATH/restart" >> install.log
    chmod 755 $MYSL_PATH/restart
   fi
   
   #Clean mysql server to get ready for the next installation
   echo "Exec make clean" >> install.log
   make clean
   
   INSTALLED_SERVER_COUNT=$(($INSTALLED_SERVER_COUNT + 1))
 done
 
 echo "Configurations! MySQL servers has been installed successfully."
 echo ""
 echo "1. To start mysql server, use the following command:"
 echo "  cd "
 echo "  ./start"
 echo ""
 echo "2. To stop mysql server, use the following command:"
 echo "  cd "
 echo "  ./stop"
 echo ""
 echo "3. To restart mysql server, use the following command:"
 echo "  cd "
 echo "  ./restart"
fi

#Install cluster programs
if [ 0 -lt $INST_CLUSTER ]
then
 if [ -e $INST_PATH/1 ]
 then
  echo "Now, installing the cluster programs..."
  
   #Define the cluster installation path
   CLST_PATH=$INST_PATH/cluster
   
   #Create cluster directory
   echo "Exec mkdir -p $CLST_PATH" >> install.log
   mkdir -p $CLST_PATH
 
   #Copy cluster binaries
   echo "Exec cp $INST_PATH/1/bin/ndb* $CLST_PATH/" >> install.log
   cp $INST_PATH/1/bin/ndb* $CLST_PATH/
   echo "Exec cp $INST_PATH/1/libexec/ndb* $CLST_PATH/" >> install.log
   cp $INST_PATH/1/libexec/ndb* $CLST_PATH/
 
   #Create config.ini
   echo "Create $CLST_PATH/config.ini" >> install.log
     
     #Write default global configuration
    echo "[TCP DEFAULT]" >> $CLST_PATH/config.ini
    echo "" >> $CLST_PATH/config.ini
    echo "[MGM DEFAULT]" >> $CLST_PATH/config.ini
    echo "" >> $CLST_PATH/config.ini
    echo "[DB DEFAULT]" >> $CLST_PATH/config.ini
    echo "  NoOfReplicas=1" >> $CLST_PATH/config.ini
    echo "" >> $CLST_PATH/config.ini
    echo "[API DEFAULT]" >> $CLST_PATH/config.ini
    echo "" >> $CLST_PATH/config.ini
    
    #Write computers configuration
    COMPUTER_ID=1
    for COMPUTER in $COMPUTERS
    do
      echo "[COMPUTER]" >> $CLST_PATH/config.ini
      echo "  Id=$COMPUTER_ID" >> $CLST_PATH/config.ini
      echo "  HostName=$COMPUTER" >> $CLST_PATH/config.ini
      echo "" >> $CLST_PATH/config.ini
      
      COMPUTER_ID=$(($COMPUTER_ID + 1))
    done
    
    #Write management server configuration
    for MGM in $MGMS
    do
      echo "[MGM]" >> $CLST_PATH/config.ini
      echo "  HostName=$MGM" >> $CLST_PATH/config.ini
      echo "" >> $CLST_PATH/config.ini
    done
    
    #Write storage nodes configuration
    for DB in $DBS
    do
      echo "[DB]" >> $CLST_PATH/config.ini
      echo "  ExecuteOnComputer=$DB" >> $CLST_PATH/config.ini
      echo "" >> $CLST_PATH/config.ini
    done
    
    #Write mysql servers configuration
    for API in $APIS
    do
      echo "[API]" >> $CLST_PATH/config.ini
      if [ 0 -ne $API ]
      then
        echo "  ExecuteOnComputer=$API" >> $CLST_PATH/config.ini
      fi
      echo "" >> $CLST_PATH/config.ini
    done
    
  #Create Ndb.cfg
  echo "Create $CLST_PATH/Ndb.cfg" >> install.log
  echo "host=$MGM_HOST:$MGM_PORT" >> $CLST_PATH/Ndb.cfg
  echo "" >> $CLST_PATH/Ndb.cfg
 
   echo "Configurations! Cluster programs has been installed successfully."
   echo ""
   echo "1. To start management server(MGM), use the following command:"
   echo "  cd $CLST_PATH"
   echo "  ./ndb_mgmd"
   echo ""
   echo "2. To start stroage node(DB), use the following command:"
   echo "  cd $CLST_PATH"
   echo "  ./ndbd"
   echo ""
   echo "3. To manage the cluster, use the following command:"
   echo "  cd $CLST_PATH"
   echo "  ./ndb_mgm"
   echo ""
   echo "4. Else, nothing to do.;)"
   echo ""
   echo "Enjoy yourself."
 else
   echo "Cluster installation has been stopped, the reason is:";
   echo "  No database server installed."
   echo "So you can not use cluster programs in this machine!"
 fi
fi

2. 设置脚本权限，让它可执行：chmod 755 install.sh
3. 执行该脚本：./install.sh 或者 ./install

内容总结

以上是互联网集市为您收集整理的MySQL集群自动安装脚本全部内容，希望文章能够帮你解决MySQL集群自动安装脚本所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/561222.html

来源：【匿名】

【上一篇】MySQL管理介绍【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【MySQL集群自动安装脚本】教程文章相关的互联网学习教程文章

脚本里面没有把同步时间写进去，这个写在最前面yum install -y ntp ntpdatecp -f /usr/share/zoneinfo/Asia/Shanghai /etc/localtime执行下列语句之前，请详细了解ntp和ntpdate的区别，由于我这里是测试环境，所以ntpdate并无问题，正式环境请慎用ntpdate（ntp是逐渐校正时间，ntpdate是跳跃式的直接修改时间，可能会对应用造成不良影响）（另外，在虚拟机上测试时，ntpd不是太明显）service ntpdate start /sbin/chkconfig --add ...

mysql自动安装脚本

为适应自己工作习惯和需要，花一点时间写了一个mysql自动安装脚本，供大家参考学习。注意：1、需要先安装cmake2、数据库版本需要在第二步安装mysql时修改3、该脚本是以root用户安装并启动脚本内容如下：#########################################################################mysql自动安装脚本，其中变量/mysql_v_dir/和/port/可根据实际需要修改 ##执行脚本命令：sh mysql_install.sh >mysql_install.log ...

VS2010（英文版）打包部署自动安装数据库

上周第一次打包自己的系统时，在别人电脑上使用不了，因为远程连接不了我的数据库，所以要想在别人的电脑上运行我的系统则需要手动附加我的数据库。下面我来为大家介绍一种方法：在打包程序时将数据库一起打包，这样安装程序的时候会自动附加数据库（前提是上周第一次打包自己的系统时，在别人电脑上使用不了，因为远程连接不了我的数据库，所以要想在别人的电脑上运行我的系统则需要手动附加我的数据库。下面我来为大家介绍一种...

mysql 自动安装脚本，记得提前安装依赖包

CMake Error: your CXX compiler: "CMAKE_CXX_COMPILER-NOTFOUND" was not found.yum install -y gcc gcc-c++本文出自 “初学者” 博客，请务必保留此出处http://xiochen.blog.51cto.com/2468288/1679314mysql 自动安装脚本，记得提前安装依赖包标签：mysql cmake error 本文系统来源：http://xiochen.blog.51cto.com/2468288/1679314

yum自动安装mysql

1、安装客户端和服务器端查看CentOS自带mysql： yum list installed | grep mysql卸载CentOS系统自带mysql数据库？ yum -y remove mysql-libs.x86_64安装mysql客户端和服务器： yum -y install mysql-server mysql mysql-devel当结果显示为“Complete！”即安装完毕。查看刚安装mysql数据库版本信息。 rpm -qi mysql-server信息如下： Name : mysql-server Relocations: (not relocatable) Version : 5...

python自动安装mysql5.7

!/usr/bin/env python # -*- coding:utf-8 -*- # @Author : huazai # @Time : 2017/5/4 22:04 # @File : installmysql.py # @Description : mysql数据目录路径：/data/mysql/ ,mysql安装目录路径：/usr/local/mysqlimport os import sys from optparse import OptionParser from subprocess import Popen, PIPE import shlex import time import MySQLdb import re import shutil import tarfile import stat import logging impo...

python自动安装mysql5.7【转】

pythonimport os import sys import rebase_dir = ‘/opt/software/mysql-5.7.17-linux-glibc2.5-x86_64‘os.chdir(‘/opt/software‘) tar_result = os.system(‘tar xvf %s &>/dev/null‘ % sys.argv[1]) if tar_result == 0:os.chdir(‘/usr/local‘)os.system(‘ln -s %s mysql‘ % base_dir) else:print "uncompress wrong"user_result = os.system(‘id mysql‘) if user_result==0:print "user exist" else:os.system(‘gr...

CentOS7.5源码shell脚本自动安装MySQL5.7.28多实例【代码】

在文章上一篇文章中https://blog.51cto.com/8355320/2463218我使用的是手动源码安装mysql5.7.28，安装过程还是比较耗时，我编写了shell自动安装脚本，请大家参考，脚本我测试没有出现问题，脚本我有二次修改里面的实例名与变量名，可能存在不一致，请自行对比确认下。脚本中有什么可以优化的还请多多指点，谢谢！！以下是脚本中的几点说明：1、mysql5.7.28软件包(脚本中配置wget下载，如果下载比较慢，可以事先下载好，上传到 /opt...

ubuntu12.04：Mysql数据库：自动安装

打开终端，输入下面命令： 1sudoapt-getinstallmysql-server 2sudoapt-getinstallmysql-client 一旦安装完成， MySQL 服务器应该自动启动。您可以在终端提示符后运行以下命令来检查 MySQL 服务器是否正在运行： Sudonetstat-nat 或 sudonetstat-tap|grepmysq打开终端，输入下面命令： 1 sudo apt-get install mysql-server 2 sudo apt-get install mysql-client一旦安装完成，MySQL 服务器应该自动启动。您可以在终端提示符后运行以...

tengine全自动安装

tengine官方: http://tengine.taobao.org/ #!/bin/bash PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin #QQ：917611 export PATH if [ $(id -u) != "0" ]; then echo "Error: You must be root to run this script, please use rtengine官方: http://tengine.taobao.org/ #!/bin/bash PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin#QQ：917611 export PATH if [ $(id -u)...

自动安装MySQL脚本

在Linux 上安装MySQL单实例SHELL脚本在CentOS 6.5环境测试通过#!/bin/bashuser=mysql group=mysql port=3306 basedir=/usr/local/mysql datadir=/data/mysql/mysql_${port}/data sourcefile=$1 mysqlprofile=/etc/my.cnf logfile=/tmp/mysqlinstall.log nowtime=`date +%Y-%m-%d %H:%M:%S` retval=0Usage(){nowtime=`date +%Y-%m-%d %H:%M:%S`echo -e "\e[0;36m${nowtime}[INFO]:Usage: `basename $0` MySQL_Source_File\e[m" }if ...

MySQL5.5自动安装脚本【图】

MySQL 5.5 自动安装脚本,本脚本适合部署mysql5.5 ，省去了手动编译的繁琐过程，本人centos 5.8 x64 测试通过，朋友们可以用于测试简介：本脚本适合部署mysql5.5 ，省去了手动编译的繁琐过程，本人CentOS 5.8 x64 测试通过，朋友们可以用于测试环境安装，，线上需谨慎。默认设置（详细内容见 conf/config）：用户名：mysql 安装目录：/usr/local/mysql-5.5.20 数据库目录：/data/mysql/data 源码包：mysql-5.5.21.tar.gz脚本下载...

一个检查并自动安装Oralce所需rpm的shell脚本【图】

在Linux上安装Oralce时，先要检查一对rpm有没有安装，如果每次都一个一个地去检查，会很麻烦，于是做了一个脚本简化一下。在Linux上安装Oralce时，先要检查一对rpm有没有安装，如果每次都一个一个地去检查，会很麻烦，于是做了一个脚本简化一下。使用这个脚本只需3步： 1）将如下shell脚本另存为orarpm.sh，本文将该文件放在home目录下： 2）在Oracle的安装文档中找到需要检查的rpm列表，复制下来存成一个文件，这里我使用pkg.ls...

解决CentOs自动安装的PHP不支持MySQL【图】

在CentOs 5.3上装一个Discuz论坛,发现Discuz的提示信息里显示不支持MySQL：mysql_connect() 不支持请检查mysql 模块是否正确加载在CentOS 5.3上装一个Discuz论坛,发现Discuz的提示信息里显示不支持MySQL： mysql_connect() 不支持请检查mysql 模块是否正确加载. 查看/usr/lib/php/modules/里面根本没有mysql.so 找到CentOS 5.3安装盘，，找到CentOS目录下的 php-mysql-5.1.6-20.el5.i386.rpm php-pdo-5.1.6-20.el5.i386.rpm 上传...