shell
#!/bin/bash
# Create by
# version 1.0
# //
# # check out lockfile whether or not exist
IsInputParam=""
InputParamFile=""
install_home=`pwd`
mysql_proxy_home=/usr/local/mysql-proxy
install()
{
# 确保脚本不被重复执行
lockfile=/tmp/$(basename $)_lockfile
if [ -f $lockfile ];then
pid=$(cat $lockfile)
ps -p $pid | grep $pid &> /dev/null
if [ $? == ]; then
echo -e "\033[32m the script is already running !!! \033[0m" && exit
else
echo $$ > $lockfile
fi
else
echo $$ > $lockfile
fi setupMode=`cat $InputParamFile |grep "setup-mode" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 安装lua+MySQL proxy，支持任意局主机安装
if [ "$setupMode" -eq "" ] ; then heartbeatSetup=`cat $InputParamFile |grep "heartbeatSetup" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
if [ "$heartbeatSetup" -eq "" ] ; then
installheartbeat;
fi #echo -e "\033[32m *** install lua \033[0m"
#lua_home=$install_home/lua-5.2.
#cd $install_home
# 安装lua，安装前先卸载再安装；
#tar -zxvf $install_home/lua-5.2..tar.gz
#cd $lua_home/src && cd /usr/local/bin && rm -f lua luac
#cd $lua_home/src && cd /usr/local/include && rm -f lua.h luaconf.h lualib.h lauxlib.h lua.hpp
#cd $lua_home/src && cd /usr/local/lib && rm -f liblua.a
#cd $lua_home/doc && cd /usr/local/man/man1 && rm -f lua. luac. #cd $lua_home
#make linux
#make install # 导出环境变量
#export LUA_CFLAGS="-I/usr/local/include" LUA_LIBS="-L/usr/local/lib -llua -ldl" LDFLAGS="-lm" echo -e "\033[32m *** install mysql Proxy \033[0m"
# 安装MySQL Proxy，解压即可使用
tar -zxf $install_home/mysql-proxy-0.8.-linux-el6-x86-64bit.tar.gz -C /usr/local
cd /usr/local # 一点点清理工作
killall - mysql-proxy
rm -rf /usr/local/mysql-proxy mv mysql-proxy-0.8.-linux-el6-x86-64bit mysql-proxy # 设置MySQL Proxy，根据安装参数进行配置
max_open_files=`cat $InputParamFile |grep "max-open-files" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
event_threads=`cat $InputParamFile |grep "event-threads" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
log_level=`cat $InputParamFile |grep "log-level" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
proxy_address=`cat $InputParamFile |grep "proxy-address" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
proxy_backend_addresses=`cat $InputParamFile |grep "proxy-backend-addresses" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
proxy_read_only_backend_addresses=`cat $InputParamFile |grep "proxy-read-only-backend-addresses" | tail -n | cut -d "=" -f2- | awk '{print $1}'` echo "[mysql-proxy]" >> $mysql_proxy_home/mysql-proxy.cnf
# daemon进程运行
echo "daemon=true" >> $mysql_proxy_home/mysql-proxy.cnf
echo "#user=mysql" >> $mysql_proxy_home/mysql-proxy.cnf
echo "proxy-skip-profiling=true" >> $mysql_proxy_home/mysql-proxy.cnf
# 保持连接（启动进程会有2个，一号进程用来监视二号进行，如果二号进程死掉自动重建，此参数在旧版本中无法使用）
echo "keepalive=true" >> $mysql_proxy_home/mysql-proxy.cnf
# 最大文件句柄数
echo "max-open-files=$max_open_files" >> $mysql_proxy_home/mysql-proxy.cnf
# 线程数
echo "event-threads=$event_threads" >> $mysql_proxy_home/mysql-proxy.cnf
# pid文件
echo "pid-file=/var/run/mysql-proxy.pid" >> $mysql_proxy_home/mysql-proxy.cnf
# 日志文件
echo "log-file=/var/log/mysql-proxy.log" >> $mysql_proxy_home/mysql-proxy.cnf
# 日志级别：error|warning|info|message|debug
echo "log-level=$log_level" >> $mysql_proxy_home/mysql-proxy.cnf
# admin-address=主机：端口 - 指定主机名（或IP地址）和端口管理端口。默认为localhost：。
#admin-address=172.20.100.36:
# 数据库用户名（主从上都需建立相同用户）
#admin-username=admin
# 数据库密码
#admin-password=coship
# admin脚本
#admin-lua-script=/usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua
# mysql-proxy的ip和port，默认port是4040
echo "proxy-address=$proxy_address" >> $mysql_proxy_home/mysql-proxy.cnf
# mysql主库（写）地址，多个以逗号分隔
echo "proxy-backend-addresses=$proxy_backend_addresses" >> $mysql_proxy_home/mysql-proxy.cnf
# mysql从库（读）地址，多个以逗号分隔
echo "proxy-read-only-backend-addresses=$proxy_read_only_backend_addresses" >> $mysql_proxy_home/mysql-proxy.cnf
# 读写分离脚本
echo "proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua" >> $mysql_proxy_home/mysql-proxy.cnf
# 设置文件权限
chmod $mysql_proxy_home/mysql-proxy.cnf echo "export PATH=$PATH:/usr/local/mysql-proxy/bin/" >> /etc/profile
source /etc/profile
sleep
# 启动mysqlProxy
mysql-proxy --defaults-file=$mysql_proxy_home/mysql-proxy.cnf # 设置MySQL Proxy服务操作脚本
echo "#!/bin/bash" >> $mysql_proxy_home/mysql-proxy.sh
echo ". /root/.bashrc" >> $mysql_proxy_home/mysql-proxy.sh
echo ". /etc/profile" >> $mysql_proxy_home/mysql-proxy.sh
echo 'mode=$1' >> $mysql_proxy_home/mysql-proxy.sh
echo 'if [ -z "$mode" ] ; then' >> $mysql_proxy_home/mysql-proxy.sh
echo 'mode="start"' >> $mysql_proxy_home/mysql-proxy.sh
echo "fi" >> $mysql_proxy_home/mysql-proxy.sh
echo 'case $mode in' >> $mysql_proxy_home/mysql-proxy.sh
echo "start)" >> $mysql_proxy_home/mysql-proxy.sh
echo "mysql-proxy --defaults-file=/usr/local/mysql-proxy/mysql-proxy.cnf>/usr/local/mysql-proxy/cn.log &" >> $mysql_proxy_home/mysql-proxy.sh
echo ";;" >> $mysql_proxy_home/mysql-proxy.sh
echo "stop)" >> $mysql_proxy_home/mysql-proxy.sh
echo "killall -9 mysql-proxy" >> $mysql_proxy_home/mysql-proxy.sh
echo ";;" >> $mysql_proxy_home/mysql-proxy.sh
echo "restart)" >> $mysql_proxy_home/mysql-proxy.sh
echo 'if $0 stop ; then' >> $mysql_proxy_home/mysql-proxy.sh
echo '$0 start' >> $mysql_proxy_home/mysql-proxy.sh
echo "else" >> $mysql_proxy_home/mysql-proxy.sh
echo 'echo "Restart failed!"' >> $mysql_proxy_home/mysql-proxy.sh
echo "exit 1" >> $mysql_proxy_home/mysql-proxy.sh
echo "fi" >> $mysql_proxy_home/mysql-proxy.sh
echo ";;" >> $mysql_proxy_home/mysql-proxy.sh
echo "esac" >> $mysql_proxy_home/mysql-proxy.sh
echo "exit 0" >> $mysql_proxy_home/mysql-proxy.sh chmod a+x $mysql_proxy_home/mysql-proxy.sh else
# 安装MySQL数据库
echo
echo -e "\033[32m *** step 1: check whether mysql is already installed? \033[0m"
echo # 一点点清理工作############################################
# 检查当前系统是否已安装MySQL，如果已经安装就卸载
for i in `rpm -qa|grep -i mysql`
do
rpm -q $i &> /dev/null
if [ $? == ]; then
# 删除mysql
rpm -e $i --nodeps &> /dev/null
echo $i "was uninstalled"
fi
done # 处理CentOS内部集成Mysql的情况
touch ys
echo "yes">ys
yum remove mysql-libs <ys >/dev/null # 删除配置文件
rm -f /etc/my.cnf
rm -rf /var/lib/mysql
############################################################ echo
echo -e "\033[32m *** step 2: install packages MySQL-server \033[0m"
echo # 开始安装MySQL服务
rpm -ivh MySQL-server-5.5.-.el6.x86_64.rpm if [ "$?" == ] ;
then
echo -e "\033[32m *** MySQL-server install success! \033[0m"
else
echo -e "\033[32m *** MySQL-server is not installed! \033[0m"
exit
fi echo
echo -e "\033[32m *** step 3: install packages MySQL-client \033[0m"
echo # 开始安装MySQL客户端
rpm -ivh MySQL-client-5.5.-.el6.x86_64.rpm if [ "$?" == ] ;
then
echo -e "\033[32m *** MySQL-client install success! \033[0m"
else
echo -e "\033[32m *** MySQL-client is not installed! \033[0m"
exit
fi echo
echo -e "\033[32m *** step 4: configure installation variables for mysql \033[0m"
echo echo -e "\033[32m *** service mysql start \033[0m"
service mysql start echo -e "\033[32m *** mysqladmin -u root password \033[0m" echo $InputParamFile # 获取数据库设置密码
password=`cat $InputParamFile |grep "password" | tail -n | cut -d "=" -f2- | awk '{print $1}'` mysqladmin -u root password $password mysql -uroot -p$password -e "grant all on *.* to 'root'@'%' identified by '$password' WITH GRANT OPTION;FLUSH PRIVILEGES;" echo -e "\033[32m *** cretae /etc/my.cnf \033[0m"
cp /usr/share/doc/MySQL-server-5.5./my-huge.cnf /etc/my.cnf character_set_server=`cat $InputParamFile |grep "character_set_server" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
tmp_table_size=`cat $InputParamFile |grep "tmp_table_size" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
max_heap_table_size=`cat $InputParamFile |grep "max_heap_table_size" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
lower_case_table_names=`cat $InputParamFile |grep "lower_case_table_names" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
key_buffer_size=`cat $InputParamFile |grep "key_buffer_size" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
binlog_ignore_db=`cat $InputParamFile |grep "binlog-ignore-db" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_buffer_pool_size=`cat $InputParamFile |grep "innodb_buffer_pool_size" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_additional_mem_pool_size=`cat $InputParamFile |grep "innodb_additional_mem_pool_size" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_log_file_size=`cat $InputParamFile |grep "innodb_log_file_size" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_log_buffer_size=`cat $InputParamFile |grep "innodb_log_buffer_size" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_flush_log_at_trx_commit=`cat $InputParamFile |grep "innodb_flush_log_at_trx_commit" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_lock_wait_timeout=`cat $InputParamFile |grep "innodb_lock_wait_timeout" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_flush_method=`cat $InputParamFile |grep "innodb_flush_method" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_log_files_in_group=`cat $InputParamFile |grep "innodb_log_files_in_group" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
max_connections=`cat $InputParamFile |grep "max_connections" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
max_connect_errors=`cat $InputParamFile |grep "max_connect_errors" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
innodb_max_dirty_pages_pct=`cat $InputParamFile |grep "innodb_max_dirty_pages_pct" | tail -n | cut -d "=" -f2- | awk '{print $1}'` # 默认都加上
sed -i '/\[client\]/a\default-character-set=utf8' /etc/my.cnf # 先统统干掉
sed -i -e "/character_set_server=/d" /etc/my.cnf
sed -i -e "/tmp_table_size=/d" /etc/my.cnf
sed -i -e "/max_heap_table_size=/d" /etc/my.cnf
sed -i -e "/lower_case_table_names=/d" /etc/my.cnf
sed -i -e "/key_buffer_size=/d" /etc/my.cnf
sed -i -e "/binlog-ignore-db=/d" /etc/my.cnf
sed -i -e "/innodb_buffer_pool_size=/d" /etc/my.cnf
sed -i -e "/innodb_additional_mem_pool_size=/d" /etc/my.cnf
sed -i -e "/innodb_log_file_size=/d" /etc/my.cnf
sed -i -e "/innodb_log_buffer_size=/d" /etc/my.cnf
sed -i -e "/innodb_flush_log_at_trx_commit=/d" /etc/my.cnf
sed -i -e "/innodb_lock_wait_timeout=/d" /etc/my.cnf
sed -i -e "/innodb_flush_method=/d" /etc/my.cnf
sed -i -e "/innodb_log_files_in_group=/d" /etc/my.cnf
sed -i -e "/max_connections=/d" /etc/my.cnf
sed -i -e "/max_connect_errors=/d" /etc/my.cnf
sed -i -e "/innodb_max_dirty_pages_pct=/d" /etc/my.cnf # 再加上所有配置
sed -i "/\[mysqld\]/a\character_set_server=$character_set_server" /etc/my.cnf
sed -i "/\[mysqld\]/a\tmp_table_size=$tmp_table_size" /etc/my.cnf
sed -i "/\[mysqld\]/a\max_heap_table_size=$max_heap_table_size" /etc/my.cnf
sed -i "/\[mysqld\]/a\lower_case_table_names=$lower_case_table_names" /etc/my.cnf
sed -i "/\[mysqld\]/a\key_buffer_size=$key_buffer_size" /etc/my.cnf
sed -i "/\[mysqld\]/a\binlog-ignore-db=$binlog_ignore_db" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_buffer_pool_size=$innodb_buffer_pool_size" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_additional_mem_pool_size=$innodb_additional_mem_pool_size" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_log_file_size=$innodb_log_file_size" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_log_buffer_size=$innodb_log_buffer_size" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_flush_log_at_trx_commit=$innodb_flush_log_at_trx_commit" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_lock_wait_timeout=$innodb_lock_wait_timeout" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_flush_method=$innodb_flush_method" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_log_files_in_group=$innodb_log_files_in_group" /etc/my.cnf
sed -i "/\[mysqld\]/a\max_connections=$max_connections" /etc/my.cnf
sed -i "/\[mysqld\]/a\max_connect_errors=$max_connect_errors" /etc/my.cnf
sed -i "/\[mysqld\]/a\innodb_max_dirty_pages_pct=$innodb_max_dirty_pages_pct" /etc/my.cnf sed -i "/\[myisamchk\]/a\key_buffer_size=$key_buffer_size" /etc/my.cnf # 设置数据库id号
serverid=`cat $InputParamFile |grep "server-id" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
sed -i -e '/server-id/d' /etc/my.cnf
sed -i "/\[mysqld\]/a\server-id=$serverid" /etc/my.cnf # 默认去掉该配置项
sed -i '/log-bin=mysql-bin/d' /etc/my.cnf echo -e "\033[32m *** service mysql restart \033[0m"
rm -rf /var/lib/mysql/ib_logfile*
service mysql restart if [ "$?" != ] ;
then rm -rf /var/lib/mysql/ib_logfile*
service mysql restart
fi echo -e "\033[32m *** chkconfig --list mysql \033[0m"
chkconfig --list mysql
if [ "$?" != ] ;
then
chkconfig --add mysql
fi # 添加自启项
chkconfig --level mysql on # 注册启、停、重启、查看状态命令
rm -rf /bin/start_mysql
rm -rf /bin/stop_mysql
rm -rf /bin/status_mysql
rm -rf /bin/restart_mysql echo "sh `pwd`/start_mysql.sh" >> /bin/start_mysql
chmod /bin/start_mysql echo "sh `pwd`/stop_mysql.sh" >> /bin/stop_mysql
chmod /bin/stop_mysql echo "sh `pwd`/status_mysql.sh" >> /bin/status_mysql
chmod /bin/status_mysql echo "sh `pwd`/restart_mysql.sh" >> /bin/restart_mysql
chmod /bin/restart_mysql # 设置互备数据库
# 根据模式进行MySQL数据库的安装工作
# setupMode= 表示只安装单纯的MySQL单机服务
# setupMode= 表示安装主MySQL服务
# setupMode= 表示安装从MySQL服务
# setupMode= 表示安装读写分离服务
# setupMode= 表示安装主主服务主1
# setupMode= 表示安装主主服务主2
# 主主服务中主1和主2区别在于主1需要先安装，不需要知道主2的信息，主2安装需要配置主1的信息
if [ "$setupMode" -eq "" ] ; then # 先把防火墙关了
/etc/init.d/iptables stop # 设置主用mysql
#sed -i "/\[mysqld\]/a\auto_increment_offset=1" /etc/my.cnf
#sed -i "/\[mysqld\]/a\auto_increment_increment=2" /etc/my.cnf
#sed -i "/\[mysqld\]/a\sync_binlog=1" /etc/my.cnf
#sed -i "/\[mysqld\]/a\log-salve-updates" /etc/my.cnf
# 获取从数据库账号
slaveToMasterUser=`cat $InputParamFile |grep "slaveToMaster-user" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取从数据库密码
slaveToMasterPassword=`cat $InputParamFile |grep "slaveToMaster-password" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
sed -i "/\[mysqld\]/a\log-bin=mysql-bin" /etc/my.cnf # 更改配置文件后需要重启MySQL服务
rm -rf /var/lib/mysql/ib_logfile*
service mysql restart
# 用于访问自身数据账号
echo `mysql -uroot -p$password -e "grant all privileges on *.* to '$slaveToMasterUser'@'%' identified by '$slaveToMasterPassword';FLUSH PRIVILEGES;"`
# 从安装
elif [ "$setupMode" -eq "" ] ; then
# 先把防火墙关了
/etc/init.d/iptables stop # 获取主用数据库IP地址
masterhost=`cat $InputParamFile |grep "master-host" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取主用数据库账号
masteruser=`cat $InputParamFile |grep "master-user" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取主用数据库密码
masterpassword=`cat $InputParamFile |grep "master-password" | tail -n | cut -d "=" -f2- | awk '{print $1}'` # 获取从数据库IP地址
slavehost=`cat $InputParamFile |grep "slaveToMaster-host" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取从数据库账号
slaveuser=`cat $InputParamFile |grep "slaveToMaster-user" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取从数据库密码
slavepassword=`cat $InputParamFile |grep "slaveToMaster-password" | tail -n | cut -d "=" -f2- | awk '{print $1}'` echo `mysql -uroot -p$password -e "grant all privileges on *.* to '$slaveuser'@'%' identified by '$slavepassword';FLUSH PRIVILEGES;"` # 登陆主MySQL得到Master Status信息
masterStatus=$(echo `mysql -h$masterhost -u$slaveuser -p$slavepassword -e "show master status\G"`) masterlogfile=$(echo $masterStatus | grep "Position" | tail -n | cut -d ":" -f2- | awk '{print $1}')
masterlogpos=$(echo $masterStatus | grep "Position" | tail -n | cut -d ":" -f2- | awk '{print $3}') # 添加主服务
echo `mysql -uroot -p$password -e "change master to master_host='$masterhost', master_user='$masteruser', master_password='$masterpassword',master_log_file='$masterlogfile', master_log_pos=$masterlogpos;start slave;"` #主主安装（主1）
elif [ "$setupMode" -eq "" ] ; then # 先把防火墙关了
/etc/init.d/iptables stop # 设置主用mysql
#sed -i "/\[mysqld\]/a\auto_increment_offset=1" /etc/my.cnf
#sed -i "/\[mysqld\]/a\auto_increment_increment=2" /etc/my.cnf
#sed -i "/\[mysqld\]/a\sync_binlog=1" /etc/my.cnf
#sed -i "/\[mysqld\]/a\log-salve-updates" /etc/my.cnf
# 获取从数据库账号
slaveToMasterUser=`cat $InputParamFile |grep "slaveToMaster-user" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取从数据库密码
slaveToMasterPassword=`cat $InputParamFile |grep "slaveToMaster-password" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
sed -i "/\[mysqld\]/a\log-bin=mysql-bin" /etc/my.cnf
sed -i "/\[mysqld\]/a\auto_increment_offset = 1" /etc/my.cnf
sed -i "/\[mysqld\]/a\auto_increment_increment = 2" /etc/my.cnf
sed -i "/\[mysqld\]/a\log-slave-updates" /etc/my.cnf # 更改配置文件后需要重启MySQL服务
rm -rf /var/lib/mysql/ib_logfile*
service mysql restart
# 用于访问自身数据账号
echo `mysql -uroot -p$password -e "grant all privileges on *.* to '$slaveToMasterUser'@'%' identified by '$slaveToMasterPassword';FLUSH PRIVILEGES;"`
#主主安装（主2...n）
elif [ "$setupMode" -eq "" ] ; then
# 先把防火墙关了
/etc/init.d/iptables stop sed -i "/\[mysqld\]/a\log-bin=mysql-bin" /etc/my.cnf
sed -i "/\[mysqld\]/a\auto_increment_offset = 2" /etc/my.cnf
sed -i "/\[mysqld\]/a\auto_increment_increment = 2" /etc/my.cnf
sed -i "/\[mysqld\]/a\log-slave-updates" /etc/my.cnf # 更改配置文件后需要重启MySQL服务
rm -rf /var/lib/mysql/ib_logfile*
service mysql restart # 获取主用数据库IP地址
masterhost=`cat $InputParamFile |grep "master-master-host" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取主用数据库账号
masteruser=`cat $InputParamFile |grep "master-master-user" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取主用数据库密码
masterpassword=`cat $InputParamFile |grep "master-master-password" | tail -n | cut -d "=" -f2- | awk '{print $1}'` # 获取从数据库IP地址
slavehost=`cat $InputParamFile |grep "slaveToMaster-host" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取从数据库账号
slaveuser=`cat $InputParamFile |grep "slaveToMaster-user" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取从数据库密码
slavepassword=`cat $InputParamFile |grep "slaveToMaster-password" | tail -n | cut -d "=" -f2- | awk '{print $1}'` echo `mysql -uroot -p$password -e "grant all privileges on *.* to '$slaveuser'@'%' identified by '$slavepassword';FLUSH PRIVILEGES;"` # 登陆主MySQL得到Master Status信息
masterStatus=$(echo `mysql -h$masterhost -u$slaveuser -p$slavepassword -e "show master status\G"`) masterlogfile=$(echo $masterStatus | grep "Position" | tail -n | cut -d ":" -f2- | awk '{print $1}')
masterlogpos=$(echo $masterStatus | grep "Position" | tail -n | cut -d ":" -f2- | awk '{print $3}') # 添加主服务
echo `mysql -uroot -p$password -e "change master to master_host='$masterhost', master_user='$masteruser', master_password='$masterpassword',master_log_file='$masterlogfile', master_log_pos=$masterlogpos;start slave;"` # 设置同步数据账号
#echo `mysql -h$masterhost -u$slaveuser -p$slavepassword -e "grant replication slave,replication client on *.* to '$slaveuser'@'$slavehost' identified by '$slavepassword';FLUSH PRIVILEGES;"` # 设置对端主主关联
# 登陆主MySQL得到Master Status信息
slaveStatus=$(echo `mysql -u$slaveuser -p$slavepassword -e "show master status\G"`) slavelogfile=$(echo $slaveStatus | grep "Position" | tail -n | cut -d ":" -f2- | awk '{print $1}')
slavelogpos=$(echo $slaveStatus | grep "Position" | tail -n | cut -d ":" -f2- | awk '{print $3}') echo `mysql -h$masterhost -u$slaveuser -p$slavepassword -e "change master to master_host='$slavehost', master_user='$slaveuser', master_password='$slavepassword',master_log_file='$slavelogfile', master_log_pos=$slavelogpos;start slave;"` ######################## else
echo "No setupMode";
fi
fi
} installheartbeat()
{ echo
echo -e "\033[32m *** step 1: check whether heartbeat is already installed? \033[0m"
echo # 检查当前系统是否已安装heartbeat，如果已经安装就卸载
for i in `rpm -qa|grep heartbeat`
do
rpm -q $i &> /dev/null
if [ $? == ]; then
# 删除heartbeat
rpm -e $i --nodeps &> /dev/null
echo $i "was uninstalled"
fi
done # 删除配置文件
rm -rf /usr/lib/heartbeat
rm -rf /etc/ha.d cd $install_home # 解压安装包
tar -xf packages.tar.gz; # 进入到安装包目录
cd packages # 创建用户
groupadd haclient
useradd hacluster -g haclient
useradd haclient -g haclient # 忽略应用进行安装
rpm -ivh *.rpm --force --nodeps # 安装成功，继续配置
if [ $? == ]; then rm -rf /usr/lib/heartbeat
mkdir -p /usr/lib/heartbeat/ \cp -f /usr/lib64/heartbeat/ipfail /usr/lib/heartbeat/ \cp -f /usr/share/doc/heartbeat-3.0./ha.cf /etc/ha.d/
\cp -f /usr/share/doc/heartbeat-3.0./haresources /etc/ha.d/
\cp -f /usr/share/doc/heartbeat-3.0./authkeys /etc/ha.d/ # 配置鉴权模式
sed -i "/\#auth 1/a\auth 3" /etc/ha.d/authkeys
sed -i "/\#3 md5 Hello\!/a\3 md5 Hello\!" /etc/ha.d/authkeys
sed -i -e '/#auth 1/d' /etc/ha.d/authkeys
sed -i -e '/#3 md5 Hello\!/d' /etc/ha.d/authkeys # 修改文件权限
chmod /etc/ha.d/authkeys # 清空文件内容
echo > /etc/ha.d/ha.cf # 获取主IP和用户名
masterIP=`cat $InputParamFile |grep "masterIP" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
masterName=`cat $InputParamFile |grep "masterName" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取备主IP和用户名
backupIP=`cat $InputParamFile |grep "backupIP" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
backupName=`cat $InputParamFile |grep "backupName" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取仲裁ip地址
pingIP=`cat $InputParamFile |grep "pingIP" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 网卡名称
ethName=`cat $InputParamFile |grep "ethName" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 浮动IP
flotIP=`cat $InputParamFile |grep "flotIP" | tail -n | cut -d "=" -f2- | awk '{print $1}'` # 配置用户，先删除再添加
sed -i -e "/$masterName/d" /etc/hosts
sed -i -e "/$backupName/d" /etc/hosts echo "$masterIP $masterName" >> /etc/hosts
echo "$backupIP $backupName" >> /etc/hosts echo "#debugfile /var/log/ha-debug.log" >> /etc/ha.d/ha.cf
echo "logfile /var/log/ha.log" >> /etc/ha.d/ha.cf
echo "#logfacility local0" >> /etc/ha.d/ha.cf
echo "keepalive 2" >> /etc/ha.d/ha.cf
echo "deadtime 10" >> /etc/ha.d/ha.cf
echo "warntime 5" >> /etc/ha.d/ha.cf
echo "initdead 60" >> /etc/ha.d/ha.cf
echo "udpport 694" >> /etc/ha.d/ha.cf
echo "bcast $ethName" >> /etc/ha.d/ha.cf
echo "#mcast eth1 225.0.0.1 694 1 0" >> /etc/ha.d/ha.cf
echo "#ucast eth1 10.0.0.2 " >> /etc/ha.d/ha.cf
echo "auto_failback off" >> /etc/ha.d/ha.cf
echo "#watchdog /dev/watchdog" >> /etc/ha.d/ha.cf
echo "node $masterName" >> /etc/ha.d/ha.cf
echo "node $backupName" >> /etc/ha.d/ha.cf
echo "ping $pingIP" >> /etc/ha.d/ha.cf
echo "#ping_group group1 10.10.99.254 10.10.99.253" >> /etc/ha.d/ha.cf
echo "respawn hacluster /usr/lib/heartbeat/ipfail" >> /etc/ha.d/ha.cf
echo "apiauth ipfail gid=haclient uid=hacluster" >> /etc/ha.d/ha.cf # 添加Mysql配置
echo "$masterName IPaddr::$flotIP/24/$ethName mysql_umount" >> /etc/ha.d/haresources rm -rf /etc/ha.d/resource.d/mysql_umount
rm -rf /etc/ha.d/resource.d/resetslave.properties
rm -rf /etc/ha.d/resource.d/resetslave.sh cp $install_home/resetslave.properties /etc/ha.d/resource.d/
cp $install_home/resetslave.sh /etc/ha.d/resource.d/ masterhost=`cat $InputParamFile |grep "master-host"`
if [ -n "$masterhost" ]; then
# 获取主用数据库IP地址 # 获取主用数据库账号
masteruser=`cat $InputParamFile |grep "master-user"`
# 获取主用数据库密码
masterpassword=`cat $InputParamFile |grep "master-password"` echo "" > /etc/ha.d/resource.d/resetslave.properties
echo "$masterhost" >> /etc/ha.d/resource.d/resetslave.properties
echo "$masteruser" >> /etc/ha.d/resource.d/resetslave.properties
echo "$masterpassword" >> /etc/ha.d/resource.d/resetslave.properties
# 循环遍历所有从服务
i=
while [ -eq ]
do
# 获取从数据库IP地址
slavehost=`cat $InputParamFile |grep "slave-host$i" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取从数据库账号
slaveuser=`cat $InputParamFile |grep "slave-user$i" | tail -n | cut -d "=" -f2- | awk '{print $1}'`
# 获取从数据库密码
slavepassword=`cat $InputParamFile |grep "slave-password$i" | tail -n | cut -d "=" -f2- | awk '{print $1}'` # 如果找不到编号了就结束
if [ -n "$slavehost" ];
then echo "$slavehost" >> /etc/ha.d/resource.d/resetslave.properties
echo "$slaveuser" >> /etc/ha.d/resource.d/resetslave.properties
echo "$slavepassword" >> /etc/ha.d/resource.d/resetslave.properties else
break
fi
i=$(($i+))
done
fi echo "#!/bin/sh" >> /etc/ha.d/resource.d/mysql_umount
echo ". /root/.bashrc" >> /etc/ha.d/resource.d/mysql_umount
echo ". /etc/profile" >> /etc/ha.d/resource.d/mysql_umount
echo "unset LC_ALL; export LC_ALL" >> /etc/ha.d/resource.d/mysql_umount
echo "unset LANGUAGE; export LANGUAGE" >> /etc/ha.d/resource.d/mysql_umount
echo "prefix=/usr" >> /etc/ha.d/resource.d/mysql_umount
echo "exec_prefix=/usr" >> /etc/ha.d/resource.d/mysql_umount
echo "sh /etc/ha.d/shellfuncs" >> /etc/ha.d/resource.d/mysql_umount
echo 'case $1 in' >> /etc/ha.d/resource.d/mysql_umount
echo "'start')" >> /etc/ha.d/resource.d/mysql_umount
echo "sh resetslave.sh start" >> /etc/ha.d/resource.d/mysql_umount
echo "mysql-proxy --defaults-file=/usr/local/mysql-proxy/mysql-proxy.cnf>/usr/local/mysql-proxy/cn.log &" >> /etc/ha.d/resource.d/mysql_umount
echo " ;;" >> /etc/ha.d/resource.d/mysql_umount
echo "'pre-start')" >> /etc/ha.d/resource.d/mysql_umount
echo " ;;" >> /etc/ha.d/resource.d/mysql_umount
echo "'post-start')" >> /etc/ha.d/resource.d/mysql_umount
echo " ;;" >> /etc/ha.d/resource.d/mysql_umount
echo "'stop')" >> /etc/ha.d/resource.d/mysql_umount
echo "killall -9 mysql-proxy" >> /etc/ha.d/resource.d/mysql_umount
echo " ;;" >> /etc/ha.d/resource.d/mysql_umount
echo "'pre-stop')" >> /etc/ha.d/resource.d/mysql_umount
echo " ;;" >> /etc/ha.d/resource.d/mysql_umount
echo "'post-stop')" >> /etc/ha.d/resource.d/mysql_umount
echo " ;;" >> /etc/ha.d/resource.d/mysql_umount
echo "*)" >> /etc/ha.d/resource.d/mysql_umount
echo " echo \"Usage: $0 { start | pre-start | post-start | stop | pre-stop | post-stop }\"" >> /etc/ha.d/resource.d/mysql_umount
echo " ;;" >> /etc/ha.d/resource.d/mysql_umount
echo "esac" >> /etc/ha.d/resource.d/mysql_umount
echo "exit 0" >> /etc/ha.d/resource.d/mysql_umount chmod /etc/ha.d/resource.d/mysql_umount
chmod /etc/ha.d/resource.d/resetslave.sh ln -s /etc/init.d/mysql /etc/ha.d/resource.d/mysql service heartbeat start chkconfig --add heartbeat
chkconfig --level heartbeat on
fi
} paramNum=$#
if [ "$paramNum" != "" ];then
echo "-n \"no start\""
echo "-f \"Install from file ,need filePath after this param\""
echo "ip \"ip addr\""
exit ;
fi; IsInputParam=$
if [ "${IsInputParam}d" != "d" -a "$IsInputParam" != "-f" ]; then
echo "Second parameter must be -f"
exit ;
fi;
InputParamFile=$
if [ ! -e $InputParamFile ]; then
echo "The param file doesn't existed."
exit ;
fi; install; echo "install end"
exit ;
配置文件
######################################################################
# 该配置文件为安装单机MySQL数据库
# Create by
# 请仔细阅读每项配置，避免安装出错！！
######################################################################
# 指定MySQL数据库的安装类型
# 表示只安装单纯的MySQL单机服务
# 表示安装主MySQL服务
# 表示安装从MySQL服务
# 表示安装读写分离服务
# 表示安装主主服务主1
# 表示安装主主服务主2
# 主主服务中主1和主2区别在于主1需要先安装，不需要知道主2的信息，主2安装需要配置主1的信息
setup-mode=
# 指定Mysql安装后的root数据库用户的登陆密码（这里安装的数据用户名默认为root）
password=root
# 指定MySQL的serverid，一般单机或者主MySQL默认server-id=1即可，如果是从MySQL需要改成其他值
server-id=
# =======MySQL的my.cnf配置，请根据服务器硬件配置决定=========
# 数据库默认编码
character_set_server=utf8 tmp_table_size=64M
max_heap_table_size=64M
# 让MySQL不区分大小写
lower_case_table_names=
# 建议：使用5..x以上版本
# 修改/etc/my.cnf(主备服务器都修改),在mysqld节点下增加如下配置:
# MYISAM--如果使用混合引擎我们需要对key_buffer_size=/ 内存
key_buffer_size=2G
###关闭global数据库的binlog日志，减少io需求###
binlog-ignore-db = global
# 优化innodb配置。增大innodb数据内存缓冲区，减少io请求；内存的60%
innodb_buffer_pool_size = 8G
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 512M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit =
innodb_lock_wait_timeout =
# 以下为需要新添加配置项##
innodb_flush_method = O_DIRECT
innodb_log_files_in_group =
# 在实际商用环境用不到1000个连接，连接太多了对系统性能&CPU消耗对会有影响！
max_connections=
max_connect_errors=
innodb_max_dirty_pages_pct=
# 在商用环境，建议使用AB模式！