docker镜像mysql主从_【图片】Docker Compose搭建mysql主从复制，mysql 镜像容器中报错【docker吧】_百度贴吧...

最新推荐文章于 2023-10-23 22:24:52 发布
最新推荐文章于 2023-10-23 22:24:52 发布
阅读量91 收藏
点赞数
文章标签： docker镜像mysql主从
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_36233098/article/details/114494133
版权

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

Docker Compose搭建mysql主从复制，mysql 镜像容器中报错日志如下：

0901e32ccbdaa0459083bb4f158d5026.png

2020-02-10T11:00:53.415057Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 2 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:01:53.420131Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 3 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:02:53.424220Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 4 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:03:53.429087Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 5 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:04:53.433366Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 6 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:05:53.437484Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 7 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:06:53.440067Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 8 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:07:53.445776Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 9 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:08:53.450953Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 10 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:09:53.455924Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 11 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:10:53.459021Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 12 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:11:53.464126Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 13 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:12:53.468037Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 14 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:13:53.472272Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 15 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:14:53.473742Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 16 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:15:53.478213Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 17 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:16:53.482333Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 18 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:17:53.484064Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 19 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:18:53.488469Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 20 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:19:53.492874Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 21 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

2020-02-10T11:20:53.495222Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 22 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045

mysql 主从服务已启动

ce0c7a34ccaa83169942b5e5434862fc.png

查看master库状态

5153d449339ec8f855c1e54d450ae0f1.png

slave 库状态

404789797ee1254113eba452e329b3d8.png

经反复排查分析，排除以下几点问题：

1、检查Linux服务器端口正常：排除

netstat -apn | grep 3306

2、检查Linux防火墙全部都关闭了,排除

3、网络不通排除

请大佬解答在此感谢

