mysql多实例部署

最新推荐文章于 2020-02-23 12:05:13 发布
最新推荐文章于 2020-02-23 12:05:13 发布
阅读量145 收藏 2
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44504261/article/details/99877512
版权

mysql多实例部署

软件下载

[root@lwq-client ~]# cd /usr/src/
[root@lwq-client src]# ls
debug  kernels  mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
[root@lwq-client src]# cd
[root@lwq-client ~]#

配置用户和组并解压二进制程序至/usr/local

//创建用户和组
[root@lwq-client ~]# groupadd -r mysql
[root@lwq-client ~]# useradd -M -s /sbin/nologin -g mysql mysql

//解压软件至/usr/local
[root@lwq-client src]# ls
debug  kernels  mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
[root@lwq-client src]# tar xf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
[root@lwq-client src]# ls
debug  kernels  mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
[root@lwq-client src]# cd /usr/local/
[root@lwq-client local]# ls
bin  games    lib    libexec                              sbin   src
etc  include  lib64  mysql-5.7.22-linux-glibc2.12-x86_64  share
[root@lwq-client local]# ln -sv mysql-5.7.22-linux-glibc2.12-x86_64/ mysql
"mysql" -> "mysql-5.7.22-linux-glibc2.12-x86_64/"
[root@lwq-client local]# ll
总用量 0
drwxr-xr-x. 2 root root   6 3月  10 2016 bin
drwxr-xr-x. 2 root root   6 3月  10 2016 etc
drwxr-xr-x. 2 root root   6 3月  10 2016 games
drwxr-xr-x. 2 root root   6 3月  10 2016 include
drwxr-xr-x. 2 root root   6 3月  10 2016 lib
drwxr-xr-x. 2 root root   6 3月  10 2016 lib64
drwxr-xr-x. 2 root root   6 3月  10 2016 libexec
lrwxrwxrwx. 1 root root  36 8月  19 10:25 mysql -> mysql-5.7.22-linux-glibc2.12-x86_64/
drwxr-xr-x. 9 root root 129 8月  19 10:24 mysql-5.7.22-linux-glibc2.12-x86_64
drwxr-xr-x. 2 root root   6 3月  10 2016 sbin
drwxr-xr-x. 5 root root  49 7月  20 01:10 share
drwxr-xr-x. 2 root root   6 3月  10 2016 src

//修改/usr/local/mysql的属组属组
[root@lwq-client local]# chown -R mysql.mysql /usr/local/mysql
[root@lwq-client local]# ll -d /usr/local/mysql
lrwxrwxrwx. 1 mysql mysql 36 8月  19 10:25 /usr/local/mysql -> mysql-5.7.22-linux-glibc2.12-x86_64/

//配置环境变量
[root@lwq-client ~]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@lwq-client ~]# . /etc/profile.d/mysql.sh 
[root@lwq-client ~]# echo $PATH
/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

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

[root@lwq-client ~]# mkdir -p /opt/data/{3306,3307,3308}
[root@lwq-client ~]# chown -R mysql.mysql /opt/data/
[root@lwq-client ~]# ll /opt/data/
总用量 0
drwxr-xr-x. 2 mysql mysql 6 8月  19 10:32 3306
drwxr-xr-x. 2 mysql mysql 6 8月  19 10:32 3307
drwxr-xr-x. 2 mysql mysql 6 8月  19 10:32 3308

[root@lwq-client ~]# yum -y install tree
[root@lwq-client ~]# tree /opt/data/
/opt/data/
├── 3306
├── 3307
└── 3308

3 directories, 0 files

初始化各实例

