Dockerfile.syncer84

FROM python:3.10-slim

RUN apt-get update && \
    apt-get install -y --no-install-recommends \
        default-libmysqlclient-dev pkg-config build-essential default-mysql-client git && \
    rm -rf /var/lib/apt/lists/*

WORKDIR /app

# Install patched python-mysql-replication with MySQL 8.4 support
# COPY mysql-replication/ ./mysql-replication/
# RUN pip install --no-cache-dir ./mysql-replication/

COPY syncer/ ./clickhouse-mysql-data-reader/
# freeze_schema=True skips column metadata lookup; combined with binlog-row-metadata=FULL in my.cnf this avoids UNKNOWN_COL names
RUN sed -i 's/freeze_schema=True/freeze_schema=False/' ./clickhouse-mysql-data-reader/clickhouse_mysql/reader/mysqlreader.py
# Replace pinned 1.0.6 with a patched fork that uses SHOW BINARY LOG STATUS instead of SHOW MASTER STATUS
RUN sed -i "s|mysql-replication==1.0.6|mysql-replication @ git+https://github.com/tinybirdco/python-mysql-replication.git|" ./clickhouse-mysql-data-reader/setup.py
RUN pip install --no-cache-dir ./clickhouse-mysql-data-reader/

COPY run-syncer.sh .
RUN chmod +x run-syncer.sh

ENTRYPOINT ["./run-syncer.sh"]