社区 学习 工具库 休闲
搜索
简体中文
首页 > 数据库 > mysql教程 > MySQL集群自动安装脚本_MySQL

MySQL集群自动安装脚本_MySQL

WBOY
发布： 2016-06-01 13:57:34
原创
810 人浏览过

Mysql集群


　　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="{GetProperty(Content)}"

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

  

   #清理mysql服务器，为下次安装做好准备

   echo "Exec make clean">>>; install.log

   清理

  

   INSTALLED_SERVER_COUNT=$(($INSTALLED_SERVER_COUNT 1))

 完成

 

 echo "配置！MySQL 服务器已成功安装。"

 echo ""

 echo "1. 要启动 mysql 服务器，请使用以下命令："
 

相关标签：
安装 新建 源代码
来源：php.cn
上一篇：java语言存取mysql快速构建_MySQL 下一篇：服务器优化和硬件优化_MySQL
本站声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
作者最新文章
最新问题
返回值中变量的格式是什么？ 我是php的新学习者。我发现有一段代码：if($x<time()){return[false,'error'];}逻辑或变量并不重要，但我不明白[false,'error']...
来自于 2024-04-06 21:55:20
0
1
778
数独检查器无法工作？谁能帮我识别错误？ 我尝试了在线编辑器上的所有方法，但仍然收到错误。但当我在我的机器上的VSCode上执行此操作时，它工作正常。我很困惑，在没有发现错误的情况下无法提交代码。我不知道该去哪里寻找了。我...
来自于 2024-04-06 21:21:07
0
1
474
如何在 CSS 中使浮动元素垂直堆叠而不是水平堆叠？ 我正在尝试制作一个包含两列的网页，一侧具有主要内容，另一侧具有额外的内容。但是因为我使用浮动属性将额外的列向左对齐，所以它水平堆叠，但我希望它垂直堆叠。我当前的代码：.topich...
来自于 2024-04-06 20:45:26
0
2
386
有没有办法强制弹性框中的文本垂直居中，无论我们有什么其他 CSS 代码？ 我有以下CSS代码，它是我正在开发的网站中使用的更大CSS代码的一部分：.cards-u{display:flex;flex-wrap:wrap;justify-content:c...
来自于 2024-04-06 20:41:51
0
1
518
解决CSS中页面底部神秘空白的方法 我正在尝试使用Bootstrap和D3构建一个简单的网页，但我不知道如何消除底部的所有空白。我想摆脱它。我尝试将body和html的min-height设置为100%，但没有任何作...
来自于 2024-04-06 20:22:15
0
1
454
相关专题
更多>
热门推荐
热门教程
更多>
相关教程
热门推荐
最新课程
最新下载
更多>
网站特效
网站源码
网站素材
前端模板