CDC for MySQL 8.4

[yuhao-su]

There are some changes in MySQL 8.4. For example SHOW MASTER STATUS, which is used for get the bin log position, does not exist.

[cyliu0]

https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html#mysqld-8-4-0-deprecation-removal

SQL statements removed. The following SQL statements have been removed (replacements in brackets): START SLAVE (START REPLICA); STOP SLAVE (STOP REPLICA); SHOW SLAVE STATUS (SHOW REPLICA STATUS); SHOW SLAVE HOSTS (SHOW REPLICAS); RESET SLAVE (RESET REPLICA); CHANGE MASTER TO (CHANGE REPLICATION SOURCE TO); RESET MASTER (RESET BINARY LOGS AND GTIDS); SHOW MASTER STATUS (SHOW BINARY LOG STATUS); PURGE MASTER LOGS (PURGE BINARY LOGS); and SHOW MASTER LOGS (SHOW BINARY LOGS).

[cyliu0]

Now we can't create MySQL CDC shared source on MySQL 8.4 since the above MySQL changes.

[StrikeW]

SHOW MASTER STATUS is replaced by SHOW BINARY LOG STATUS
https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html