MySQL集群自动安装脚本

来源：作者：出处：巧巧读书 2006-10-04 进入讨论组
　　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 d.com/mysql/z227041.html  更多内容请看Windows操作系统安装、MySQL数据备份、系统安装手册专题，或进入讨论组讨论。
        【深 度 阅 读】 相 关 文 章
        Excel中用宏和VBa自动统计成绩
Photoshop7的安装程序自动输入序列号
让系统自动备份C盘
裸奔之旅之：关闭XP自动更新后该做什么
      
    
    
    【收藏此文】【大 中 小】【打印】【关闭】
    较早的文章：MySQL集群配置


      较新的文章：MYSQL列类型参考

    
      
    
    
      相关图文阅读
      
        
      
      频道图文推荐
      
        健 康 咨 询
        
          
        
      
      
        时 尚 咨 询
        
          
        
      
    
    
  
  
  
    
      相关专题
    
    
      
        Windows操作系统安装 (15328篇文章)
MySQL数据备份 (1897篇文章)
系统安装手册 (20515篇文章)
脚本攻击和防范 (2330篇文章)
Linux集群技术 (8137篇文章)
WEB应用集群技术专题 (436篇文章)
MySQL (1774篇文章)
Windows 群集服务应用专题 (436篇文章)
MySQL安全 (9696篇文章)
城域网专题 (7762篇文章)
      
    
    
      阅读排行榜
      最新技术文档
      更多排行>>
    
    
      
        触发器概述  (522次浏览)
mysql数据库下损坏数据的恢复操作其过程总结  (348次浏览)
MySQL企业数据库前景分析  (171次浏览)
导入导出大量数据程序实现方法  (143次浏览)
my.cnf  (143次浏览)
详细讲解MySQL 4.1数据如何转换  (138次浏览)
linux mysql jdbc 权限问题  (138次浏览)
MySQL 5.0 新特性教程 存储  (115次浏览)
使用MYSQL索引(1)  (110次浏览)
启动多个mysqld-HOWTO  (102次浏览)
      
    
    
      
        MySQL数据库和oracle的区别和选择 01-07
MySQL数据库配置技巧 12-23
触发器概述 12-16
详细讲解MySQL 4.1数据如何转换 12-15
my.cnf 12-15
linux mysql jdbc 权限问题 12-15
启动多个mysqld-HOWTO 12-14
MySQL 5.0 新特性教程 存储过程:第 12-14
使用MYSQL索引(1) 12-14
mysql数据库下损坏数据的恢复操作其过程总结 12-13
      
    
    
      最新论坛文章
    
    
      
    
    
      站内各频道最新更新文档
    
    
      
        
          
            形形色色的台湾特产
          
          
            怀念“黛玉”妹妹
          
        
      
      
    
    
      站内最新制作专题
    
    
      
        
          
            阳春三月 境内境外赏花忙
          
          
            运动促前第二次发育
          
        
      
      
        
          ACDSEE专题教程-下载使用
          迅雷专题教程-下载使用
          Windows XP频道
          Windows Vista频道
          Windows 2000频道
          win2003频道
          Freebsd频道
          Oracle频道
        
        
          Linux频道
          Windows频道
          邮件服务器专题
          协议大全
          数据恢复指南教程
          FreeBSD使用教程
          Linux数据库宝典
          Linux基础知识
        
      
    
    
      热门关键字导读
    
    
      
      Photoshop教 程：照片处理 照片制作 PS快捷键 抠图

      计 算 机 故 障：XP系统修复

      艺 术 与 设 计：设计 流媒体 设计欣赏 边框

      计 算 机 安 全：ARP

    
    
      站内频道文章精选
    
    
      
        新闻资讯
        
          秘密:Vista隐蔽的动态屏保
          腾讯开发新电子宠物--QQ熊
          惠普否认2999元PC有价无货
        
        操作系统
        
          在DOS下恢复回收站中的文件
          拯救WinXP崩溃的救命稻草
          Linux系统中超级权限的应用
        
        桌面开发
        
          AVIFile函数制做AVI文件
          VC中链接动态链接库的方法
          熊猫烧香核心源码(Delphi)
        
        数据库
        
          SQL Server数据库优化方案
          Oracle的初学者入门心得
          JSP连接Mysql数据库
        
      
      
        电脑技巧
        
          驱逐Win系统“流氓”文件
          WinXP中获取未使用的IP地址
          尝试format C:格式化硬盘？
        
        常用软件
        
          搜狗PK谷歌：谁能代言拼...
          昨日重现，一键GHOST轻松..
          实现Web迅雷在空闲时杀毒
        
        网络程序开发
        
          DateDiff函数祥解
          JavaScript去除空格的三种 
          js效果   图片加载进度实时..
        
        图像处理
        
          Photoshop为美女做艺术处理
          用Freehand创建发光字特效
          设计自己的个性QQ动态表情
        
      
    
  
  






































  巧巧电脑频道编辑信箱  告诉我们您想看的专题或文章