洛岗
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL 8.0 搭建主从复制报错：[ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master '
wangbin9536的博客
02-02 1万+
操作系统：CentOS Linux release 7.7.1908 (Core) MySQL版本：8.0.11 主库创建用户： create user 'repl'@'%' identified by 'repl'; grant replication slave,replication client on *.* to 'repl'@'%'; flush privileges; 从库执行： ...
[MY-010584] [Repl] Slave SQL for channel ‘‘: Worker 1 failed executing transaction ‘8a6a904d-f
の正在缓存99%
05-23 1001
2022-07-26T09:42:41.428914+08:00 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction '8a6a904d-f8df-11ec-8bc3-000c2927da2f:132' at master log jaspondb-binlog.000006, end_log_pos 45170; Error executing row event:
MYSQL8.0主从复制SLAVE搭建
m0_54370643的博客
06-10 835
mysql主从服务配置及相关常遇问题解决
mysqlsh的import工具导致唯一索引失效引起集群崩溃的真实案例
t384061961的博客
12-27 1272
最近在生产上的MySQL集群出现了所有从节点异常退出的奇怪现象，可给孩子吓得不轻，立马开始排查问题 和当时正在做操作的老师沟通后定位到他们当时正在使用mysqlsh的import工具进行数据导入。 具体的执行命令如下 mysqlsh --uri dcsp@$ip $port -pd$pwd -e "util.importTable('data.txt', {schema:'mydb',table: 'mytable', fieldsTerminatedBy:'|',characterSet:'gbk',
mysql主从失败处理办法
幸福街--linux技术分享
03-22 768
在主上 show master status; 查看Position ，File  在从库 slave stop; change master to master_log_file='binlog.0000x',master_log_pos=xx; slave start;
因修改 MySQL 复制账号密码导致主从复制中断
JiekeXu的博客
10-23 249
作者 | JiekeXu来源 |公众号 JiekeXu DBA之路（ID: JiekeXu_IT）如需转载请联系授权 |(个人微信 ID：JiekeXu_DBA)大家好，我是 JiekeXu,很高兴又和大家见面了,今天和大家一起来看看因修改 MySQL 复制账号密码导致主从复制异常，欢迎点击上方蓝字“JiekeXu DBA之路”关注我的公众号，标星或置顶，更多干货第一时间到达！书接上回，通过Li...
docker-compose关于mysql主从复制一键搭建脚本
09-18
关于博客: https://blog.csdn.net/qq_42413011/article/details/126914080 的搭建脚本
Docker搭建MySQL主从复制(docker-compose)
12-22
docker_compose搭建mysql主从复制
mysql5.7镜像+docker-compose.yaml
02-15
mysql5.7+docker-compose.yaml
docker-compose构建mysql主从镜像包
01-09
docker-compose构建mysql主从镜像包
docker-compose搭建mysql主从环境.md
06-07
docker-compose搭建mysql主从环境.md
MySQL 8.0.18使用clone plugin重建MGR的实现
09-08
主要介绍了MySQL 8.0.18使用clone plugin重建MGR的实现,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
mysql 数据库主从复制、双主复制集群产生的问题以及mysql常见的错误代码
Shallow的博客
01-04 3125
mysql 数据库主从复制、双主复制集群产生的问题以及mysql常见的错误代码
分布式数据库报错－Error_code: MY-008503
jiaona_chen123的博客
12-27 1237
报错一： 2021-12-27T02:46:23.537007-05:00 4446 [ERROR] [MY-010584] [Repl] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '67726561-7464-625f-636c-757374657200:4' at master log greatdb-bin.000001, end_log_pos 2026; Err
Mysql 主从简单配置
doStruggle的博客
06-28 304
本文为mysql主从的简单配置，仅简单开始主从复制。创建新的master和slave服务，并使用binlog同步数据。 开启master的binlog 默认binlog是开启的，为了确认，可在master的mysql上执行： mysql> show VARIABLES like '%log_bin%'; 如果log_bin显示为OFF，则需要手动打开。 找到my.cnf，添加或修改为...
mgr未同步 mysql_强烈推荐好文：最真实的MGR运维指南
weixin_42513870的博客
12-30 1548
导读作者：多年金融行业5年+DBA，比较低调，对技术比较钻研。简介本文涉及版本MySQL8.0.20的MGR、MGR介绍、单主/多主模式、MGR监控、单主/多主切换、异常恢复、流控、性能压测、遇到的问题和MGR的限制。想要全文pdf版本可添加微信：tian786376668(备注：求MGR运维指南)一、目的了解mysql8的MGR也就是组复制的特性，搭建和配置，MGR异常的处理。二、MG...
MySql基于Docker的快速主从搭建以及常见问题处理方式
轨迹的博客
10-26 930
MySql基于Docker的快速主从搭建以及常见问题处理方式，感兴趣的小伙伴快来看看吧~~
MySQL入门到精通视频教程
10-28
本课程全面讲授了MySQL数据库的相关技术知识，内容全面翔实，是技术开发人员、数据库人员不可多得的视频资料；
docker compose搭建mysql主从
最新发布
05-29
Docker Compose是一种用于定义和运行多容器Docker应用程序的工具。使用Docker Compose可以轻松地定义和管理多个Docker容器之间的依赖关系，实现容器化应用程序的快速部署和管理。 要搭建MySQL主从复制，可以使用Docker Compose来定义两个MySQL容器，并在其中一个容器上启用主节点，另一个容器上启用从节点。下面是一个简单的Docker Compose文件示例： ``` version: '3' services: master: image: mysql environment: MYSQL_ROOT_PASSWORD: example MYSQL_DATABASE: example ports: - "3306:3306" slave: image: mysql environment: MYSQL_ROOT_PASSWORD: example MYSQL_DATABASE: example MYSQL_MASTER_HOST: master MYSQL_MASTER_PASSWORD: example MYSQL_REPLICA_USER: replica MYSQL_REPLICA_PASSWORD: example depends_on: - master ``` 在上面的示例中，我们定义了两个服务：`master`和`slave`。`master`是主节点，`slave`是从节点。我们使用MySQL官方镜像，并为每个容器设置了相同的环境变量。在`slave`容器中，我们还设置了一些额外的环境变量，以便将其配置为从节点。我们使用了`depends_on`关键字来告诉Docker Compose，`slave`容器依赖于`master`容器。 在实际使用中，您需要根据自己的需求调整上述示例文件，例如更改端口号、更改用户名密码等。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值