MySQL不同版本多实例(5.6.X,5.7.X,8.0.X)

本文主要是介绍MySQL不同版本多实例(5.6.X,5.7.X,8.0.X)，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

1.1 准备工作
1.1.1 创建数据目录

mkdir -p /data/335{6..7}/data 
chown -R mysql.mysql /data/
ls -ld /data/335*

结果：

[root@localhost ~]# mkdir -p /data/335{6..7}/data 
[root@localhost ~]# chown -R mysql.mysql /data/
[root@localhost ~]# ls -ld /data/335*
drwxr-xr-x 3 mysql mysql 18 Nov 27 11:17 /data/3356
drwxr-xr-x 3 mysql mysql 18 Nov 27 11:17 /data/3357
[root@localhost ~]# 

1.1.2 配置文件
实例5.6:

cat > /etc/my3356.cnf <<EOF
[mysqld]
user=mysql
basedir=/usr/local/mysql56
datadir=/data/3356/data
server_id=56
port=3356
socket=/tmp/mysql56.sock
EOF

实例5.7:

cat > /etc/my3357.cnf <<EOF
[mysqld]
user=mysql
basedir=/usr/local/mysql56
datadir=/data/3357/data
server_id=57
port=3357
socket=/tmp/mysql57.sock
EOF

结果：

[root@localhost ~]# cat /etc/my3356.cnf  # 5.6
[mysqld]
user=mysql
basedir=/usr/local/mysql56
datadir=/data/3356/data
server_id=56
port=3356
socket=/tmp/mysql56.sock
[root@localhost ~]# 
[root@localhost ~]# cat /etc/my3357.cnf # 5.6
[mysqld] 
user=mysql
basedir=/usr/local/mysql57
datadir=/data/3357/data
server_id=57
port=3357
socket=/tmp/mysql57.sock
[root@localhost ~]# 

1.1.3 解压文件

tar xf mysql-5.6.50-linux-glibc2.12-x86_64.tar.gz
tar xf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
ln -s  /usr/local/mysql-5.7.32-linux-glibc2.12-x86_64 mysql57
ln -s  /usr/local/mysql-5.6.50-linux-glibc2.12-x86_64 mysql56

结果：

[root@localhost local]# tar xf mysql-5.6.50-linux-glibc2.12-x86_64.tar.gz
[root@localhost local]# tar xf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
[root@localhost local]# ln -s  /usr/local/mysql-5.7.32-linux-glibc2.12-x86_64 mysql57
[root@localhost local]# ln -s  /usr/local/mysql-5.6.50-linux-glibc2.12-x86_64 mysql56

1.2 初始化
5.6版本初始化：

/usr/local/mysql56/scripts/mysql_install_db  --user=mysql --basedir=/usr/local/mysql56 --datadir=/data/3356/data

5.7版本初始化：

/usr/local/mysql57/bin/mysqld --defaults-file=/etc/my3357.cnf --initialize-insecure

结果：

[root@localhost ~]# /usr/local/mysql56/scripts/mysql_install_db  --user=mysql --basedir=/usr/local/mysql56 --datadir=/data/3356/data  # 5.6版本初始化
Installing MySQL system tables...2021-11-27 14:10:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
……
32021-11-27 14:10:38 11415 [Note] InnoDB: Shutdown completed; log sequence number 1625977
OK

Filling help tables...2021-11-27 14:10:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
……
2021-11-27 14:10:40 11437 [Note] InnoDB: Shutdown completed; log sequence number 1625987
OK  # 出现两个OK，没有报错表示初始化成功
……  
[root@localhost ~]#  

5.7

[root@localhost ~]# /usr/local/mysql57/bin/mysqld --defaults-file=/etc/my3357.cnf --initialize-insecure   # 5.7版本初始化
2021-11-27T06:15:12.408238Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-11-27T06:15:12.558959Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-11-27T06:15:12.586227Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-11-27T06:15:12.653529Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 61600db3-4f49-11ec-8f13-000c2943a92f.
2021-11-27T06:15:12.658569Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-11-27T06:15:13.557983Z 0 [Warning] CA certificate ca.pem is self signed.
2021-11-27T06:15:13.850982Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
[root@localhost ~]# 

1.3 启动
命令：

/usr/local/mysql57/bin/mysqld_safe --defaults-file=/etc/my3357.cnf &
/usr/local/mysql56/bin/mysqld_safe --defaults-file=/etc/my3356.cnf &
检查：
[root@localhost ~]# netstat -lntup|grep 335
tcp6       0      0 :::3356                 :::*                    LISTEN      11836/mysqld        
tcp6       0      0 :::3357                 :::*                    LISTEN      11670/mysqld        
[root@localhost ~]# 

1.4 登录

mysql -S /tmp/mysql56.sock
mysql -S /tmp/mysql57.sock
mysql -S /tmp/mysql.sock

结果：

[root@localhost ~]# mysql -S /tmp/mysql56.sock  # 登录5.6
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.50 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye
[root@localhost ~]# 
[root@localhost ~]# mysql -S /tmp/mysql57.sock # 登录5.7
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.32 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye 
[root@localhost ~]# mysql -S /tmp/mysql.sock  # 登录8.0
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.24 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

1.5 停止

/usr/local/mysql56/bin/mysqladmin -S /tmp/mysql56.sock shutdown
/usr/local/mysql57/bin/mysqladmin -S /tmp/mysql56.sock shutdown
/usr/local/mysql/bin/mysqladmin -S /tmp/mysql.sock shutdown

1.6 小结
0、8.0可以参照8.0.X多实例
1、5.6的初始化命令和5.7+的命令有些区别，注意一下就好。
2、应用建议部署在/usr/local/下。
3、多实例时，连接服务器的客户端程序版本可以比服务器版本高，当前客户端的版本为8.0.24，如：

[root@localhost ~]# mysql --version
mysql  Ver 8.0.24 for Linux on x86_64 (MySQL Community Server - GPL)
[root@localhost ~]#

这篇关于MySQL不同版本多实例(5.6.X,5.7.X,8.0.X)的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！