首先,你需要将两个MySQL和MariaDB实例的配置文件分别修改为以下内容:
对于MySQL 5实例:
复制代码
[mysqld]
basedir=/usr/local/mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid-file=/var/run/mysqld/mysqld.pid
port=3306
user=mysql
log_error=/var/log/mysql/error.log
log_output=/var/log/mysql/output.log
对于MariaDB 10实例:
复制代码
[mariadb]
basedir=/usr
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid-file=/var/run/mariadb/mariadb.pid
port=3306
user=mysql
log_error=/var/log/mysql/error.log
log_output=/var/log/mysql/output.log
然后,将这两个配置文件分别拷贝到/etc/init.d/aaa和/etc/init.d/bbb。
接下来,你需要编辑这两个服务文件,添加启动命令。在/etc/init.d/aaa中添加以下内容:
复制代码
#!/bin/sh
### BEGIN INIT INFO
# Provides: aaa
# Required-Start: $remote_fs $syslog
# Required-Stop: $remote_fs $syslog
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Start daemon at boot time
# Description: Enable service provided by daemon.
### END INIT INFO
PATH=/sbin:/bin:/usr/sbin:/usr/bin
DAEMON=/usr/local/mysql/bin/mysqld_safe
NAME=mysql
DESC=mysqld
test -x "$DAEMON" || exit 0
case "$1" in
start)
echo -n "Starting $DESC: "
$DAEMON --defaults-file=/etc/my.cnf &> /dev/null
if [ $? -eq 0 ]; then
echo "OK"
else
echo "FAILED"
fi
;;
stop)
echo -n "Stopping $DESC: "
killall -q $NAME
if [ $? -eq 0 ]; then
echo "OK"
else
echo "FAILED"
fi
;;
*)
echo "Usage: $0 {start|stop}"
exit 1
esac
exit 0
在/etc/init.d/bbb中添加以下内容:
复制代码
#!/bin/sh
### BEGIN INIT INFO
# Provides: bbb
# Required-Start: $remote_fs $syslog
# Required-Stop: $remote_fs $syslog
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Start daemon at boot time
# Description: Enable service provided by daemon.
### END INIT INFO
PATH=/sbin:/bin:/usr/sbin:/usr/bin
DAEMON=/usr/bin/mysqld_safe
NAME=mariadb
DESC=mariadb
test -x "$DAEMON" || exit 0
case "$1" in
start)
echo -n "Starting $DESC: "
$DAEMON --defaults-file=/etc/mysql/my.cnf &> /dev/null
if [ $? -eq 0 ]; then
echo "OK"
else
echo "FAILED"
fi
;;
stop)
echo -n "Stopping $DESC: "
killall -q $NAME
if [ $? -eq 0 ]; then
echo "OK"
else
echo "FAILED"
fi
;;
*)
echo "Usage: $0 {start|stop}"
exit 1
esac
exit 0
最后,给这两个服务文件添加可执行权限:
bash复制代码
chmod +x /etc/init.d/aaa /etc/init.d/bbb
现在,你可以使用以下命令来启动和停止这两个服务:
bash复制代码
sudo /etc/init.d/aaa start
sudo /etc/init.d/aaa stop
sudo /etc/init.d/bbb start
sudo /etc/init.d/bbb stop
注意:端口不能冲突,否则只能启动一个。