二进制安装mysql5.7多实例

信仰圣光么

已于 2024-11-05 10:11:35 修改

阅读量430

点赞数 4

文章标签： mysql 运维

于 2024-11-01 11:43:20 首次发布

本文链接：https://blog.youkuaiyun.com/a142151/article/details/143425147

版权

一、准备工作

1、下载二进制包：

wget https://mirrors.aliyun.com/mysql/MySQL-5.7/mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz

2、安装依赖：

yum -y install gcc gcc-c++ ncurses ncurses-devel bison cmake bzip2

3、创建mysql用户

useradd -s /sbin/nologin mysql

4、创建数据目录

mkdir -p /mysql_data/{3306..3308}/data

二、开始安装mysql

1、解压缩二进制包

tar -zxvf mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz -C /usr/local

2、修改mysql目录名

cd /usr/local
mv mysql-5.7.37-linux-glibc2.12-x86_64/ mysql-5.7.37

3、准备多实例配置文件

7、准备多实例配置文件
cat > /mysql_data/3306/my.cnf << 'EOF'
[client]
port = 3306
socket=/mysql_data/3306/mysql.sock

[mysqld]
user = mysql
port = 3306
socket=/mysql_data/3306/mysql.sock
basedir=/usr/local/mysql-5.7.37/
datadir=/mysql_data/3306/data
log-bin=/mysql_data/3306/mysql-bin
character-set-server=utf8mb4
bind-address = 0.0.0.0
skip-name-resolve
max_connections=2048
default-storage-engine=INNODB
max_allowed_packet=16M
server-id = 5

[mysqld_safe]
log-error=/mysql_data/3306/mysql_3306_error.log
pid-file=/mysql_data/3306/mysql_3306.pid
EOF

cat > /mysql_data/3307/my.cnf << 'EOF'
[client]
port = 3307
socket=/mysql_data/3307/mysql.sock

[mysqld]
user = mysql
port = 3307
socket=/mysql_data/3307/mysql.sock
basedir=/usr/local/mysql-5.7.37/
datadir=/mysql_data/3307/data
log-bin=/mysql_data/3307/mysql-bin
character-set-server=utf8mb4
bind-address = 0.0.0.0
skip-name-resolve
max_connections=2048
default-storage-engine=INNODB
max_allowed_packet=16M
server-id = 10

[mysqld_safe]
log-error=/mysql_data/3307/mysql_3307_error.log
pid-file=/mysql_data/3307/mysql_3307.pid
EOF

cat > /mysql_data/3308/my.cnf << 'EOF'
[client]
port = 3308
socket=/mysql_data/3308/mysql.sock

[mysqld]
user = mysql
port = 3308
socket=/mysql_data/3308/mysql.sock
basedir=/usr/local/mysql-5.7.37/
datadir=/mysql_data/3308/data
log-bin=/mysql_data/3308/mysql-bin
character-set-server=utf8mb4
bind-address = 0.0.0.0
skip-name-resolve
max_connections=2048
default-storage-engine=INNODB
max_allowed_packet=16M
server-id = 15

[mysqld_safe]
log-error=/mysql_data/3308/mysql_3308_error.log
pid-file=/mysql_data/3308/mysql_3308.pid
EOF

4、修改数据目录属组

chown -R mysql:mysql /mysql_data/

5、设置path

echo "export PATH=/usr/local/mysql-5.7.37/bin/:$PATH" >> /etc/profile
source /etc/profile

三、初始化mysql实例

1、3306

mysqld \
--initialize-insecure \
--user=mysql \
--basedir=/usr/local/mysql-5.7.37/ \
--datadir=/mysql_data/3306/data

2、3307

mysqld \
--initialize-insecure \
--user=mysql \
--basedir=/usr/local/mysql-5.7.37/ \
--datadir=/mysql_data/3307/data

3、3308

mysqld \
--initialize-insecure \
--user=mysql \
--basedir=/usr/local/mysql-5.7.37/ \
--datadir=/mysql_data/3308/data

四、启动mysql实例

1、3306

touch /mysql_data/3306/mysql_3306_error.log
chown -R mysql:mysql /mysql_data/3306
chmod -R 755 /mysql_data/3306

mysqld_safe --defaults-file=/mysql_data/3306/my.cnf --user=mysql &

2、3307

touch /mysql_data/3307/mysql_3307_error.log
chown -R mysql:mysql /mysql_data/3307
chmod -R 755 /mysql_data/3307

mysqld_safe --defaults-file=/mysql_data/3307/my.cnf --user=mysql &

