忘记密码   免费注册 查看新帖 | 论坛精华区

ChinaUnix.net

  平台 论坛 博客 认证专区 大话IT HPC论坛 徽章 文库 沙龙 自测 下载 频道自动化运维 虚拟化 储存备份 C/C++ PHP MySQL 嵌入式 Linux系统
12下一页
最近访问板块 发新帖
查看: 13293 | 回复: 10

发布MySQL集群自动安装脚本1.0 [复制链接]

论坛徽章:
0
发表于 2005-08-23 14:27 |显示全部楼层
发表时间:2005-1-15 22:33:00 作者:本站

来源:http://www.hackhome.com/2005/1-15/22330015062.shtml


经过几天的测试,终于可以发布了!

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


#!/bin/bash
#####################################################
## Title: MySQL 4.1 Cluster Installation Script    ##
## Version: 1.0                                    ##
## Date: 2004-11-11                                ##
## Author: yipsilon                                ##
## Email: yipsilon@163.com                         ##
## License: General Public License (GPL)           ##
## Copyright(c) 2004, yipsilon All Rights Reserved ##
#####################################################
##                 ChangeLog                       ##
#####################################################
##            Installation Guide                   ##
##  1. Copy the script file into mysql source path ##
##  2. Change script file's permission to 755      ##
##  3. execute it and wait for...                  ##
#####################################################
############################################
######### 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_HOSTMGM_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 <MYSQL_INSTALLATION_PATH>;"
echo "  ./start"
echo ""
echo "2. To stop mysql server, use the following command:"
echo "  cd <MYSQL_INSTALLATION_PATH>;"
echo "  ./stop"
echo ""
echo "3. To restart mysql server, use the following command:"
echo "  cd <MYSQL_INSTALLATION_PATH>;"
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_HOSTMGM_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安装目录>;

具体使用说明,英语好的看脚本注释吧;英语不好的,那就再等等,过几天会release出来。

论坛徽章:
0
发表于 2005-08-23 15:57 |显示全部楼层

发布MySQL集群自动安装脚本1.0

是Mysql数据库服务器集群?
应该大概的解释一下做什么用的啊?谢谢了。

论坛徽章:
1
丑牛
日期:2015-01-07 15:25:00
发表于 2005-08-24 21:24 |显示全部楼层

发布MySQL集群自动安装脚本1.0

搂住研究过oracle9i的集群安装吗?

论坛徽章:
0
发表于 2005-08-24 23:44 |显示全部楼层

发布MySQL集群自动安装脚本1.0

研究过

你想做吗

希望多多交流

论坛徽章:
0
发表于 2005-08-26 20:20 |显示全部楼层

发布MySQL集群自动安装脚本1.0

RAC的安装文档网上一大堆。

论坛徽章:
0
发表于 2005-08-27 19:46 |显示全部楼层

发布MySQL集群自动安装脚本1.0

[root@test cluster]# ./ndbd
Unable to connect with connect string: nodeid=0,192.168.0.55:2200
Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1, failed.
Error handler restarting system
Error handler shutdown completed - exiting

论坛徽章:
0
发表于 2005-09-01 12:46 |显示全部楼层

发布MySQL集群自动安装脚本1.0

Unable to connect with connect string: nodeid=0,192.168.0.55:2200
按你的实际情况,更改对应的
The management server IP AND PORT

论坛徽章:
0
发表于 2005-09-04 00:19 |显示全部楼层

发布MySQL集群自动安装脚本1.0

楼上的说的没错

论坛徽章:
0
发表于 2005-09-12 10:33 |显示全部楼层

发布MySQL集群自动安装脚本1.0

有没有在一台机器上两个mysql实例的脚本,应该修改一下就能用了

论坛徽章:
0
发表于 2011-05-23 17:34 |显示全部楼层
echo "  ExecuteOnComputer=$DB" >;>; $CLST_PATH/config.ini


>;>;  
这种脚本也写得出 真烂
您需要登录后才可以回帖 登录 | 注册

本版积分规则

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号 北京市公安局海淀分局网监中心备案编号:11010802020122
广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员  联系我们:
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP