julien-duponchelle / julien-duponchelle/python-mysql-replication

Compatibility Issue with MySQL 8.4+ - SHOW MASTER STATUS Deprecated in binlogstream.py

Open Beginner friendly
#627 7 comments 7 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
2.4k
Forks
690
PR merge metrics
No merged PRs in 30d

Description

## Description:
This project has been tested and confirmed to work with MySQL versions up to 8.0.4.
However, for users attempting to use this library with MySQL 8.4 or later, there is a compatibility issue.
The `SHOW MASTER STATUS` query, which is used in the `binlogstream.py` file, i[s deprecated in MySQL 8.4 and replaced by `SHOW BINARY LOG STATUS`.](https://dev.mysql.com/doc/refman/8.4/en/show-master-status.html)

As a result, when running the library with MySQL 8.4 or newer versions, the SHOW MASTER STATUS query will fail

Contributor guide

Open the contributing guide

Research direction

Start by opening binlogstream.py and locating the SHOW MASTER STATUS query. Verify the replacement against the linked MySQL 8.4 documentation; the work is done when the library can retrieve binary log status with MySQL 8.4 or newer without the deprecated query failing.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, python
Domain
databases
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Quiet
Clarity
Clearly specified
Newbie friendliness
72/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.