sync-diff-inspector: Compatibility with MySQL 8.4.0

[dveeden]

Feature Request

MySQL 8.4.0 is a LTS release that has removed some deprecated commands and variables like SHOW MASTER STATUS. It looks like sync-diff-inspector is using some of this and needs to be updated.

tidb-tools/sync_diff_inspector/utils/pd.go

Line 271 in a005a94

query := "SHOW MASTER STATUS;"

tidb-tools/pkg/dbutil/common.go

Line 649 in a005a94

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

tidb-tools/tests/sync_diff_inspector/snapshot/run.sh

Line 15 in a005a94

mysql -uroot -h 127.0.0.1 -P 4000 -e "show master status" > $OUT_DIR/ts.log