MYSQL Extended Storage Engine

MYSQL Extended Storage Engine


Here are a few of the Columnstore engines (all two versions: Community Edition, Commercial Edition):


One: Tokudb


Tokudb is a high-performance, transactional-enabled MySQL and MariaDB storage engine. The main feature of TOKUDB is the support for high write pressure.


Tokudb V7 was released.
Starting with this release TOKUDB announces open source, the open source Community version provides full functionality and performance, no downtime for column additions, deletions and renames, and index creation, the second primary key for the cluster. It also improves the enterprise version, including additional support packages and advanced backup and recovery tools.


TOKUDB uses indexes to speed up queries, is highly scalable, and supports hot scheme modification.


Characteristics:
1. Fast insertion performance 20~80 times;
2. Compress data to reduce storage space;
3. The amount of data can be extended to several terabytes;
4. No index fragmentation is generated;
5. Support Hot column addition, hot indexing, MVCC;


How to consider using:
1. If you want to store the blob, do not use tokudb because his record is not too large;
2. If the record count is over billion, use Tokudb;
3. If you pay attention to the performance of update, do not use TOKUDB, he did not innodb fast;
4. If you want to store the old records, use TOKUDB;
5. If you want to reduce the storage space occupied by the data, use TOKUDB;


II: Infobrigh (Infobright Community Edition only supports load data operations)


Infobright is an open source MySQL data warehousing solution that introduces columnstore scenarios, high-intensity data compression, optimized statistical calculations (like Sum/avg/group by, etc.),


Infobright is MySQL-based, but does not install MySQL, because it has its own one. MySQL can be divided into logical layer and physical storage engine, infobright mainly implement is a storage engine, but because its own storage logic and relational database is fundamentally different, so, it does not like InnoDB as directly as plug-in hook to MySQL, Its logical layer is the logical layer of MySQL plus its own optimizer.


1, high compression ratio, the average compression ratio can reach 10:1, or even up to 40:1, I use Infobright to save 3.1G of data into less than 300M.


2, column storage, even if the amount of data is very large, query speed is fast. For the Data warehouse, the processing of large amounts of data is not a set.


3, does not need to build index, avoids maintains the index and the index as the data expands the question. Each column of data block compressed storage, each block has a knowledge grid node record block statistics, in place of the index, speed up the search.


4. Single server can read and write 30T data efficiently. Extensible, this means that for the same query, when the amount of data is 10T, it should not consume more time than 1T data volume, basically is an order of magnitude.


Three: Infinidb


INFINIDB:INFINIDB Community Edition (Community Edition) provides a scalable, analytic database engine that is primarily developed for data warehousing, business intelligence, and applications that are less demanding in real time. Based on MySQL build. Includes support for querying, transaction processing, and large data volume loading. There are not many users.




Engine Selection Recommendations:


1. Preferred InnoDB

2. Secondly, it is recommended to study tokudb, INFINIDB

Description: Self summary and network collation.

MYSQL Extended Storage Engine