mysql-5.5.55 多实例安装总结
mysql数据库多实例安装1.
mkdir -p /home/oldboy/tools
mkdir -p /application
yum -y install ncurses-devel libaio-devel
rpm -qa ncurses-devel libaio-devel
cd /home/oldboy/tools
wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.55.tar.gz
到http://download.chinaunix.net/download/0002000/1605.shtml下载cmake-2.8.6.tar.gz
然后scp -P52113 spring@192.168.1.155:/home/spring/Downloads/softwares/centos/cmake-2.8.6.tar.gz /home/oldboy/tools/
(也可以直接wget https://cmake.org/files/v3.11/cmake-3.11.4.tar.gz，但这个下载的速度非常慢)
tar -xf cmake-2.8.6.tar.gz
cd cmake-2.8.6
./configure
gmake
gmake install
which cmake /dev/null &
else
printf "MySQL is running...\n"
exit
fi
}
#stop function
function_stop_mysql()
{
if [ ! -e "$mysql_sock" ];then
printf "MySQL is stopped...\n"
exit
else
printf "stoping MySQL is stopping...\n"
${CmdPath}/mysqladmin -u${mysql_user} -p${mysql_pwd} -S /data/${port}/mysql.sock shutdown
fi
}
#restart function
function_restart_mysql()
{
printf "MySQL is restarting...\n"
function_stop_mysql
sleep 2
function_start_mysql
}
case $1 in
start)
function_start_mysql
;;
stop)
function_stop_mysql
;;
restart)
function_restart_mysql
;;
*)
printf "usage:/data/${port}/mysql {start|stop\restart}\n"
esac
#################################################################################################################
/bin/cp /data/3306/mysql /data/3307/mysql
sed -i 's#3306#3307#g' /data/3307/mysql
一些杂项
#######################################################################################################################
cd /application/mysql/scripts
./mysql_install_db --basedir=/application/mysql --datadir=/data/3306/data --user=mysql
./mysql_install_db --basedir=/application/mysql --datadir=/data/3307/data --user=mysql
#/application/mysql/scripts/mysql_install_db --basedir=/application/mysql/ --datadir=/data/3306/data --user=mysql
#/application/mysql/scripts/mysql_install_db --basedir=/application/mysql/ --datadir=/data/3307/data --user=mysql
########################################################################################################
chown -R mysql.mysql /data
find /data -name mysql |xargs chmod 700
#########################################################################################################
############
/application/mysql/bin/mysqladmin -u root -S /data/3306/mysql.sock password 'oldboy123'
/application/mysql/bin/mysqladmin -u root -S /data/3307/mysql.sock password 'oldboy123'
############
touch /data/3306/mysql_oldboy3306.err
touch /data/3307/mysql_oldboy3307.err
/application/mysql/bin/mysqld_safe --defaults-file=/data/3306/my.cnf 2>&1 > /dev/null &
/application/mysql/bin/mysqld_safe --defaults-file=/data/3307/my.cnf 2>&1 > /dev/null &
netstat -lntup|grep 330
############
/application/mysql/bin/mysqladmin -u root -poldboy123 -S /data/3306/mysql.sock shutdown
/application/mysql/bin/mysqladmin -u root -poldboy123 -S /data/3307/mysql.sock shutdown
netstat -lntup|grep 330
########################################################################################################################
页:
[1]