分享
 
 
 

发布MySQL集群自动安装脚本1.0

王朝mysql·作者佚名  2008-05-19
窄屏简体版  字體: |||超大  

1. 在MySQL源代码目录下新建脚本 install.sh,把下面的代码添加到这个脚本中:

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

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

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有