julien-duponchelle / julien-duponchelle/python-mysql-replication
Compatibility Issue with MySQL 8.4+ - SHOW MASTER STATUS Deprecated in binlogstream.py
- 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
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