Mysql DBA Advanced Operations Learning Note-mysql Multiple installation methods for the database

3.1 MySQL Database installation

3.1.1 yum/rpm mode installation

Note: The yum/rpm way to install MySQL is suitable for all MySQL software PRODUCT families.

(1) RPM package installation MySQL
We have to install the Mysql-server and mysql.client packages, the RPM installation is very simple here will not say.

(2) Yum mode install MySQL
The Yum installation is simple, as long as you execute the Yum install Mysql-server–y.
Large portal to the source code according to the needs of enterprises to make RPM, set up Yum Warehouse, yum install xxx-y.

3.1.2 Install MySQL using CMake method

Due to the particularity of the mysql5.5.xx-5.6.xx product line, the compiling method is also different from the early-riser product installation method, which is compiled and installed in CMake or Gmake way.

3.1.3 uses binary mode to install MySQL without compiling.

Using binary method to install MySQL without compiling, this method and YUM/RPM package installation method is similar, suitable for all kinds of MySQL product line, do not need to complex compilation settings and compile time wait, directly unzip the downloaded package, initialize to complete the installation of MySQL start.

3.1.4 How to correctly choose the installation method of MySQL

Binary installation is simple and convenient, suitable for 5.0-5.1 and 5.5-5.6 series, is a lot of professional DBA choice, ordinary Linux operation and maintenance personnel to use the way of compiling, 5.0-5.1 series is the conventional way of compiling, 5.5-5.6 or more series is cmake compile the way. Therefore, mysql5.5 and above, the installation of a small number of machines, recommended CMake compiling method, which is the choice of most operations personnel. If you have a large quantity, you can use binary to install it. is no problem.

Mysql DBA Advanced Operations Learning Note-mysql Multiple installation methods for the database