mysqllinux多实例详解_linux之mysql多实例实现演练

1、 实战案例&＃xff1a;CentOS 7 实现MySQL的多实例

实验目的 CentOS 7.7 yum安装mariadb并实现三个实例

1.安装mariadb

yum install mariadb-server

Systemctl start mariadb

2.准备三个实例的目录

mkdir -pv /mysql/{3306,3307,3308}/{data,etc,socket,log,bin,pid}

chown -R mysql.mysql /mysql

3. 生成数据库文件

mysql_install_db --datadir&＃61;/mysql/3306/data --user&＃61;mysql

mysql_install_db --datadir&＃61;/mysql/3307/data --user&＃61;mysql

mysql_install_db --datadir&＃61;/mysql/3308/data --user&＃61;mysql

4. 准备配置文件

cp /etc/my.cnf /mysql/3306/etc/

vim /mysql/3306/etc/my.cnf

port&＃61;3306

datadir&＃61;/mysql/3306/data/

socket&＃61;/mysql/3306/socket/mysql.sock

[mysqld_safe]

log-error&＃61;/mysql/3306/log/mariadb.log

pid-file&＃61;/mysql/3306/pid/mariadb.pid

重复上面步骤设置3307&＃xff0c;3308

准备启动脚本

vim /mysql/3306/bin/mysqld

!/bin/bash

port&＃61;3306

mysql_user&＃61;"root"

mysql_pwd&＃61;"magedu"

cmd_path&＃61;"/usr/bin"

mysql_basedir&＃61;"/mysql"

mysql_sock&＃61;"${mysql_basedir}/${port}/socket/mysql.sock"

function_start_mysql()

{

if [ ! -e "$mysql_sock" ];then

printf "Starting MySQL...\n"

${cmd_path}/mysqld_safe --defaults-file&＃61;${mysql_basedir}/${port}/etc/my.cnf &> /dev/null &

else

printf "MySQL is running...\n"

exit

fi

}

function_stop_mysql()

{

if [ ! -e "$mysql_sock" ];then

printf "MySQL is stopped...\n"

exit

else

printf "Stoping MySQL...\n"

${cmd_path}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S ${mysql_sock} shutdown

#${cmd_path}/mysqladmin -u ${mysql_user} -S ${mysql_sock} shutdown

fi

}

function_restart_mysql()

{

printf "Restarting MySQL...\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: ${mysql_basedir}/${port}/bin/mysqld {start|stop|restart}\n"

esac

6.测试启动3306实例

7.停止服务

登录测试

mysqladmin -uroot -S /mysql/3306/socket/mysql.sock password &＃39;magedu&＃39; #加上新口令

mysql -uroot -pmagedu -S /mysql/3306/socket/mysql.sock

重复上述过程&＃xff0c;分别建立3307&＃xff0c;3308的启动脚本

到此演示完毕