#!/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
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
#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
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