mysql多实例部署之开机自启

1. 找到控制服务的文件

[root@localhost ~]# find /usr/local/ -name  mysqld_multi*
/usr/local/mysql-5.7.34-linux-glibc2.12-x86_64/bin/mysqld_multi
/usr/local/mysql-5.7.34-linux-glibc2.12-x86_64/share/mysqld_multi.log
/usr/local/mysql-5.7.34-linux-glibc2.12-x86_64/man/man1/mysqld_multi.1
/usr/local/mysql-5.7.34-linux-glibc2.12-x86_64/support-files/mysqld_multi.server # 这个就是

2. cp到etc/init.d/

[root@localhost ~]# cp /usr/local/mysql-5.7.34-linux-glibc2.12-x86_64/support-files/mysqld_multi.server /etc/init.d/mysqld_multi

3. 加入环境变量

export PATH=/usr/local/mysql/bin:$PATH
#加到cp的mysqld_multi

4. 看看能否正常启动

[root@localhost ~]# service mysqld_multi start 
[root@localhost ~]# ss -antl
State      Recv-Q Send-Q              Local Address:Port                             Peer Address:Port              
LISTEN     0      128                             *:111                                         *:*                  
LISTEN     0      5                   192.168.122.1:53                                          *:*                  
LISTEN     0      128                             *:22                                          *:*                  
LISTEN     0      128                     127.0.0.1:631                                         *:*                  
LISTEN     0      100                     127.0.0.1:25                                          *:*                  
LISTEN     0      80                             :::3306                                       :::*                  
LISTEN     0      80                             :::3307                                       :::*                  
LISTEN     0      80                             :::3308                                       :::*                  
LISTEN     0      128                            :::111                                        :::*                  
LISTEN     0      128                            :::22                                         :::*                  
LISTEN     0      128                           ::1:631                                        :::*                  
LISTEN     0      100                           ::1:25                                         :::*                  
[root@localhost ~]# pkill mysqld
[root@localhost ~]# ss -antl
State      Recv-Q Send-Q              Local Address:Port                             Peer Address:Port              
LISTEN     0      128                             *:111                                         *:*                  
LISTEN     0      5                   192.168.122.1:53                                          *:*                  
LISTEN     0      128                             *:22                                          *:*                  
LISTEN     0      128                     127.0.0.1:631                                         *:*                  
LISTEN     0      100                     127.0.0.1:25                                          *:*                  
LISTEN     0      128                            :::111                                        :::*                  
LISTEN     0      128                            :::22                                         :::*                  
LISTEN     0      128                           ::1:631                                        :::*                  
LISTEN     0      100                           ::1:25                                         :::*                  

加入chkconfig

[root@localhost ~]# chkconfig --add mysqld_multi
[root@localhost ~]# chkconfig --list
注：该输出结果只显示 SysV 服务，并不包含
原生 systemd 服务。SysV 配置数据
可能被原生 systemd 配置覆盖。 

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

mysqld_multi    0:关    1:关    2:开    3:开    4:开    5:开    6:关
netconsole      0:关    1:关    2:关    3:关    4:关    5:关    6:关
network         0:关    1:关    2:开    3:开    4:开    5:开    6:关

重启尝试

[root@localhost ~]# reboot

连接断开
连接成功
Last login: Sun Aug 29 03:01:45 2021 from 192.168.216.1
[root@localhost ~]# ss -antl
State      Recv-Q Send-Q              Local Address:Port                             Peer Address:Port              
LISTEN     0      128                             *:111                                         *:*                  
LISTEN     0      5                   192.168.122.1:53                                          *:*                  
LISTEN     0      128                             *:22                                          *:*                  
LISTEN     0      128                     127.0.0.1:631                                         *:*                  
LISTEN     0      100                     127.0.0.1:25                                          *:*                  
LISTEN     0      80                             :::3306                                       :::*                  
LISTEN     0      80                             :::3307                                       :::*                  
LISTEN     0      80                             :::3308                                       :::*                  
LISTEN     0      128                            :::111                                        :::*                  
LISTEN     0      128                            :::22                                         :::*                  
LISTEN     0      128                           ::1:631                                        :::*                  
LISTEN     0      100                           ::1:25                                         :::*