Failed to Add MySQL 8.0 Data Source in DM 2.0

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: dm 2.0添加MySQL8.0数据源失败

| username: TiDBer_OB4kHrS7

【TiDB Usage Environment】Production Environment
【TiDB Version】V5.3
【Reproduction Path】Failed to add MySQL 8.0 data source with DM 2.0
【Encountered Problem: Phenomenon and Impact】
【Resource Configuration】
【Attachments: Screenshots/Logs/Monitoring】


| username: yulei7633 | Original post link

DM does not support MySQL 8 well, nor does it support 5.6. Currently, it seems to only support 5.7.

| username: TiDBer_OB4kHrS7 | Original post link

It is possible to create tdsql-c 8.0 using DM, so I don’t understand.

| username: yulei7633 | Original post link

I suggest you try the same method with 5.7. There should be no problem with 5.7. It is not fully supported for 8.0.

| username: TiDBer_OB4kHrS7 | Original post link

No issues with 5.7, but it’s my first time using 8.0, so I encountered the error mentioned above when trying to create it.

| username: yulei7633 | Original post link

This indicates that the support for 8.0 is not good. TiDB has very good support for 5.7, but incomplete support for 5.6 and 8.0.

| username: 有猫万事足 | Original post link

Have you tried upgrading the DM version?
2.0 is a bit outdated.

| username: yulei7633 | Original post link

Once there is any news, you can reply here. I have been following this closely as well.

| username: TiDBer_OB4kHrS7 | Original post link

After a while, the administrator will close the thread.

| username: TiDBer_OB4kHrS7 | Original post link

I remembered incorrectly, the DM version is already 5.1.

| username: yulei7633 | Original post link

[root@localhost ~]# tiup list dm
Available versions for dm:
Version                       Installed  Release                    Platforms
-------                       ---------  -------                    ---------
nightly -> v1.12.2-nightly-3             2023-06-07T10:05:12Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.0.9                                   2020-08-21T18:34:30+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.1.0                                   2020-08-28T18:40:59+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.1.1                                   2020-09-01T21:34:50+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.1.2                                   2020-09-11T20:40:23+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.2.0                                   2020-09-29T17:32:32+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.2.1                                   2020-10-23T18:25:12+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.2.3                                   2020-10-30T19:17:34+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.2.4                                   2020-11-19T21:09:29+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.2.5                                   2020-11-27T18:09:14+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.3.0                                   2020-12-18T19:05:10+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.3.1                                   2020-12-31T17:41:15+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.3.2                                   2021-03-02T14:59:45+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.3.3                                   2021-03-04T20:43:34+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.3.4                                   2021-03-05T19:38:51+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.3.5                                   2021-03-11T21:22:13+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.3.6                                   2021-03-19T20:04:17+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.3.7                                   2021-03-25T18:05:58+08:00  darwin/amd64,linux/amd64,linux/arm64
v1.4.0                                   2021-03-31T09:20:06Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.4.1                                   2021-04-07T11:58:21Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.4.2                                   2021-04-26T03:57:45Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.4.3                                   2021-05-13T03:42:27Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.4.4                                   2021-05-27T05:05:02Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.5.0                                   2021-06-09T04:32:05Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.5.1                                   2021-06-11T07:05:24Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.5.2                                   2021-06-24T06:58:27Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.5.3                                   2021-07-15T03:44:03Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.5.4                                   2021-08-05T07:16:59Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.5.5                                   2021-08-19T04:07:43Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.5.6                                   2021-09-01T08:45:40Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.6.0                                   2021-10-09T03:59:46Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.6.1                                   2021-10-21T06:26:35Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.7.0                                   2021-11-15T03:54:20Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.8.0                                   2021-12-06T10:55:16Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.8.1                                   2021-12-20T09:43:58Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.8.2                                   2022-01-11T06:16:14Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.9.0                                   2022-02-10T06:51:04Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.9.1                                   2022-02-24T08:00:12Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.9.2                                   2022-03-10T07:18:29Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.9.3                                   2022-03-24T10:23:50Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.9.4                                   2022-04-12T15:43:13Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.9.5                                   2022-05-10T10:26:40Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.9.6                        YES        2022-05-20T08:03:06Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.10.0                                  2022-06-08T10:31:35Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.10.1                                  2022-06-09T09:02:02Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.10.2                                  2022-06-16T11:54:57Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.10.3                                  2022-08-12T05:50:40Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.11.0                                  2022-09-23T11:59:33Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.11.1                                  2022-11-24T06:22:03Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.11.2                                  2023-02-02T09:25:24Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.11.3                                  2023-02-14T07:26:01Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.12.0                                  2023-03-31T12:38:02Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.12.1                       YES        2023-04-13T10:31:21Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.12.2-nightly-3                        2023-06-07T10:05:12Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
v1.12.2                                  2023-05-19T10:12:51Z       darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
[root@localhost ~]#
| username: TiDBer_OB4kHrS7 | Original post link

| username: yulei7633 | Original post link

The versions of dm and tidb seem to be consistent.

| username: TiDBer_OB4kHrS7 | Original post link

Yes, v1.12.2 should be the version of tiup.

| username: yulei7633 | Original post link

tiup dm upgrade dm-test v7.0.0 dm can also be upgraded to version v7.0.0
[root@localhost ~]# tiup dm list
tiup is checking updates for component dm …
A new version of dm is available:
The latest version: v1.12.2
Local installed version: v1.12.1
Update current component: tiup update dm
Update all components: tiup update --all

Starting component dm: /root/.tiup/components/dm/v1.12.1/tiup-dm list
Name User Version Path PrivateKey


dm-test tidb v7.0.0 /root/.tiup/storage/dm/clusters/dm-test /root/.tiup/storage/dm/clusters/dm-test/ssh/id_rsa

| username: TiDBer_OB4kHrS7 | Original post link

Production will not be upgraded. If any issues arise, it’s hard to say. Stability comes first.

| username: yulei7633 | Original post link

I’m currently just in the learning phase, doing things casually. You can’t mess around in production.

| username: Billmay表妹 | Original post link

v7.1.0 is only partially compatible with MySQL 8.0, while MySQL 5.7 is highly compatible.

| username: lance6716 | Original post link

You can try using DM version 6.5 or above. Here is the fix record for this issue:

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.