Mysql 一主多实例与主从同步详解
#!/bin/bash#
IP="127.0.0.1"
PASSWORD="new_password"
echo_err(){
echo -e "\E[1;31m""$@ \033[0m"
}
echo_ok(){
echo -e "\E[1;32m""$@ \033[0m"
}
test -d /data/mysql/|| mkdir -p /data/mysql
cd /opt/
wget http://10.10.114.178:8008/mysql-5.5.24-1.el6.x86_64.rpm
yum -y install cmake gcc-c++ ncurses-devel bison perl readline-devel time zlib-devel libaio-devel perl-DBI perl-Time-HiRes libtool
rpm -ivh mysql-5.5.24-1.el6.x86_64.rpm --nodeps --force
source /etc/profile
/etc/init.d/mysqld stop
ln -s /usr/local/mysql/bin/mysqld_multi /usr/bin/mysqld_multi
ln -s /usr/local/mysql/scripts/mysql_install_db /usr/bin/mysql_install_db
cp /usr/local/mysql/support-files/mysqld_multi.server /etc/init.d/mysqld_multi.server
for i in {3307..3310}
do
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql${i}
while [[ `test -d /data/mysql${i} && echo $?` -ne 0 ]]
do
sleep 1
done
chown -R mysql:mysql /data/mysql${i}
touch /data/mysql${i}/{mysql${i}.sock,mysql${i}.pid}
done
echo_ok "数据库初始化完成，开始部署多实例"
cat >> /etc/mysqld_multi.cnf
页:
[1]