Upgrade for Surprises, Act Quickly!

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

Original topic: 升级有惊喜,快快行动吧!

| username: h5n1

After upgrading from version 5.2.3 to 7.5.0, the disk write volume has significantly decreased, various latencies have greatly reduced, and the overall QPS has improved. The only downside is that the IOPS and disk utilization have increased (HDD).

image

| username: oceanzhang | Original post link

It’s already 7.5, HDD disks really don’t work.

| username: TiDBer_jYQINSnf | Original post link

Did you enable this? Partitioned Raft KV
In principle, enabling this would significantly reduce read and write amplification.

| username: oceanzhang | Original post link

What is this feature?

| username: h5n1 | Original post link

It can only be enabled during initialization; the upgraded version won’t work.

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

Awesome!

| username: xingzhenxiang | Original post link

Directly 7.5.0, a true warrior.

| username: TiDBer_jYQINSnf | Original post link

It can be understood as one region per RocksDB. The advantage of this is that compaction between regions will not affect each other, and each will handle its own. Previously, mixing them together would cause mutual interference, leading to read and write amplification.

| username: Jellybean | Original post link

The Partitioned Raft KV feature has only been supported since v6.6.0 and is still an experimental feature in v7.5.0, making it inconvenient to enable in production environments. Additionally, it can only be set during the initial deployment of a new cluster.

I’ve heard that this feature has not been advanced due to prioritization issues and there is a possibility that it might be canceled in the future.

| username: Jellybean | Original post link

Boss, your IOPS increase should be a normal phenomenon since the business QPS has gone up.

From v5 to v7.5, did you make any adaptations or compatibility adjustments on the business side? Do you have any other experiences or pitfalls to share?

| username: zhanggame1 | Original post link

Can an HDD really run it?

| username: heiwandou | Original post link

Upgrading has its benefits!

| username: h5n1 | Original post link

Yes, it’s normal. For less important databases, they are usually upgraded directly after data entry and a small number of queries, and there are no major issues.

| username: 这里介绍不了我 | Original post link

This title really makes people want to click in.

| username: TiDBer_jYQINSnf | Original post link

Did this feature encounter any issues? Why is it being canceled? It sounded pretty good when it was introduced.

| username: wangccsy | Original post link

What kind of magic is there?

| username: Jellybean | Original post link

There are likely other higher priority tasks being worked on, such as further enhancing stability and performance. Additionally, after a comprehensive evaluation, the risk-reward ratio is not as high as expected. The features of PRKV are not currently a priority for advancement, but it can still be used in the testing environment.

| username: Kongdom | Original post link

:flushed: This directly discourages the use of HDDs~

| username: forever | Original post link

As long as the business can meet the requirements, it’s not a big problem. :stuck_out_tongue_winking_eye: