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

[why-arong]

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, is deprecated in MySQL 8.4 and replaced by SHOW BINARY LOG STATUS.

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

[sean-k1]

@why-arong cool!
Do you mind make pr for this issue?

[why-arong]

Yeah sure. It seems the MySQL team is officially updating their terminology, so the syntax is gradually changing...

However, I'm curious whether there are plans to maintain this project to support MySQL 8.4 and above.
If we're just looking to resolve this immediate issue, we could implement a version check and use different queries accordingly.
Though I haven't verified it myself yet, I wonder if there might be other issues due to features that have been removed or deprecated in version 8.4?
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html#mysql-nutshell-deprecations

[sean-k1]

@why-arong
It seems the best approach is to handle it by branching the logic for versions before and after 8.4.
It seems that many Master commands are being removed in version 8.4. I’ll investigate how these commands are being used in our project.

[raven-kg]

Any updates here?

[matt-snider]

@raven-kg I see you fixed this in c442393. Could you submit it as an MR?

I notice there is also resetBinLog() in tests/base.py:L157 , which appears to cause an issue with RESET MASTER. This should be changed to [RESET BINARY LOGS AND GTIDS](https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html) according to the docs

[raven-kg]

@matt-snider actually I did this just for myself and now I am waiting for it to be fixed in the main repo. The main problem of my version is that I tried to implement gtid related changes as well but I haven't tested them. So I can't recommend these changes to upstream, as it could open Pandora's box for some people. In my environment I only use classic replication and it works fine.
I also tried to update the tests and add some new test environments, but it turned out to be a lot of effort and I unfortunately didn't have that much time