julien-duponchelle / python-mysql-replication

Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL
2.33k stars 679 forks source link

Bug - docker compose parameter doesn't updated #549

Open davinc71998 opened 1 year ago

davinc71998 commented 1 year ago

Issue Summary

In python-mysql-replication (version 1.0.0~ ) need to execute binlog schema parsing. To achieve this, it seems that I need to set the binlog_row_metadata option to FULL in my Docker Compose configuration.

x-mysql: &mysql
  environment:
    MYSQL_ALLOW_EMPTY_PASSWORD: true
  command: >
    mysqld
    --log-bin=mysql-bin.log
    --server-id 1
    --binlog-format=row
    --gtid_mode=on
    --enforce-gtid-consistency=on

x-mariadb: &mariadb
  environment:
    MARIADB_ALLOW_EMPTY_ROOT_PASSWORD: 1
  command: >
    --log-bin=master-bin
    --server-id=1
    --default-authentication-plugin=mysql_native_password
    --binlog-format=row

Solution

set the binlog_row_metadata option to FULL in my Docker Compose configuration.

davinc71998 commented 1 year ago

I'm solving it with @jaehyeonpy