Linux 中添加多个Mysql服务

Mysql 多服务注意点有如下:

1. my.cnf 不能相同
2. data 目录不能相同
3. scoket 文件不能相同

注意点注意以上几点.....

找到 ./support-files/mysql.server 文件

更改配置：

lockdir='/var/lock/subsys/' -> lockdir='/var/lock/subsys/2' 
lock_file_path="$lockdir/mysql"

 # conf=/etc/my.cnf
 conf=/usr/local/mysql2/my.cnf

# $bindir/mysqld_safe  --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &

# $bindir/mysqld_safe --defaults-file=/usr/local/mysql2/my.cnf --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &

# 注释这行
# parse_server_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server`

 

cp /usr/local/mysql2/support-files/mysql.server /etc/init.d/mysql2

systemctl start mysql2