mysql5.7多实例

最新推荐文章于 2024-06-10 17:17:14 发布
最新推荐文章于 2024-06-10 17:17:14 发布
阅读量821 收藏 19
点赞数 17
文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zj88189748/article/details/136744789
版权

目录

1.配置文件配置多实例参数

2.初始化第2个实例（无密码）

3.启动第2个实例

4.未找到实例报错

5.配置第3个实例

6.启动第3个实例

7.停止多实例

8.多实例停不下来处理

9.设置启动关闭服务

10.忘记密码处理

11.安装多版本mysql

11.1安装mysql5.7.32

11.2安装mysql8.0.35

1.配置文件配置多实例参数

在/etc/my.cnf中加入

[mysqld_multi]
mysqld=/usr/local/mysql/bin/mysqld_safe #启动多实例mysql时的命令，也可以用/usr/local/mysql/bin/mysqld，但是一般用mysqld_safe，会多一个守护进程
mysqladmin=/usr/local/mysql/bin/mysqladmin #关闭多实例mysql时用的命令，需要用户名和密码
log=/usr/local/mysql/mysqld_multi.log

[mysqld1]
port =3307
datadir= /mysql1_data
socket = /tmp/mysql.sock1

[root@localhost ~]# cat /etc/my.cnf
[mysql]
prompt=(\\u@\\h) [\\d]>\\_

[mysqld]
port =3306
user = mysql
datadir = /mysql_data
log_error = error.log

