At which minor version release do people generally choose to use a major version of TiDB in production?

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

Original topic: 大家一般tidb大版本发行到几个小版本才选择用到生产

| username: xingzhenxiang

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] Generally, how many minor versions after a major TiDB release do people choose to use it in production?
[Encountered Issues: Problem Symptoms and Impact]

| username: Miracle | Original post link

It is generally recommended to use the latest minor version of the relatively new major version.

| username: 托马斯滑板鞋 | Original post link

At least 3, and the latest version is still only deployed in the test environment :upside_down_face:

| username: TiDBer_jYQINSnf | Original post link

Consider using the new version six months after its release, but it is not recommended to immediately upgrade for critical business. It is only recommended for trial with new business.

| username: xingzhenxiang | Original post link

Thank you for the response. Do you have production versions 7.1.x or v7.5.x?

| username: xingzhenxiang | Original post link

Which version are you currently using?

| username: xingzhenxiang | Original post link

Does your company have version 7 or above? Could you provide a reference for the specific versions involved?

| username: Miracle | Original post link

Currently, we are still using version 6.5. Generally, we don’t upgrade unless there are critical flaws or particularly needed new features. The main focus for a database is stability.

| username: TiDBer_jYQINSnf | Original post link

7.+ hasn’t been released yet. The latest version is 6.5.8, but the main version in use is 5.4.

| username: 连连看db | Original post link

Using version 5, we generally don’t change the version once it’s selected, unless there’s a need for specific features or bug fixes, then we consider upgrading. If the company is just starting to use TiDB, it’s recommended to go directly with version 6.5+.

| username: xingzhenxiang | Original post link

Is there currently a version 8.0 of MySQL?

| username: xingzhenxiang | Original post link

After MySQL 5.7 reaches EOL, are you considering upgrading to 8.0? Is TiDB compatibility with 8.0 under consideration?

| username: xingzhenxiang | Original post link

Is there a MySQL version 8.0+?

| username: TiDBer_jYQINSnf | Original post link

If the business volume reaches a certain level, TiDB should be used instead of MySQL.

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

Generally, older versions are used. Previously, we used version 5.4.3, and recently we upgraded to 6.5.8. We haven’t used version 7 yet. If you are considering migrating from MySQL to TiDB, first consider whether your business volume has reached a certain level. For small data volumes, single-machine MySQL performs better than TiDB. Don’t migrate just for the sake of migrating.

| username: Miracle | Original post link

We are not using version 8.0+ in production for the time being.

| username: xingzhenxiang | Original post link

My business database is MySQL, and the summary database is TiDB. After MySQL 5.7 EOL, the compatible version of AWS Aurora RDS MySQL 5.7 has a lifecycle. Considering that the business database has already been upgraded, I’m afraid that not upgrading the summary database might bring unknown impacts.

| username: onlyacat | Original post link

Just follow the LTS for TiDB, like 5.4, 6.5, etc.

| username: zhanggame1 | Original post link

I think it will take at least version 7.5 or later.

| username: Jellybean | Original post link

The relatively new LTS versions are v7.5, v7.1, and v6.5.

Typically, production environments do not choose the latest v7.5 version, but considering all factors, v7.1 can be considered.

For testing environments, it is recommended to use the latest v7.5.