mysql多实例部署

最新推荐文章于 2023-05-21 10:17:45 发布

阿立血鹦鹉

最新推荐文章于 2023-05-21 10:17:45 发布

阅读量146

点赞数

文章标签： mysql linux centos

本文链接：https://blog.csdn.net/m0_53765226/article/details/126090510

版权

本文详细介绍了如何在Linux CentOS系统上部署多个MySQL实例。首先，你需要下载MySQL软件，接着创建各自实例的数据存放目录并进行初始化。然后，安装Perl以支持MySQL的某些功能。接下来，配置每个实例的配置文件`/etc/my.cnf`，确保每个实例的配置互不冲突。最后，启动所有实例，并完成数据库密码的修改工作。

摘要由CSDN通过智能技术生成

软件下载

//下载二进制格式的mysql软件包
[root@localhost ~]# wget  https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
[root@localhost ~]# mv mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz /usr/src/
[root@localhost ~]# cd /usr/src/
[root@localhost src]# ls
debug  kernels  mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz

//创建用户
[root@localhost src]# useradd -M -r -s  /sbin/nologin mysql 
[root@localhost src]# id mysql 
uid=987(mysql) gid=983(mysql) groups=983(mysql)


//解压软件至/usr/local/
[root@localhost src]# tar xf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz  -C  /usr/local/
[root@localhost ~]# cd /usr/local/
[root@localhost local]# ls
bin  games    lib    libexec                              sbin   src
etc  include  lib64  mysql-5.7.38-linux-glibc2.12-x86_64  share
[root@localhost local]# 

//做个软链接替身
[root@localhost local]# ln -sv mysql-5.7.38-linux-glibc2.12-x86_64  mysql 
'mysql' -> 'mysql-5.7.38-linux-glibc2.12-x86_64'
[root@localhost local]# 
[root@localhost local]# ll
total 0
drwxr-xr-x. 2 root root   6 May 19  2020 bin
drwxr-xr-x. 2 root root   6 May 19  2020 etc
drwxr-xr-x. 2 root root   6 May 19  2020 games
drwxr-xr-x. 2 root root   6 May 19  2020 include
drwxr-xr-x. 2 root root   6 May 19  2020 lib
drwxr-xr-x. 3 root root  17 Jul 14 22:23 lib64
drwxr-xr-x. 2 root root   6 May 19  2020 libexec
lrwxrwxrwx. 1 root root  35 Jul 27 19:45 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 9 root root 129 Jul 27 19:42 mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 2 root root   6 May 19  2020 sbin
drwxr-xr-x. 5 root root  49 Jul 14 22:23 share
drwxr-xr-x. 2 root root   6 May 19  2020 src

//修改目录/usr/local/mysql的属主属组
[root@localhost local]# chown -R mysql.mysql mysql*
[root@localhost local]# ll
total 0
drwxr-xr-x. 2 root  root    6 May 19  2020 bin
drwxr-xr-x. 2 root  root    6 May 19  2020 etc
drwxr-xr-x. 2 root  root    6 May 19  2020 games
drwxr-xr-x. 2 root  root    6 May 19  2020 include
drwxr-xr-x. 2 root  root    6 May 19  2020 lib
drwxr-xr-x. 3 root  root   17 Jul 14 22:23 lib64
drwxr-xr-x. 2 root  root    6 May 19  2020 libexec
lrwxrwxrwx. 1 mysql mysql  35 Jul 27 19:45 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 9 mysql mysql 129 Jul 27 19:42 mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x. 2 root  root    6 May 19  2020 sbin
drwxr-xr-x. 5 root  root   49 Jul 14 22:23 share
drwxr-xr-x. 2 root  root    6 May 19  2020 src


//添加环境变量
[root@localhost mysql]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@localhost mysql]# source /etc/profile.d/mysql.sh
[root@localhosysql]# echo $PATH
/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin
[root@localhost mysql]# 
[root@localhost mysql]# which mysql
/usr/local/mysql/bin/mysql
[root@localhost mysql]# 
[root@localhost mysql]# ln -sv /usr/local/mysql/include/  /usr/include/mysql  
'/usr/include/mysql' -> '/usr/local/mysql/include/'
[root@localhost mysql]# 
[root@localhost mysql]# vim /etc/ld.so.conf.d/mysql.conf
[root@localhost mysql]# cat /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib/
[root@localhost ]# 
[root@localhost ]# 
//重新加载
[root@localhost mysql]# ldconfig 

[root@localhost mysql]# vim /etc/man_db.conf 
[root@localhost mysql]# cat /etc/man_db.conf 
MANDATORY_MANPATH            /usr/man
MANDATORY_MANPATH            /usr/share/man
MANDATORY_MANPATH            /usr/local/share/man
MANDATORY_MANPATH     /usr/local/mysql/man

创建各实例数据存放的目录

[root@localhost ~]# mkdir -p /opt/data/{3306,3307,3308}
[root@localhost ~]#  chown -R mysql.mysql /opt/data/
[root@localhost ~]# ll /opt/data/
total 0
drwxr-xr-x. 2 mysql mysql 6 Jul 30 00:15 3306
drwxr-xr-x. 2 mysql mysql 6 Jul 30 00:15 3307
drwxr-xr-x. 2 mysql mysql 6 Jul 30 00:15 3308
[root@localhost ~]# 
[root@localhost ~]#

初始化各实例

//初始化3306实例
[root@localhost ~]# mysqld --initialize --datadir=/opt/data/3306 --user=mysql
2022-07-29T16:18:33.182333Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is depr