Publish MySQL cluster auto install Script 1.0!

mysql| Script | Automatic installation After a few days of testing, finally can be released!

1. Under the MySQL source code directory to create a new script install.sh, add the following code to this script:

#!/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) the Copyright (c), 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 Programsinst_server=1#mysql installation Pathinst_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 $INST installed and _PATH/1 listen He second server is 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 Cluster Config ######################################################## Determine to install cluster# "0" means does not install cluster the programsinst_cluster=1#define in COMPUTERs, Config.ini T strings of HostName with whitespace separated. #The Id are auto increment and start with 1. #e. G. "192.168.1.253 192.168.252 "would generate the following code# [computer]# id=1# hostname=192.168.1.253# [computer]# id=2#] hostname=192.1 68.1.252computers= "192.168.1.253 192.168.1.252" #Define mgms in Config.ini, intput strings to HostName with whitespace Sep Arated. #e. G. "192.168.1.253 192.168.252" to 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" to 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 "would generate the following code# [api]# executeoncomputer=1# [api]# [api]# executeoncomputer=1#] [api]# Executeonco Mputer=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= "$" Else inst_path= "/usr/local/mysql" Fiif [0-lt $I Nst_server]then echo "Now, installing the MySQL servers ..." #Loop to install MySQL servers installed_server_count=1 for P ORT in $INST _portS do #Define the current MySQL server installation path mysl_path= $INST _path/$INSTALLED _server_count #Configure mysql Serv Er 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" >& Gt Install.log make && make install #Create the 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= ">> $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 Spe Cific 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 _p ath/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 SE RVer start Script echo "Create $MYSL _path/start" >> install.log echo "$MYSL _path/share/mysql/mysql.server start" &G T $MYSL _path/start echo "Chmod 755 $MYSL _path/start" >> install.log Chmod 755 $MYSL _path/start #Create MySQL Server St Op script echo "Create $MYSL _path/stop" >> install.log echo "$MYSL _path/share/mysql/mysql.server Stop" > $MYSL _p Ath/stop echo "Chmod 755 $MYSL _path/stop" >> install.log Chmod 755 $MYSL _path/stop #Create MySQL server restart SCRI PT 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 star T 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 ech O "Chmod 755 $MYSL _path/stop" >> install.log Chmod 755 $MYSL _path/stop #Create MySQL server restart script echo Cre Ate $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 stalled_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 <MYSQL_INSTALLATION_PATH> "echo"./start "echo" "echo" "2. To stop MySQL server, use the following command:" echo "CD <MYSQL_INSTALLATION_PATH>" echo "./stop" echo "" E Cho "3. To restart MySQL server, use the following command: "echo" CD <MYSQL_INSTALLATION_PATH> "echo"./restart "Fi#instal L cluster programsif [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 #Create cluster directory echo" Exec mkdir-p $CLST _ PATH ">> install.log mkdir-p $CLST _path #Copy cluster binaries echo" Exec cp $INST _path/1/bin/ndb* $CLST _path/">> install.log cp $INST _path/1/bin/ndb* $CLST _path/echo" Exec cp $INST _path/1/libexec/ndb* $CLST _path/"&GT;&G T Install.log CP $INST _path/1/libexec/ndb* $CLST _path/#Create config.ini echo "Create $CLST _path/config.ini" >> Install.log #Write Default global configuration echo "[TCP default]" >> $CLST _path/config.ini echo "" >> $CLST _path/config.ini echo "[MGM DEFAULT]" >> $CLST _path/config.ini echo ">> $CLST _path/config.ini echo" [DB DEFA ULT] ">> $CLST _path/config.ini echo" Noofreplicas=1 ">> $CLST _path/config.ini echo" ">> $CLST _path/co Nfig.ini echo "[API DEFAULT]" >> $CLST _path/config.ini echo "" >> $CLST _path/config.ini #Write Computers confi Guration 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) #Write Management Server configuration for MGM in $MGMS do echo "[MGM]" >> $CLST _path/config.in I echo "hostname= $MGM" >> $CLST _path/config.ini echo "" >> $CLST _path/config.ini done #Write storage Nodes Co Nfiguration 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 the for APIs in $APIS do Echo [API] ">> $CLST _path/config.ini if [0-ne $API] then echo" executeoncomputer= $API ">> $CLST _path/config.ini fi E Cho "" >> $CLST _path/config.ini done #Create ndb.cfg echo "Create $CLST _path/ndb.cfg" >> install.log echo hos t= $MGM _host: $MGM _port ">> $CLST _path/ndb.cfg echo" ">> $CLST _path/ndb.cfg 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 ' ' cluster programs in this machine! ' Fifi

2. Set script permissions to allow it to execute: chmod 755 install.sh
3. Execute the script:./install.sh or./install <mysql installation directory >

The specific use of instructions, English good to see the script annotation bar, English is not good, then wait a few days will release out.