[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
log = /usr/local/mysql/mysqld_multi.log
user = root
pass = 123456

[mysqld1]
port = 3307
datadir = /mysql1_data
socket = /tmp/mysql.sock1

2.初始化第2个实例（无密码）

# mysqld --initialize-insecure --datadir=/mysql1_data

[root@localhost /]# mysqld --initialize-insecure --datadir=/mysql1_data

3.启动第2个实例

mysqld_multi start 1命令中的1代表my.cnf中配置的[mysqld1]的1

[root@localhost ~]# mysqld_multi start 1
[root@localhost ~]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running

查看端口

[root@localhost ~]# netstat -ntl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State      
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:6010          0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:6011          0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN     
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN     
tcp6       0      0 ::1:631                 :::*                    LISTEN     
tcp6       0      0 ::1:25                  :::*                    LISTEN     
tcp6       0      0 ::1:6010                :::*                    LISTEN     
tcp6       0      0 ::1:6011                :::*                    LISTEN     
tcp6       0      0 :::3306                 :::*                    LISTEN     
tcp6       0      0 :::3307                 :::*                    LISTEN     
tcp6       0      0 :::111                  :::*                    LISTEN     
tcp6       0      0 :::22                   :::*                    LISTEN

4.未找到实例报错

[root@localhost mysql]# mysqld_multi report
Reporting MySQL servers
No groups to be reported (check your GNRs)

是因为我在配置文件中的参数写错了，[mysqld1]写成[mysql1]了

5.配置第3个实例

[root@localhost ~]# cat /etc/my.cnf
[mysql]
prompt=(\\u@\\h) [\\d]>\\_

[mysqld]
port =3306
user = mysql
datadir = /mysql_data
log_error = error.log

[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
log = /usr/local/mysql/mysqld_multi.log

[mysqld1]
port = 3307
datadir = /mysql1_data
socket = /tmp/mysql.sock1

[mysqld2]
port = 3308
datadir = /mysql2_data
socket = /tmp/mysql.sock2

6.启动第3个实例

[root@localhost ~]# mysqld_multi start 2
[root@localhost ~]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running

查看第3个示例端口

[root@localhost ~]# netstat -ntl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State      
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:6010          0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:6011          0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN     
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN     
tcp6       0      0 ::1:631                 :::*                    LISTEN     
tcp6       0      0 ::1:25                  :::*                    LISTEN     
tcp6       0      0 ::1:6010                :::*                    LISTEN     
tcp6       0      0 ::1:6011                :::*                    LISTEN     
tcp6       0      0 :::3306                 :::*                    LISTEN     
tcp6       0      0 :::3307                 :::*                    LISTEN     
tcp6       0      0 :::3308                 :::*                    LISTEN     
tcp6       0      0 :::111                  :::*                    LISTEN     
tcp6       0      0 :::22                   :::*                    LISTEN

7.停止多实例

[root@localhost ~]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
[root@localhost mysql1_data]# mysqld_multi stop
[root@localhost mysql1_data]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is not running

8.多实例停不下来处理

需要注意如果不能停止多实例，把mysql配置文件中[mysqld_multi]下的password = 123456改成pass = 123456就可以正常停止

或者

需修改mysqld_multi 代码，把
my $com= join ' ', 'my_print_defaults ', @defaults_options, $group;
替换为：
my $com= join ' ', 'my_print_defaults -s', @defaults_options, $group;

其中增加了一个-s

并且需要我们做一个授权
(root@not_connected) [mysql]> grant shutdown on *.* to 'username'@'localhost' identified by '123456'
另外还需要在my.cnf配置文件中加上：
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
log = /usr/local/mysql/mysqld_multi.log
user = root
password = password

或者

[client]
user=root
password=123456
 

9.设置启动关闭服务

[root@localhost support-files]# cp /usr/local/mysql/support-files/mysqld_multi.server /etc/init.d/
[root@localhost support-files]# /etc/init.d/mysqld_multi.server stop
[root@localhost support-files]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is not running
[root@localhost support-files]# mysqld_multi start
[root@localhost support-files]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running

mysql是通过mysqld程序来启动的，启动进入mysql后，可以通过shutdown命令关闭

[root@localhost mysql1_data]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
[root@localhost mysql1_data]# mysql -S/tmp/mysql.sock1 -p123456
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 3
Server version: 5.7.44 MySQL Community Server (GPL)

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.

(root@localhost) [(none)]> shutdown
    -> ;
Query OK, 0 rows affected (0.00 sec)

(root@localhost) [(none)]> exit
Bye
[root@localhost mysql1_data]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is running
[root@localhost mysql1_data]# mysqladmin -S/tmp/mysql.sock2 -uroot -p123456 shutdown
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
[root@localhost mysql1_data]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is not running

mysql_safe是mysql守护进程，检测mysql进程是否存在，不存在就启动mysql进程

[root@localhost mysql1_data]# ps -ef | grep mysql
root       1326      1  0 10:13 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/mysql_data --pid-file=/mysql_data/localhost.localdomain.pid
mysql      1468   1326  0 10:13 ?        00:01:03 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/mysql_data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=/mysql_data/localhost.localdomain.pid --port=3306
root      10494   2407  0 13:33 pts/0    00:00:00 grep --color=auto mysql
[root@localhost mysql1_data]# kill -9 1468
[root@localhost mysql1_data]# ps -ef | grep mysql
root       1326      1  0 10:13 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/mysql_data --pid-file=/mysql_data/localhost.localdomain.pid
mysql     10519   1326 12 13:34 ?        00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/mysql_data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=/mysql_data/localhost.localdomain.pid --port=3306
root      10549   2407  0 13:34 pts/0    00:00:00 grep --color=auto mysql

/etc/init.d/mysql.server stop命令是安全关闭，其中kill -0是发送给mysql一个信号，我要关闭你了

10.忘记密码处理

如果忘记mysql的用户密码可以在配置文件中加上参数skip_grant_tables，然后更新mysql数据库中user表的authentication_string字段

[root@localhost mysql1_data]# /etc/init.d/mysql.server stop
Shutting down MySQL.. SUCCESS! 
[root@localhost mysql1_data]# /etc/init.d/mysql.server start
Starting MySQL. SUCCESS!
[root@localhost mysql1_data]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.44 MySQL Community Server (GPL)

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.

(root@localhost) [(none)]> set password = '123456';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
(root@localhost) [(none)]> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
(root@localhost) [mysql]> select Host,User,authentication_string from user;
+-----------+---------------+-------------------------------------------+
| Host      | User          | authentication_string                     |
+-----------+---------------+-------------------------------------------+
| localhost | root          | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| localhost | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | mysql.sys     | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| %         | zhangsan      | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| %         | ame           | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| %         | lisi          | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+-----------+---------------+-------------------------------------------+ 
(root@localhost) [mysql]> update user set authentication_string=password('1234567') where User='root' and Host = 'localhost';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 1
(root@localhost) [mysql]> flush privileges;
Query OK, 0 row affected (0.00 sec)

另一个窗口，my.cnf中屏蔽掉skip_grant_tables后重启mysql，密码修改成功

[root@localhost support-files]# /etc/init.d/mysql.server restart
Shutting down MySQL.... SUCCESS! 
Starting MySQL. SUCCESS! 
[root@localhost support-files]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost support-files]# mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost support-files]# mysql -uroot -p1234567
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 4
Server version: 5.7.44 MySQL Community Server (GPL)

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.

(root@localhost) [(none)]>

11.安装多版本mysql

11.1安装mysql5.7.32

  • 创建数据目录/mysql32_data
  • 修改属组为mysql:mysql
  • 在my.cnf中加入另一个版本的参数
  • 做好软连接：ln -s /usr/local/mysql-5.7.32-linux-glibc2.12-x86_64 mysql32
  • 初始化该mysql：bin/mysqld --initialize-insecure --datadir=/mysql32_data
  • 启动该mysql实例：mysqld_multi start 32
[root@localhost local]# mkdir /mysql32_data
[root@localhost local]# chown mysql:mysql /mysql32_data
[root@localhost local]# ln -s /usr/local/mysql-5.7.32-linux-glibc2.12-x86_64 mysql32
[root@localhost local]# cat /etc/my.cnf
[mysqld32]
server_id = 32
port = 3332
basedir = /usr/local/mysql32
datadir = /mysql32_data
socket = /tmp/mysql.sock32
[root@localhost mysql32]# bin/mysqld --initialize-insecure --datadir=/mysql32_data
[root@localhost mysql32]# mysqld_multi report 
Reporting MySQL servers
MySQL server from group: mysqld32 is not running
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
[root@localhost mysql32]# mysqld_multi start 32
[root@localhost mysql32]# mysqld_multi report 
Reporting MySQL servers
MySQL server from group: mysqld32 is running
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
[root@localhost mysql32_data]# ps -ef | grep mysql
root      11465      1  0 13:56 pts/1    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/mysql_data --pid-file=/mysql_data/localhost.localdomain.pid
mysql     11605  11465  0 13:56 pts/1    00:00:17 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/mysql_data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=/mysql_data/localhost.localdomain.pid --port=3306
root      12282      1  0 14:27 pts/0    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --port=3307 --datadir=/mysql1_data --socket=/tmp/mysql.sock1
mysql     12437  12282  0 14:27 pts/0    00:00:07 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/mysql1_data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=localhost.localdomain.pid --socket=/tmp/mysql.sock1 --port=3307
root      12720      1  0 14:29 pts/0    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --port=3308 --datadir=/mysql2_data --socket=/tmp/mysql.sock2
mysql     12875  12720  0 14:29 pts/0    00:00:06 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/mysql2_data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=localhost.localdomain.pid --socket=/tmp/mysql.sock2 --port=3308
root      13872      1  0 14:50 pts/1    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --server_id=32 --port=3332 --basedir=/usr/local/mysql32 --datadir=/mysql32_data --socket=/tmp/mysql.sock32
mysql     14056  13872  3 14:50 pts/1    00:00:00 /usr/local/mysql32/bin/mysqld --basedir=/usr/local/mysql32 --datadir=/mysql32_data --plugin-dir=/usr/local/mysq32/lib/plugin --user=mysql --server-id=32 --log-error=error.log --pid-file=localhost.localdomain.pid --socket=/tmp/mysql.sock32 --port=3332
root      14105   2921  0 14:50 pts/1    00:00:00 grep --color=auto mysql

11.2安装mysql8.0.35

  • 解压mysql-8.0.35-linux-glibc2.12-x86_64.tar.xz至/usr/local/
  • 创建数据目录/mysql80_data
  • 修改数据目录属组：chown mysql:mysql /mysql80_data
  • 做好软连接：ln -s /usr/local/mysql-8.0.35-linux-glibc2.12-x86_64 mysql80
  • 在my.cnf中加入8.0版本的参数
  • 初始化8.0版本mysql：bin/mysqld --initialize --datadir=/mysql80_data
  • 启动该mysql实例：mysqld_multi start 80
[root@localhost local]# tar xf mysql-8.0.35-linux-glibc2.12-x86_64.tar.xz
[root@localhost local]# mkdir /mysql80_data
[root@localhost local]# chown mysql:mysql /mysql80_data
[root@localhost local]# ln -s /usr/local/mysql-8.0.35-linux-glibc2.12-x86_64 mysql80
[root@localhost local]# cat /etc/my.cnf
[mysqld80]
port = 3380
basedir = /usr/local/mysql80
datadir = /mysql80_data
socket = /tmp/mysql.sock80
[root@localhost local]# cd mysql80
[root@localhost mysql80]# bin/mysqld --initialize-insecure --datadir=/mysql80_data
[root@localhost mysql80]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld32 is running
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld80 is not running
[root@localhost mysql80]# mysqld_multi start 80
[root@localhost mysql80]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld32 is running
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld80 is running
[root@localhost mysql80]# netstat -nlt
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State      
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:6010          0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:6011          0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN     
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN     
tcp6       0      0 ::1:631                 :::*                    LISTEN     
tcp6       0      0 ::1:25                  :::*                    LISTEN     
tcp6       0      0 ::1:6010                :::*                    LISTEN     
tcp6       0      0 ::1:6011                :::*                    LISTEN     
tcp6       0      0 :::33060                :::*                    LISTEN     
tcp6       0      0 :::3332                 :::*                    LISTEN     
tcp6       0      0 :::3306                 :::*                    LISTEN     
tcp6       0      0 :::3307                 :::*                    LISTEN     
tcp6       0      0 :::3308                 :::*                    LISTEN     
tcp6       0      0 :::111                  :::*                    LISTEN     
tcp6       0      0 :::3380                 :::*                    LISTEN     
tcp6       0      0 :::22                   :::*                    LISTEN

需要注意在mysql5.7.4-5.7.10中default_password_lifetime参数默认是360天密码过期，5.7.10后默认密码期限为不过期

[root@localhost mysql80]# mysql -uroot -p123456
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 12
Server version: 5.7.44 MySQL Community Server (GPL)

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.

(root@localhost) [(none)]> show variables like 'default_password_lifetime';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| default_password_lifetime | 0     |
+---------------------------+-------+
1 row in set (0.01 sec)

鱼跃龙门Smile
关注
  • 17
    点赞
  • 踩
  • 19
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql5.7单机多实例环境搭建
11-27 275
如何在一台主机上部署mysql 5.7 多个实例
mysql5.7.26多实例配置
捕翼^的博客
06-02 197
实验环境:CentOS 7.5 1.提前应该将用户授权做好 mysql> grant all on *. * to root@‘192.168.200.%’ identified by ‘000000’; 2.多实例管理 2.1 准备多个目录 mkdir -p /data/330{7,8,9}/data 2.2 准备配置文件 cat > /data/3307/my.cnf <<EOF [mysqld] basedir=/application/mysql datadir=/dat
Mysql5.7 多实例
u010648194的博客
02-28 936
mysqld_safe The file /usr/local/mysql/bin/mysqld does not exist or is not executable_xiaozhuangyumaotao的博客-CSDN博客
mysql5.7多实例部署
09-08
此文档描述了mysql5.7数据库多多实例部署方法，另有多实例多部署脚本
MySQL5.7.23，单配置文件的多实例启动
马路上开飞机
09-25 979
这几天想要在阿里云服务器上实验Mysql的主从复制功能，需要在单机部署MySQL多实例，网上搜索了很多文章，由于版本不同操作会存在偏差，同时参考了MySql社区文档，完成了部署，步骤较简单，本文作为记录。 首先，在CentOS上安装MySQL。使用Yum方式安装：优点是比较简单，一路跟着指引执行就可以，环境变量也会自动配置好,不需要单独设置；缺点是安装目录和数据目录等比较分散，后续管理会有点麻烦...
CentOS6.5 上部署 MySQL5.7.17 二进制安装以及多实例配置
09-09
主要介绍了CentOS6.5 上部署 MySQL5.7.17 二进制安装以及多实例配置,需要的朋友可以参考下
MySQL5.7主从配置实例解析
09-09
主要为大家详细解析了MySQL5.7主从配置的实例，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
mysql多实例部署
03-27
mysql5.7在生产环境redhat7.2中，多个实例安装部署详细步骤记录
MySQL5.7.16，多实例配置
记录学习生活的点滴(Linux运维、java)
12-04 444
已经安装完mysql 1. 修改配置文件my.cnf 配置文件my.cnf的位置一般在/etc/my.cnf，找不到的可以使用以下命令看一下，根据顺序找。 mysql --help|grep my.cnf 2.修改my.cnf，默认的my.cnf很简单，包括datadir目录, socket文件，pid文件，log文件的路径。大概长这样： 首先修改[mysqld]为[mysqld...
mysql5.7多实例安装部署
热门推荐
Jian Sun_的博客
08-13 1万+
1. 背景    MySQL数据库的集中化运维，可以通过在一台服务器上，部署运行多个MySQL服务进程，通过不同的socket监听不同的服务端口来提供各自的服务。各个实例之间是相互独立的，每个实例的datadir, port, socket, pid都是不同的。 2. 多实例特点   * 有效利用服务器资源，当单个服务器资源有剩余时，可以充分利用剩余的资源提供更多的服务。   * 资源
MySQL5.7多实例安装及开机启动配置（亲测）
liguoxi666
06-20 1936
安装环境： CentOS版本：CentOS7.6.1810 MySQL版本：5.7.9 以前一些很low的方法是，解压两个mysql，分别放到不同文件夹，其实在mysql中已经考虑到了多实例安装的情况。也有相应的脚本命令的支持。 现在安装两个mysql 一个3307，3308 新建 /etc/my.cnf 配置如下： [mysqld_multi] mysqld = /usr/local/mysql...
mysql5.7.18多实例配置
weixin_33861800的博客
01-17 142
当前实验环境默认存在3306端口的mysql并可以正常运行，在此基础上增加一个新的mysql实例并使用3307端口。 配置过程如下： 1、将默认的mysql配置文件复制一份 cp /etc/my.cnf /etc/my3307.cnf 2、修改/etc/my3307.cnf（将原来3306的port、socket及相关数据路径换掉，下面是一个修改好后的m...
【干货】MySQL 5.7 多实例（多进程）配置教程
愚蠢的小根儿
03-15 9203
前言 大学把数据库的课全翘了，之后可能是报应吧，后面数据库相关的东西怎么都学不会。最近有个MySQL多开的需求，正好借这个机会再复习一遍MySQL安装配置。 写这篇博客还有另一个原因，现在网上搜到的MySQL多开教程都不是针对5.7版本的，直接按那些教程做很多地方会报错。 MySQL多实例的原理 MySQL本来就可以多实例运行，只要修改启动脚本和配置文件，把端口，basedir，dat...
MySQL5.7-多实例部署
bpb_cx的博客
11-07 572
一、mysql多实例的原理 mysql多实例，简单的说，就是在一台服务器上开启多个不同的mysql服务端口（如3306，3307），运行多个mysql服务进程。这些服务进程通过不同的socket监听不同的服务端口，来提供各自的服务。 这些mysql实例共用一套mysql安装程序，使用不同的my.cnf配置文件、启动程序、数据文件。在提供服务时，mysql多实例在逻辑上看来是各自独立的，各个实例...
jmeter性能优化之mysql监控sql慢查询语句分析
回家吃月饼的学习交流地
06-09 836
jmeter性能之sql慢查询语句分析
【MySQL】服务器配置和管理
p_fly的博客
06-09 713
MySQL服务器通常说的是mysqld程序。mysqld 是 MySQL 数据库服务器的核心程序，负责处理客户端的请求、管理数据库和执行数据库操作。管理员可以通过配置文件和各种工具来管理和监控 mysqld 服务器的运行本文将介绍下面三个内容：服务器启动选项：可以在命令行和配置文件中指定，用于配置服务器的行为和特性。服务器系统变量：反映了启动选项的当前状态和值，其中一些变量可以在服务器运行时修改。服务器状态变量：包含了关于运行时操作的计数器和统计信息。
Mysql的 存储过程（procedure）
shark1978的专栏
06-09 725
存储过程（Stored Procedure）是一组为了完成特定功能的SQL语句集合，经编译后存储在数据库中，用户通过指定存储过程的名字和参数（如果有）来执行它。存储过程可以在很多数据库管理系统（DBMS）中找到，如SQL Server、Oracle、MySQL等。
Mysql 的分布式策略
最新发布
只会写bug的靓仔的博客
06-10 1083
MySQL 作为最最常用的数据库，了解 Mysql 的分布式策略对于掌握 MySQL 的高性能使用方法和更安全的储存方式有非常重要的作用。它同时也是面试中最最常问的考点，我们这里就简单总结下 Mysq 的常用分布式策略。
MySQL5.7多实例
09-04
MySQL 5.7 支持多实例的配置。通过创建多个配置文件和数据目录，你可以在同一台服务器上运行多个独立的 MySQL 实例。下面是一些步骤来配置 MySQL 5.7 的多实例： 1. 复制 MySQL 安装目录：将 MySQL 安装目录复制到...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值