CentOS开机启动时执行Shell脚本文件启动MySql多实例服务

最新推荐文章于 2024-06-27 01:29:00 发布

lufy0908

最新推荐文章于 2024-06-27 01:29:00 发布

阅读量416

点赞数

分类专栏： Linux MySql

本文链接：https://blog.csdn.net/u012548939/article/details/106973557

版权

MySql 同时被 2 个专栏收录

9 篇文章 0 订阅

订阅专栏

Linux

4 篇文章 0 订阅

订阅专栏

编辑my.cnf，将用户名和密码录入到文件中

[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin =/usr/local/mysql/bin/mysqladmin
log =/usr/local/mysql/mysqld_multi.log
user=root
pass=root1234%

[mysqld1]
socket = /tmp/mysql1.sock
port = 3307
pid-file = /usr/local/data1/mysql.pid
datadir = /usr/local/data1
server-id = 1

[mysqld2]
socket = /tmp/mysql2.sock
port = 3308
pid-file = /usr/local/data2/mysql.pid
datadir = /usr/local/data2
server-id = 2

[mysqld3]
socket = /tmp/mysql3.sock
port = 3309
pid-file = /usr/local/data3/mysql.pid
datadir = /usr/local/data3
server-id = 3

先检查实例是否在运行，如果运行先把实例停了

[root@localhost ~]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is not running
MySQL server from group: mysqld3 is not running

编写脚本写一个shell脚本

#!/bin/bash
#chkconfig: - 85 15
#description:auto run
##启动sql多实例'
export PATH=/usr/local/mysql/bin:$PATH
mysqld_multi start

执行测试一下看看有没有问题

[root@localhost local]# ./mulIns.sh

注册服务

[root@localhost local]# cp mulIns.sh /etc/init.d/mulIns
[root@localhost local]# chkconfig mulIns on

测试执行看看有没有报错

[root@localhost init.d]# service mulIns stop

如果重报错尝试这个命令后再试

root@localhost init.d]# systemctl daemon-reexec

查看启动项

[root@localhost local]# chkconfig --list

注：该输出结果只显示 SysV 服务，并不包含
原生 systemd 服务。SysV 配置数据
可能被原生 systemd 配置覆盖。 

      要列出 systemd 服务，请执行 'systemctl list-unit-files'。
      查看在具体 target 启用的服务请执行
      'systemctl list-dependencies [target]'。

mulIns.sh      	0:关	1:关	2:开	3:开	4:开	5:开	6:关
mysql.server   	0:关	1:关	2:开	3:开	4:开	5:开	6:关
mysqld_multid  	0:关	1:关	2:开	3:开	4:开	5:开	6:关
netconsole     	0:关	1:关	2:关	3:关	4:关	5:关	6:关
network        	0:关	1:关	2:开	3:开	4:开	5:开	6:关

执行reboot命令，重启机器后检查是否设置成功。

[root@localhost ~]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is running