DM: Support MySQL 8.0 compressed binlog

[dveeden]

Is your feature request related to a problem?

tiflow/dm/pkg/checker/mysql_server.go

Lines 38 to 48 in 77f8196

	// SupportedVersion defines the MySQL/MariaDB version that DM/syncer supports
	// * 5.6.0 <= MySQL Version < 8.0.0.
	var SupportedVersion = map[string]struct {
	Min MySQLVersion
	Max MySQLVersion
	}{
	"mysql": {
	MySQLVersion{5, 6, 0},
	MySQLVersion{8, 0, 0},
	},
	}

When creating a task with a MySQL 8.0 source:

			{
				"id": 0,
				"name": "mysql_version",
				"desc": "check whether mysql version is satisfied",
				"state": "warn",
				"errors": [
					{
						"severity": "warn",
						"short_error": "version suggested less than 8.0.0 but got 8.0.29"
					}
				],
				"extra": "address of db instance - 127.0.0.1:39135"
			}

Describe the feature you'd like

Support MySQL 8.0

Describe alternatives you've considered

No response

Teachability, Documentation, Adoption, Migration Strategy

No response

[dveeden]

/area dm

[lance6716]

There is a MySQL 8.0 features that will break the replication #5141 . And we have not fully utilized new features like https://dev.mysql.com/worklog/task/?id=4618 . A long way to go!

[dveeden]

There is a MySQL 8.0 features that will break the replication #5141 . And we have not fully utilized new features like https://dev.mysql.com/worklog/task/?id=4618 . A long way to go!

Could we convert this check from a version based check to a feature based one? In this case to check if binlog compression is enabled instead of checking if the server is running MySQL 8.0.0 or newer?

Also, shouldn't this check be (also) done when defining the source instead of only when defining the task?