MySQL的多实例部署

最新推荐文章于 2024-05-28 17:10:36 发布

NiqayZ

最新推荐文章于 2024-05-28 17:10:36 发布

阅读量238

点赞数 4

分类专栏： MySQL 文章标签： mysql adb 服务器

本文链接：https://blog.csdn.net/2201_75905322/article/details/139000443

版权

MySQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

文章目录

多实例部署

多实例部署

下载软件包

下载二进制格式的mysql软件包
[root@zyq ~]#: useradd -r -s /sbin/nologin -M mysql
[root@zyq ~]#: id mysql
uid=991(mysql) gid=991(mysql) groups=991(mysql)

[root@zyq ~]#: ls
anaconda-ks.cfg
mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz

[root@zyq ~]#: tar xf mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz -C  /usr/local/
[root@zyq ~]#: cd /usr/local/
[root@zyq local]#: ls
bin      lib                                  sbin
etc      lib64                                share
games    libexec                              src
include  mysql-8.0.35-linux-glibc2.28-x86_64
[root@zyq local]#: cd /usr/local/
[root@zyq local]#: mv mysql-8.0.35-linux-glibc2.28-x86_64/ mysql
[root@zyq local]#: echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@zyq local]#: source /etc/profile.d/mysql.sh 
[root@zyq local]#: which mysql
/usr/local/mysql/bin/mysql

修改目录/usr/local/mysql的属主属组
[root@zyq local]#: chown -R mysql.mysql /usr/local/mysql
[root@zyq local]#: ll /usr/local/mysql -d
drwxr-xr-x. 9 mysql mysql 129 Dec 10 19:25 /usr/local/mysql

部署多实例

创建格实例数据存放的目录
[root@zyq local]#: mkdir -p /opt/data/{3306,3307,3308}
[root@zyq local]#: chown -R mysql.mysql /opt/data/
[root@zyq local]#: ll /opt/data/
total 0
drwxr-xr-x. 2 mysql mysql 6 Dec 10 19:29 3306
drwxr-xr-x. 2 mysql mysql 6 Dec 10 19:29 3307
drwxr-xr-x. 2 mysql mysql 6 Dec 10 19:29 3308
 
 初始化各实例
