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