What are the advantages and disadvantages of TokuDB

This article mainly explains "what are the advantages and disadvantages of TokuDB". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "What are the advantages and disadvantages of TokuDB"!

TokuDB Benefits

1 High compression ratio, zlib is used for compression by default, especially for string (varchar,text, etc.) types, which is more suitable for storing logs, raw data, etc. Generally 5-10 times compression ratio.

2 Support online field add, delete, expand, rename operations.

3 Support complete ACID features and transaction mechanisms

4 Support fast write scenarios, Fractal-tree has advantages in transaction implementation, no undo log

TokuDB Disadvantages

1, response time is relatively long

2, online ddl does not apply to fields of type text,blob, etc.

3. There is no perfect hot backup tool. At present, there are backup schemes and logical backups recommended by Alibaba Cloud database team.

Recommended scenarios:

1 Infrequently accessed data or historical data archive

Table 2 is very large and requires ddl operations from time to time

How to choose TokuDB compression algorithm

tokudb_zlib: table enables zlib compression, compression effect is moderate, CPU consumption is moderate, recommended to use (default);

tokudb_quicklz: table enables quicklz compression, poor compression effect, low CPU consumption;

tokudb_lzma: table Enable lzma compression, good compression effect, high CPU consumption.

TokuDB default compression algorithm is zlib, it is recommended that you do not modify, because zlib compression is very cost-effective.

At this point, I believe that everyone has a deeper understanding of "TokuDB advantages and disadvantages", so let's actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!