[root@zyq local]#: mysqld --initialize --user mysql --datadir /opt/data/3306
2023-12-10T11:31:17.646433Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.35) initializing of server in progress as process 1551
2023-12-10T11:31:17.660299Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-12-10T11:31:18.152315Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-12-10T11:31:19.436062Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: J>dn_/QIO8gP
[root@zyq local]#: cd
[root@zyq ~]#: echo 'J>dn_/QIO8gP' > 3306
[root@zyq ~]#: mysqld --initialize --user mysql --datadir /opt/data/3307
2023-12-10T11:32:35.559120Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.35) initializing of server in progress as process 1593
2023-12-10T11:32:35.563243Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-12-10T11:32:35.701119Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-12-10T11:32:36.967417Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: x8.xj.x=lnzY
[root@zyq ~]#: echo 'x8.xj.x=lnzY' > 3307
[root@zyq ~]#: mysqld --initialize --user mysql --datadir /opt/data/3308
2023-12-10T11:33:02.894952Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.35) initializing of server in progress as process 1635
2023-12-10T11:33:02.899210Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-12-10T11:33:03.035325Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-12-10T11:33:04.332390Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 0NJw-(eJRlku
[root@zyq ~]#: echo '0NJw-(eJRlku' > 3308

[root@zyq ~]#: ls
3306  anaconda-ks.cfg
3307  mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz
3308

安装perl
[root@zyq ~]#: yum -y install perl

配置[root@zyq ~]#: vi /etc/my.cnf
[root@zyq ~]#: cat /etc/my.cnf
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin

[mysqld3306]
datadir = /opt/data/3306
port = 3306
socket = /tmp/mysql3306.sock
pid-file = /opt/data/3306/mysql_3306.pid
log-error=/var/log/3306.log

[mysqld3307]
datadir = /opt/data/3307
port = 3307
socket = /tmp/mysql3307.sock
pid-file = /opt/data/3307/mysql_3307.pid
log-error=/var/log/3307.log

[mysqld3308]
datadir = /opt/data/3308
port = 3308
socket = /tmp/mysql3308.sock
pid-file = /opt/data/3308/mysql_3308.pid
log-error=/var/log/3308.log

启动各实例
[root@zyq ~]#: mysqld_multi start 3306
[root@zyq ~]#: mysqld_multi start 3307
[root@zyq ~]#: mysqld_multi start 3308
[root@zyq ~]#: ss -antl
State  Recv-Q Send-Q Local Address:Port  Peer Address:Port                     Process                      
LISTEN 0      128          0.0.0.0:22         0.0.0.0:*                                                     
LISTEN 0      70                 *:33060            *:*                                                     
LISTEN 0      151                *:3306             *:*                                                     
LISTEN 0      151                *:3307             *:*                                                     
LISTEN 0      151                *:3308             *:*                                                     
LISTEN 0      128             [::]:22            [::]:*

初始化密码
[root@zyq ~]#: cat 3306
J>dn_/QIO8gP
[root@zyq ~]#: mysql -uroot -p'J>dn_/QIO8gP' -S /tmp/mysql3306.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.35

Copyright (c) 2000, 2023, 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> alter user 'root'@'localhost' identified with mysql_native_password by 'Pssword@_';
Query OK, 0 rows affected (0.00 sec)





[root@zyq ~]#: cat 3307
x8.xj.x=lnzY
[root@zyq ~]#: mysql -uroot -p'x8.xj.x=lnzY' -S /tmp/mysql3307.sock
......
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'Pssword@_';
Query OK, 0 rows affected (0.00 sec)





[root@zyq ~]#: cat 3308
0NJw-(eJRlku
[root@zyq ~]#: mysql -uroot -p'0NJw-(eJRlku' -S /tmp/mysql3308.sock
......
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'Pssword@_';
Query OK, 0 rows affected (0.01 sec)

设置开机自启

3306
[root@zyq ~]#: cd /usr/lib/systemd/system
[root@zyq system]#: cp sshd.service mysql3306.service
[root@zyq system]#: vi mysql3306.service 
[root@zyq system]#: cat mysql3306.service 
[Unit]
Description=OpenSSH server daemon
After=network.target sshd-keygen.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/bin/mysqld_multi start 3306
ExecStop=kill -9 $(ps -ef |grep -v 'grep' | grep 3306 | awk '{print $2}')
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target

3307
[root@zyq system]#: cp sshd.service mysql3307.service
[root@zyq system]#: vi mysql3307.service 
[root@zyq system]#: cat mysql3307.service 
[Unit]
Description=OpenSSH server daemon
After=network.target sshd-keygen.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/bin/mysqld_multi start 3307
ExecStop=kill -9 $(ps -ef |grep -v 'grep' | grep 3307 | awk '{print $2}')
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target

3308
[root@zyq system]#: cp sshd.service mysql3308.service
[root@zyq system]#: vi mysql3308.service 
[root@zyq system]#: cat mysql3308.service 
[Unit]
Description=OpenSSH server daemon
After=network.target sshd-keygen.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/bin/mysqld_multi start 3308
ExecStop=kill -9 $(ps -ef |grep -v 'grep' | grep 3308 | awk '{print $2}')
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target


启动3306实例
[root@zyq ~]#: systemctl daemon-reload
[root@zyq ~]#: systemctl status mysql3306
○ mysql3306.service - OpenSSH server daemon
     Loaded: loaded (/usr/lib/systemd/system/mysql3306.service; d>
     Active: inactive (dead)

[root@zyq ~]#: ln -s /usr/local/mysql/bin/my_print_defaults /usr/bin/
[root@zyq ~]#: which my_print_defaults
/usr/local/mysql/bin/my_print_defaults
[root@zyq ~]#: systemctl daemon-reload
[root@zyq ~]#: ss -antl
State  Recv-Q Send-Q Local Address:Port Peer Address:Port Process 
LISTEN 0      128          0.0.0.0:22        0.0.0.0:*            
LISTEN 0      128             [::]:22           [::]:*   
[root@zyq ~]#: systemctl start mysql3306
[root@zyq ~]#: ss -antl
State  Recv-Q Send-Q Local Address:Port  Peer Address:PortProcess 
LISTEN 0      128          0.0.0.0:22         0.0.0.0:*           
LISTEN 0      70                 *:33060            *:*           
LISTEN 0      151                *:3306             *:*           
LISTEN 0      128             [::]:22            [::]:* 
[root@zyq ~]#: systemctl enable mysql3306
Created symlink /etc/systemd/system/multi-user.target.wants/mysql3306.service → /usr/lib/systemd/system/mysql3306.service.
[root@zyq ~]#: systemctl status mysql3306
● mysql3306.service - OpenSSH server daemon
     Loaded: loaded (/usr/lib/systemd/system/mysql3306.service; e>
     Active: active (running) since Sun 2023-12-10 20:03:50 CST; >
   Main PID: 7894 (mysqld_safe)
      Tasks: 39 (limit: 48715)
     Memory: 368.7M
        CPU: 558ms
     CGroup: /system.slice/mysql3306.service
             ├─7894 /bin/sh /usr/local/mysql/bin/mysqld_safe --da>
             └─8033 /usr/local/mysql/bin/mysqld --basedir=/usr/lo>

Dec 10 20:03:50 zyq systemd[1]: Starting OpenSSH server daemon...
Dec 10 20:03:50 zyq systemd[1]: Started OpenSSH server daemon.


启动3307实例
[root@zyq ~]#: systemctl start mysql3307
[root@zyq ~]#: ss -antl
State  Recv-Q Send-Q Local Address:Port  Peer Address:PortProcess 
LISTEN 0      128          0.0.0.0:22         0.0.0.0:*           
LISTEN 0      70                 *:33060            *:*           
LISTEN 0      151                *:3306             *:*           
LISTEN 0      151                *:3307             *:*           
LISTEN 0      128             [::]:22            [::]:*           
[root@zyq ~]#: systemctl enable mysql3307
Created symlink /etc/systemd/system/multi-user.target.wants/mysql3307.service → /usr/lib/systemd/system/mysql3307.service.
[root@zyq ~]#: systemctl status mysql3307
● mysql3307.service - OpenSSH server daemon
     Loaded: loaded (/usr/lib/systemd/system/mysql3307.service; e>
     Active: active (running) since Sun 2023-12-10 20:08:07 CST; >
   Main PID: 8116 (mysqld_safe)
      Tasks: 37 (limit: 48715)
     Memory: 366.6M
        CPU: 603ms
     CGroup: /system.slice/mysql3307.service
             ├─8116 /bin/sh /usr/local/mysql/bin/mysqld_safe --da>
             └─8255 /usr/local/mysql/bin/mysqld --basedir=/usr/lo>

Dec 10 20:08:07 zyq systemd[1]: Starting OpenSSH server daemon...
Dec 10 20:08:07 zyq systemd[1]: Started OpenSSH server daemon.


启动3308实例
[root@zyq ~]#: systemctl start mysql3308
[root@zyq ~]#: ss -antl
State  Recv-Q Send-Q Local Address:Port  Peer Address:PortProcess 
LISTEN 0      128          0.0.0.0:22         0.0.0.0:*           
LISTEN 0      70                 *:33060            *:*           
LISTEN 0      151                *:3306             *:*           
LISTEN 0      151                *:3307             *:*           
LISTEN 0      151                *:3308             *:*           
LISTEN 0      128             [::]:22            [::]:*           
[root@zyq ~]#: systemctl enable mysql3308
Created symlink /etc/systemd/system/multi-user.target.wants/mysql3308.service → /usr/lib/systemd/system/mysql3308.service.
[root@zyq ~]#: systemctl status mysql3308
● mysql3308.service - OpenSSH server daemon
     Loaded: loaded (/usr/lib/systemd/system/mysql3308.service; e>
     Active: active (running) since Sun 2023-12-10 20:09:13 CST; >
   Main PID: 8355 (mysqld_safe)
      Tasks: 37 (limit: 48715)
     Memory: 372.6M
        CPU: 568ms
     CGroup: /system.slice/mysql3308.service
             ├─8355 /bin/sh /usr/local/mysql/bin/mysqld_safe --da>
             └─8494 /usr/local/mysql/bin/mysqld --basedir=/usr/lo>

Dec 10 20:09:13 zyq systemd[1]: Starting OpenSSH server daemon...
Dec 10 20:09:13 zyq systemd[1]: Started OpenSSH server daemon.