Linux Service Chapter Four: building MySQL server

Linux Service Chapter Four: building MySQL server

MySQL is a small open-source relational database management system, the developer of the Swedish MySQL AB, currently belonging to the Oracle company, MySQL is widely used in small and medium-sized web sites on the Internet. Because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownership of the site chose MySQL as the site database.

For the current mainstream of the lamp architecture, MySQL is to get your IT operations, DBAs favor, currently MySQL has been orcacle acquisition, but the good news is that the original MySQL founder has independently developed a mariadb, and the use of more and more people. And MARIADB is compatible with all MySQL functions and related parameters.

MySQL commonly used two big engines have MyISAM and InnoDB, then they have what obvious difference, what kind of occasion use what engine?

The MyISAM type of table emphasizes performance, which is performed more quickly than the InnoDB type, but does not provide transactional support, and if a large number of select operations are performed, MyISAM is a better choice to support table locks.

InnoDB provides transaction support transactions, external keys and other advanced database functions, performs a large number of inserts or update, for performance reasons, should use the InnoDB table, support row lock.

There are two ways to install MySQL, one is yum/rpm installation, the other is tar source installation.

1, Yum installation method is very simple, the following commands can be executed:

1.1, start the installation,

This article from "Bershir-system operation and Maintenance" blog, reproduced please contact the author!

Linux Service Chapter Four: building MySQL server