3、3308

touch /mysql_data/3308/mysql_3308_error.log
chown -R mysql:mysql /mysql_data/3308
chmod -R 755 /mysql_data/3308

mysqld_safe --defaults-file=/mysql_data/3308/my.cnf --user=mysql &

五、登录mysql

1、修改密码

mysqladmin -uroot -p password 123456 -S /mysql_data/3306/mysql.sock

mysqladmin -uroot -p password 123456 -S /mysql_data/3307/mysql.sock

mysqladmin -uroot -p password 123456 -S /mysql_data/3308/mysql.sock

2、尝试登录mysql

mysql -uroot -p -S /mysql_data/3306/mysql.sock

mysql -uroot -p -S /mysql_data/3307/mysql.sock

mysql -uroot -p -S /mysql_data/3308/mysql.sock

六、设置开机自启

1、编辑启动脚本

cat > /mysql_data/3306/mysqld_3306 << 'EOF'
port="3306"
mysql_user="mysql"
Cmdpath="/usr/local/mysql-5.7.37/bin"
mysql_sock="/mysql_data/${port}/mysql.sock"
mysqld_pid_file_path="/mysql_data/${port}/mysql_${port}.pid"

start(){
  if [ -e "$mysql_sock" ]; then
    printf "Mysql socket file exists, checking if MySQL is running...\n"
    # 检查 MySQL 进程是否已经存在
    mysql_pid=$(cat "$mysqld_pid_file_path" 2>/dev/null)
    if [ -n "$mysql_pid" ] && kill -0 "$mysql_pid" 2>/dev/null; then
      printf "MySQL is already running (pid: $mysql_pid)\n"
      exit 1
    fi
  fi

  printf "Starting Mysql...\n"
  /bin/sh ${Cmdpath}/mysqld_safe --defaults-file=/mysql_data/${port}/my.cnf --user=mysql 2>&1 &
  sleep 5  # 等待 MySQL 启动
  # 确认 MySQL 是否已启动
  if [ -e "$mysql_sock" ]; then
    printf "MySQL started successfully.\n"
  else
    printf "Failed to start MySQL.\n"
    exit 1
  fi
}

stop(){
  if [ ! -e "$mysql_sock" ]; then
    printf "Mysql is already stopped...\n"
    exit 1
  fi

  printf "Stopping Mysql...\n"
  mysqld_pid=$(cat "$mysqld_pid_file_path" 2>/dev/null)
  if [ -n "$mysqld_pid" ] && kill -0 "$mysqld_pid" 2>/dev/null; then
    kill "$mysqld_pid"
    sleep 2
  fi
  if [ ! -e "$mysql_sock" ]; then
    printf "Mysql stopped successfully.\n"
  else
    printf "Failed to stop Mysql.\n"
  fi
}

restart(){
  printf "Restarting Mysql...\n"
  stop
  sleep 2
  start
}

case "$1" in
start)
  start
  ;;
stop)
  stop
  ;;
restart)
  restart
  ;;
*)
  printf "Usage: /mysql_data/${port}/mysql {start|stop|restart}\n"
  ;;
esac
EOF

cp /mysql_data/3306/mysqld_3306 /mysql_data/3307/
mv /mysql_data/3307/mysqld_3306 /mysql_data/3307/mysqld_3307
sed -i 's#3306#3307#g' /mysql_data/3307/mysqld_3307

cp /mysql_data/3306/mysqld_3306 /mysql_data/3308/
mv /mysql_data/3308/mysqld_3306 /mysql_data/3308/mysqld_3308
sed -i 's#3306#3308#g' /mysql_data/3308/mysqld_3308

# 添加可执行权限，修改属主
chmod +x /mysql_data/3306/mysqld_3306 
chmod +x /mysql_data/3307/mysqld_3307
chmod +x /mysql_data/3308/mysqld_3308
chown mysql:mysql /mysql_data/3306/mysqld_3306 
chown mysql:mysql /mysql_data/3307/mysqld_3307
chown mysql:mysql /mysql_data/3308/mysqld_3308

2、添加rc.local

echo "/mysql_data/3306/mysqld_3306 start" >> /etc/rc.local
echo "/mysql_data/3307/mysqld_3307 start" >> /etc/rc.local
echo "/mysql_data/3308/mysqld_3308 start" >> /etc/rc.local
chmod +x /etc/rc.d/rc.local

3、reboot测试

七、常用操作

1、创建远程登录用户

DROP USER 'root'@'localhost';  -- 删除现有的 localhost 用户

CREATE USER 'root'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;