[TiDBer Chat Session 88] Regarding TiDB's Compatibility with MySQL 8.0, What Feature/Functionality Do You Most Want to Be Supported?

Translated
1

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

Original topic: 【TiDBer 唠嗑茶话会 88】关于 TiDB 兼容 MySQL 8.0 ，你最想支持的特性/功能是什么？

| username: Billmay表妹

After MySQL 5.7 reached EOL, community members have been frequently inquiring about MySQL 8.0, as shown in the image. Many features and functionalities of MySQL 8.0 have been made compatible since version 7.3!

If you wish to be compatible with 8.0 and use it in a production environment, you can consider TiDB v7.5 and later versions!

This Topic:

Regarding TiDB’s compatibility with MySQL 8.0, what feature/function do you most want to be supported?

TiDB v7.3 Compatibility with MySQL 5.7 and MySQL 8.0

Documentation on TiDB v7.3’s compatibility with MySQL 5.7 and MySQL 8.0:

Further Reading:

Here are some issues related to TiDB’s compatibility with MySQL that might interest you:

Event Rewards:

Participation Award

Participate in this discussion to receive 30 points reward~

Event Duration:

2023.9.28-2023.10.13

2
| username: Kongdom | Original post link

:yum: Perfect compatibility~
Recently, I’ve been having a lot of trouble with MySQL 8.0~

3
| username: ShawnYan | Original post link

MySQL 8 is not even compatible with itself, just directly support MySQL 8.1.

4
| username: xfworld | Original post link

The diagram makes it very clear. Except for GIS, FULLTEXT, and skip locked lateral join, it is basically compatible.

Is it possible to provide another method: to read MySQL data through TiDB…

Mount MySQL as a data source to TiDB, and read it through TiDB’s JDBC…

5
| username: tomxu | Original post link

Observing and learning~

6
| username: Fly-bird | Original post link

Compatible with MySQL 5 and 8

7
| username: waeng | Original post link

Basically, it’s enough.

8
| username: 像风一样的男子 | Original post link

Need GIS functionality

9
| username: Miracle | Original post link

Memory management

10
| username: dba-kit | Original post link

Stored procedures, character/collation compatibility (got burned several times, converting from utf8mb4 to utf8, MySQL 8.0’s utf8mb3…)

11
| username: Z六月星星 | Original post link

It would be great if stored procedures were supported.

12
| username: Soysauce520 | Original post link

Can you make an Oracle ASH?

13
| username: 大飞哥online | Original post link

Perfect compatibility

14
| username: Jellybean | Original post link

You’re absolutely right, MySQL itself can’t fully be compatible with itself, so TiDB just needs to achieve compatibility with the greatest common divisor.

15
| username: 昵称想不起来了 | Original post link

Stored procedure

16
| username: 索隆爱喝酒 | Original post link

Memory management and stored procedures

17
| username: datamz | Original post link

The features I most want to support are: stored procedures, functions, user-defined functions, CTAS (Create Table As Select) syntax, and full-text indexing.