Does DM v7 currently not support migrating versions above MySQL 8.0?

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

Original topic: dm v7版本目前不支持迁移mysql8.0以上的版本吗

| username: andone

Does DM version 7 currently not support migrating versions above MySQL 8.0?

| username: chenhanneu | Original post link

I have migrated MySQL 8.0 several times using DM. Some adjustments are needed in certain areas, such as COLLATE=utf8mb4_0900_ai_ci, which is not yet supported in version 7.1.

| username: andone | Original post link

Does it also support MySQL version 8.0 and above?

| username: chenhanneu | Original post link

Yes, it can be used. When configuring the task, first check-task. During the load phase, some tables may not be created, so you need to create them manually and then resume the task.

| username: tidb菜鸟一只 | Original post link

TiDB 7.4 supports MySQL 8 syntax,

but DM does not mention support for MySQL 8,

| username: Kongdom | Original post link

You can refer to this, it is currently experimentally supported. :thinking: My understanding is that it is supported, but there may be potential risks.
image

| username: TiDBer_小阿飞 | Original post link

It should be either not fully supported or fully compatible.

| username: andone | Original post link

Okay, thank you all for your answers.

| username: zhanggame1 | Original post link

You can give it a try. I did a simple test and didn’t find any issues.

| username: 江湖故人 | Original post link

  • Experimental Support: Although partially validated, testing has not covered all preset scenarios or has few users, posing a risk of errors in a small number of scenarios.
| username: Jellybean | Original post link

When DM performs a full data migration from MySQL 8.0, there might be compatibility issues with the internal dumpling tool. Incremental synchronization should be fine.

It is recommended to thoroughly test and validate in your own business scenario before using it.

| username: dba远航 | Original post link

MYSQL8 support should not have passed the final verification yet.