//初始化3306实例
[root@lwq-client ~]# mysqld --initialize --datadir=/opt/data/3306 --user=mysql
2019-08-19T02:38:05.198072Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-19T02:38:05.461387Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-08-19T02:38:05.520051Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-08-19T02:38:05.578159Z 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: 5f5bdc74-c22a-11e9-b95e-000c29b10852.
2019-08-19T02:38:05.578956Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-08-19T02:38:05.579787Z 1 [Note] A temporary password is generated for root@localhost: f16p+M(3yip4
[root@lwq-client ~]# echo 'f16p+M(3yip4' > 3306
[root@lwq-client ~]# cat 3306
f16p+M(3yip4

//初始化3307实例
[root@lwq-client ~]# mysqld --initialize --datadir=/opt/data/3307 --user=mysql
2019-08-19T02:42:00.670652Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-19T02:42:01.536789Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-08-19T02:42:01.581895Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-08-19T02:42:01.638243Z 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: ec0fc565-c22a-11e9-8178-000c29b10852.
2019-08-19T02:42:01.658200Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-08-19T02:42:01.659373Z 1 [Note] A temporary password is generated for root@localhost: 2F1su>bsprZ%
[root@lwq-client ~]# echo '2F1su>bsprZ%' > 3307
[root@lwq-client ~]# cat 3307
2F1su>bsprZ%

//初始化3308实例
[root@lwq-client ~]# mysqld --initialize --datadir=/opt/data/3308 --user=mysql
2019-08-19T02:43:33.071868Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-19T02:43:33.416574Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-08-19T02:43:33.461321Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-08-19T02:43:33.516636Z 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: 22d34d4e-c22b-11e9-86fd-000c29b10852.
2019-08-19T02:43:33.517589Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-08-19T02:43:33.519590Z 1 [Note] A temporary password is generated for root@localhost: hSY:.&FRO6kq
[root@lwq-client ~]# echo 'hSY:.&FRO6kq' > 3308
[root@lwq-client ~]# cat 3308
hSY:.&FRO6kq

安装perl

[root@lwq-client ~]# yum -y install perl

配置配置文件/etc/my.cnf

[root@lwq-client ~]# vim /etc/my.cnf
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/muysql/bin/mysqladmin
#user = root                             //以下两行可以注释
#password = lwq

[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@lwq-client ~]# mysqld_multi start 3306
[root@lwq-client ~]# mysqld_multi start 3307
[root@lwq-client ~]# mysqld_multi start 3308
[root@lwq-client ~]# ss -antl
State       Recv-Q Send-Q Local Address:Port               Peer Address:Port              
LISTEN      0      128               *:111                           *:*                  
LISTEN      0      5      192.168.122.1:53                            *:*                  
LISTEN      0      128               *:22                            *:*                  
LISTEN      0      128       127.0.0.1:631                           *:*                  
LISTEN      0      100       127.0.0.1:25                            *:*                  
LISTEN      0      128       127.0.0.1:6010                          *:*                  
LISTEN      0      80               :::3307                         :::*                  
LISTEN      0      80               :::3308                         :::*                  
LISTEN      0      128              :::111                          :::*                  
LISTEN      0      128              :::22                           :::*                  
LISTEN      0      128             ::1:631                          :::*                  
LISTEN      0      100             ::1:25                           :::*                  
LISTEN      0      128             ::1:6010                         :::*                  
LISTEN      0      80               :::3306                         :::*

初始化密码

//初始化3306密码
[root@lwq-client ~]# ls
3306  3308  3307  anaconda-ks.cfg  
[root@lwq-client ~]# cat 3306
f16p+M(3yip4
[root@lwq-client ~]# mysql -uroot -p'f16p+M(3yip4' -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 2
Server version: 5.7.22

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

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> set password = password('lwq');
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> exit
Bye
//用修改的密码登陆
[root@lwq-client ~]# mysql -uroot -plwq -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 3
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

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> exit
Bye

[root@lwq-client ~]# mysql -uroot -plwq -h 127.0.0.1 -P 3306
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 5
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

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> 



//初始化3307密码
[root@lwq-client ~]# cat 3307
2F1su>bsprZ%
[root@lwq-client ~]# mysql -uroot -p'2F1su>bsprZ%' -S /tmp/mysql3307.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 2
Server version: 5.7.22

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

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> set password = password('lwq');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> exit
Bye
//用修改的密码登陆
[root@lwq-client ~]# mysql -uroot -plwq -S /tmp/mysql3307.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 3
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

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> exit
Bye


//初始化3308密码
[root@lwq-client ~]# cat 3308
hSY:.&FRO6kq
[root@lwq-client ~]# mysql -uroot -p'hSY:.&FRO6kq' -S /tmp/mysql3308.sock -e 'set password = password("lwq");' --connect-expired-password
mysql: [Warning] Using a password on the command line interface can be insecure.
//用修改的密码登陆
[root@lwq-client ~]# mysql -uroot -plwq -S /tmp/mysql3308.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 3
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

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>
Lu鹿夫人
关注
MySQL多实例部署
该学习了a的博客
03-14 675
MySQL 多实例部署指的是在同一台服务器上同时运行多个独立的 MySQL 实例，每个实例有自己的配置、数据目录和端口。这种部署方式通常用于在单个物理服务器上托管多个数据库，提高资源利用率，降低成本，并且可以隔离不同应用或服务的数据。
应用部署多个实例数据同步（占）
weixin_34138255的博客
01-22 419
docker
mysql安装：“root@localhost is created with an empty password !”，而非A temporary password is generated for
热门推荐
qq_30039127的博客
02-23 3万+
问题：在安装mysqd~l时，打开DESKTOP-8UNK26K.err未发现密码，发现： [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 而非： [Warning] A temporary pa...
安装mysql时的修改初始密码
fenfenguai的专栏
12-25 2186
安装mysql时记住初始密码 例如我的： 2016-12-23T19:53:06.375910Z 1 [Note] A temporary password is generated for root@localhost: dOsJ>ZWj/0)X If you lose this password, please consult the section How to Reset t
mysql多实例部署shell脚本
10-26
mysql多实例部署shell脚本
mysql5.7多实例部署
09-08
MySQL 5.7 多实例部署 本文档主要介绍了 MySQL 5.7 数据库的多实例部署方法，包括自动化部署脚本的使用和多实例创建。下面是详细的知识点： 一、MySQL 5.7 多实例部署的优点 * 提高数据库的可用性和可扩展性 * ...
RAR密码暴力瞬间破解.rar
03-19
一个速度很快，可以帮你找回RAR文件的密码，注册后可以解开多达128位密码。它提供有预估算出密码所需要的时间；可中断计算与恢复继续前次的计算。 强力的 RAR/WinRAR 密码破解工具。 功能特性： 简单易用 一个实例只可破解一个文件，但运行多个实例即可同时破解多个文件 支持各种压缩方式 支持自解压压缩包 可自设暴破字符集（支持非英文字符） 随时可中断破解进度，稍后可自断点继续 可后台运行，仅在闲置状态下占用 CPU 可选用自定义化的“暴破”方式，也可选用高效的字典方式 支持经 AES-128 算法加密的各类 RAR/WinRAR 压缩包 注册码:ARPR-83296730531875-CBBVYBXFEXDEVPMB
Ubuntu 解压文件中文名乱码
Stay hungry,stay foolish.
05-04 683
Ubuntu 解压文件中文名乱码 解决方案 sudo apt-get install unar unar 解压文件名称 Have Fun:)
zip4j加密压缩、解压缩文件、文件夹
dgqvhtlwq472235338的博客
06-10 192
原文：http://blog.csdn.net/k21325/article/details/54376188 1.首先，引用到zip4j的第三方类库，感谢作者的无私奉献，官网打不开，这里就不贴了，下面是maven仓库的jar包 <!-- https://mvnrepository.com/artifact/net.lingala.zip4j/zip4j -->...
使用jedis对redis集群进行密码认证
destiny_lwq的博客
04-25 1947
因发现公司redis存在被入侵迹象，将redis迁至内网，redis集群增加密码。2.9.0之前的版本，JedisCluster未实现集群密码配置，升级到2.9.0实现 原版本：<jedis.version>2.7.2</jedis.version> 现版本：<jedis.version>2.9.0</jedis.version> <jedis...
解压带密码的rar
dhcdhcdhcdhcdhc的博客
10-25 5866
#解压rar 把winrar添加环境变量后 在cmd中输入winrar e -p123456 E:\python_work\12345.rar E:\python_work\out 参数依次为 解压 密码 源文件 解压到
一个tomcat部署多个应用实例总结
xafc_2370的专栏
09-21 567
项目组有好几个项目需要运行，之前项目少，一个tomcat对应一个项目还能应付，但现在项目多了，要是再一个tomcat对应一个项目的话，一方面看起来很业余，一方面也加大服务器的维护难度。所以现在需要对tomcat进行整理，用一个tomcat来启动多个应用实例，每个应用相互独立，互不干扰。 准备工作：下载的apache-tomcat-7.0.26.zip,上传到linux服务器下/opt/a...
mysql源码安装
Lu鹿夫人的博客
08-17 121
mysql源码安装 环境说明： 操作系统：redhat7.0 mysql版本：mysql-5.7.26 1.关闭防火墙以及selinux [root@lwq-client ~]# systemctl stop firewalld [root@lwq-client ~]# systemctl disable firewalld [root@lwq-client ~]# getenforce Dis...
VTOL-7-Nano-3D-Print
09-17
VTOL-7-Nano-3D-Print for T1 Ranger
c1900-universalk9-mz.SPA.153-1.T.bin
最新发布
09-17
c1900-universalk9-mz.SPA.153-1.T.bin
常用命令_linux.zip
09-17
常用命令_linux
Red Hat 7.2上MariaDB 5.7多实例部署详解
多实例部署下，还需要考虑不同实例之间的备份和恢复策略，以防止数据丢失。可以利用mysqldump或InnoDB Cluster等工具进行备份，并制定相应的恢复流程。 通过以上步骤，您可以在Red Hat 7.2生产环境中成功部署MySQL...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值