[Original] Installation of MySQL5.7.4forRedHatEnterprise7 (RHEL7) _ MySQL

[Original] installing RHEL for MySQL5.7.4forRedHatEnterprise7 (RHEL7)

From a long history, MySQL aims to run on a single-processor core commercial server. One change in MySQL users may not notice today, that is, Oracle has begun to rebuild MySQL code, making it a lot of modular. Such as the software parser, the optimization and replication functions are rewritten in a modular form.

The query performance of this version is greatly improved, doubled from MySQL 5.6. The new version of MySQL can reach 512000 read-only QPS per second on the test platform, while MySQL 5.6 can only reach 250000 QPS. This performance improvement is achieved through its Memcached plug-in. At the same time, this version has also been improved in other aspects of the database, such as reducing the time for establishing database connections, thanks to Facebook's contribution.

1. First, we understand the features of MySQL.

MySQL features

• It is written in C and C ++ and tested using multiple compilers to ensure source code portability.

• Supports multiple operating systems, including AIX, BSDi, FreeBSD, HP-UX, Linux, Mac OS, Novell Netware, NetBSD, OpenBSD, OS/2 Wrap, Solaris, SunOS, and Windows.

• Provides APIs for multiple programming languages. These programming languages include C, C ++, C #, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl.

• Supports multithreading, making full use of CPU resources, and supporting multiple users.

• The optimized SQL query algorithm effectively improves the query speed.

• It can be used as a separate application in the client server network environment, and can also be embedded into other software as a library.

• Supports multiple languages. common codes such as Chinese GB 2312, BIG5, and Japanese Shift_JIS can be used as data table names and data column names.

• Provides multiple database connection methods, such as TCP/IP, ODBC, and JDBC.

• Provides management tools for managing, checking, and optimizing database operations.

• It can process large databases with tens of millions of records.

Chinese MySQL documentation: http://tool.oschina.net/apidocs/apidoc? Api = mysql-5.1-zh

MySQL documentation: http://tool.oschina.net/apidocs/apidoc? Api = mysql-5.5-en

2. download MySQL

Open http://dev.mysql.com/downloads/mysql/ select developer version

Select the RHEL version

Download the 32-or 64-bit mysql version of the x86 architecture you need. click to download it.

Select download now or download tool to open

Http://cdn.mysql.com/Downloads/MySQL-5.7/MySQL-5.7.4-m14-0.2.m14.el7.x86_64.rpm-bundle.tar

3. transfer MySQL to the VM.

To start RHEL7, we need to use the root user to install it. in order to make it more direct, we can directly log on to RHEL7 with the root user.

4. release the installation package: tar-xvf MySQL-5.7.4-m14-0.2.m14.el7.x86_64.rpm-bundle.tar

5. Start Installation below

It shows that there is a conflict. I should uninstall the original software mariadb-devel and mariadb.

Rpm-e -- nodeps mariadb-libs-5.5.33a-3.el7.x86_64

Rpm-ivh mysql-community-common-5.7.4-0.2.m14.el7.x86_64.rpm

Rpm-ivh mysql-community-libs-5.7.4-0.2.m14.el7.x86_64.rpm

Rpm-ivh mysql-community-embedded-5.7.4-0.2.m14.el7.x86_64.rpm

Rpm-e mariadb-devel-nodeps

Rpm-e mariadb-nodeps

Rpm-ivh mysql-community-devel-5.7.4-0.2.m14.el7.x86_64.rpm

Rpm-ivh mysql-community-embedded-devel-5.7.4-0.2.m14.el7.x86_64.rpm

Rpm-ivh mysql-community-client-5.7.4-0.2.m14.el7.x86_64.rpm

Attach your image to the drive of the VM

Install several dependent packages in the iso file

Rpm-ivh perl-Net-Daemon-0.48-4.el7.noarch.rpm

Rpm-ivh perl-PlRPC-0.2020-12.el7.noarch.rpm

Rpm-ivh perl-DBI-1.627-1.el7.x86_64.rpm

Work path back to the desktop and then continue to install our server

Rpm-ivh mysql-community-server-5.7.4-0.2.m14.el7.x86_64.rpm

6. change the user password

After the Server is installed, find the key file.

Find/-name. mysql_secret

The root user is denied access when logging on to mysql.

Log on again

Change the password to 123456 in a simple example.