DM: Support MySQL 8.4

[dveeden]

Is your feature request related to a problem?

MySQL 8.4 removes things like SHOW MASTER STATUS. These have been replaced with SHOW BINARY LOG STATUS.

So things like this needs an update:

tiflow/dm/pkg/conn/utils.go

Line 112 in be15534

rows, err := db.QueryContext(ctx, `SHOW MASTER STATUS`)

tiflow/dm/pkg/conn/db.go

Line 108 in be15534

rows, err := db.QueryContext(ctx, `SHOW SLAVE HOSTS`)

This should be done without breaking compatibility with MySQL 8.0, 5.7 or MariaDB

Describe the feature you'd like

.

Describe alternatives you've considered

No response

Teachability, Documentation, Adoption, Migration Strategy

No response

[dveeden]

/area dm
/label compatibility

[ti-chi-bot]

@dveeden: The label(s) compatibility cannot be applied. These labels are supported: duplicate, bug-from-internal-test, bug-from-user, ok-to-test, needs-ok-to-test, affects-5.4, affects-6.1, affects-6.5, affects-7.1, affects-7.5, affects-8.1, may-affects-5.4, may-affects-6.1, may-affects-6.5, may-affects-7.1, may-affects-7.5, may-affects-8.1, needs-cherry-pick-release-5.4, needs-cherry-pick-release-6.1, needs-cherry-pick-release-6.5, needs-cherry-pick-release-7.1, needs-cherry-pick-release-7.5, needs-cherry-pick-release-8.1, question, release-blocker, wontfix, MariaDB.

In response to this:

/area dm
/label compatibility

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.

[dveeden]

cc @lance6716

[lance6716]

/assign @lyzx2001

[dveeden]

Related: go-mysql-org/go-mysql#866