Bitnami mysql docker镜像-在docker swarm上复制

Question

有人使用bitnami的mysql docker镜像成功创建了一个复制组吗？

Docker和docker是最新版本。

由于以下错误，我无法启动复制：

mysql_master.1.wnusvzmnltfe@32g-960g-node1    | 2020-12-14T20:57:40.490733Z 0 [System] [MY-010931] [Server] /opt/bitnami/mysql/bin/mysqld: ready for connections. Version: '8.0.22'  socket: '/opt/bitnami/mysql/tmp/mysql.sock'  port: 3306  Source distribution.
mysql_master.1.wnusvzmnltfe@32g-960g-node1    | 2020-12-14T20:57:43.350634Z 8 [Warning] [MY-013130] [Server] Aborted connection 8 to db: 'unconnected' user: 'repl_user' host: '192.168.10.199' (init_connect command failed; diagnostics area: MY-001064 - You have an error in your SQL syntax; check the manual that corr)

这是我的docker-compose.yml文件：

version: '3.7'
  
services:
  master:
    image: 'bitnami/mysql:8.0-debian-10'
    user: root
    networks:
      - one
    ports:
      - '3306'
    volumes:
      - /home/one/data/mysql/data:/bitnami/mysql/data
      - /home/one/data/mysql/conf/my_custom.cnf:/opt/bitnami/mysql/conf/my_custom.cnf:ro
    environment:
      - MYSQL_REPLICATION_MODE=master
      - MYSQL_REPLICATION_USER=repl_user
      - MYSQL_REPLICATION_PASSWORD=repl_pass
      - MYSQL_ROOT_PASSWORD=rootpass
      - MYSQL_DATABASE=mydb
  
  slave1:
    image: 'bitnami/mysql:8.0-debian-10'
    user: root
    depends_on:
      - master
    networks:
      - one
    ports:
      - '3306'
    volumes:
      - /home/one/data/mysql/data:/bitnami/mysql/data
      - /home/one/data/mysql/conf/my_custom.cnf:/opt/bitnami/mysql/conf/my_custom.cnf:ro
    environment:
      - MYSQL_REPLICATION_MODE=slave
      - MYSQL_REPLICATION_USER=repl_user
      - MYSQL_REPLICATION_PASSWORD=repl_pass
      - MYSQL_MASTER_HOST=mysql_master
      - MYSQL_MASTER_PORT_NUMBER=3306
      - MYSQL_MASTER_ROOT_PASSWORD=rootpass

networks:
  one:
    external: true
    name: one-overlay

谢谢

Answer 1

我切换到mysql镜像，它起作用了。我怀疑是一些遗留的binlog (我将binlog挂载到主机上)导致了这个问题，但无法验证，因为我不再拥有该环境。