MySQL entry (2), mysql entry

MySQL entry (2), mysql entry
I. MySQL Overview

MySQL is a very popular open source database. when I switched from Oracle to MySQL, I felt the most profound point was that this guy was actually separated by Server and Storage! What's more, it turns out to be a plug-in storage engine. The characteristics of each engine are quite different. At that time, I felt that it was too difficult to learn, how many engines should I learn. Later, I found that I don't need to learn anything, because the most widely used engines are InnoDB and MyISAM. After 5.5, InnoDB became popular, therefore, many DBAs only need to master InnoDB.

This figure is an illustration in high-performance MySQL, which roughly illustrates the MySQL architecture. The most interesting part is plug-in storage engine. Although InnoDB is widely used, there are still many engines suitable for different scenarios, such as the column-based storage engine infobright, which is the first-class data warehouse, such as tokuDB, with first-class insertion efficiency, the compression ratio is also extremely high, which is very suitable for storing log archive data. This is the benefit of the plug-in storage engine, with the most suitable storage engine.

2. MySQL Branch

All the useful open-source software has branches. For Linux, MySQL is no exception. MySQL now has two major branches: MariaDB and Percona Server. In fact, I think Percona Server is called a branch, but it is not as good as MySQL's enhance version, because I personally think Percona Server is more focused on improving performance. In addition, the XtraBackup and pt-tookit released by Percona are easy to use. These tools allow DBAs to become even more powerful when managing MySQL. When I wrote this article, Percona Server did not officially launch version 5.7, but it already has a candidate version.

In addition, the famous high-performance MySQL author is written by Percona engineers. It is a classic in the MySQL field, not one of them.

After Sun acquired MySQL AB, the Founder launched MariaDB. MariaDB versions to 5.5 are consistent with the official version, but then the version 10 is started directly. MariaDB is more concerned with new functions. For example, the official version of Hash Join has not yet implemented the algorithm, such as the official version of 5.7, which is released in parallel.

Previously, we found that CentOS has replaced MySQL with MariaDB. According to the data, companies such as Facebook and Google have also switched to MariaDB. They are said to be concerned about open source risks. In fact, many large companies have their own patch capabilities for MySQL, so they all have their own branches.

 

 

Bytes ------------------------------------------------------------------------------------------------------------------------------

Today, I wrote so many messy things that it seems useless. However, even if I warm up, I may be able to hear the excitement of learning.