Protocols Supported by TiDB

Translated
1

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

Original topic: tidb支持的协议

| username: TiDBer_h9um7nOg

To improve efficiency, please provide the following information. Clear problem descriptions can be resolved more quickly:
【TiDB Usage Environment】Production, Testing, Research
【TiDB Version】
【Encountered Problem】
Does TiDB now support the MySQL 8.0 protocol?
【Reproduction Path】What operations were performed to encounter the problem
【Problem Phenomenon and Impact】

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

If the question is related to performance optimization or fault troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

2
| username: HACK | Original post link

It should not be supported currently, but future versions should support it.

3
| username: TiDBer_h9um7nOg | Original post link

Oh, I see.

4
| username: cs58_dba | Original post link

It should not be supported, but TiDB has also optimized features like online DDL.

5
| username: 啦啦啦啦啦 | Original post link

Currently, it mainly supports MySQL 5.7 and 8.0. There are significant differences in usage between 5.7 and 8.0, but some features of 8.0 that do not conflict with 5.7, such as invisible indexes, are also supported.

6
| username: 张雨齐0720 | Original post link
  • Compatible with MySQL 5.7 protocol and MySQL ecosystem: TiDB is compatible with MySQL 5.7 protocol, commonly used MySQL features, and the MySQL ecosystem. Applications can migrate from MySQL to TiDB with little or no code modification. It provides a rich set of data migration tools to help applications complete data migration conveniently. TiDB 简介 | PingCAP 文档中心
7
| username: cs58_dba | Original post link

I hope support for 8.0 will be available soon. Version 5.7 will no longer be maintained in 2023, and I’ve heard that version 9.0 is about to be released.

8
| username: HACK | Original post link

Is MySQL 8.0 widely used now?

9
| username: cs58_dba | Original post link

We use it quite a lot. Last year, one-third of our MySQL instances at the parent company were already upgraded to 8.0, and we will continue to upgrade this year.

10
| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.