Getting Started with MySQL (ii)

a MySQL overview

MySQL is a very popular open source database, when I turn from Oracle to do MySQL, the most profound thing is that this guy actually is the server and storage separate! And even more can not endure is, it unexpectedly is plug-in storage engine, each kind of engine characteristics is very different, at that time I feel this thing is too difficult to learn, I have to learn how many engines ah. Later I found that I did not need to learn anything, because now the most used engines are basically only InnoDB and MyISAM, and after 5.5, InnoDB the way, so a lot of DBAs only need to be proficient in innodb.

This picture is an illustration of high performance MySQL, which outlines the MySQL architecture, the most interesting of which I think is the plug-in storage engine. Although InnoDB is widely used now, there are many engines for different scenarios, such as the Columnstore engine infobright, a data warehouse first-class, such as Tokudb, with first-class insertion efficiency, compression ratio is also very high, ideal for storing log archive data. This is the benefit of the plug-in storage engine, with the most appropriate storage engine.

two branch of MySQL

Good open source software has branches, Linux so, MySQL is no exception. MySQL now has two large branches, mariadb and Percona Server. In fact I think Percona server called branch, rather than call MySQL version enhance, because I personally think, Percona server more attention to enhance performance. In addition Percona company released Xtrabackup and Pt-tookit easy to use to no friends, these weapons can let DBAs in the management of MySQL. Percona server did not formally launch version 5.7 when I wrote this, but I have a candidate version.

In addition, the famous "high-performance MySQL" is the author of Percona company's engineers wrote, is called the classic MySQL world, not one of the kind.

After MySQL AB was acquired by Sun, the founders released MARIADB. MARIADB version number to 5.5 is consistent with the official version, but then directly started the 10 version number. MARIADB more attention to new features, such as the official version of the hash join is not yet implemented algorithms, such as the parallel copy of the official version of the 5.7 feature.

Previously discovered that CentOS had replaced MySQL with mariadb, according to data that Facebook,google and other companies have turned to mariadb, they are said to be concerned about the risk of open source. In fact, many large companies have their own to the MySQL patch ability, so they have their own branches.

--------------------------------------------------------------------------------------------------------------- ---------------

Today wrote so many messy, it seems to listen to no use, but even if it is warm-up, listen to the lively may be able to arouse interest in learning.

Getting Started with MySQL (ii)