Shulou(Shulou.com)05/31 Report--

This article mainly talks about "what are the differences between hbase and mysql". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what's the difference between hbase and mysql?"

Differences: 1, MySQL is row storage mode, hbase is column storage mode; 2, the bottom layer of MySQL is binlog,hbase is hdfs;3, MySQL is mainly used to store business data, the amount of data storage is small, while HBase is mainly used to store massive business data and log data, which has a large amount of data storage.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

MySQL + HBase are two databases commonly used in our daily applications, which solve the online transaction problem of the application and the mass storage problem of big data scene respectively.

Comprehensive comparison

MySQL: is a commonly used database, using row storage mode, the bottom layer is binlog, used to store business data, the amount of data storage is small.

HBase: column database, the underlying is hdfs, can store huge amounts of data, mainly used to store massive business data and log data.

See the difference from the comparison of architecture

Compared to the architectural features of MySQL,HBase:

1. Fully distributed (data fragmentation, fault self-recovery)

two。 The underlying layer uses HDFS (storage computing separation).

Capability differences seen by the architecture:

1. MySQL: simple operation and maintenance (few components), low latency (short access path)

2.HBase: good scalability, built-in fault-tolerant recovery and data redundancy

Differences in engine structure

Compared to the internal engine features of MySQL,HBase:

1. HBase does not have sQL engine natively (cannot be accessed by sQL, use APlI). Cloud HBase enhanced (Lindorm) and open source Phoenix both provide sQL capabilities.

2.HBase uses the LSM (Log-Structure Merge) tree, and Innodb uses the B+ tree.

The capability differences seen by the engine architecture (B+Tree vs LSM Tree):

1.MySQL: balanced reading and writing, presence of space debris

2. HBase: focus on writing, compact storage, no waste, Io magnification, strong data import ability

Data access

What they have in common: the data is logically organized by the model of the table, and the application is used to add, delete, modify and check the data.

The difference: MySQL has more SQL functions: stronger transaction capabilities. HBase can not only use APIl for more flexible and better performance access, but also use standard sQL access with Phoenix. Only single-line transactions are supported.

At this point, I believe you have a deeper understanding of "what's the difference between hbase and mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.