Mysql5.7多实例安装

Mysql5.7多实例安装

𝓓𝓸𝓷 Lv6
  2024-07-10 12:23:08 2024-07-10 12:23:08 Created   2024-07-20 05:15:41 2024-07-20 05:15:41 Updated    

Mysql多实例安装

一、创建数据目录
1
[root@db01 ~]# mkdir -p /data/330{7,8,9}/data
二、创建配置文件
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
[root@db01 ~]# cat > /data/3307/my.cnf <<EOF

[mysqld]
basedir=/application/mysql

datadir=/data/3307/data

socket=/data/3307/mysql.sock

log_error=/data/3307/mysql.log

port=3307

server_id=7

pid-file=/data/3307/mysql.pid

log_bin=/data/3307/mysql-bin

EOF


[root@db01 ~]# cat > /data/3308/my.cnf <<EOF

[mysqld]
basedir=/application/mysql

datadir=/data/3308/data

socket=/data/3308/mysql.sock

log_error=/data/3308/mysql.log

port=3308

server_id=8

pid-file=/data/3308/mysql.pid

log_bin=/data/3308/mysql-bin

EOF


[root@db01 ~]# cat > /data/3309/my.cnf <<EOF

[mysqld]
basedir=/application/mysql

datadir=/data/3309/data

socket=/data/3309/mysql.sock

log_error=/data/3309/mysql.log

port=3309

server_id=9

pid-file=/data/3309/mysql.pid

log_bin=/data/3309/mysql-bin

EOF


三、初如化数据
1
2
3
4
5
[root@db01 ~]# mysqld --initialize-insecure --user=mysql --datadir=/data/3307/data --basedir=/application/mysql

[root@db01 ~]# mysqld --initialize-insecure --user=mysql --datadir=/data/3308/data --basedir=/application/mysql

[root@db01 ~]# mysqld --initialize-insecure --user=mysql --datadir=/data/3309/data --basedir=/application/mysql
四、给目录授权
1
[root@db01 ~]# chown -R mysql.mysql /data/
五、systemd管理多实例
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
[root@db01 ~]# more /etc/systemd/system/mysqld.service 
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Service]
User=mysql
Group=mysql 
ExecStart= /application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
ExecReload= /etc/init.d/mysqld restart
LimitNOFILE = 5000
[Install]
WantedBy=multi-user.target


[root@db01 ~]# cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld3307.service

[root@db01 ~]# cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld3308.service

[root@db01 ~]# cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld3309.service


修改mysqld3307.service：

[root@db01 ~]# vi /etc/systemd/system/mysqld3307.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Service]
User=mysql
Group=mysql
ExecStart= /application/mysql/bin/mysqld --defaults-file=/data/3307/my.cnf
ExecReload= /etc/init.d/mysqld restart
LimitNOFILE = 5000
[Install]
WantedBy=multi-user.target



[root@db01 ~]# vi /etc/systemd/system/mysqld3308.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Service]
User=mysql
Group=mysql
ExecStart= /application/mysql/bin/mysqld --defaults-file=/data/3308/my.cnf
ExecReload= /etc/init.d/mysqld restart
LimitNOFILE = 5000
[Install]
WantedBy=multi-user.target





[root@db01 ~]# vi /etc/systemd/system/mysqld3309.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Service]
User=mysql
Group=mysql
ExecStart= /application/mysql/bin/mysqld --defaults-file=/data/3309/my.cnf
ExecReload= /etc/init.d/mysqld restart
LimitNOFILE = 5000
[Install]
WantedBy=multi-user.target


六、启动数据库
1
2
3
[root@db01 ~]# systemctl start mysqld3307.service
[root@db01 ~]# systemctl start mysqld3308.service
[root@db01 ~]# systemctl start mysqld3309.service
七、查看数据库
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
[root@db01 ~]# netstat -nltp |grep 330
tcp6       0      0 :::3306                 :::*                    LISTEN      3435/mysqld         
tcp6       0      0 :::3307                 :::*                    LISTEN      4104/mysqld         
tcp6       0      0 :::3308                 :::*                    LISTEN      4141/mysqld         
tcp6       0      0 :::3309                 :::*                    LISTEN      4179/mysqld   

[root@db01 ~]# mysql -S /data/3307/mysql.sock -e "select @@server_id"
+-------------+
| @@server_id |
+-------------+
|           7 |
+-------------+

[root@db01 ~]# mysql -S /data/3308/mysql.sock -e "select @@server_id"
+-------------+
| @@server_id |
+-------------+
|           8 |
+-------------+

[root@db01 ~]# mysql -S /data/3309/mysql.sock -e "select @@server_id"
+-------------+
| @@server_id |
+-------------+
|           9 |
+-------------+

八、登录数据库
1
2
3
[root@db01 ~]# mysql -S /data/3307/mysql.sock
[root@db01 ~]# mysql -S /data/3308/mysql.sock
[root@db01 ~]# mysql -S /data/3309/mysql.sock
  • Title: Mysql5.7多实例安装
  • Author: 𝓓𝓸𝓷
  • Created at : 2024-07-10 12:23:08
  • Updated at : 2024-07-20 05:15:41
  • Link: https://www.zhangdong.me/multiple-instance-installation.html
  • License: This work is licensed under CC BY-NC-SA 4.0.
推荐文章
Linux安装Mysql5.6 Linux安装Mysql5.6 Linux安装Mysql8.0 Linux安装Mysql8.0 Linux安装Mysql5.6 Linux安装Mysql5.6
推荐文章
Linux安装Mysql5.6 Linux安装Mysql5.6 Linux安装Mysql8.0 Linux安装Mysql8.0
评论
  1. 一、创建数据目录
  2. 二、创建配置文件
  3. 三、初如化数据
  4. 四、给目录授权
  5. 五、systemd管理多实例
  6. 六、启动数据库
  7. 七、查看数据库
  8. 八、登录数据库