python-mysql-replication

python-mysql-replication copied to clipboard

Possible bad alignment of data when decoding the query event

3

I have issues when processing the query event. The problem is not present in version 0.26. It seems it was introduced in version 0.28 and it's still present in 0.30....

the4thdoctor

resume_stream attribute of BinLogStreamReader not working as documented

7

According to documentation, BinLogStreamReader starts from a given position if an specific position of the binlog file is assigned to log_pos and resume_stream = True. Nevertheless: - when resume_stream =...

jmanuelnavarro

Environment: MySQL: 8.0.27 mysql-replication: 0.24 ``` Traceback (most recent call last): File "extract.py", line 57, in routine() File "extract.py", line 46, in routine binlog2sql.process_binlog(gv.conf.Target) File "/root/mysql2db/binlog2sql.py", line 155, in process_binlog...

david2chandra

AssertionError: Result length not requested length

2

mysql:8.0.25 mysql-replication:0.28 python:3.8 error: /Users/tu/Desktop/daily_demo/venv/bin/python /Users/tu/Desktop/daily_demo/mysql_binlog.py === RotateEvent === Position: 4 Next binlog file: mysql-bin.000001 === FormatDescriptionEvent === Date: 2022-04-08T15:33:35 Log position: 125 Event size: 98 Read bytes: 0 Traceback...

peijianbo

does it support mariadb

2

Hi all I am currently using mariadb 10.6 and want to know whether this library supports mariadb. Thanks

ygl-rg

improve performance and documentation, skip the first 2 events after reconnected

3

* sleep 5s after disconnected accidently and skip the first 2 events after reconnected * symplify BinLogStreamReader.fetchone * improve documentation of BinLogStreamReader * some cleanup and compacting works * tests/test_data_type.py:...

woods-chen

max_allowed_packet issue when using ## for binlogEvent in stream

1

#### error message like below: ``` log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master ``` #### the stack is: ``` python for binlog_event in stream: File "/usr/lib/python2.7/dist-packages/pymysqlreplication/binlogstream.py", line 408,...

BlackWatchuser

AssertionError: Result length not requested length:

14

We are using pg_chameleon for replicating data from MySQL to PostgreSQL and pg_chameleon is using python-MySQL-replication internally. We are getting below error during replication. Is there any way to resolve...

rahilsh

Duplicate event when using `auto_position` and losing mysql connection

1

Hi, We're using `auto_position` option and we notice some strange behavior when the MySQL connection drops. Our setup is as follow: One MySQL master with 2 read-only replicas. We're doing...

MikaYuoadas

If binlog has been removed due to expire_log_days(), there's no way to replicate data?

1

Hello. I'm trying to replicate data from mysql, but my binlog has been removed due to expire_log_day. But I can't get the binlog back by turing on/off my db, because...

joseya7