centos7部署两个mysql_mysql 多实例部署 Centos7.6 部署3个Mariadb 实例

最新推荐文章于 2021-10-06 16:00:58 发布

野之风

最新推荐文章于 2021-10-06 16:00:58 发布

阅读量169

点赞数

CC 4.0 BY-SA版权

文章标签： centos7部署两个mysql

本文链接：https://blog.csdn.net/weixin_42525353/article/details/112018223

本文介绍了在 CentOS 7 系统中部署多个 MySQL 实例的相关操作。包含启动、停止、重启 MySQL 服务的脚本函数，还展示了启动多个不同端口 MySQL 实例的命令，以及连接测试和关闭数据库的操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

if [ ! -e “$mysql_sock” ];then printf “Starting MySQL…\n” ${cmd_path}/mysqld_safe –defaults-file=${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 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 # 启动服务 [root@localhost ~]# /mysql/3306/bin/mysqld start Starting MySQL… [root@localhost ~]# /mysql/3307/bin/mysqld start Starting MySQL… [root@localhost ~]# /mysql/3308/bin/mysqld start Starting MySQL… # 连接测试 mysql -S /mysql/3308/socket/mysql.sock -e ‘select version()’ +—————-+ | version() | +—————-+ | 5.5.60-MariaDB | +—————-+ # 关闭数据库 [root@localhost ~]# /mysql/3306/bin/mysqld stop Stoping MySQL… Enter password: