WEB开发网
开发学院数据库MySQL MySQL集群自动安装脚本 阅读

MySQL集群自动安装脚本

 2007-11-11 16:18:36 来源:WEB开发网   
核心提示:·用Excel制作自动记录的考勤表·禁止CTFMON.EXE自动加载·解决IE自动关闭故障一例·自动限制电脑功能的小窍门·录入数据时让Excel自动插入当前时间·巧设置让电脑实现自动开关机·电脑自动重新启动现象全面剖析&m
    ·用Excel制作自动记录的考勤表
    ·禁止CTFMON.EXE自动加载
    ·解决IE自动关闭故障一例
    ·自动限制电脑功能的小窍门
    ·录入数据时让Excel自动插入当前时间
    ·巧设置让电脑实现自动开关机
    ·电脑自动重新启动现象全面剖析
    ·利用宏给Excel工作簿文档自动添加密码
    ·有福之人不用忙 常用软件自动学会更新
    ·Excel中用宏和VBa自动统计成绩

  1. 在MySQL(和PHP搭配之最佳组合)源代码目录下新建脚本 install.sh,把下面的代码添加到这个脚本中:
#!/bin/bash##################################################### MySQL(和PHP搭配之最佳组合) Server Config ###########################################################Determine to install MySQL(和PHP搭配之最佳组合) server#"0" means do not install server programsINST_SERVER=1#MySQL(和PHP搭配之最佳组合) installation pathINST_PATH="/usr/local/MySQL(和PHP搭配之最佳组合)"#Define the ports of MySQL(和PHP搭配之最佳组合) installation, intput strings of #PORT with whitespace separated.#e.g. "3306 3307" means install two MySQL(和PHP搭配之最佳组合) 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 informationMGM_HOST="192.168.1.253"MGM_PORT="2200"#################################################### MySQL(和PHP搭配之最佳组合) Cluster Config ########################################################Determine to install cluster#"0" means do not install cluster programsINST_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.252COMPUTERS="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.252MGMS="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=2DBS="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=2APIS="1 0 2 2"################################################################################ Starting to install programs, do not modify them! ###############################################################################echo "Starting to install programs" > install.log#Find installation pathif [ $# -gt 0 ] then   INST_PATH="$1"else   INST_PATH="/usr/local/MySQL(和PHP搭配之最佳组合)"fiif [ 0 -lt $INST_SERVER ]then echo "Now, installing the MySQL(和PHP搭配之最佳组合) servers..."  #Loop to install MySQL(和PHP搭配之最佳组合) servers INSTALLED_SERVER_COUNT=1 for PORT in $INST_PORTS do  #Define the current MySQL(和PHP搭配之最佳组合) server installation path   MYSL_PATH=$INST_PATH/$INSTALLED_SERVER_COUNT      #Configure MySQL(和PHP搭配之最佳组合) server   echo "Exec ./configure --prefix=$MYSL_PATH --with-pthread --with-unix-socket-path=$MYSL_PATH/var/MySQL(和PHP搭配之最佳组合).sock --with-MySQL(和PHP搭配之最佳组合)d-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(和PHP搭配之最佳组合).sock --with-MySQL(和PHP搭配之最佳组合)d-user=root --with-tcp-port=$PORT --with-charset=gbk --with-ndbcluster    #Make MySQL(和PHP搭配之最佳组合) server   echo "Exec make && make install" >> install.log   make && make install      #Create var directory for MySQL(和PHP搭配之最佳组合) 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(和PHP搭配之最佳组合).sock" >> $MYSL_PATH/var/my.cnf   echo "" >> $MYSL_PATH/var/my.cnf   echo "[MySQL(和PHP搭配之最佳组合)d]" >> $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(和PHP搭配之最佳组合).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(和PHP搭配之最佳组合) database   echo "Exec $MYSL_PATH/bin/MySQL(和PHP搭配之最佳组合)_install_db" >> install.log   $MYSL_PATH/bin/MySQL(和PHP搭配之最佳组合)_install_db      #Create MySQL(和PHP搭配之最佳组合) control script   if [ -e $MYSL_PATH/share/MySQL(和PHP搭配之最佳组合)/MySQL(和PHP搭配之最佳组合).server ]   then       #Use default MySQL(和PHP搭配之最佳组合) control script        #Create MySQL(和PHP搭配之最佳组合) server start script    echo "Create $MYSL_PATH/start" >> install.log    echo "$MYSL_PATH/share/MySQL(和PHP搭配之最佳组合)/MySQL(和PHP搭配之最佳组合).server start" > $MYSL_PATH/start    echo "Chmod 755 $MYSL_PATH/start" >> install.log    chmod 755 $MYSL_PATH/start        #Create MySQL(和PHP搭配之最佳组合) server stop script    echo "Create $MYSL_PATH/stop" >> install.log    echo "$MYSL_PATH/share/MySQL(和PHP搭配之最佳组合)/MySQL(和PHP搭配之最佳组合).server stop" > $MYSL_PATH/stop    echo "Chmod 755 $MYSL_PATH/stop" >> install.log    chmod 755 $MYSL_PATH/stop        #Create MySQL(和PHP搭配之最佳组合) server restart script    echo "Create $MYSL_PATH/restart" >> install.log    echo "$MYSL_PATH/share/MySQL(和PHP搭配之最佳组合)/MySQL(和PHP搭配之最佳组合).server restart" > $MYSL_PATH/restart    echo "Chmod 755 $MYSL_PATH/restart" >> install.log    chmod 755 $MYSL_PATH/restart   else        #Use custom MySQL(和PHP搭配之最佳组合) control script         #Create MySQL(和PHP搭配之最佳组合) server start script    echo "Create $MYSL_PATH/start" >> install.log    echo "$MYSL_PATH/libexec/MySQL(和PHP搭配之最佳组合)d &" > $MYSL_PATH/start    echo "Chmod 755 $MYSL_PATH/start" >> install.log    chmod 755 $MYSL_PATH/start        #Create MySQL(和PHP搭配之最佳组合) server stop script    echo "Create $MYSL_PATH/stop" >> install.log    echo "$MYSL_PATH/bin/MySQL(和PHP搭配之最佳组合)admin -u root -p shutdown" > $MYSL_PATH/stop    echo "Chmod 755 $MYSL_PATH/stop" >> install.log    chmod 755 $MYSL_PATH/stop        #Create MySQL(和PHP搭配之最佳组合) server restart script    echo "Create $MYSL_PATH/restart" >> install.log    echo "$MYSL_PATH/bin/MySQL(和PHP搭配之最佳组合)admin -u root -p shutdown" > $MYSL_PATH/restart    echo "$MYSL_PATH/libexec/MySQL(和PHP搭配之最佳组合)d &" >> $MYSL_PATH/restart    echo "Chmod 755 $MYSL_PATH/restart" >> install.log    chmod 755 $MYSL_PATH/restart   fi      #Clean MySQL(和PHP搭配之最佳组合) 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(和PHP搭配之最佳组合) servers has been installed successfully." echo "" echo "1. To start MySQL(和PHP搭配之最佳组合) server, use the following command:" echo "  cd (和PHP搭配之最佳组合)_INSTALLATION_PA 
			

1 2 3 4 5 6  下一页

Tags:MySQL 集群 自动

编辑录入:coldstar [复制链接] [打 印]
赞助商链接